My Oracle Support Banner

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

Last updated on APRIL 24, 2023

Applies to:

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


Failed while following the post installation step mentioned in 32890399

[FCCMIQA@lapprib00001q12 bin]$ ./ 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(
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 Problem: The file was loaded, but 1 out of 4 views failed to create. See the log for more information.
*** 1 files


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.