Task45 failed with ORA-00001: unique constraint (PK_446) violated (Doc ID 2803363.1)

Last updated on NOVEMBER 28, 2022

Applies to:

Symptoms

Task 45 which is inserting data from DERIVED_ADDRESS_ARC to  FCC_DERIVED_ADDRESS_EVNT has been failed.

Error in Task log.

Query to get Runskey>>select N_RUN_SKEY from FCC_BATCH_RUN where V_BATCH_RUN_ID = ?
setString(1, ECMINFO_*)
2021/08/04 11:55:02:::runskey::15305
2021/08/04 11:55:02:::filters::"$RUNSKEY"="15305"[]"$MISDATE"="to_date(^20210803^,^yyyyMMdd^)"
2021/08/04 11:55:02:::sql:::{call PKG_FCC_DM.FccDMSameDBSepSchemaDI(?, ?, ?,?)}
2021/08/04 11:55:02:::sourceName::prd_ofsaafccmdataMovementCode::BD_DERIVED_ADDRESS_EVNT::runskey::15305::filters::"$RUNSKEY"="15305"[]"$MISDATE"="to_date(^20210803^,^yyyyMMdd^)"
java.sql.SQLException: ORA-20106: Insert into final target table failed
ORA-06512: at "PRD_OFSAAECM.PKG_FCC_DM", line 260
ORA-06512: at line 1

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.T4CCallableStatement.doOall8(T4CCallableStatement.java:220)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:48)
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:938)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1150)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:4798)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:4901)
at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:5631)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1385)
at org.apache.commons.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:198)
at org.apache.commons.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:198)
at com.ofs.aai.fcc.datamovement.dao.DataMigrationExternalDAO.moveDataFromSeparteSourceSamefDB(DataMigrationExternalDAO.java:144)
at com.ofs.aai.fcc.datamovement.service.DataMovementService.moveDataFromSeparteSourceSameDB(DataMovementService.java:125)
at com.ofs.aai.fcc.datamovement.client.DMClient.main(DMClient.java:115)
2021/08/04 11:55:04:::result:::1

Error in FCC_DM_ERROR_DETAILS Table.
ORA-00001: unique constraint (PK_446) violated.

PK_446 is  combination of below fields which is PK of FCC_DERIVED_ADDRESS_EVNT table.
MIS_DATE
DATA_ORIGIN
DERVD_ADDR_SEQ_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.