Error "ORA-00955: Name Is Already Used by an Existing Object" When Trying to Clean Up Duplicate Cell Values
(Doc ID 2304586.1)
Last updated on JULY 23, 2023
Applies to:
Primavera Portfolio Management - Version 15.1.1.0 and laterInformation in this document applies to any platform.
Symptoms
When attempting to cleanup database (duplicate data removal),
the following error occurs.
ERROR
-----------------------
Cleanup failed.
<Trace Type="Error" Time="4/3/2017 11:42:2.044" Class="DeleteData"
Method="deleteDataInNewThread" Process="psDatabaseCleanup.exe (4640)"
Client="">
Failed to cleanup database
<Exception>
Oracle.DataAccess.Client.OracleException ORA-00955: name is already used by
an existing object at
Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode,
OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object
src, String procedure, Boolean bCheck)
at Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode,
OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx*
pOpoSqlValCtx, Object src, Boolean bCheck)
at Oracle.DataAccess.Client.OracleCommand.ExecuteNonQuery()
at ProSight.Portfolios.Infrastructure.Database.psCommand.update()
at
ProSight.Portfolios.BusinessLogic.Infrastructure.Objects.psCellObj.createStagi
ngTable()
at
ProSight.Portfolios.Application.psDatabaseCleanup.DeleteData.deleteDataInNewTh
read()
</Exception>
</Trace>
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Start up OPPM console.
2. Click button “cleanup" and login, then choose "Define clean".
3. Choose option ”Duplicate cell values".
4. Click button "Run Cleanup".
BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot clean up duplicate value.
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 |