ORA-02089: "COMMIT is not allowed in a subordinate session" Error Occurs After Upgrading To OPPM 9.0 SP2HF1 (Doc ID 1923482.1)

Last updated on APRIL 07, 2017

Applies to:

Primavera Portfolio Management - Version 9.0 SP2 to 9.1.1.3 [Release 9.0]
Information in this document applies to any platform.

Symptoms

After upgrading to OPPM 9.0 SP2 HF1, while connected to Oracle RDBMS 10.2.0.5 via EZ Connect, the following error appears repeatedly in the Prosight logs

ERROR
-----------------------
Oracle.DataAccess.Client.OracleException ORA-02089: COMMIT is not allowed in a subordinate session
ORA-06512: at "PPM_DEV.PS_USP_TEMP_EVENTS_SUBS_INS", line 1
ORA-06512: at line 1 at ProSight.Portfolios.BusinessLogic.TS.TransactionalScenarioInterface.psTransactionalScenarioInterface.invokeTS(String className, String methodName, Object[] parameters, Int32 maxRetries, Int32 minRetryWait, psResultContainer containerToClean, Boolean iDisableTransaction)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Allow the application to run normally.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, action queue performance is poor.

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