Monthly Archives: April 2016

ODI-1228: java.sql.SQLException

Scenario ODI Scenario errored
Error ODI-1226: Step LOAD_AGG_YEAR_WEEK fails after 1 attempt(s).
  ODI-1232: Procedure LOAD_AGG_YEAR_WEEK execution fails.
  ODI-1228: Task LOAD_AGG_YEAR_WEEK (Procedure) fails on the target ORACLE connection ORACLE_TEST.
  Caused By: java.sql.SQLException: ORA-06550: line 2, column 1:
  PLS-00201: identifier ‘ODI_WORK.ADW_LOAD_AGG_YEAR_WEEK’ must be declared
  ORA-06550: line 2, column 1:
  PL/SQL: Statement ignored
Cause Make sure the procedure exists in the correct schema