My Oracle Support Banner

CS-ECM Batch Fail At Correlation Task (Doc ID 2738393.1)

Last updated on DECEMBER 21, 2020

Applies to:

Oracle Financial Services Enterprise Case Management - Version 8.0.7 and later
Information in this document applies to any platform.

Symptoms

On : 8.0.7 version, Web UI

ACTUAL BEHAVIOR
---------------
CS-ECM batch fail at correlation task

Hi team,

It is failing in one task (task 42) DT_Correlation 



Batch Name is:::ORACLECS
java.sql.SQLException: ORA-20007: ORA-06512: at "BADR_ATOM.PKG_CORRELATION", line 575
ORA-06512: at "BADR_ATOM.PKG_CORRELATION", line 575
--> ORA-00922: missing or invalid option
ORA-06512: at "BADR_ATOM.PKG_CORRELATION", line 687
ORA-06512: at "BADR_ATOM.PKG_CORRELATION", line 2223
ORA-06512: at line 1

at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494)
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:223)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:56)
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:907)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1119)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3780)
at oracle.jdbc.driver.T4CCallableStatement.executeInternal(T4CCallableStatement.java:1300)
at oracle.jdbc.driver.OraclePreparedStatement.executeLargeUpdate(OraclePreparedStatement.java:3865)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3845)
at oracle.jdbc.driver.OracleCallableStatement.executeUpdate(OracleCallableStatement.java:4253)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1061)
at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:87)
at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:87)
at com.ofss.ecm.corelation.execution.InitiateCorelation.preExecution(InitiateCorelation.java:180)
at com.ofss.ecm.corelation.execution.InitiateCorelation.main(InitiateCorelation.java:113)
Caused by: Error : 20007, Position : 0, Sql = BEGIN pkg_correlation.proc_corr_init (:1 ,:2 ,:3 ,:4 ); END;, OriginalSql = {call pkg_correlation.proc_corr_init (?,?,?,?)}, Error Msg = ORA-20007: ORA-06512: at "BADR_ATOM.PKG_CORRELATION", line 575
ORA-06512: at "BADR_ATOM.PKG_CORRELATION", line 575

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.