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

Last updated on AUGUST 15, 2023

Applies to:

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

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