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:

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
&ltException&gt
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()
&lt/Exception&gt
</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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.