Tuesday, July 23, 2013

Datastage Log Errors - Part 1

Noting down some of the Log file Errors and their Resolutions - 

Error 1 -  'osh_conductor: APT_CONFIG_FILE setting does not point to a valid filename'
Resolution - Config file is missing. Check config file path in DS admin 

Error 2 - 'operator sync table cannot be created'
Resolution - terasync table is missing in the Database which Teradata Enterprise stage is referring to.

Error 3 - 'APT_CombinedOperatorController,0: [DataDirect][ODBC DB2 Wire Protocol driver][UDB DB2 for iSeries and AS/400]UPDATE OR INSERT SPECIFIES STRING TOO LONG X1URRF.  15 30 {0}'
Resolution - Check Data type and Precision of columns

Error 4 - 'APT_CombinedOperatorController,0: [DataDirect][ODBC DB2 Wire Protocol driver][UDB DB2 for iSeries and AS/400]F5900011   in PY02DTA    not valid for operation.  3 {0}'
Resolution - User doesnot  have insert or update access on that table

No comments:

Post a Comment