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:
Oracle Financial Services Analytical Applications Infrastructure - Version 8.1.1 and laterInformation 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 |