My Oracle Support Banner

OPPM Database Cleanup Utility (Utilizing the Delete Duplicates Mode) Failed To Run To Complete (Doc ID 2865754.1)

Last updated on OCTOBER 19, 2023

Applies to:

Primavera Portfolio Management - Version 19.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to run the OPPM Database Cleanup Utility (Utilizing the Delete Duplicates Mode),
the following error occurs.

ERROR
-----------------------

Error in psTSDatabaseCleanup.deleteDuplicateCellsForCategory
&ltException&gt
System.Transactions.TransactionAbortedException: The transaction has aborted. ---&gt System.TimeoutException: Transaction Timeout
  --- End of inner exception stack trace ---
  at System.Transactions.TransactionStateAborted.BeginCommit(InternalTransaction tx, Boolean asyncCommit, AsyncCallback asyncCallback, Object asyncState)
  at System.Transactions.CommittableTransaction.Commit()
  at System.Transactions.TransactionScope.InternalDispose()
  at System.Transactions.TransactionScope.Dispose()
  at ProSight.Portfolios.Infrastructure.Misc.psTransactionScope.Dispose()
  at ProSight.Portfolios.BusinessLogic.TS.TransactionalScenarioInterface.psTransactionalScenarioInterface.invokeTS(String className, String methodName, Object[] parameters, Int32 maxRetries, Int32 minRetryWait, psResultContainer containerToClean, Boolean iDisableTransaction)
&lt/Exception&gt


Failed to cleanup database
&ltException&gt
System.Transactions.TransactionAbortedException: The transaction has aborted. ---&gt System.TimeoutException: Transaction Timeout
  --- End of inner exception stack trace ---
  at ProSight.Portfolios.BusinessLogic.TS.TransactionalScenarioInterface.psTransactionalScenarioInterface.handleException(Exception iEx, String iAddionalMsg)
  at ProSight.Portfolios.BusinessLogic.TS.TransactionalScenarioInterface.psTransactionalScenarioInterface.invokeTS(String className, String methodName, Object[] parameters, Int32 maxRetries, Int32 minRetryWait, psResultContainer containerToClean, Boolean iDisableTransaction)
  at ProSight.Portfolios.BusinessLogic.TS.TransactionalScenarioInterface.psTransactionalScenarioInterface.invokeTS(String className, String methodName, Object[] parameters, Int32 maxRetries, Int32 minRetryWait, psResultContainer containerToClean)
  at ProSight.Portfolios.BusinessLogic.TS.TransactionalScenarioInterface.psTSIDatabaseCleanup.deleteDuplicateCellsForCategory(Int32 iUserId, Int32 iCategoryId, String registryKeyValue)
  at ProSight.Portfolios.Application.psDatabaseCleanup.DeleteData.deleteDataInNewThread()
&lt/Exception&gt

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


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