Monthly Archives: May 2016

ODI-17511: No value to be set to variable DefDate:null

Scenario ODI Scenario errors
Error ODI-1226: Step VAR_FILE_NAME fails after 1 attempt(s).
ODI-1236: Error while refreshing variable DATAMIG.VAR_FILE_NAME.
Caused By: java.lang.Exception: ODI-17511: No value to be set to variable DefDate:null
DefN:null
DefV:null
IndStore:H
ITxtDefT:null
ITxtVar:null
SessNo:40336175
VarDatatype:A
VarLongValue:null
VarName:DATAMIG.VAR_FILE_NAME.
Code Refresh Variable DATAMIG.VAR_FILE_NAME:
select substr(file_name,1,instr(file_name,’*’)-1)||TO_CHAR(SYSDATE,’YYYYMMDD’)
from        STG.FILE_CONFIG
where     GROUP_NAME = ‘#DATAMIG.VAR_GROUP_NAME’
AND        FILE_NAME = ‘#DATAMIG.VAR_FILE_NAME_MASK’
AND       SUB_GROUP_NAME = ‘#DATAMIG.VAR_SUB_GROUP_NAME’
Reason There is no value returned by the SQL query

 

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