CTR Scenario Threshold load issue using sm_load.sh (Doc ID 2828207.1)

Last updated on MAY 24, 2023

Applies to:

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

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