Hi NISHIL,
After I added a new physical send port and ran the orchestration, it’s still stopped by the same error w/o producing the xml file. It’s still looking for a stored procedure named Table1. So I got in the monitoring and copied the message body out of the send adapter where the error took place.
<?xml version=”1.0″?><DB2arsif2Req xmlns=”http://DB2arsif2″><Table1 T7WDG4=”1100315″ T7WDG5=”130400″ T7WAHI=”1″ T7WDG7=”163403″ T7WDG9=”0″ T6WBP7=”1100314″ T7WDG8=”0″ T7WDG6=”1100323″ T7WBNW=”183012″ T7ACTN=”I” /><Table1 T7WDG4=”1100315″ T7WDG5=”130400″ T7WAHI=”1″ T7WDG7=”163403″ T7WDG9=”0″ T6WBP7=”1100314″ T7WDG8=”0″ T7WDG6=”1100323″ T7WBNW=”183012″ T7ACTN=”I” /></DB2arsif2Req>
Looks like what I said, it simply ignored the mapping and threw the data with source schema into the send adapter.
Is it possible that you could provide your email address for me to send u the project file and u take a look?
Regards, Steve