Getting Following Errors In OPPM Logs And PIF (Integration) Job Has Started Failing (Doc ID 2787855.1)

Last updated on SEPTEMBER 23, 2021

Applies to:

Symptoms

When running PIF (Integration) jobs, they run very slowly and / or fail, and
the following error occurs.

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

Cell_GetChildrenMultipleCellValues failed
USERID: 1
DEADLOCK DETECTED: False

&ltException&gt
System.Threading.ThreadAbortException: Thread was being aborted.
  at Oracle.DataAccess.Client.OpsSql.ExecuteReader(IntPtr opsConCtx, IntPtr& opsErrCtx, IntPtr& opsSqlCtx, IntPtr& opsDacCtx, IntPtr& opsReaderErrCtx, IntPtr opsSubscrCtx, Int32& isSubscrRegistered, Int32 bchgNTFNExcludeRowidInfo, Int32 bQueryBasedNTFNRegistration, Int64& query_id, OpoSqlValCtx*& pOpoSqlValCtx, String pCommandText, OpoDacValCtx*& pOpoDacValCtx, IntPtr[] pOpoPrmValCtx, String[] ppOpoPrmRefCtx, OpoMetValCtx*& pOpoMetValCtx, Int32 NoOfParams)
  at Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
  at Oracle.DataAccess.Client.OracleDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
  at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
  at ProSight.Portfolios.Infrastructure.Database.psCommand.fillDataTable(IDbDataAdapter da, DataSet ds, Int32 iTableIndex, String iTableName)
  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.Objects.psCellObj.getScorecard


 

Cause

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