OPPM Is Not Generating Alerts For All Intended Recipients (Doc ID 1923508.1)

Last updated on JULY 21, 2017

Applies to:

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

Symptoms

On OPPM 9.0 SP1, after running for a brief period (approx a week) some recipients for email alerts fail to be added to outgoing emails (while collaboration email still remains functional).

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

psEventHandler.psTriggerSendEmail.addRecipient: failure
&ltException&gt
System.Transactions.TransactionException: The operation is not valid for the state of the transaction. ---&gt System.TimeoutException: Transaction Timeout
  --- End of inner exception stack trace ---
  at System.Transactions.TransactionState.EnlistPromotableSinglePhase(InternalTransaction tx, IPromotableSinglePhaseNotification promotableSinglePhaseNotification, Transaction atomicTransaction)
  at System.Transactions.Transaction.EnlistPromotableSinglePhase(IPromotableSinglePhaseNotification promotableSinglePhaseNotification)
  at System.Data.SqlClient.SqlInternalConnection.EnlistNonNull(Transaction tx)
  at System.Data.ProviderBase.DbConnectionInternal.ActivateConnection(Transaction transaction)
  at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
  at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
  at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
  at System.Data.SqlClient.SqlConnection.Open()
  at ProSight.Portfolios.Infrastructure.Database.psConnection.getConnection()
  at ProSight.Portfolios.Infrastructure.Database.psCommand.openConnection()
  at ProSight.Portfolios.Infrastructure.Database.psCommand.getDataTableAddToDataSet(DataSet iDataSet, String iNewTableName, Int32 iTableIndex)
  at ProSight.Portfolios.Infrastructure.Database.psCommand.getDataTable()
  at ProSight.Portfolios.BusinessLogic.Infrastructure.Caches.Objects.psCSHUser.getObject(Int32 iID)
  at ProSight.Portfolios.BusinessLogic.Infrastructure.Caches.psUsersCache.getImp(Int32 iID)
  at ProSight.Portfolios.BusinessLogic.Infrastructure.Caches.psUsersCache.get(Int32 iID)
  at ProSight.Portfolios.Services.Service.psEventHandler.psTriggerSendEmail.addRecipient(psRecipient iRecipient)
&lt/Exception&gt



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Allow the system to run and alert conditions to be met.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, critical notifications are not being sent to all users.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms