IBM Sterling Transformation Extender

Sterling Transformation Extender

Come for answers, stay for best practices. All we're missing is you.


#Sterling
#Supplychain
 View Only

  • 1.  Adapter vs. Provider return codes

    Posted 11/05/08 11:56 AM

    Originally posted by: SystemAdmin


    Is there a way in a map to get the actual provider return codes/messages instead of the adapter returns?

    For example, if a map tries to insert a duplicate row into Oracle, the WTX adapter returns "(-1009) Failed_to_execute_the_SQL_statement".

    I find the "ORA-00001: unique constraint (HR.LOC_ID_PK) violated" error message to be much more helpful in troubleshooting what went wrong.
    #DataExchange
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender


  • 2.  Re: Adapter vs. Provider return codes

    Posted 11/24/08 05:15 AM

    Originally posted by: SystemAdmin


    I have not worked on Oracle, but in DB2 if you turn the audit on, then it provides the exact error code in the audit log. You can try turning the audit on.
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender
    #DataExchange


  • 3.  Re: Adapter vs. Provider return codes

    Posted 12/01/08 10:03 AM

    Originally posted by: JulienT


    You can have more information if you activate the adapter trace with the commande -T.
    If you use oracle db adapter you can find the oracle return codes in this adapter trace file.
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender
    #DataExchange