My Oracle Support Banner

Object Registration Hung During Data Model Upload (Doc ID 2650382.1)

Last updated on MARCH 24, 2020

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.2 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Oracle Financial Services Profitability Management (PFT)
Oracle Financial Services Funds Transfer Pricing (FTP)
Oracle Financial Services Asset Liability Management (ALM)
Oracle Financial Services Enterprise Performance Management (EPM)
Object Registration

Symptoms

On OFSAA 8.0.2, it seems model upload is hanging during Object Registration.  The model upload log ends as follows:


MODEL UPLOAD COMPLETED AT Wed Feb 12 22:26:00 PST 2020
----------------------------------------------
----------------------------------------------
OBJECT REGISTRATION STARTED AS PART OF MODEL UPLOAD AT Wed Feb 12 22:26:00 PST 2020
----------------------------------------------

After copying good <INFODOM>_database.xml and restarting the model upload it again (per steps Document 2339356.1 Object Registration Failed - ORA-01400 Cannot Insert Null Into (REV_TAB_REF_CONSTRAINTS.CONSTRAINT_NAME), it is still stuck on Object registration.

Upon executing ./RegisterObjects.sh below error appears:

ERROR

Triggering Object Registration ......................................
Picked up JAVA_TOOL_OPTIONS: -Xss2m
Feb 20,20 11:03:01 : [SMSSERVICES]Error occurred while getting MASTER DSN Name
java.lang.Exception: Error occurred while getting MASTER DSN Name
  at com.iflex.fic.client.SMSServices.getMasterDSN(SMSServices.java:106)
  at com.iflex.fic.ficml.JSPInitBean.defaultInitialize(JSPInitBean.java:225)
  at UploadModel.ObjectRegistrationUtility.main(ObjectRegistrationUtility.java:91)

During run of ./RegisterObjects.sh post model uplad, the SMSService.log shows the following error:

[UMMLOG] Feb 13,20 13:53:04 : [DACDATABASEGATEWAY]Failed Executing Batch: error occurred during batching: ORA-01400: cannot insert NULL into ("<ATOMIC_SCHEMA>"."REV_TAB_REF_CONSTRAINTS"."CONSTRAINT_NAME")

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.