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.  Oracle ORA-03113 error code

    Posted 07/02/12 07:57 AM

    Originally posted by: Silver.Su


    Hi, I'm using wtx 8.2.0.4 and faced ORA-03113 error code with oracle adapter.

    I have a map with oracle adapter in output card for writing record to database.
    This map will get ORA-03113 error code after it is idle for 3 hours later.

    How could I resolve this problem? Could I set the timeout within the adapter?
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender
    #DataExchange


  • 2.  Re: Oracle ORA-03113 error code

    Posted 07/02/12 08:37 AM

    Originally posted by: richlee


    Hi,

    Try changing the following entries in the DTX.INI file...
    
    IdleDB=10 KeepDB=5
    

    Richard
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender
    #DataExchange


  • 3.  Re: Oracle ORA-03113 error code

    Posted 07/02/12 10:26 PM

    Originally posted by: Silver.Su


    Richlee, thanks for your suggestion about my problem.

    It works! Thanks a lot.
    #DataExchange
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender