# system.db.execSProcCall Read timed out

**URL:** <https://forum.inductiveautomation.com/t/system-db-execsproccall-read-timed-out/45428>\
**Category:** Ignition\
**Created:** [April 9, 2021, 1:19pm UTC](https://forum.inductiveautomation.com/t/system-db-execsproccall-read-timed-out/45428 "2021-04-09T13:19:24Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![joe.miller](https://avatars.discourse-cdn.com/v4/letter/j/b4bc9f/32.png) [@joe.miller](https://forum.inductiveautomation.com/u/joe.miller)\
**Post date:** [April 9, 2021, 1:19pm UTC](https://forum.inductiveautomation.com/t/system-db-execsproccall-read-timed-out/45428/1 "2021-04-09T13:19:25Z")

</div>

I randomly receive the following error with a script that uses system.db.execSProcCall. I am looking for some guidance on why this is a random ocurrance and what I can do to decrease the frequency of ocurrance.

* * *

Traceback (most recent call last):  
File “event:actionPerformed”, line 15, in getData  
at com.inductiveautomation.ignition.common.script.builtin.AbstractDBUtilities.error(AbstractDBUtilities.java:362)  
at com.inductiveautomation.ignition.common.script.builtin.AbstractDBUtilities.execSProcCall(AbstractDBUtilities.java:497)  
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)  
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)  
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)  
at java.base/java.lang.reflect.Method.invoke(Unknown Source)  
java.lang.Exception: java.lang.Exception: Error executing system.db.execSProcCall()

```
        at org.python.core.Py.JavaError(Py.java:552)
        at com.inductiveautomation.ignition.common.script.builtin.AbstractDBUtilities.error(AbstractDBUtilities.java:362)
        at com.inductiveautomation.ignition.common.script.builtin.AbstractDBUtilities.execSProcCall(AbstractDBUtilities.java:497)
        at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
        at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        at java.base/java.lang.reflect.Method.invoke(Unknown Source)
        at org.python.core.PyReflectedFunction. __call__ (PyReflectedFunction.java:188)
        at com.inductiveautomation.ignition.common.script.ScriptManager$ReflectedInstanceFunction. __call__ (ScriptManager.java:524)
        at org.python.core.PyObject. __call__ (PyObject.java:480)
        at org.python.core.PyObject. __call__ (PyObject.java:484)
        at org.python.pycode._pyx47.getData$1(<event:actionPerformed>:24)
        at org.python.pycode._pyx47.call_function(<event:actionPerformed>)
        at org.python.core.PyTableCode.call(PyTableCode.java:171)
        at org.python.core.PyBaseCode.call(PyBaseCode.java:308)
        at org.python.core.PyFunction.function ___call__ (PyFunction.java:471)
        at org.python.core.PyFunction. __call__ (PyFunction.java:466)
        at org.python.core.PyFunction. __call__ (PyFunction.java:461)
        at com.inductiveautomation.ignition.common.script.ScriptManager.runFunction(ScriptManager.java:822)
        at com.inductiveautomation.ignition.client.script.DesignerSystemUtilities.lambda$_invokeAsyncImpl$1(DesignerSystemUtilities.java:135)
        at java.base/java.lang.Thread.run(Unknown Source)

```

Caused by: java.lang.Exception: Error executing system.db.execSProcCall()  
… 20 more  
Caused by: com.inductiveautomation.ignition.client.gateway\_interface.GatewayException: Read timed out  
at com.inductiveautomation.ignition.client.gateway\_interface.GatewayInterface.newGatewayException(GatewayInterface.java:351)  
at com.inductiveautomation.ignition.client.gateway\_interface.GatewayInterface.sendMessage(GatewayInterface.java:325)  
at com.inductiveautomation.ignition.client.gateway\_interface.GatewayInterface.sendMessage(GatewayInterface.java:278)  
at com.inductiveautomation.ignition.client.gateway\_interface.GatewayInterface.invoke(GatewayInterface.java:934)  
at com.inductiveautomation.ignition.client.script.ClientDBUtilities.\_call(ClientDBUtilities.java:345)  
at com.inductiveautomation.ignition.common.script.builtin.AbstractDBUtilities.execSProcCall(AbstractDBUtilities.java:495)  
… 18 more  
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Read timed out  
at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:2887)  
at com.microsoft.sqlserver.jdbc.TDSChannel.read(IOBuffer.java:2029)  
at com.microsoft.sqlserver.jdbc.TDSReader.readPacket(IOBuffer.java:6418)  
at com.microsoft.sqlserver.jdbc.TDSCommand.startResponse(IOBuffer.java:7579)  
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:590)  
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:522)  
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7194)  
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2930)  
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:248)  
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:223)  
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPreparedStatement.java:503)  
at org.apache.commons.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:94)  
at org.apache.commons.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:94)  
at com.inductiveautomation.ignition.gateway.datasource.SRConnectionWrapper$SRPreparedStatement.execute(SRConnectionWrapper.java:996)  
at com.inductiveautomation.ignition.gateway.script.GatewayDBUtilities.\_callSProc(GatewayDBUtilities.java:310)  
at com.inductiveautomation.ignition.gateway.servlets.gateway.functions.CallSProc.call(CallSProc.java:42)  
at jdk.internal.reflect.GeneratedMethodAccessor171.invoke(null)  
at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(null)  
at java.lang.reflect.Method.invoke(null)  
at com.inductiveautomation.ignition.gateway.servlets.gateway.AbstractGatewayFunction.invoke(AbstractGatewayFunction.java:225)  
at com.inductiveautomation.ignition.gateway.servlets.Gateway.doPost(Gateway.java:414)  
at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)  
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)  
at com.inductiveautomation.ignition.gateway.bootstrap.MapServlet.service(MapServlet.java:86)  
at org.eclipse.jetty.servlet.ServletHolder$NotAsyncServlet.service(ServletHolder.java:1391)  
at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:760)  
at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:547)  
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)  
at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:590)  
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127)  
at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:235)  
at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1607)  
at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:233)  
at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1297)  
at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:188)  
at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:485)  
at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1577)  
at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:186)  
at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1212)  
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)  
at org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:59)  
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127)  
at org.eclipse.jetty.rewrite.handler.RewriteHandler.handle(RewriteHandler.java:322)  
at org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:59)  
at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:146)  
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127)  
at org.eclipse.jetty.server.Server.handle(Server.java:500)  
at org.eclipse.jetty.server.HttpChannel.lambda$handle$1(HttpChannel.java:383)  
at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:547)  
at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:375)  
at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:270)  
at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311)  
at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:103)  
at org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:117)  
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:336)  
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:313)  
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:171)  
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:129)  
at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:388)  
at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:806)  
at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:938)  
at java.lang.Thread.run(null)

Ignition v8.0.17 (b2020121412)  
Java: Azul Systems, Inc. 11.0.7

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [April 9, 2021, 6:48pm UTC](https://forum.inductiveautomation.com/t/system-db-execsproccall-read-timed-out/45428/2 "2021-04-09T18:48:08Z")

</div>

That’s a timeout. There’s a number of places in Ignition and in some drivers where you get 60 seconds. IIRC, some of them (depending on driver, I think) are not changeable.