ODI-nnnn: Errors

ODI-1227 ODI-1227: Task SHOPPING.PRC.MSSERVER.DL_New (Procedure) fails on the source MICROSOFT_SQL_SERVER connection DYN_SHOP.
  Caused By: java.sql.SQLException: [FMWGEN][SQLServer JDBC Driver]Error establishing socket. Unknown host:
Cause Unable to establish connection to target host
   
ODI-1228 ODI-1228: Task SHOPPING.PRC.MSSERVER.DL_New (Procedure) fails on the target ORACLE connection ORA_MIG.
ORA-00984 Caused By: java.sql.BatchUpdateException: ORA-00984: column not allowed here
   
ODI-1228 ODI-1228: Task SHOPPING.PRC.MSSERVER.DL_New (Procedure) fails on the target ORACLE connection ORA_MIG.
ORA-00904 Caused By: java.sql.BatchUpdateException: ORA-00904: “SHOP_NO”: invalid identifier
   
ODI-1228 ODI-1228: Task SHOPPING.PRC.MSSERVER.DL_New (Procedure) fails on the target ORACLE connection ORA_MIG.
ORA-01722 Caused By: java.sql.BatchUpdateException: ORA-01722: invalid number
Cause Data type mismatch for a column
   
ODI-1228 ODI-1228: Task SHOPPING.PRC.MSSERVER.DL_New (Procedure) fails on the target ORACLE connection ORA_MIG.
ORA-00942 Caused By: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
Cause Ensure table exists in the schema
   
ODI-1246 ODI-1246: The Logical Schema has not been set for SHOPPING.PRC.MSSERVER.FL.
  at com.sunopsis.dwg.dbobj.SnpSessTask.getDefaultDwgConnectConnection(SnpSessTask.java:508)
   
ODI-1228 ODI-1228: Task RETAIL.PRC.TILLOPERATORLOGINS.FL (Procedure) fails on the target ORACLE connection ORA_MIG.
ORA-00904 Caused By: java.sql.SQLSyntaxErrorException: ORA-00904: “TGT”.”CUSTOM_REF”: invalid identifier
Cause Ensure column exists in the table
   
ODI-1228 ODI-1228: Task RETAIL.PRC.LOAD_STAGING (Procedure) fails on the target ORACLE connection ORA_MIG.
ORA-00972 Caused By: java.sql.SQLSyntaxErrorException: ORA-00972: identifier is too long
Cause Ensure the length of table name is less than or equal to 30 characters
   
ODI-1228 ODI-1228: Task SHOP.PRC.LOAD_STAGING (Procedure) fails on the target ORACLE connection ORA_MIG.
ORA-00922 Caused By: java.sql.SQLSyntaxErrorException: ORA-00922: missing or invalid option
   
ODI-1228 ODI-1228: Task RETAIL.PRC.LOAD_STAGING (Procedure) fails on the target ORACLE connection ORA_MIG.
ORA-00936 Caused By: java.sql.SQLSyntaxErrorException: ORA-00936: missing expression
   
ODI-1228 ODI-1228: Task RETAIL.PRC.LOAD_PERFORMANCE (Procedure) fails on the target ORACLE connection ORA_MIG.
ORA-00932 Caused By: java.sql.SQLSyntaxErrorException: ORA-00932: inconsistent datatypes: expected NUMBER got DATE
   
ODI-1228 ODI-1228: Task SHOPPING.PRC.MSSERVER.FL (Procedure) fails on the target ORACLE connection ORA_MIG.
ORA-01722 Caused By: java.sql.SQLSyntaxErrorException: ORA-01722: invalid number
   
ODI-1228 ODI-1228: Task RETAIL.PRC.LOAD_STAGING (Procedure) fails on the target ORACLE connection ORA_MIG.
ORA-00947 Caused By: java.sql.SQLSyntaxErrorException: ORA-00947: not enough values

2 thoughts on “ODI-nnnn: Errors

  1. ODI-1217: Session CSV_EXPORT_PKG (65494) fails with return code 7000.

    DI-1226: Step OdiSftpPut fails after 1 attempt(s).
    ODI-1241: Oracle Data Integrator tool execution fails.
    Caused By: java.lang.NullPointerException

  2. I got this type of error in executing the package.so please give me a solution..
    ODI-1217: Session CSV_EXPORT_PKG (65494) fails with return code 7000.

    DI-1226: Step OdiSftpPut fails after 1 attempt(s).
    ODI-1241: Oracle Data Integrator tool execution fails.
    Caused By: java.lang.NullPointerException

Leave a Reply

Your email address will not be published. Required fields are marked *