"ORA-03113: end-of-file on communication channel" Error Causes Functions to Stop (Doc ID 1301895.1)

Last updated on JANUARY 17, 2017

Applies to:

Primavera Portfolio Management - Version 8.0 SP2 and later
Oracle Database - Enterprise Edition - Version 10.2.0.4 and later
Information in this document applies to any platform.
Checked for currency on 20-Aug-2012

Symptoms

PPM functions appear stuck
Calculations not processing

Errors in ProSight log:

<Trace Type="Error" Time="3/7/2011 0:34:41.770" Class="psTransactionalScenarioInterface" Method="handleException" Process="prosightService.exe (8544)" Client="">
Error in psTSOem.Cell_GetMultipleCellValues
&ltException&gt
Oracle.DataAccess.Client.OracleException ORA-03113: end-of-file on communication channel at ProSight.Portfolios.BusinessLogic.TS.TransactionalScenarioInterface.psTransactionalScenarioInterface.shouldRetry(Exception iEx, Int32 iRetries, Int32 iMaxRetries)
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
</Trace>
<Trace Type="Error" Time="3/7/2011 0:35:1.214" Class="psFunctionDispatcher" Method="run" Process="prosightFunctions.exe (8516)" Client="">
Error in function dispatcher execution loop.
&ltException&gt
ProSight.Portfolios.Infrastructure.Exceptions.psDataManagerSyncFailureException: could not read parameters for calculation (loosing current rank)!
at ProSight.Portfolios.FunctionEngine.FunctionDispatcher.psFunctionDispatcher.dispatchCells(psArrayList iCells, Int32 iFromIndex, Int32 iToIndex)
at ProSight.Portfolios.FunctionEngine.FunctionDispatcher.psFunctionDispatcher.run()
&lt/Exception&gt
</Trace>
<Trace Type="Error" Time="3/7/2011 0:35:4.901" Class="psDataReader" Method="readRequests" Process="prosightFunctions.exe (8516)" Client="">
Couldn't read request for cloned buffer
&ltException&gt
Oracle.DataAccess.Client.OracleException ORA-03113: end-of-file on communication channel at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure)
at Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src)
at Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
at Oracle.DataAccess.Client.OracleCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
at ProSight.Portfolios.Infrastructure.Database.psCommand.getDataReader()
at ProSight.Portfolios.BusinessLogic.Infrastructure.Objects.psDataObj.getCellAndSourcesCellsHistViaTemp(ICollection iCategories, psDateTime targetDate)
at ProSight.Portfolios.FunctionEngine.DataManager.psDataReader.readRequests(ParameterType iParameterType)
&lt/Exception&gt
</Trace>
<Trace Type="Error" Time="3/7/2011 0:35:4.979" Class="psFunctionDispatcher" Method="run" Process="prosightFunctions.exe (8516)" Client="">
Error in function dispatcher execution loop.
&ltException&gt
ProSight.Portfolios.Infrastructure.Exceptions.psDataManagerSyncFailureException: could not read parameters for calculation (loosing current rank)!
at ProSight.Portfolios.FunctionEngine.FunctionDispatcher.psFunctionDispatcher.dispatchCells(psArrayList iCells, Int32 iFromIndex, Int32 iToIndex)
at ProSight.Portfolios.FunctionEngine.FunctionDispatcher.psFunctionDispatcher.run()
&lt/Exception&gt
</Trace>

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