runPrepStmtGetKey error

We have started getting the following error on a window that has been working just fine for months with no resent changes. any ideas what would be causing it?

Traceback (innermost last):
  File "<event:actionPerformed>", line 176, in ?
java.lang.Exception: Error executing system.db.runPrepStmt(INSERT INTO dbo.tblPackLineCheck (PACKAGEID,CHECKTIME,VJC,Notes,LineSpeed) VALUES (?,?,?,?,?), , [19331, 2012-02-09 16:11:00, 1900-01-01 16:11:00, , 0])

                at com.inductiveautomation.ignition.common.script.builtin.AbstractDBUtilities.error(AbstractDBUtilities.java:293)

                at com.inductiveautomation.ignition.common.script.builtin.AbstractDBUtilities.__runPrepStmtCatcher(AbstractDBUtilities.java:199)

                at com.inductiveautomation.ignition.common.script.builtin.AbstractDBUtilities.runPrepStmtGetKey(AbstractDBUtilities.java:187)

                at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

                at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

                at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

                at java.lang.reflect.Method.invoke(Unknown Source)

                at org.python.core.PyReflectedFunction.__call__(PyReflectedFunction.java)

                at com.inductiveautomation.ignition.common.script.ScriptManager$ReflectedInstanceFunction.__call__(ScriptManager.java:314)

                at org.python.core.PyObject.__call__(PyObject.java)

                at org.python.core.PyObject.invoke(PyObject.java)

                at org.python.pycode._pyx47.f$0(<event:actionPerformed>:176)

                at org.python.pycode._pyx47.call_function(<event:actionPerformed>)

                at org.python.core.PyTableCode.call(PyTableCode.java)

                at org.python.core.PyCode.call(PyCode.java)

                at org.python.core.Py.runCode(Py.java)

                at com.inductiveautomation.ignition.common.script.ScriptManager.runCode(ScriptManager.java:395)

                at com.inductiveautomation.factorypmi.application.binding.action.ActionAdapter.runActions(ActionAdapter.java:139)

                at com.inductiveautomation.factorypmi.application.binding.action.ActionAdapter.invoke(ActionAdapter.java:247)

                at com.inductiveautomation.factorypmi.application.binding.action.RelayInvocationHandler.invoke(RelayInvocationHandler.java:55)

                at $Proxy0.actionPerformed(Unknown Source)

                at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)

                at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)

                at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)

                at javax.swing.DefaultButtonModel.setPressed(Unknown Source)

                at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)

                at java.awt.Component.processMouseEvent(Unknown Source)

                at javax.swing.JComponent.processMouseEvent(Unknown Source)

                at java.awt.Component.processEvent(Unknown Source)

                at java.awt.Container.processEvent(Unknown Source)

                at java.awt.Component.dispatchEventImpl(Unknown Source)

                at java.awt.Container.dispatchEventImpl(Unknown Source)

                at java.awt.Component.dispatchEvent(Unknown Source)

                at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)

                at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)

                at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)

                at java.awt.Container.dispatchEventImpl(Unknown Source)

                at java.awt.Window.dispatchEventImpl(Unknown Source)

                at java.awt.Component.dispatchEvent(Unknown Source)

                at java.awt.EventQueue.dispatchEvent(Unknown Source)

                at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)

                at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)

                at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)

                at java.awt.EventDispatchThread.pumpEvents(Unknown Source)

                at java.awt.EventDispatchThread.pumpEvents(Unknown Source)

                at java.awt.EventDispatchThread.run(Unknown Source)

Caused by: com.inductiveautomation.ignition.client.gateway_interface.GatewayException: SQL error for "INSERT INTO dbo.tblPackLineCheck (PACKAGEID,CHECKTIME,VJC,Notes,LineSpeed) VALUES (?,?,?,?,?)": A result set was generated for update.

                at com.inductiveautomation.ignition.client.gateway_interface.GatewayInterface.newGatewayException(GatewayInterface.java:283)

                at com.inductiveautomation.ignition.client.gateway_interface.GatewayInterface.sendMessage(GatewayInterface.java:257)

                at com.inductiveautomation.ignition.client.gateway_interface.GatewayInterface.sendMessage(GatewayInterface.java:210)

                at com.inductiveautomation.ignition.client.gateway_interface.GatewayInterface.runPrepStmt(GatewayInterface.java:470)

                at com.inductiveautomation.ignition.client.script.ClientDBUtilities._runPrepStmt(ClientDBUtilities.java:71)

                at com.inductiveautomation.ignition.common.script.builtin.AbstractDBUtilities.__runPrepStmtCatcher(AbstractDBUtilities.java:197)

                ... 44 more

Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: A result set was generated for update.

                at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:170)

                at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:401)

                at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:338)

                at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4026)

                at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1416)

                at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:185)

                at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:160)

                at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(SQLServerPreparedStatement.java:306)

                at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)

                at com.inductiveautomation.ignition.gateway.datasource.SRConnectionWrapper$SRPreparedStatement.executeUpdate(SRConnectionWrapper.java:814)

                at com.inductiveautomation.ignition.gateway.servlets.gateway.functions.RunPrepStmt.runUpdateQuery(RunPrepStmt.java:68)

                at com.inductiveautomation.ignition.gateway.servlets.gateway.functions.AbstractUpdateQuery.run(AbstractUpdateQuery.java:31)

                at com.inductiveautomation.ignition.gateway.servlets.gateway.functions.AbstractDBAction.invoke(AbstractDBAction.java:76)

                at com.inductiveautomation.ignition.gateway.servlets.Gateway.doPost(Gateway.java:398)

                at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)

                at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

                at com.inductiveautomation.ignition.gateway.bootstrap.MapServlet.service(MapServlet.java:85)

                at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)

                at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

                at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)

                at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)

                at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)

                at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)

                at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

                at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)

                at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)

                at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)

                at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)

                at java.lang.Thread.run(null)


java.lang.Exception: java.lang.Exception: Error executing system.db.runPrepStmt(INSERT INTO dbo.tblPackLineCheck (PACKAGEID,CHECKTIME,VJC,Notes,LineSpeed) VALUES (?,?,?,?,?), , [19331, 2012-02-09 16:11:00, 1900-01-01 16:11:00, , 0])

                at org.python.core.Py.JavaError(Py.java)
                at com.inductiveautomation.ignition.common.script.builtin.AbstractDBUtilities.error(AbstractDBUtilities.java:293)
                at com.inductiveautomation.ignition.common.script.builtin.AbstractDBUtilities.__runPrepStmtCatcher(AbstractDBUtilities.java:199)
                at com.inductiveautomation.ignition.common.script.builtin.AbstractDBUtilities.runPrepStmtGetKey(AbstractDBUtilities.java:187)
                at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
                at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
                at java.lang.reflect.Method.invoke(Unknown Source)
                at org.python.core.PyReflectedFunction.__call__(PyReflectedFunction.java)
                at com.inductiveautomation.ignition.common.script.ScriptManager$ReflectedInstanceFunction.__call__(ScriptManager.java:314)
                at org.python.core.PyObject.__call__(PyObject.java)
                at org.python.core.PyObject.invoke(PyObject.java)
                at org.python.pycode._pyx47.f$0(<event:actionPerformed>:176)
                at org.python.pycode._pyx47.call_function(<event:actionPerformed>)
                at org.python.core.PyTableCode.call(PyTableCode.java)
                at org.python.core.PyCode.call(PyCode.java)
                at org.python.core.Py.runCode(Py.java)
                at com.inductiveautomation.ignition.common.script.ScriptManager.runCode(ScriptManager.java:395)
                at com.inductiveautomation.factorypmi.application.binding.action.ActionAdapter.runActions(ActionAdapter.java:139)
                at com.inductiveautomation.factorypmi.application.binding.action.ActionAdapter.invoke(ActionAdapter.java:247)
                at com.inductiveautomation.factorypmi.application.binding.action.RelayInvocationHandler.invoke(RelayInvocationHandler.java:55)
                at $Proxy0.actionPerformed(Unknown Source)
                at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
                at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
                at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
                at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
                at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
                at java.awt.Component.processMouseEvent(Unknown Source)
                at javax.swing.JComponent.processMouseEvent(Unknown Source)
                at java.awt.Component.processEvent(Unknown Source)
                at java.awt.Container.processEvent(Unknown Source)
                at java.awt.Component.dispatchEventImpl(Unknown Source)
                at java.awt.Container.dispatchEventImpl(Unknown Source)
                at java.awt.Component.dispatchEvent(Unknown Source)
                at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
                at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
                at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
                at java.awt.Container.dispatchEventImpl(Unknown Source)
                at java.awt.Window.dispatchEventImpl(Unknown Source)
                at java.awt.Component.dispatchEvent(Unknown Source)
                at java.awt.EventQueue.dispatchEvent(Unknown Source)
                at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
                at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
                at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
                at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
                at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
                at java.awt.EventDispatchThread.run(Unknown Source)

Ignition v7.3.3 (b570)
Java: Sun Microsystems Inc. 1.6.0_17

The solution is to add “SET NOCOUNT OFF” in the advanced settings of the database connection on the gateway.