0

Hi All, We are facing an issue on the application after the migration of the database, for application it is just a database connection details got changed. Application comes up without any issues and we are able to login and perform operations. However if we leave session idle for sometime and the session is automatically removed, and then we try to relogin we get exceptions in the logs, and a blank application screen comes up. We checked with DBA team and they don't see any issues in the DB logs. Could you please help us investigate this. 2019-11-29 15:39:51.195 ERROR - Connector: An error has occurred while handling the request. [User 'sheik500' with session id '3b43e816-367e-4dbf-ace0-95364263942d' and roles 'Transmission_Maintainer, Administrator, TransmissionStatus_Maintainer, MxAdmin, Transmission_Administrator'] 2019-11-29 15:39:51.195 ERROR - Connector: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.core.CoreRuntimeException: Exception occurred in action '{"xpath":"//MaintainHardware.Site[id=\"20266198323189033\"]","amount":0,"depth":0,"offset":0,"sort":{"NumberSorting":"asc"},"type":"RetrieveXPathAction"}', all database changes executed by this action were rolled back     at com.mendix.basis.actionmanagement.ActionManager.executeSync(ActionManager.java:195) Caused by: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.core.CoreRuntimeException: Exception occurred in action '{"xpath":"//MaintainHardware.Site[id=\"20266198323189033\"]","amount":0,"depth":0,"offset":0,"sort":{"NumberSorting":"asc"},"type":"RetrieveXPathAction"}', all database changes executed by this action were rolled back     at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:37) Caused by: com.mendix.core.CoreRuntimeException: Exception occurred in action '{"xpath":"//MaintainHardware.Site[id=\"20266198323189033\"]","amount":0,"depth":0,"offset":0,"sort":{"NumberSorting":"asc"},"type":"RetrieveXPathAction"}', all database changes executed by this action were rolled back     at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.processErrorState(CoreActionHandlerImpl.scala:155) Caused by: java.util.concurrent.ExecutionException: com.mendix.basis.connectionbus.ConnectionBusException: Exception occurred while retrieving data.     at java.util.concurrent.FutureTask.report(FutureTask.java:122)     at java.util.concurrent.FutureTask.get(FutureTask.java:192)     at com.mendix.connectionbus.retrieve.dependentexecutions.QueryExecution$$anonfun$1.apply(QueryExecution.scala:20)     at com.mendix.connectionbus.retrieve.dependentexecutions.QueryExecution$$anonfun$1.apply(QueryExecution.scala:20)     at scala.collection.immutable.List.map(List.scala:284)     at com.mendix.connectionbus.retrieve.dependentexecutions.QueryExecution.getAndMergeResult$1(QueryExecution.scala:20)     at com.mendix.connectionbus.retrieve.dependentexecutions.QueryExecution.getDataSet(QueryExecution.scala:29)     at com.mendix.connectionbus.retrieve.dependentexecutions.AssociationDataRetriever.handleQueryResult(AssociationDataRetriever.java:156)     at com.mendix.connectionbus.retrieve.dependentexecutions.AssociationDataRetriever.executeQueriesPerQueryInstance(AssociationDataRetriever.java:114)     at com.mendix.connectionbus.retrieve.dependentexecutions.AssociationDataRetriever.executeQueryInstances(AssociationDataRetriever.java:89)     at com.mendix.connectionbus.retrieve.dependentexecutions.AssociationDataRetriever.executeQueries(AssociationDataRetriever.java:62)     at com.mendix.connectionbus.retrieve.dependentexecutions.AssociationDataRetriever.executeAssociationQueries(AssociationDataRetriever.java:36)     at com.mendix.connectionbus.retrieve.dependentexecutions.DependentDataRetriever.executeQueries(DependentDataRetriever.java:47)     at com.mendix.connectionbus.retrieve.DataStoreCaller.executeQueries(DataStoreCaller.java:236)     at com.mendix.connectionbus.retrieve.DataStoreCaller.executeQueries(DataStoreCaller.java:197)     at com.mendix.connectionbus.retrieve.DataStoreCaller.getResult(DataStoreCaller.java:78)     at com.mendix.connectionbus.retrieve.GetRequestHandler.doRequest(GetRequestHandler.java:78)     at com.mendix.connectionbus.RequestAnalyzer.doRequest(RequestAnalyzer.java:48)     at com.mendix.connectionbus.ConnectionBusImpl.doRequest(ConnectionBusImpl.java:450)     at com.mendix.basis.action.user.RetrieveXPathRawAction.retrieveXPathRaw(RetrieveXPathRawAction.java:123)     at com.mendix.basis.action.user.RetrieveXPathRawAction.executeAction(RetrieveXPathRawAction.java:69)     at com.mendix.basis.action.user.RetrieveXPathAction.executeAction(RetrieveXPathAction.java:49)     at com.mendix.basis.action.user.RetrieveXPathAction.executeAction(RetrieveXPathAction.java:17)     at com.mendix.systemwideinterfaces.core.UserAction.execute(UserAction.java:50)     at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.doCall(CoreActionHandlerImpl.scala:76)     at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.call(CoreActionHandlerImpl.scala:55)     at com.mendix.core.actionmanagement.CoreAction.call(CoreAction.java:51)     at com.mendix.basis.actionmanagement.ActionManager$1.execute(ActionManager.java:186)     at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:33)     at com.mendix.basis.actionmanagement.ActionManager.executeSync(ActionManager.java:191)     at com.mendix.basis.component.InternalCore.retrieveXPathQuery(InternalCore.java:1369)     at com.mendix.basis.component.InternalCore.retrieveXPathQuery(InternalCore.java:1335)     at com.mendix.basis.component.InternalCore.retrieveXPathQuery(InternalCore.java:1267)     at com.mendix.webui.actions.client.ExecuteAction.getObjectsForSet(ExecuteAction.java:214)     at com.mendix.webui.actions.client.ExecuteAction.execute(ExecuteAction.java:106)     at com.mendix.webui.requesthandling.ClientRequestHandler$$anonfun$handleRequest$1.apply$mcV$sp(ClientRequestHandler.scala:328)     at com.mendix.webui.requesthandling.ClientRequestHandler$$anonfun$handleRequest$1.apply(ClientRequestHandler.scala:313)     at com.mendix.webui.requesthandling.ClientRequestHandler$$anonfun$handleRequest$1.apply(ClientRequestHandler.scala:313)     at com.mendix.basis.actionmanagement.IMonitoredAction$$anon$1.execute(IMonitoredAction.scala:47)     at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:33)     at com.mendix.basis.actionmanagement.IMonitoredAction$class.monitor(IMonitoredAction.scala:49)     at com.mendix.webui.requesthandling.ClientRequestHandler$ClientMonitoredAction.monitor(ClientRequestHandler.scala:431)     at com.mendix.webui.requesthandling.ClientRequestHandler.handleRequest(ClientRequestHandler.scala:313)     at com.mendix.webui.requesthandling.ClientRequestHandler.handleActionWithSessionRequired(ClientRequestHandler.scala:251)     at com.mendix.webui.requesthandling.ClientRequestHandler.handleAction(ClientRequestHandler.scala:218)     at com.mendix.webui.requesthandling.ClientRequestHandler.liftedTree1$1(ClientRequestHandler.scala:104)     at com.mendix.webui.requesthandling.ClientRequestHandler.processRequest(ClientRequestHandler.scala:96)     at com.mendix.externalinterface.connector.RequestHandler.doProcessRequest(RequestHandler.java:40)     at com.mendix.external.connector.MxRuntimeConnector$1.execute(MxRuntimeConnector.java:70)     at com.mendix.external.connector.MxRuntimeConnector$1.execute(MxRuntimeConnector.java:67)     at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:33)     at com.mendix.external.connector.MxRuntimeConnector.processRequest(MxRuntimeConnector.java:73)     at com.mendix.basis.impl.MxRuntimeImpl.processRequest(MxRuntimeImpl.java:858)     at com.mendix.m2ee.appcontainer.server.handler.RuntimeHandler.handle(RuntimeHandler.java:41)     at org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:52)     at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116)     at org.eclipse.jetty.server.Server.handle(Server.java:368)     at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:489)     at org.eclipse.jetty.server.AbstractHttpConnection.content(AbstractHttpConnection.java:953)     at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.content(AbstractHttpConnection.java:1014)     at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:861)     at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:240)     at org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:82)     at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:628)     at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:52)     at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:608)     at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:543)     at java.lang.Thread.run(Thread.java:748) Caused by: com.mendix.basis.connectionbus.ConnectionBusException: Exception occurred while retrieving data.     at com.mendix.connectionbus.connections.jdbc.JdbcDataStore.getCorrectException(JdbcDataStore.java:729) Caused by: java.lang.NegativeArraySizeException: null     at oracle.net.ano.CryptoNIONSDataChannel.readDataFromSocketChannel(Unknown Source)     at oracle.jdbc.driver.T4CMAREngineNIO.prepareForReading(T4CMAREngineNIO.java:98)     at oracle.jdbc.driver.T4CMAREngineNIO.unmarshalUB1(T4CMAREngineNIO.java:534)     at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:485)     at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252)     at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612)     at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:213)     at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:37)     at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:733)     at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:904)     at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1082)     at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1276)     at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:366)     at org.apache.commons.dbcp2.DelegatingStatement.executeQuery(DelegatingStatement.java:207)     at org.apache.commons.dbcp2.DelegatingStatement.executeQuery(DelegatingStatement.java:207)     at com.mendix.connectionbus.connections.jdbc.JdbcDataStore.execRetrieveQuery(JdbcDataStore.java:308)     at com.mendix.connectionbus.connections.jdbc.JdbcDataStore.execRetrieveQueries(JdbcDataStore.java:191)     at com.mendix.connectionbus.connections.jdbc.JdbcDataStore.retrieve(JdbcDataStore.java:155)     at com.mendix.connectionbus.connections.jdbc.JdbcDataStore.retrieve(JdbcDataStore.java:150)     at com.mendix.connectionbus.connections.DataStoreRetrieveAction.call(DataStoreRetrieveAction.java:29)     at com.mendix.connectionbus.connections.DataStoreRetrieveAction.call(DataStoreRetrieveAction.java:11)     at java.util.concurrent.FutureTask.run(FutureTask.java:266)     at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)     at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)     at java.lang.Thread.run(Thread.java:748)  

asked 2019-12-04

1 answers