Page 1 of 1

Reject handling in web service transformer stage

Posted: Mon Mar 09, 2009 3:53 am
by srai
Hi All,

Does anybody has any idea how to handle reject rows in WSTransformer stage.

My job is something like this-

SQLserver database will be source to WStransformer stage and based on the input it will call WSDL operation and WSDL will update Salesforce.com internally.
Lets suppose there are 10 rows coming from source and out of which 6 are able to call WSDL and update SF.com successfully. Now there are 4 failed update. I need to store these 4 records in the Sequential file.

Could anybody help in cofiguring Reject handling in Ws Transformer stage?

Thanks in advance.

Thanks.

Posted: Mon Mar 09, 2009 6:18 am
by eostic
The failure code (assuming that the call to sf.com worked) should be in the response body......parse out the body in a downstream transformer, and then send your logical rejects to an appropriate location.

Ernie

Posted: Mon Mar 09, 2009 7:42 am
by s_boyapati
It is advisable to generate sequence number and use in naming convensions for file name in "appropriate location". Also extract return code from mesage body for further filtering and error handling purposes, if you have that requirement.

Posted: Tue Mar 10, 2009 2:40 am
by srai
eostic wrote:The failure code (assuming that the call to sf.com worked) should be in the response body......parse out the body in a downstream transformer, and then send your logical rejects to an appropriate location.

Ernie
Thanks a lot Erine.

One doubt about parsing. Do we need to use XML input stage only to parse the SOAP message to tabular form. I am getting some error with XML input stage. Is there any workaround of this available in DataStage.

Thanks
Santosh

Posted: Tue Mar 10, 2009 3:45 pm
by ray.wurlod
"Some error"?!!! Get serious. We charge a lot extra to read your mind.

WHAT error?