1. Jon Tzeng
  2. PowerServer 2020 or older (Obsolete)
  3. Thursday, 10 February 2022 10:34 AM UTC

Hello,

Our PowerServer application gets AppeonWAShell message "Session is disconnected. Connect again?"  after the database SQL takes about 2 minutes 30 seconds. We are using PowerServer 2020, Oracle database 19, Dynamic Database Connection and Pooling setting with Maximum connection Pool Size 300, Minimum Connection Pool Size 1. Long connection setting is true on applications.config. 

I attached the error log. Is there any setting can be done to avoid?

 

 2022-02-09 14:24:39.430 : [Application name=ic_m20,conn cache=M20,SQLOrProcedure=]Failed to start new transaction due to System.InvalidOperationException: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.OracleClient.OracleConnection.Open()
at Appeon.Server.Services.DataService.EonDbConnection.Open()
at Appeon.Server.Services.TransactionServices.NoTransactionWrapper..ctor(EonDbConnection connection, String cacheName)
at Appeon.Server.Services.TransactionServices.TransactionFactory.CreateObject(PBTransactionProperties pbTrans, String connCache, Boolean isNeedTransaction)
at Appeon.Server.SessionManage.SessionAccessInfo.NewTransaction(String transactionName, Boolean isNeedTransaction, String sessionID)
at Appeon.Server.SessionManage.SessionAccessInfo.NewTransaction(String transactionName, Boolean isNeedTransaction, String sessionID)
at Appeon.Server.Commands.DWRetrieveCommand.ExecuteCommand()
2022-02-09 14:24:59.286 : [Application name=ic_m20,conn cache=M20,SQLOrProcedure=SELECT Statement ... FROM ...] Thread was being aborted.
at System.Data.Common.UnsafeNativeMethods.OCIStmtFetch(OciHandle stmtp, OciHandle errhp, UInt32 nrows, FETCH orientation, MODE mode)
at System.Data.OracleClient.OracleDataReader.ReadInternal()
at System.Data.OracleClient.OracleDataReader.Read()
at Appeon.Server.Services.DataService.EonDbDataReader.Read()
at Appeon.Server.Services.DataService.DataServiceUtil.OutputResultSet(DataWriter writer, EonDbDataReader dr, String pbVersion, CommandData commandData)
at Appeon.Server.Commands.DWRetrieveCommand.ExecuteOneDataObject(DataWriter writer, DataObject dataObject, Object wrapper, Nullable`1 lastModifyTime)
at Appeon.Server.Commands.DWRetrieveCommand.ExecuteDBDataObject(DataObject curDataObject)
at Appeon.Server.Commands.DWRetrieveCommand.ExecuteCommand()
2022-02-09 14:24:59.286 : Thread was being aborted.
at Appeon.Server.Commands.DWRetrieveCommand.ExecuteCommand()
at Appeon.Server.Commands.Command.ConstructAndExecute(CommandData commandData)
at Appeon.Server.Services.Controller.JRouterImpl.ExecuteInTransaction(CommandData commandData)
at Appeon.Server.Services.Controller.JRouterImpl.ExecuteCommand(HttpResponse response, CommandData superCommand, SessionAccessInfo session)
at Appeon.Server.Services.Controller.JRouterImpl.Call(Int32 clientType, Object requestData, Hashtable clientContext, String& outPutStream_Key)
2022-02-09 14:24:59.302 : Thread was being aborted.

Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Thursday, 10 February 2022 16:01 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 1

Hi Jon, Please open a support ticket for this particular issue.  Thanks!

Comment
There are no comments made yet.
mike S Accepted Answer Pending Moderation
  1. Thursday, 10 February 2022 17:12 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 2

you need to check your time out settings in AEM.  most likely it is that

 

there are also standard timeout settings for web sessions at the web server level.  IIS Web.config has these settings.  depends on what your web server is.

 

if you attended elevate 2018 i had listed these settings out in my presentation, and the presentation powerpoint is available for download for attendees.

Comment
  1. Jon Tzeng
  2. Thursday, 10 February 2022 17:23 PM UTC
Hi Mike,

Do you have the presentation available for me? Thank you.
  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.