My Oracle Support Banner

Remoting Container Service Crashes Periodically and P4P Will Redirect to Login Page (Doc ID 2604767.1)

Last updated on JUNE 10, 2020

Applies to:

Oracle Agile Product Lifecycle Management for Process - Version 6.2.1.0 and later
Information in this document applies to any platform.

Symptoms

Actual Behavior
Remoting Container service crashes every 1 or 2 week.
When Remoting Container crashes, after login to P4P, when accessing to specific module window for the first time it will redirect to login page again.

Error
Below errors are confirmed from Windows Event Error logs :

Unhandled Exception: System.Data.SqlClient.SqlException: Execution Timeout
Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception: The
wait operation timed out
  --- End of inner exception stack trace ---
  at Xeno.Data.XDataObjectTransaction.Commit()
  at Xeno.Prodika.Transaction.TransactionContextShared.Commit()
  at Xeno.Data.Transaction.TransactionContextProxy.Commit()
  at Oracle.PLM4P.SolutionPack.HierarchyDenorm.DetectorService.DenormRequestDetectorService.OnTimer(Object state)
  at System.Threading.ExecutionContext.RunInternal(ExecutionContextexecutionContext, ContextCallback callback, Object state, BooleanpreserveSyncCtx)


Application: RemotingContainer.exe
Framework Version: v4.0.30319
Description: The process was terminated due to an unhandled exception.
Exception Info: Oracle.DataAccess.Client.OracleException
  at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32, Oracle.DataAccess.Client.OracleConnection, IntPtr, Oracle.DataAccess.Client.OpoSqlValCtx*, System.Object, System.String, Boolean, Int32)
  at Oracle.DataAccess.Client.OracleException.HandleError(Int32, Oracle.DataAccess.Client.OracleConnection, IntPtr, System.Object)
  at Oracle.DataAccess.Client.OracleConnection.Open()



Exception Info: Xeno.Data.DataAccessException
  at Xeno.Data.XDataQueryIsolated.execute(System.String)
  at Oracle.PLM4P.SolutionPack.HierarchyDenorm.HierarchyDenormRuntimeConfigHelper.GetDenormRequestDetectorLastRunDate()
  at Oracle.PLM4P.SolutionPack.HierarchyDenorm.DetectorService.DetectorCheckpoint..ctor()
  at Oracle.PLM4P.SolutionPack.HierarchyDenorm.DetectorService.DenormRequestDetectorService.OnTimer(System.Object)
  at System.Threading.ExecutionContext.RunInternal(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean)




Steps
The issue can be reproduced at will with the following steps:
1. Start the Remoting Container Service

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


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