Object Registration Failing With ORA-00955: Name Is Already Used By An Existing Object Errors
(Doc ID 2604287.1)
Last updated on MAY 10, 2023
Applies to:
Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.7 and laterInformation 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)
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)
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
Changes
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 |
| Changes |
| Cause |
| Solution |
| References |