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

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