1 Reply Latest reply: Aug 9, 2012 10:43 AM by yasir - oracle grc consulting - oracle RSS

    Upon AACG instal ETL failed with ODI-1241: Oracle Data Integrator tool ....

    user302579
      I got the below error message upon installation of AACG and initiating Synchronization steps:

      2012-08-07 14:03:00,799 DEBUG [Thread-47] OdiSessionMonitor:96 *** name: Execution of the Scenario LOADACCESSDATACORE version 001
      2012-08-07 14:03:00,799 DEBUG [Thread-47] OdiSessionMonitor:98 *** step #: 13
      2012-08-07 14:03:00,799 DEBUG [Thread-47] OdiSessionMonitor:100 *** start time: Tue Aug 07 13:57:38 CDT 2012
      2012-08-07 14:03:00,799 DEBUG [Thread-47] OdiSessionMonitor:102 *** end time: Tue Aug 07 14:02:59 CDT 2012
      2012-08-07 14:03:00,799 DEBUG [Thread-47] OdiSessionMonitor:104 *** duration: 321
      2012-08-07 14:03:00,799 DEBUG [Thread-47] OdiSessionMonitor:106 *** status: ERROR
      2012-08-07 14:03:00,799 DEBUG [Thread-47] OdiSessionMonitor:108 *** insert count: 0
      2012-08-07 14:03:00,799 DEBUG [Thread-47] OdiSessionMonitor:110 *** record count: 0
      2012-08-07 14:03:00,800 DEBUG [Thread-47] OdiSessionMonitor:112 *** error count: 0
      2012-08-07 14:03:00,807 DEBUG [Thread-47] OdiSessionMonitor:114 *** error message: ODI-1226: Step Execution of the Scenario LOADACCESSDATACORE version 001 fails after 1 attempt(s).
      ODI-1241: Oracle Data Integrator tool execution fails.
           at com.sunopsis.dwg.dbobj.SnpSessTaskSqlS.getExceptionOnStepTaskFailure(SnpSessTaskSqlS.java:53)
           at com.sunopsis.dwg.dbobj.SnpSessStep.treatStepTaskError(SnpSessStep.java:995)
           at com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:546)
           at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:449)
           at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1954)
           at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1818)
           at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$2.doAction(StartScenRequestProcessor.java:559)
           at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:224)
           at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.doProcessStartScenTask(StartScenRequestProcessor.java:481)
           at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(StartScenRequestProcessor.java:1040)
           at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:114)
           at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:82)
           at java.lang.Thread.run(Thread.java:662)

      Metalink Note 1293758.1 refers to it for 11.5.10.

      I have attached the NLS_Database_parameters output from both the environments

      The installation document insists that the GRC database be in the UTF8. The Vision database is also UTF8 i hope that is not an issue ?

      Vis Database:

      SQL> /

      PARAMETER||''||VALUE
      --------------------------------------------------------------------------------
      NLS_CALENDAR GREGORIAN
      NLS_CHARACTERSET AL32UTF8
      NLS_COMP BINARY
      NLS_CSMIG_SCHEMA_VERSION 5
      NLS_CURRENCY $
      NLS_DATE_FORMAT DD-MON-RR
      NLS_DATE_LANGUAGE AMERICAN
      NLS_DUAL_CURRENCY $
      NLS_ISO_CURRENCY AMERICA
      NLS_LANGUAGE AMERICAN
      NLS_LENGTH_SEMANTICS BYTE

      PARAMETER||''||VALUE
      --------------------------------------------------------------------------------
      NLS_NCHAR_CHARACTERSET UTF8
      NLS_NCHAR_CONV_EXCP FALSE
      NLS_NUMERIC_CHARACTERS .,
      NLS_RDBMS_VERSION 11.1.0.7.0
      NLS_SAVED_NCHAR_CS WE8ISO8859P1
      NLS_SORT BINARY
      NLS_TERRITORY AMERICA
      NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
      NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZH:TZM
      NLS_TIME_FORMAT HH.MI.SSXFF AM
      NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZH:TZM

      GRCDB Below:

      SQL> @afiedt.buf

      PARAMETER||''||VALUE
      --------------------------------------------------------------------------------
      NLS_CALENDAR GREGORIAN
      NLS_CHARACTERSET AL32UTF8
      NLS_COMP BINARY
      NLS_CURRENCY $
      NLS_DATE_FORMAT DD-MON-RR
      NLS_DATE_LANGUAGE AMERICAN
      NLS_DUAL_CURRENCY $
      NLS_ISO_CURRENCY AMERICA
      NLS_LANGUAGE AMERICAN
      NLS_LENGTH_SEMANTICS BYTE
      NLS_NCHAR_CHARACTERSET UTF8
      NLS_NCHAR_CONV_EXCP FALSE
      NLS_NUMERIC_CHARACTERS .,
      NLS_RDBMS_VERSION 11.2.0.1.0
      NLS_SORT BINARY
      NLS_TERRITORY AMERICA
      NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
      NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR
      NLS_TIME_FORMAT HH.MI.SSXFF AM
      NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR

      Thanks,