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.