Oracle Business Intelligence Applications

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Business Intelligence Applications

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

ANOMALY INFO::: Error while executing : TRUNCATE TABLE:OPI_OBIA_W_BOM_HEADER_DS:"Table Action: Overr

Received Response
1
Views
3
Comments
3351264
3351264 Rank 1 - Community Starter
in Oracle Business Intelligence Applications

We are running into an issue while running the ETL in DAC, followed everything listed on oracle's support document and applied the correct patch and made the changes in informatica and dac and still the ETL fails with below erros.

All Task Batches

  Truncate Batch

  ------------------------------

  TRUNCATE TABLE:W_BOM_ITEM_FS

  ------------------------------

  2016-11-21 09:27:31.663 Acquiring Resources

  2016-11-21 09:27:31.713 Acquired Resources

  2016-11-21 09:27:31.726 TRUNCATE TABLE:W_BOM_ITEM_FS has started.

  Successfully executed : TRUNCATE TABLE:W_BOM_ITEM_FS

  (Number of retries : 1)

  Commands executed :

  TRUNCATE TABLE W_BOM_ITEM_FS

  2016-11-21 09:27:31.76 TRUNCATE TABLE:W_BOM_ITEM_FS has finished execution with Completed status.

  ------------------------------

  ------------------------------

  TRUNCATE TABLE:W_BOM_HEADER_DS

  ------------------------------

  2016-11-21 09:27:31.674 Acquiring Resources

  2016-11-21 09:27:31.714 Acquired Resources

  2016-11-21 09:27:31.726 TRUNCATE TABLE:W_BOM_HEADER_DS has started.

  Successfully executed : TRUNCATE TABLE:W_BOM_HEADER_DS

  (Number of retries : 1)

  Commands executed :

  TRUNCATE TABLE W_BOM_HEADER_DS

  2016-11-21 09:27:31.969 TRUNCATE TABLE:W_BOM_HEADER_DS has finished execution with Completed status.

  ------------------------------

  ------------------------------

  TRUNCATE TABLE:OPI_OBIA_W_BOM_HEADER_DS:"Table Action: Override OPI truncate command" template

  ------------------------------

  2016-11-21 09:27:31.841 Acquiring Resources

  2016-11-21 09:27:31.856 Acquired Resources

  2016-11-21 09:27:31.867 TRUNCATE TABLE:OPI_OBIA_W_BOM_HEADER_DS:"Table Action: Override OPI truncate command" template has started.

  ANOMALY INFO::: Error while executing : TRUNCATE TABLE:OPI_OBIA_W_BOM_HEADER_DS:"Table Action: Override OPI truncate command" template

  MESSAGE:::com.siebel.analytics.etl.execution.exceptions.ActionFailedException: Running Custom Sql list TRUNCATE TABLE:OPI_OBIA_W_BOM_HEADER_DS:"Table Action: Override OPI truncate command" template

  Default retries for this custom SQL is 1.

  executing sql (Truncate OPI:ORA_R1213)

  Call

  apps.OPI_OBIA_BOMPEXPL_WRAPPER_P.TRUNCATE_W_BOM_HEADER_DS('OPI')

  "Truncate OPI" failed on "ORA_R1213"

  SQL: Call

  apps.OPI_OBIA_BOMPEXPL_WRAPPER_P.TRUNCATE_W_BOM_HEADER_DS('OPI')

  Error: MESSAGE:::ORA-06576: not a valid function or procedure name

  EXCEPTION CLASS::: java.sql.SQLException

  oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)

  oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)

  oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)

  oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)

  oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)

  oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)

  oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)

  oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1044)

  oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1329)

  oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3593)

  oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3694)

  oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1378)

  com.siebel.etl.database.cancellable.CancellablePreparedStatement.execute(CancellablePreparedStatement.java:84)

  com.siebel.etl.engine.custom.SQLFileCommand.executeFineGrain(SQLFileCommand.java:817)

  com.siebel.etl.engine.custom.SQLFileCommand.executeCustomSQLStructurePerConnection(SQLFileCommand.java:477)

  com.siebel.etl.engine.custom.SQLFileCommand.executeCustomSQLStructure(SQLFileCommand.java:365)

  com.siebel.etl.engine.custom.SQLFileCommand.doExecute(SQLFileCommand.java:262)

  com.siebel.etl.command.MultiSourceSqlCommand.execute(MultiSourceSqlCommand.java:83)

  com.siebel.analytics.etl.etltask.CreateIndexTaskWrapper.exerciseOverride(CreateIndexTaskWrapper.java:107)

  com.siebel.analytics.etl.etltask.AnalyzeTableTaskWrapper.exerciseOverride(AnalyzeTableTaskWrapper.java:65)

  com.siebel.analytics.etl.etltask.TruncateTableTaskWrapper.doExecute(TruncateTableTaskWrapper.java:29)

  com.siebel.analytics.etl.etltask.GenericTaskImpl.doExecuteWithRetries(GenericTaskImpl.java:477)

  com.siebel.analytics.etl.etltask.GenericTaskImpl.execute(GenericTaskImpl.java:372)

  com.siebel.analytics.etl.etltask.GenericTaskImpl.execute(GenericTaskImpl.java:253)

  com.siebel.analytics.etl.etltask.GenericTaskImpl.run(GenericTaskImpl.java:655)

  com.siebel.analytics.etl.taskmanager.XCallable.call(XCallable.java:63)

  java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)

  java.util.concurrent.FutureTask.run(FutureTask.java:166)

  java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)

  java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)

  java.util.concurrent.FutureTask.run(FutureTask.java:166)

  java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)

  java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)

  java.lang.Thread.run(Thread.java:722)

  Execution of custom sql file failed.

  EXCEPTION CLASS::: java.lang.Exception

  com.siebel.analytics.etl.etltask.GenericTaskImpl.doExecuteWithRetries(GenericTaskImpl.java:516)

  com.siebel.analytics.etl.etltask.GenericTaskImpl.execute(GenericTaskImpl.java:372)

  com.siebel.analytics.etl.etltask.GenericTaskImpl.execute(GenericTaskImpl.java:253)

  com.siebel.analytics.etl.etltask.GenericTaskImpl.run(GenericTaskImpl.java:655)

  com.siebel.analytics.etl.taskmanager.XCallable.call(XCallable.java:63)

  java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)

  java.util.concurrent.FutureTask.run(FutureTask.java:166)

  java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)

  java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)

  java.util.concurrent.FutureTask.run(FutureTask.java:166)

  java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)

  java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)

  java.lang.Thread.run(Thread.java:722)

  ::: CAUSE :::

  MESSAGE :::Running Custom Sql list TRUNCATE TABLE:OPI_OBIA_W_BOM_HEADER_DS:"Table Action: Override OPI truncate command" template

  Default retries for this custom SQL is 1.

  executing sql (Truncate OPI:ORA_R1213)

  Call

  apps.OPI_OBIA_BOMPEXPL_WRAPPER_P.TRUNCATE_W_BOM_HEADER_DS('OPI')

  "Truncate OPI" failed on "ORA_R1213"

  SQL: Call

  apps.OPI_OBIA_BOMPEXPL_WRAPPER_P.TRUNCATE_W_BOM_HEADER_DS('OPI')

  Error: MESSAGE:::ORA-06576: not a valid function or procedure name

  EXCEPTION CLASS::: java.sql.SQLException

  oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)

  oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)

  oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)

  oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)

  oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)

  oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)

  oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)

  oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1044)

  oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1329)

  oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3593)

  oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3694)

  oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1378)

  com.siebel.etl.database.cancellable.CancellablePreparedStatement.execute(CancellablePreparedStatement.java:84)

  com.siebel.etl.engine.custom.SQLFileCommand.executeFineGrain(SQLFileCommand.java:817)

  com.siebel.etl.engine.custom.SQLFileCommand.executeCustomSQLStructurePerConnection(SQLFileCommand.java:477)

  com.siebel.etl.engine.custom.SQLFileCommand.executeCustomSQLStructure(SQLFileCommand.java:365)

  com.siebel.etl.engine.custom.SQLFileCommand.doExecute(SQLFileCommand.java:262)

  com.siebel.etl.command.MultiSourceSqlCommand.execute(MultiSourceSqlCommand.java:83)

  com.siebel.analytics.etl.etltask.CreateIndexTaskWrapper.exerciseOverride(CreateIndexTaskWrapper.java:107)

  com.siebel.analytics.etl.etltask.AnalyzeTableTaskWrapper.exerciseOverride(AnalyzeTableTaskWrapper.java:65)

  com.siebel.analytics.etl.etltask.TruncateTableTaskWrapper.doExecute(TruncateTableTaskWrapper.java:29)

  com.siebel.analytics.etl.etltask.GenericTaskImpl.doExecuteWithRetries(GenericTaskImpl.java:477)

  com.siebel.analytics.etl.etltask.GenericTaskImpl.execute(GenericTaskImpl.java:372)

  com.siebel.analytics.etl.etltask.GenericTaskImpl.execute(GenericTaskImpl.java:253)

  com.siebel.analytics.etl.etltask.GenericTaskImpl.run(GenericTaskImpl.java:655)

  com.siebel.analytics.etl.taskmanager.XCallable.call(XCallable.java:63)

  java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)

  java.util.concurrent.FutureTask.run(FutureTask.java:166)

  java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)

  java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)

  java.util.concurrent.FutureTask.run(FutureTask.java:166)

  java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)

  java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)

  java.lang.Thread.run(Thread.java:722)

  Execution of custom sql file failed.

  EXCEPTION CLASS::: com.siebel.analytics.etl.execution.exceptions.ActionFailedException

  com.siebel.analytics.etl.etltask.CreateIndexTaskWrapper.exerciseOverride(CreateIndexTaskWrapper.java:114)

  com.siebel.analytics.etl.etltask.AnalyzeTableTaskWrapper.exerciseOverride(AnalyzeTableTaskWrapper.java:65)

  com.siebel.analytics.etl.etltask.TruncateTableTaskWrapper.doExecute(TruncateTableTaskWrapper.java:29)

  com.siebel.analytics.etl.etltask.GenericTaskImpl.doExecuteWithRetries(GenericTaskImpl.java:477)

  com.siebel.analytics.etl.etltask.GenericTaskImpl.execute(GenericTaskImpl.java:372)

  com.siebel.analytics.etl.etltask.GenericTaskImpl.execute(GenericTaskImpl.java:253)

  com.siebel.analytics.etl.etltask.GenericTaskImpl.run(GenericTaskImpl.java:655)

  com.siebel.analytics.etl.taskmanager.XCallable.call(XCallable.java:63)

  java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)

  java.util.concurrent.FutureTask.run(FutureTask.java:166)

  java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)

  java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)

  java.util.concurrent.FutureTask.run(FutureTask.java:166)

  java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)

  java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)

  java.lang.Thread.run(Thread.java:722)

  (Number of retries : 1)

  Truncate Table OPI_OBIA_W_BOM_HEADER_DS

  2016-11-21 09:27:32.294 TRUNCATE TABLE:OPI_OBIA_W_BOM_HEADER_DS:"Table Action: Override OPI truncate command" template has finished execution with Failed status.

  ------------------------------

(Failed)

  Drop Batch

  ------------------------------

  DROP INDEX:W_BOM_ITEM_FS:W_BOM_ITEM_FS_M1

  ------------------------------

  Not Executed

  ------------------------------

  ------------------------------

  DROP INDEX:W_BOM_HEADER_DS:W_BOM_HEADER_DS_U1

  ------------------------------

  Not Executed

  ------------------------------

(Queued)

  Group Pause Batch

  ------------------------------

  PAUSE

  ------------------------------

  Not Executed

  ------------------------------

(Queued)

  Create Index Batch

  ------------------------------

  CREATE INDEX:W_BOM_ITEM_FS:W_BOM_ITEM_FS_M1

  ------------------------------

  Not Executed

  ------------------------------

  ------------------------------

  CREATE INDEX:W_BOM_HEADER_DS:W_BOM_HEADER_DS_U1

  ------------------------------

  Not Executed

  ------------------------------

(Queued)

  Analyze Table Batch

  ------------------------------

  ANALYZE TABLE:W_BOM_ITEM_FS

  ------------------------------

  Not Executed

  ------------------------------

  ------------------------------

  ANALYZE TABLE:W_BOM_HEADER_DS

  ------------------------------

  Not Executed

  ------------------------------

  ------------------------------

  ANALYZE TABLE:OPI_OBIA_W_BOM_HEADER_DS:"Table Action: Override OPI truncate command" template

  ------------------------------

  Not Executed

  ------------------------------

(Queued)

CAn anyone let us know if we are missing anything.

Thanks.

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner 
    3351264 wrote:apps.OPI_OBIA_BOMPEXPL_WRAPPER_P.TRUNCATE_W_BOM_HEADER_DS('OPI')ORA-06576: not a valid function or procedure name

    Have you checked that function on the database and its usage in the context of the load itself? I.e. how it's called, is it there/valid/functioning/accessible in terms of rights?

  • Gbenga Ajakaye
    Gbenga Ajakaye Rank 5 - Community Champion

    Check to make sure that apps.OPI_OBIA_BOMPEXPL_WRAPPER_P.TRUNCATE_W_BOM_HEADER_DS('OPI') exists.

      Error: MESSAGE:::ORA-06576: not a valid function or procedure name
  • Gbenga Ajakaye
    Gbenga Ajakaye Rank 5 - Community Champion

    This thread might help;