API tools faq
paste
Advertisement
Jad85

Untitled

Jad85
Nov 12th, 2015
394
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 8.61 KB | None | 0 0
raw download clone embed print report
  1. Traceback (most recent call last):
  2. File "<event:mouseClicked>", line 12, in <module>
  3. at com.inductiveautomation.ignition.common.script.builtin.AbstractDBUtilities.error(AbstractDBUtilities.java:362)
  4.  
  5. at com.inductiveautomation.ignition.common.script.builtin.AbstractDBUtilities.runPrepUpdate(AbstractDBUtilities.java:260)
  6.  
  7. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  8.  
  9. at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
  10.  
  11. at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
  12.  
  13. at java.lang.reflect.Method.invoke(Unknown Source)
  14.  
  15.  
  16. java.lang.Exception: java.lang.Exception: Error executing system.db.runPrepUpdate(IF EXISTS( SELECT * FROM setup_sheetlist WHERE moldname='?' AND Machinename='?')UPDATE setup_sheetlist SET setupsheet ='?' WHERE moldname='?' AND Machinename='?', [100SCX-3, MM09, newly update value, 100SCX-3, MM09], , , false, false)
  17.  
  18. at org.python.core.Py.JavaError(Py.java:495)
  19. at com.inductiveautomation.ignition.common.script.builtin.AbstractDBUtilities.error(AbstractDBUtilities.java:362)
  20. at com.inductiveautomation.ignition.common.script.builtin.AbstractDBUtilities.runPrepUpdate(AbstractDBUtilities.java:260)
  21. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  22. at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
  23. at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
  24. at java.lang.reflect.Method.invoke(Unknown Source)
  25. at org.python.core.PyReflectedFunction.__call__(PyReflectedFunction.java:186)
  26. at com.inductiveautomation.ignition.common.script.ScriptManager$ReflectedInstanceFunction.__call__(ScriptManager.java:428)
  27. at org.python.core.PyObject.__call__(PyObject.java:404)
  28. at org.python.core.PyObject.__call__(PyObject.java:408)
  29. at org.python.pycode._pyx213.f$0(<event:mouseClicked>:17)
  30. at org.python.pycode._pyx213.call_function(<event:mouseClicked>)
  31. at org.python.core.PyTableCode.call(PyTableCode.java:165)
  32. at org.python.core.PyCode.call(PyCode.java:18)
  33. at org.python.core.Py.runCode(Py.java:1275)
  34. at com.inductiveautomation.ignition.common.script.ScriptManager.runCode(ScriptManager.java:624)
  35. at com.inductiveautomation.factorypmi.application.binding.action.ActionAdapter.runActions(ActionAdapter.java:168)
  36. at com.inductiveautomation.factorypmi.application.binding.action.ActionAdapter.invoke(ActionAdapter.java:265)
  37. at com.inductiveautomation.factorypmi.application.binding.action.RelayInvocationHandler.invoke(RelayInvocationHandler.java:55)
  38. at com.sun.proxy.$Proxy29.mouseClicked(Unknown Source)
  39. at java.awt.AWTEventMulticaster.mouseClicked(Unknown Source)
  40. at java.awt.Component.processMouseEvent(Unknown Source)
  41. at javax.swing.JComponent.processMouseEvent(Unknown Source)
  42. at java.awt.Component.processEvent(Unknown Source)
  43. at java.awt.Container.processEvent(Unknown Source)
  44. at java.awt.Component.dispatchEventImpl(Unknown Source)
  45. at java.awt.Container.dispatchEventImpl(Unknown Source)
  46. at java.awt.Component.dispatchEvent(Unknown Source)
  47. at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
  48. at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
  49. at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
  50. at java.awt.Container.dispatchEventImpl(Unknown Source)
  51. at java.awt.Window.dispatchEventImpl(Unknown Source)
  52. at java.awt.Component.dispatchEvent(Unknown Source)
  53. at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
  54. at java.awt.EventQueue.access$500(Unknown Source)
  55. at java.awt.EventQueue$3.run(Unknown Source)
  56. at java.awt.EventQueue$3.run(Unknown Source)
  57. at java.security.AccessController.doPrivileged(Native Method)
  58. at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
  59. at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
  60. at java.awt.EventQueue$4.run(Unknown Source)
  61. at java.awt.EventQueue$4.run(Unknown Source)
  62. at java.security.AccessController.doPrivileged(Native Method)
  63. at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
  64. at java.awt.EventQueue.dispatchEvent(Unknown Source)
  65. at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
  66. at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
  67. at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
  68. at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
  69. at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
  70. at java.awt.EventDispatchThread.run(Unknown Source)
  71. Caused by: java.lang.Exception: Error executing system.db.runPrepUpdate(IF EXISTS( SELECT * FROM setup_sheetlist WHERE moldname='?' AND Machinename='?')UPDATE setup_sheetlist SET setupsheet ='?' WHERE moldname='?' AND Machinename='?', [100SCX-3, MM09, newly update value, 100SCX-3, MM09], , , false, false)
  72. ... 52 more
  73. Caused by: com.inductiveautomation.ignition.client.gateway_interface.GatewayException: SQL error for "IF EXISTS( SELECT * FROM setup_sheetlist WHERE moldname='?' AND Machinename='?')UPDATE setup_sheetlist SET setupsheet ='?' WHERE moldname='?' AND Machinename='?'": The index 1 is out of range.
  74. at com.inductiveautomation.ignition.client.gateway_interface.GatewayInterface.newGatewayException(GatewayInterface.java:328)
  75. at com.inductiveautomation.ignition.client.gateway_interface.GatewayInterface.sendMessage(GatewayInterface.java:302)
  76. at com.inductiveautomation.ignition.client.gateway_interface.GatewayInterface.sendMessage(GatewayInterface.java:259)
  77. at com.inductiveautomation.ignition.client.script.ClientDBUtilities._runPrepStmt(ClientDBUtilities.java:137)
  78. at com.inductiveautomation.ignition.common.script.builtin.AbstractDBUtilities.runPrepUpdate(AbstractDBUtilities.java:258)
  79. ... 50 more
  80. Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The index 1 is out of range.
  81. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:170)
  82. at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.setterGetParam(SQLServerPreparedStatement.java:698)
  83. at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.setObjectNoType(SQLServerPreparedStatement.java:894)
  84. at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.setObject(SQLServerPreparedStatement.java:919)
  85. at org.apache.commons.dbcp.DelegatingPreparedStatement.setObject(DelegatingPreparedStatement.java:166)
  86. at com.inductiveautomation.ignition.gateway.datasource.SRConnectionWrapper$SRPreparedStatement.setObject(SRConnectionWrapper.java:971)
  87. at com.inductiveautomation.ignition.gateway.servlets.gateway.functions.RunPrepStmt.runUpdateQuery(RunPrepStmt.java:60)
  88. at com.inductiveautomation.ignition.gateway.servlets.gateway.functions.AbstractUpdateQuery.run(AbstractUpdateQuery.java:34)
  89. at com.inductiveautomation.ignition.gateway.servlets.gateway.functions.AbstractDBAction.invoke(AbstractDBAction.java:76)
  90. at com.inductiveautomation.ignition.gateway.servlets.Gateway.doPost(Gateway.java:345)
  91. at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
  92. at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
  93. at com.inductiveautomation.ignition.gateway.bootstrap.MapServlet.service(MapServlet.java:85)
  94. at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:769)
  95. at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:585)
  96. at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)
  97. at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:577)
  98. at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:223)
  99. at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1125)
  100. at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:515)
  101. at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185)
  102. at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1059)
  103. at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
  104. at org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:52)
  105. at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
  106. at org.eclipse.jetty.server.Server.handle(Server.java:497)
  107. at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:311)
  108. at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:248)
  109. at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:540)
  110. at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:610)
  111. at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:539)
  112. at java.lang.Thread.run(null)
  113.  
  114. Ignition v7.8.0 (b2015101414)
  115. Java: Oracle Corporation 1.8.0_65
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!