My Oracle Support Banner

"ORA-00001: unique constraint (ERM_BASEL52ATM.PK_DQ_CHECK_MASTER) violated" in ETLService.log (Doc ID 2532178.1)

Last updated on JUNE 27, 2021

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version to 8.0.4 [Release 7 to 8]
Information in this document applies to any platform.


Unable to create new DQ rule due to sequence id's unique constraint error 

Below error can be seen in ETLService.log


java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (ERM_BASEL52ATM.PK_DQ_CHECK_MASTER) 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.executeForRows( 



Capital Adequacy Pack/Basel  Solution is installed in the environment


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.