CTR Scenario Threshold load issue using sm_load.sh
(Doc ID 2828207.1)
Last updated on MAY 24, 2023
Applies to:
Oracle Financial Services Behavior Detection Platform - Version 8.0 and laterInformation in this document applies to any platform.
Symptoms
SM_LOAD is throwing below error
./sm_load.sh scenario
Starting up...
Connecting to database (jdbc:oracle:thin:@lxcncl3-scan:1521/svc_ofcncd03798_fccm)...
Reading item list file...
Loading CTR-BSACTR(118745202)
INFO: Scenario 118745202 is missing threshold <Include_State_code> in the non-base threshold set 118861482. Threshold is being added, use Admin Tools to set your desired value.
java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (OFSAAFCCM.PK_790) violated
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:225)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:53)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:943)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1150)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:4798)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:4875)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1361)
at com.mantas.dbtools.util.SMPostLoadVerify.chkTshldSets(Unknown Source)
at com.mantas.dbtools.util.SMPostLoadVerify.startCheck(Unknown Source)
at com.mantas.dbtools.util.SMXMLExecutor.loadMetadata(Unknown Source)
at com.mantas.dbtools.util.SMXMLExecutor.loadFromCommandLine(Unknown Source)
at com.mantas.dbtools.util.SMXMLExecutor.main(Unknown Source)
Recreating views...
Load successful
Done
$
In load.log below error
2021-12-03 08:06:27,901 [main] DEBUG LOAD - Message 265208: Updated threshold set parameter
2021-12-03 08:06:27,901 [main] DEBUG LOAD - Message 265209: Copied job dataset bindings
2021-12-03 08:06:27,921 [main] INFO LOAD - Message 280009: Scenario 118745202 missed threshold "Include_State_code" in the not-base threshold set 118861482
2021-12-03 08:06:27,957 [main] FATAL LOAD - Message 265060: Error during execution. Error : java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (OFSAAFCCM.PK_790) violated
Module : Checking threshold sets.
2021-12-03 08:06:27,972 [main] INFO LOAD - Message 265109: Successfully loaded scenario catalog ID CTR-BSACTR, scenario ID 118745202
2021-12-03 08:06:28,009 [main] DEBUG LOAD - Message 265003: View SQL is: --Sub Rule for Conductor Entity Display Name and Entity Display ID
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 |