SM_LOAD Is Throwing Error While Applying The Patch - 32890399 (Doc ID 2851559.1)

Last updated on APRIL 24, 2023

Applies to:

Symptoms

Failed while following the post installation step mentioned in 32890399

[FCCMIQA@lapprib00001q12 bin]$ ./sm_load.sh scenario
Starting up...
Connecting to database (jdbc:oracle:thin:@****:1521/sv***l)...
Reading item list file...
Loading CTR-BSACTR(118745200)
INFO: Scenario 118745200 is missing threshold <Trxn_Loc_Id_Lst> in the non-base threshold set 118861430. 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 Problem: The file was loaded, but 1 out of 4 views failed to create. See the log for more information.
Done
*** 1 files

Cause

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