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.  Catch a Database error and use it on a map

    Posted 10/10/05 04:24 PM

    Originally posted by: SystemAdmin


    Hi!

    How can I get the database error and use it on a map? Actually I am using the audit log of TX to catch an error. One part of the file is the following:

    i:dcdebcb759b:dcdebcb759<TargetReport card="2" adapter="DB" bytes="805" adapterreturn="-1037">
    <Message>Table is not accessible</Message>
    </TargetReport>[/b:dcdebcb759][/i:dcdebcb759]

    My trace file indicate the following:

    i:dcdebcb759b:dcdebcb759<1676-1224>: TRACE command specified, file: C:\MasterFilesIntegration\Maps\Source\ods_destino_producto_sucursal.dbl
    <1676-1224>: Table name: MGRODS.ODS_PRODUCTO
    <1676-1224>: Update mode is on.
    <1676-1224>: Error in: OCIStmtExecute Message : ORA-00942: table or view does not exist[/b:dcdebcb759][/i:dcdebcb759]
    The message that I need is : OCIStmtExecute Message : ORA-00942: table or view does not exist.

    I will appreciate any ideas

    Best!

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


  • 2.  Re: Catch a Database error and use it on a map

    Posted 10/11/05 12:55 AM

    Originally posted by: SystemAdmin


    If you run the map doing the database access from another map and put a VALID round the RUN it will return the error code 1037 and the error message Table is not accessible. You can't get the Oracle error though - that only goes to the trace file.
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender
    #DataExchange


  • 3.  Re: Catch a Database error and use it on a map

    Posted 10/12/05 09:32 AM

    Originally posted by: SystemAdmin


    Another thought is to parse the trace file for Oracle errors.
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender
    #DataExchange


  • 4.  Re: Catch a Database error and use it on a map

    Posted 10/14/05 01:15 AM

    Originally posted by: SystemAdmin


    Yvonne,
    Any suggestions on how to do that
    #IBMSterlingTransformationExtender
    #DataExchange
    #IBM-Websphere-Transformation-Extender


  • 5.  Re: Catch a Database error and use it on a map

    Posted 10/14/05 10:58 AM

    Originally posted by: SystemAdmin


    I am likely speaking out of turn here as I am not a master mapper. The thought process I was having is that after the error occurs, you know it has, so you can go grab the info in the trace file to create another log. My idea was not doing it in "real time".
    #DataExchange
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender


Related Content