com.microsoft.sqlserver.jdbc.SQLServerException: Cannot set a savepoint when the AutoCommit mode is set to true.

0
Hello Community, I have upgraded my application from 6.10.4 version to 7.2.0 version modeler. I have resolved all errors during the process. Now I have changed my application database to SQL Server from default database(HSQL). While testing my application with different scenarios, I found that I am calling MF_FectchAccount microflow several times at single transaction, which will hit the database every time. In Console log, I am getting below errors. Please find the below errors and suggest me how I can resolve them. Error:- 1) com.mendix.systemwideinterfaces.MendixRuntimeException: org.codehaus.jackson.JsonGenerationException: Can not write a field name, expecting a value     at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:37) Caused by: org.codehaus.jackson.JsonGenerationException: Can not write a field name, expecting a value     at org.codehaus.jackson.impl.JsonGeneratorBase._reportError(JsonGeneratorBase.java:480)     at org.codehaus.jackson.impl.WriterBasedGenerator.writeFieldName(WriterBasedGenerator.java:195)     at com.mendix.webui.jsonserialization.JsonGeneratorWrapper$$anonfun$writeFieldName$1.apply(JsonGeneratorWrapper.scala:43)     at com.mendix.webui.jsonserialization.JsonGeneratorWrapper$$anonfun$writeFieldName$1.apply(JsonGeneratorWrapper.scala:43)     at scala.collection.immutable.List.foreach(List.scala:381)     at scala.collection.generic.TraversableForwarder$class.foreach(TraversableForwarder.scala:35)     at scala.collection.mutable.ListBuffer.foreach(ListBuffer.scala:45)     at com.mendix.webui.jsonserialization.JsonGeneratorWrapper.writeFieldName(JsonGeneratorWrapper.scala:43)     at com.mendix.webui.jsonserialization.ResultSerializer.writeException(ResultSerializer.scala:39)     at com.mendix.webui.requesthandling.ClientRequestHandler.com$mendix$webui$requesthandling$ClientRequestHandler$$logAndWriteException(ClientRequestHandler.scala:480)     at com.mendix.webui.requesthandling.ClientRequestHandler.processException(ClientRequestHandler.scala:472)     at com.mendix.webui.requesthandling.ClientRequestHandler.handleRequest(ClientRequestHandler.scala:267)     at com.mendix.webui.requesthandling.ClientRequestHandler.handleActionWithSessionRequired(ClientRequestHandler.scala:235)     at com.mendix.webui.requesthandling.ClientRequestHandler.handleAction(ClientRequestHandler.scala:202)     at com.mendix.webui.requesthandling.ClientRequestHandler.liftedTree1$1(ClientRequestHandler.scala:101)     at com.mendix.webui.requesthandling.ClientRequestHandler.processRequest(ClientRequestHandler.scala:93)     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:885)     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) Error:-2) An error has occurred while handling the request. [User 'MxAdmin' with session id '59d436c1-8b5b-48ad-9141-2355e39a8bd0' and roles 'Administrator'] -------- com.mendix.core.CoreRuntimeException: An error occurred while executing the action 'Texisle.LI_FetchAccount'     at com.mendix.basis.objectmanagement.MendixObjectMemberImpl.getValue(MendixObjectMemberImpl.java:201) Caused by: com.mendix.modules.microflowengine.MicroflowException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.connectionbus.ConnectionBusRuntimeException: An exception has occurred for the following request(s):      InternalXPathTextGetRequest (depth = 0, amount = 1): //Texisle.Account[Texisle.Inquiry_Office/Texisle.Inquiry/Texisle.Inquiry_InquiryProduct = 14355223812280363]     at Texisle.LI_FetchAccount (RetrieveByXPath : 'Retrieve Account from database') Advanced stacktrace:     at com.mendix.modules.microflowengine.MicroflowUtil.processException(MicroflowUtil.java:143) Caused by: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.connectionbus.ConnectionBusRuntimeException: An exception has occurred for the following request(s):      InternalXPathTextGetRequest (depth = 0, amount = 1): //Texisle.Account[Texisle.Inquiry_Office/Texisle.Inquiry/Texisle.Inquiry_InquiryProduct = 14355223812280363]     at com.mendix.basis.actionmanagement.ActionManager.executeSync(ActionManager.java:178) Caused by: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.connectionbus.ConnectionBusRuntimeException: An exception has occurred for the following request(s):      InternalXPathTextGetRequest (depth = 0, amount = 1): //Texisle.Account[Texisle.Inquiry_Office/Texisle.Inquiry/Texisle.Inquiry_InquiryProduct = 14355223812280363]     at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:37) Caused by: com.mendix.connectionbus.ConnectionBusRuntimeException: An exception has occurred for the following request(s):      InternalXPathTextGetRequest (depth = 0, amount = 1): //Texisle.Account[Texisle.Inquiry_Office/Texisle.Inquiry/Texisle.Inquiry_InquiryProduct = 14355223812280363]     at com.mendix.connectionbus.RequestAnalyzer.doRequest(RequestAnalyzer.java:56) Caused by: java.lang.NullPointerException: null     at com.mendix.connectionbus.connections.jdbc.JdbcDataStore.getCorrectException(JdbcDataStore.java:1239)     at com.mendix.connectionbus.connections.jdbc.JdbcDataStore.retrieve(JdbcDataStore.java:181)     at com.mendix.connectionbus.connections.jdbc.JdbcDataStore.retrieve(JdbcDataStore.java:168)     at com.mendix.connectionbus.retrieve.DataStoreCaller.executeQueries(DataStoreCaller.java:229)     at com.mendix.connectionbus.retrieve.DataStoreCaller.executeQueries(DataStoreCaller.java:196)     at com.mendix.connectionbus.retrieve.DataStoreCaller.getResult(DataStoreCaller.java:77)     at com.mendix.connectionbus.retrieve.GetRequestHandler.doRequest(GetRequestHandler.java:69)     at com.mendix.connectionbus.RequestAnalyzer.doRequest(RequestAnalyzer.java:44)     at com.mendix.connectionbus.ConnectionBusImpl.doRequest(ConnectionBusImpl.java:463)     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:73)     at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.call(CoreActionHandlerImpl.scala:53)     at com.mendix.core.actionmanagement.CoreAction.call(CoreAction.java:51)     at com.mendix.basis.actionmanagement.ActionManager$1.execute(ActionManager.java:170)     at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:33)     at com.mendix.basis.actionmanagement.ActionManager.executeSync(ActionManager.java:174)     at com.mendix.basis.component.InternalCore.retrieveXPathQuery(InternalCore.java:1300)     at com.mendix.basis.component.InternalCore.retrieveXPathQuery(InternalCore.java:1266)     at com.mendix.modules.microflowengine.actions.mxobject.RetrieveByXPathAction.execute(RetrieveAction.scala:76)     at com.mendix.modules.microflowengine.microflow.impl.MicroflowObject.execute(MicroflowObject.java:47)     at com.mendix.modules.microflowengine.microflow.impl.MicroflowImpl.executeAfterBreakingIfNecessary(MicroflowImpl.java:200)     at com.mendix.modules.microflowengine.microflow.impl.MicroflowImpl.executeAction(MicroflowImpl.java:157)     at com.mendix.systemwideinterfaces.core.UserAction.execute(UserAction.java:50)     at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.doCall(CoreActionHandlerImpl.scala:73)     at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.call(CoreActionHandlerImpl.scala:53)     at com.mendix.core.actionmanagement.CoreAction.call(CoreAction.java:51)     at com.mendix.basis.actionmanagement.ActionManager$1.execute(ActionManager.java:170)     at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:33)     at com.mendix.basis.actionmanagement.ActionManager.executeSync(ActionManager.java:174)     at com.mendix.basis.component.InternalCore.execute(InternalCore.java:531)     at com.mendix.basis.objectmanagement.MendixObjectMemberImpl.getValue(MendixObjectMemberImpl.java:199)     at com.mendix.webui.jsonserialization.MemberValueConverter$.getValue$1(MemberValueConverter.scala:24)     at com.mendix.webui.jsonserialization.MemberValueConverter$.transformOriginalMemberValue(MemberValueConverter.scala:35)     at com.mendix.webui.jsonserialization.ResultSerializer.generateMendixObjectMember(ResultSerializer.scala:180)     at com.mendix.webui.jsonserialization.ResultSerializer.com$mendix$webui$jsonserialization$ResultSerializer$$generateMemberValue(ResultSerializer.scala:170)     at com.mendix.webui.jsonserialization.ResultSerializer$$anonfun$com$mendix$webui$jsonserialization$ResultSerializer$$generateMendixObject$1.apply(ResultSerializer.scala:146)     at com.mendix.webui.jsonserialization.ResultSerializer$$anonfun$com$mendix$webui$jsonserialization$ResultSerializer$$generateMendixObject$1.apply(ResultSerializer.scala:142)     at scala.collection.Iterator$class.foreach(Iterator.scala:893)     at scala.collection.AbstractIterator.foreach(Iterator.scala:1336)     at scala.collection.IterableLike$class.foreach(IterableLike.scala:72)     at scala.collection.AbstractIterable.foreach(Iterable.scala:54)     at com.mendix.webui.jsonserialization.ResultSerializer.com$mendix$webui$jsonserialization$ResultSerializer$$generateMendixObject(ResultSerializer.scala:142)     at com.mendix.webui.jsonserialization.ResultSerializer.com$mendix$webui$jsonserialization$ResultSerializer$$generate(ResultSerializer.scala:80)     at com.mendix.webui.jsonserialization.ResultSerializer$$anonfun$generateIterable$1.apply(ResultSerializer.scala:111)     at com.mendix.webui.jsonserialization.ResultSerializer$$anonfun$generateIterable$1.apply(ResultSerializer.scala:111)     at scala.collection.immutable.List.foreach(List.scala:381)     at com.mendix.webui.jsonserialization.ResultSerializer.generateIterable(ResultSerializer.scala:111)     at com.mendix.webui.jsonserialization.ResultSerializer.com$mendix$webui$jsonserialization$ResultSerializer$$generate(ResultSerializer.scala:85)     at com.mendix.webui.jsonserialization.ResultSerializer.generate(ResultSerializer.scala:65)     at com.mendix.webui.requesthandling.ClientRequestHandler$$anonfun$com$mendix$webui$requesthandling$ClientRequestHandler$$convertClientActionResult$1.apply(ClientRequestHandler.scala:457)     at com.mendix.webui.requesthandling.ClientRequestHandler$$anonfun$com$mendix$webui$requesthandling$ClientRequestHandler$$convertClientActionResult$1.apply(ClientRequestHandler.scala:453)     at scala.collection.mutable.HashMap$$anonfun$foreach$1.apply(HashMap.scala:99)     at scala.collection.mutable.HashMap$$anonfun$foreach$1.apply(HashMap.scala:99)     at scala.collection.mutable.HashTable$class.foreachEntry(HashTable.scala:230)     at scala.collection.mutable.HashMap.foreachEntry(HashMap.scala:40)     at scala.collection.mutable.HashMap.foreach(HashMap.scala:99)     at com.mendix.webui.requesthandling.ClientRequestHandler.com$mendix$webui$requesthandling$ClientRequestHandler$$convertClientActionResult(ClientRequestHandler.scala:453)     at com.mendix.webui.requesthandling.ClientRequestHandler$$anonfun$handleRequest$1.apply$mcV$sp(ClientRequestHandler.scala:335)     at com.mendix.webui.requesthandling.ClientRequestHandler$$anonfun$handleRequest$1.apply(ClientRequestHandler.scala:293)     at com.mendix.webui.requesthandling.ClientRequestHandler$$anonfun$handleRequest$1.apply(ClientRequestHandler.scala:293)     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:408)     at com.mendix.webui.requesthandling.ClientRequestHandler.handleRequest(ClientRequestHandler.scala:293)     at com.mendix.webui.requesthandling.ClientRequestHandler.handleActionWithSessionRequired(ClientRequestHandler.scala:235)     at com.mendix.webui.requesthandling.ClientRequestHandler.handleAction(ClientRequestHandler.scala:202)     at com.mendix.webui.requesthandling.ClientRequestHandler.liftedTree1$1(ClientRequestHandler.scala:101)     at com.mendix.webui.requesthandling.ClientRequestHandler.processRequest(ClientRequestHandler.scala:93)     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:885)     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) Error:-3) Error occurred on rollback database transaction. Cannot invoke a rollback operation when the AutoCommit mode is set to "true". Error:-4) Exception in execution of monitored action '{"name":"Texisle.MF_OnChangeInquiryQuantity","type":"Microflow"}' (execution id: 3846b29b-6c7a-4df6-822f-411edb0c2d11, execution type: CLIENT_ASYNC_MONITORED) -------- com.mendix.core.CoreRuntimeException: Exception occurred in action '{"name":"Texisle.MF_OnChangeInquiryQuantity","type":"Microflow"}', all database changes executed by this action were rolled back     at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.processErrorState(CoreActionHandlerImpl.scala:152) Caused by: com.mendix.connectionbus.ConnectionBusRuntimeException: com.microsoft.sqlserver.jdbc.SQLServerException: Cannot set a savepoint when the AutoCommit mode is set to "true".     at com.mendix.connectionbus.connections.jdbc.TransactionConnectionManagerAction.addSavepoint(TransactionConnectionManagerAction.java:67) Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Cannot set a savepoint when the AutoCommit mode is set to "true".     at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:206)     at com.microsoft.sqlserver.jdbc.SQLServerConnection.setNamedSavepoint(SQLServerConnection.java:4651)     at com.microsoft.sqlserver.jdbc.SQLServerConnection.setSavepoint(SQLServerConnection.java:4696)     at org.apache.commons.dbcp2.DelegatingConnection.setSavepoint(DelegatingConnection.java:671)     at org.apache.commons.dbcp2.DelegatingConnection.setSavepoint(DelegatingConnection.java:671)     at com.mendix.connectionbus.connections.jdbc.TransactionConnectionManagerAction.addSavepoint(TransactionConnectionManagerAction.java:63)     at com.mendix.connectionbus.connections.jdbc.TransactionConnectionManager.addSavepoint(TransactionConnectionManager.java:50)     at com.mendix.connectionbus.connections.jdbc.JdbcDataStore.addSavepoint(JdbcDataStore.java:1185)     at com.mendix.connectionbus.ConnectionBusImpl.addSavepoint(ConnectionBusImpl.java:607)     at com.mendix.basis.action.RequestScope.pushSavePoint(RequestScope.scala:159)     at com.mendix.basis.action.RequestScope.startTransaction(RequestScope.scala:95)     at com.mendix.basis.action.ContextImpl.startTransaction(ContextImpl.java:194)     at com.mendix.modules.microflowengine.microflow.impl.MicroflowImpl.executeAction(MicroflowImpl.java:150)     at com.mendix.systemwideinterfaces.core.UserAction.execute(UserAction.java:50)     at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.doCall(CoreActionHandlerImpl.scala:73)     at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.call(CoreActionHandlerImpl.scala:53)     at com.mendix.core.actionmanagement.CoreAction.call(CoreAction.java:51)     at com.mendix.basis.actionmanagement.DefaultActionMonitor$$anonfun$run$1.apply(CustomMonitoredAction.scala:18)     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.basis.actionmanagement.CustomMonitoredAction.monitor(CustomMonitoredAction.scala:22)     at com.mendix.basis.actionmanagement.DefaultActionMonitor$.run(CustomMonitoredAction.scala:18)     at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.runMonitoredAction(CoreActionHandlerImpl.scala:62)     at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.call(CoreActionHandlerImpl.scala:51)     at com.mendix.core.actionmanagement.CoreAction.call(CoreAction.java:51)     at com.mendix.basis.actionmanagement.AsyncExecution$AsyncCallableWrapper$$anonfun$2.apply(AsyncExecution.scala:28)     at scala.util.Try$.apply(Try.scala:192)     at com.mendix.basis.actionmanagement.AsyncExecution$AsyncCallableWrapper.call(AsyncExecution.scala:27)     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) --------------------------------------------------------------- Error:-5) JdbcDataStore::execRetrieveQuery caught SQLException without error number; broken JDBC driver? Message: Connection is null. -------- java.sql.SQLException: Connection is null.     at org.apache.commons.dbcp2.DelegatingConnection.checkOpen(DelegatingConnection.java:608)     at org.apache.commons.dbcp2.DelegatingConnection.createStatement(DelegatingConnection.java:255)     at com.mendix.connectionbus.connections.jdbc.JdbcDataStore.execRetrieveQuery(JdbcDataStore.java:323)     at com.mendix.connectionbus.connections.jdbc.JdbcDataStore.execRetrieveQueries(JdbcDataStore.java:215)     at com.mendix.connectionbus.connections.jdbc.JdbcDataStore.retrieve(JdbcDataStore.java:179)     at com.mendix.connectionbus.connections.jdbc.JdbcDataStore.retrieve(JdbcDataStore.java:168)     at com.mendix.connectionbus.retrieve.DataStoreCaller.executeQueries(DataStoreCaller.java:229)     at com.mendix.connectionbus.retrieve.DataStoreCaller.executeQueries(DataStoreCaller.java:196)     at com.mendix.connectionbus.retrieve.DataStoreCaller.getResult(DataStoreCaller.java:77)     at com.mendix.connectionbus.retrieve.GetRequestHandler.doRequest(GetRequestHandler.java:69)     at com.mendix.connectionbus.RequestAnalyzer.doRequest(RequestAnalyzer.java:44)     at com.mendix.connectionbus.ConnectionBusImpl.doRequest(ConnectionBusImpl.java:463)     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:73)     at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.call(CoreActionHandlerImpl.scala:53)     at com.mendix.core.actionmanagement.CoreAction.call(CoreAction.java:51)     at com.mendix.basis.actionmanagement.ActionManager$1.execute(ActionManager.java:170)     at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:33)     at com.mendix.basis.actionmanagement.ActionManager.executeSync(ActionManager.java:174)     at com.mendix.basis.component.InternalCore.retrieveXPathQuery(InternalCore.java:1300)     at com.mendix.basis.component.InternalCore.retrieveXPathQuery(InternalCore.java:1266)     at com.mendix.modules.microflowengine.actions.mxobject.RetrieveByXPathAction.execute(RetrieveAction.scala:76)     at com.mendix.modules.microflowengine.microflow.impl.MicroflowObject.execute(MicroflowObject.java:47)     at com.mendix.modules.microflowengine.microflow.impl.MicroflowImpl.executeAfterBreakingIfNecessary(MicroflowImpl.java:200)     at com.mendix.modules.microflowengine.microflow.impl.MicroflowImpl.executeAction(MicroflowImpl.java:157)     at com.mendix.systemwideinterfaces.core.UserAction.execute(UserAction.java:50)     at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.doCall(CoreActionHandlerImpl.scala:73)     at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.call(CoreActionHandlerImpl.scala:53)     at com.mendix.core.actionmanagement.CoreAction.call(CoreAction.java:51)     at com.mendix.basis.actionmanagement.ActionManager$1.execute(ActionManager.java:170)     at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:33)     at com.mendix.basis.actionmanagement.ActionManager.executeSync(ActionManager.java:174)     at com.mendix.basis.component.InternalCore.execute(InternalCore.java:531)     at com.mendix.basis.objectmanagement.MendixObjectMemberImpl.getValue(MendixObjectMemberImpl.java:199)     at com.mendix.webui.jsonserialization.MemberValueConverter$.getValue$1(MemberValueConverter.scala:24)     at com.mendix.webui.jsonserialization.MemberValueConverter$.transformOriginalMemberValue(MemberValueConverter.scala:35)     at com.mendix.webui.jsonserialization.ResultSerializer.generateMendixObjectMember(ResultSerializer.scala:180)     at com.mendix.webui.jsonserialization.ResultSerializer.com$mendix$webui$jsonserialization$ResultSerializer$$generateMemberValue(ResultSerializer.scala:170)     at com.mendix.webui.jsonserialization.ResultSerializer$$anonfun$com$mendix$webui$jsonserialization$ResultSerializer$$generateMendixObject$1.apply(ResultSerializer.scala:146)     at com.mendix.webui.jsonserialization.ResultSerializer$$anonfun$com$mendix$webui$jsonserialization$ResultSerializer$$generateMendixObject$1.apply(ResultSerializer.scala:142)     at scala.collection.Iterator$class.foreach(Iterator.scala:893)     at scala.collection.AbstractIterator.foreach(Iterator.scala:1336)     at scala.collection.IterableLike$class.foreach(IterableLike.scala:72)     at scala.collection.AbstractIterable.foreach(Iterable.scala:54)     at com.mendix.webui.jsonserialization.ResultSerializer.com$mendix$webui$jsonserialization$ResultSerializer$$generateMendixObject(ResultSerializer.scala:142)     at com.mendix.webui.jsonserialization.ResultSerializer.com$mendix$webui$jsonserialization$ResultSerializer$$generate(ResultSerializer.scala:80)     at com.mendix.webui.jsonserialization.ResultSerializer$$anonfun$generateIterable$1.apply(ResultSerializer.scala:111)     at com.mendix.webui.jsonserialization.ResultSerializer$$anonfun$generateIterable$1.apply(ResultSerializer.scala:111)     at scala.collection.immutable.List.foreach(List.scala:381)     at com.mendix.webui.jsonserialization.ResultSerializer.generateIterable(ResultSerializer.scala:111)     at com.mendix.webui.jsonserialization.ResultSerializer.com$mendix$webui$jsonserialization$ResultSerializer$$generate(ResultSerializer.scala:85)     at com.mendix.webui.jsonserialization.ResultSerializer.generate(ResultSerializer.scala:65)     at com.mendix.webui.requesthandling.ClientRequestHandler$$anonfun$com$mendix$webui$requesthandling$ClientRequestHandler$$convertClientActionResult$1.apply(ClientRequestHandler.scala:457)     at com.mendix.webui.requesthandling.ClientRequestHandler$$anonfun$com$mendix$webui$requesthandling$ClientRequestHandler$$convertClientActionResult$1.apply(ClientRequestHandler.scala:453)     at scala.collection.mutable.HashMap$$anonfun$foreach$1.apply(HashMap.scala:99)     at scala.collection.mutable.HashMap$$anonfun$foreach$1.apply(HashMap.scala:99)     at scala.collection.mutable.HashTable$class.foreachEntry(HashTable.scala:230)     at scala.collection.mutable.HashMap.foreachEntry(HashMap.scala:40)     at scala.collection.mutable.HashMap.foreach(HashMap.scala:99)     at com.mendix.webui.requesthandling.ClientRequestHandler.com$mendix$webui$requesthandling$ClientRequestHandler$$convertClientActionResult(ClientRequestHandler.scala:453)     at com.mendix.webui.requesthandling.ClientRequestHandler$$anonfun$handleRequest$1.apply$mcV$sp(ClientRequestHandler.scala:335)     at com.mendix.webui.requesthandling.ClientRequestHandler$$anonfun$handleRequest$1.apply(ClientRequestHandler.scala:293)     at com.mendix.webui.requesthandling.ClientRequestHandler$$anonfun$handleRequest$1.apply(ClientRequestHandler.scala:293)     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:408)     at com.mendix.webui.requesthandling.ClientRequestHandler.handleRequest(ClientRequestHandler.scala:293)     at com.mendix.webui.requesthandling.ClientRequestHandler.handleActionWithSessionRequired(ClientRequestHandler.scala:235)     at com.mendix.webui.requesthandling.ClientRequestHandler.handleAction(ClientRequestHandler.scala:202)     at com.mendix.webui.requesthandling.ClientRequestHandler.liftedTree1$1(ClientRequestHandler.scala:101)     at com.mendix.webui.requesthandling.ClientRequestHandler.processRequest(ClientRequestHandler.scala:93)     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:885)     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) As per my understanding, all these errors are due to JDBC connection with SQL Server DB. Please let me know how can I resolve these issues. Thank you.
asked
0 answers