5 Replies Latest reply on Mar 8, 2016 12:49 AM by 1059384

    FDMEE loading data to People Soft error out

    1059384

      Hyperion 11.1.2.3.xxx

      Windows 2008 R2

      Oracle database 11

      FDMEE

       

      When I run the write back rule i got the following error at import time. Please see the ODI logs for error. Can some one advise what insufficient privilege and which account. Is it the account use for people soft database connection. I check it from ODI and connection to the people soft database is working. Any advise is really appreciated

       

       

      ODI-1228: Task PS GL Writeback Load Interface (Procedure) fails on the target GENERIC_SQL connection for_SIT_PSFT_FMS_DATA_SERVER.

       

      Caused By: java.sql.BatchUpdateException: ORA-01031: insufficient privileges

       

       

       

                  at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:13349)

       

                  at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:248)

       

       

       

       

       

       

       

      ODI-1226: Step PS GL Writeback Load Interface fails after 1 attempt(s).

       

      ODI-1232: Procedure PS GL Writeback Load Interface execution fails.

       

      ODI-1228: Task PS GL Writeback Load Interface (Procedure) fails on the target GENERIC_SQL connection for_SIT_PSFT_FMS_DATA_SERVER.

       

      Caused By: java.sql.BatchUpdateException: ORA-01031: insufficient privileges

       

       

       

                  at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:13349)

       

                  at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:248)

       

                  at oracle.odi.runtime.agent.execution.sql.SQLCommand.end(SQLCommand.java:268)

       

                  at oracle.odi.runtime.agent.execution.sql.SQLExecutor.endExecution(SQLExecutor.java:156)

       

                  at oracle.odi.runtime.agent.execution.sql.SQLExecutor.endExecution(SQLExecutor.java:1)

       

                  at oracle.odi.runtime.agent.execution.DataMovementTaskExecutionHandler.handleTask(DataMovementTaskExecutionHandler.java:113)

       

                  at com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(SnpSessTaskSql.java:2913)

       

       

       

       

       

      Session Failed :1041501 : ODI-1217: Session PS_GL_WRITEBACK_BALANCES (1041501) fails with return code 7000.

       

      ODI-1226: Step FAILED - Load Data fails after 1 attempt(s).

       

      ODI-1232: Procedure COMM WB Finalize Process execution fails.

       

      Caused By: org.apache.bsf.BSFException: exception from Jython:

       

      Traceback (most recent call last):

       

        File "<string>", line 13, in <module>

       

        File "<string>", line 159, in finalizeProcess

       

      RuntimeError

       

       

       

                  at org.apache.bsf.engines.jython.JythonEngine.exec(JythonEngine.java:146)

       

                  at com.sunopsis.dwg.codeinterpretor.SnpScriptingInterpretor.execInBSFEngine(SnpScriptingInterpretor.java:322)

       

                  at com.sunopsis.dwg.codeinterpretor.SnpScriptingInterpretor.exec(SnpScriptingInterpretor.java:170)

       

                  at com.sunopsis.dwg.dbobj.SnpSessTaskSql.scripting(SnpSessTaskSql.java:2473)

       

                  at oracle.odi.runtime.agent.execution.cmd.ScriptingExecutor.execute(ScriptingExecutor.java:48)

       

                  at oracle.odi.runtime.agent.execution.cmd.ScriptingExecutor.execute(ScriptingExecutor.java:1)

       

       

       

       

       

       

       

      • org.apache.bsf.BSFException: exception from Jython:

       

      Traceback (most recent call last):

       

        File "<string>", line 13, in <module>

       

        File "<string>", line 162, in finalizeProcess

       

      RuntimeError: ODI-1226: Step Launch GL Writeback Balances 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:1127)

       

       

       

                  at com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:594)

       

       

       

                  at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:468)

       

       

       

                  at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2128)

       

       

       

                  at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1930)

       

       

       

                  at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$2.doAction(StartScenRequestProcessor.java:580)

       

       

       

                  at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)

       

       

       

                  at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.doProcessStartScenTask(StartScenRequestProcessor.java:513)

       

       

       

                  at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(StartScenRequestProcessor.java:1073)

       

       

       

                  at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:126)

       

       

       

                  at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:82)

       

       

       

                  at java.lang.Thread.run(Thread.java:662)