My Oracle Support Banner

CTR Scenario Threshold load issue using (Doc ID 2828207.1)

Last updated on MAY 24, 2023

Applies to:

Oracle Financial Services Behavior Detection Platform - Version 8.0 and later
Information in this document applies to any platform.


SM_LOAD is throwing below error

./ 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(
at oracle.jdbc.driver.T4CTTIoer.processError(
at oracle.jdbc.driver.T4C8Oall.processError(
at oracle.jdbc.driver.T4CTTIfun.receive(
at oracle.jdbc.driver.T4CTTIfun.doRPC(
at oracle.jdbc.driver.T4C8Oall.doOALL(
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(
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

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


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

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