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 laterInformation 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
<Exception>
System.Transactions.TransactionAbortedException: The transaction has aborted. ---> 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)
</Exception>
Failed to cleanup database
<Exception>
System.Transactions.TransactionAbortedException: The transaction has aborted. ---> 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()
</Exception>
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 |