OBIA: Error: 'ANOMALY INFO::: Error while executing : TRUNCATE TABLE:OPI_OBIA_W_BOM_HEADER_DS:' whilst Running the BOM (Bill of Materials) Subject Area (Doc ID 1406226.1)

Last updated on FEBRUARY 01, 2017

Applies to:

Business Intelligence Server Administrator - Version 11.1.1.5.0 [1308] and later
Information in this document applies to any platform.
March 2016

Symptoms

The DAC process failed whilst running the BOM (Bill of Materials) Subject Area with the following error:

2012-02-02 02:00:44.76 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_R1211)
Call apps.OPI_OBIA_BOMPEXPL_WRAPPER_PKG.do_sql('TRUNCATE TABLE OPI.OPI_OBIA_W_BOM_HEADER_DS')

"Truncate OPI" failed on "ORA_R1211"
sql: Call apps.OPI_OBIA_BOMPEXPL_WRAPPER_PKG.do_sql('TRUNCATE TABLE OPI.OPI_OBIA_W_BOM_HEADER_DS')
Error: MESSAGE:::ORA-06576: not a valid function or procedure name

EXCEPTION CLASS::: java.sql.SQLException

oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:205)
oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1008)
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1307)
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)
oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3550)
oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374)
com.siebel.etl.database.cancellable.CancellablePreparedStatement.execute(CancellablePreparedStatement.java:84)
com.siebel.etl.engine.custom.SQLFileCommand.executeFineGrain(SQLFileCommand.java:733)
com.siebel.etl.engine.custom.SQLFileCommand.executeCustomSQLStructurePerConnection(SQLFileCommand.java:446)
com.siebel.etl.engine.custom.SQLFileCommand.executeCustomSQLStructure(SQLFileCommand.java:351)
com.siebel.etl.engine.custom.SQLFileCommand.doExecute(SQLFileCommand.java:254)
com.siebel.etl.command.MultiSourceSqlCommand.execute(MultiSourceSqlCommand.java:83)
com.siebel.analytics.etl.etltask.CreateIndexTaskWrapper.exerciseOverride(CreateIndexTaskWrapper.java:112)
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:411)
com.siebel.analytics.etl.etltask.GenericTaskImpl.execute(GenericTaskImpl.java:307)
com.siebel.analytics.etl.etltask.GenericTaskImpl.execute(GenericTaskImpl.java:214)
com.siebel.analytics.etl.etltask.GenericTaskImpl.run(GenericTaskImpl.java:586)
com.siebel.analytics.etl.taskmanager.XCallable.call(XCallable.java:63)
java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
java.util.concurrent.FutureTask.run(FutureTask.java:138)
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
java.util.concurrent.FutureTask.run(FutureTask.java:138)
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:885)
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907)
java.lang.Thread.run(Thread.java:619)

Execution of custom sql file failed.

EXCEPTION CLASS::: java.lang.Exception

com.siebel.analytics.etl.etltask.GenericTaskImpl.doExecuteWithRetries(GenericTaskImpl.java:450)
com.siebel.analytics.etl.etltask.GenericTaskImpl.execute(GenericTaskImpl.java:307)
com.siebel.analytics.etl.etltask.GenericTaskImpl.execute(GenericTaskImpl.java:214)

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms