My Oracle Support Banner

Object Registration Failing With ORA-00955: Name Is Already Used By An Existing Object Errors (Doc ID 2604287.1)

Last updated on MARCH 12, 2021

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.7 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Oracle Financial Services Analytical Applications (OFSAA)
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)
CA Erwin Data Model
Model Upload

Symptoms

On OFSAAI 8.0.7.2.0, when trying to update the UDP (User Defined Property) = Yes for several columns on Super Entity Table, model upload completes successfully, but object registration is failed. From the model upload log:

ERROR

MODEL UPLOAD COMPLETED AT Wed Oct 23 13:51:10 EDT 2019
----------------------------------------------
----------------------------------------------
OBJECT REGISTRATION STARTED AS PART OF MODEL UPLOAD AT Wed Oct 23 13:51:10 EDT 2019
----------------------------------------------
Error while executing the query Failed Executing Batch: error occurred during batching: ORA-00955: name is already used by an existing object

Error- Error while executing the queryFailed Executing Batch: error occurred during batching: ORA-00955: name is already used by an existing object

Object Registration Failed.

[23-10-19 17:51:13,657 GMT PM] [ERROR] [APP] [ETL] [NA] [CLSUCNTUPLOADHANDLER]
com.iflex.fic.etl.UploadModel.cnt.ModelUploadException
at com.iflex.fic.etl.UploadModel.cnt.ClsUCntUploadHandler.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:211)
at com.iflex.fic.newservice.DynamicServiceManager.provideService(DynamicServiceManager.java:299)
at com.iflex.fic.ficserver.JavaRequestHandler.handleRequest(JavaRequestHandler.java:546)
at com.iflex.fic.ficserver.JavaSocketConnection.run(JavaSocketConnection.java:206)

Attempts to rerun Object Registration from the backend: ./RegisterObjects.sh have given the same error.

SMSService-X.log files do not show the statement triggering the error even though logging is enabled in DynamicServices.xml with LOGGERLEVEL="0".

The issue can be reproduced at will with the following steps:
1. Made the following updates under TP_BASIC_REQ in the Erwin Data Model

CHARGE_CREDIT_TRATE
CHARGE_CREDIT_TRATE_REM_TERM
UDP Property Updated to "YES" for : Base TP Charge Credit

LIQUIDITY_PREM_CHARGE_CREDIT
UDP Property Updated to "YES" for : Liquidity Prem Charge Credit

BASIS_RISK_CHARGE_CREDIT
UDP Property Updated to "YES" for : Basis Risk Charge Credit

PRICING_INC_CHARGE_CREDIT
UDP Property Updated to "YES" for : Pricing Inc Charge Credit

OTHER_ADJ_CHARGE_CREDIT
UDP Property Updated to "YES" for : Other Adj Charge Credit

2. Attempt to run Model Upload
3. Try to run Object Registration

./RegisterObjects.sh > regobj.log

4. In a separate console:

tail -f SMSService.log

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.