My Oracle Support Banner

Getting ORA-02290: Check Constraint (<ATOMIC SCHEMA>.ENSURE_JSON) Violated During Object Registration (Doc ID 2851682.1)

Last updated on MAY 12, 2022

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.1.1 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)

Symptoms

In OFSAAI 8.1.1, when running a Model Upload, the model upload portion completes successfully but the Object Registration fails with the errors below:

From the ETLService.log in $FIC_HOME/logs:

[25-01-22 20:43:53,991 GMT PM] [INFO ] [APP] [ETL] [NA] [DMMUPLOADHANDLER] Updating AAI_DMM_METADATA table records ...
[25-01-22 20:43:57,568 GMT PM] [ERROR] [APP] [ETL] [NA] [COMMONUTILS] Exception while inserting into AAI_DMM_METADATA table. ORA-02290: check constraint (<ATOMIC SCHEMA>.ENSURE_JSON) violated

and

[25-01-22 20:43:57,568 GMT PM] [ERROR] [APP] [ETL] [NA] [DMMUPLOADHANDLER] Failed to update records for AAI_DMM_METADATA table.
[25-01-22 20:43:57,569 GMT PM] [ERROR] [APP] [ETL] [NA] [DMMUPLOADHANDLER]
com.ofs.aai.dmm.jsonupload.exceptions.DMMException: failed to update records for AAI_DMM_METADATA table.
     at com.ofs.aai.dmm.jsonupload.handler.DMMUploadHandler.handleUpload(Unknown Source)
     at com.iflex.fic.metadata.services.ModelUploadServiceProvider.handleRequest(Unknown Source)
     at com.iflex.fic.newservice.ServiceProxy.invokeService(ServiceProxy.java:184)
     at com.iflex.fic.newservice.NewServiceMaster.provideService(NewServiceMaster.java:212)
     at com.iflex.fic.newservice.DynamicServiceManager.provideService(DynamicServiceManager.java:315)
     at com.iflex.fic.ficserver.JavaRequestHandler.handleRequest(JavaRequestHandler.java:546)
     at com.iflex.fic.ficserver.JavaSocketConnection.run(JavaSocketConnection.java:206)

From the nohup.out in $FIC_APP_HOME/common/FICServer/bin:

File Name Processing : FSI_AMORT_METHOD_MLS~81100.json
File Not Present In Destination..So Copying directly
File Name Processing : FSI_CONSOLIDATION_MLS~81100.json
File Not Present In Destination..So Copying directly
File Name Processing : FSI_GEOGRAPHIC_LOC_CD~81100.json
File Not Present In Destination..So Copying directly
java.sql.BatchUpdateException: ORA-02290: check constraint (OFSAA_ATOMIC.ENSURE_JSON) violated

       at oracle.jdbc.driver.OraclePreparedStatement.executeLargeBatch(OraclePreparedStatement.java:9711)
       at oracle.jdbc.driver.T4CPreparedStatement.executeLargeBatch(T4CPreparedStatement.java:1447)
       at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:9487)
       at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:237)
       at org.apache.commons.dbcp2.DelegatingStatement.executeBatch(DelegatingStatement.java:242)
       at org.apache.commons.dbcp2.DelegatingStatement.executeBatch(DelegatingStatement.java:242)
       at com.ofs.aai.dmm.jsonupload.utils.CommonUtils.insertIntoMetaDataTable(Unknown Source)
       at com.ofs.aai.dmm.jsonupload.handler.DMMUploadHandler.updateMetaDataTable(Unknown Source)
       at com.ofs.aai.dmm.jsonupload.handler.DMMUploadHandler.handleUpload(Unknown Source)
       at com.iflex.fic.metadata.services.ModelUploadServiceProvider.handleRequest(Unknown Source)
       at com.iflex.fic.newservice.ServiceProxy.invokeService(ServiceProxy.java:184)
       at com.iflex.fic.newservice.NewServiceMaster.provideService(NewServiceMaster.java:212)
       at com.iflex.fic.newservice.DynamicServiceManager.provideService(DynamicServiceManager.java:315)
       at com.iflex.fic.ficserver.JavaRequestHandler.handleRequest(JavaRequestHandler.java:546)
       at com.iflex.fic.ficserver.JavaSocketConnection.run(JavaSocketConnection.java:206)

From the Object Registration output:

Triggering Object Registartion through Json Entity...
java.lang.NullPointerException
     at com.ofs.aai.dmm.jsonupload.handler.DMMDDLScriptHandler.getExistingForeignKeyName(Unknown Source)
     at com.ofs.aai.dmm.jsonupload.handler.DMMObjectRegistrationHandler.populateTablesForObjectRegistration(Unknown Source)
     at com.ofs.aai.dmm.jsonupload.handler.DMMObjectRegistrar.handleObjectRegistration(Unknown Source)
     at UploadModel.ObjectRegistrationUtility.upload(Unknown Source)
     at UploadModel.ObjectRegistrationUtility.main(Unknown Source)
java.lang.NullPointerException
     at com.ofs.aai.dmm.jsonupload.handler.DMMObjectRegistrationHandler.getQueryForReferentialConstraints(Unknown Source)
     at com.ofs.aai.dmm.jsonupload.handler.DMMObjectRegistrationHandler.populateTablesForObjectRegistration(Unknown Source)
     at com.ofs.aai.dmm.jsonupload.handler.DMMObjectRegistrar.handleObjectRegistration(Unknown Source)
     at UploadModel.ObjectRegistrationUtility.upload(Unknown Source)
     at UploadModel.ObjectRegistrationUtility.main(Unknown Source)
Object Registartion failed...


You ran the Model Upload successfully in previous months.

Cause

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
Symptoms
Cause
Solution
References


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