I'm not seeing many options for debugging since the error presumably originates in the updateTable() call itself, which I don't have source access to obviously. The Delete SQL statement itself is simple, as you'll see below, and I can run it without issue directly on the database.
The log below shows the debug for the table's backing resource, where you can see the error being triggered immediately after running the Delete SQL. I don't know where the "0_0" string comes from; there's no such value in any of the table's columns.
Code: Select all
Tue Jul 10 14:08:25: DEBUG Start execution of command - updatetable: 14:08:25.616
Tue Jul 10 14:08:25: DEBUG Debug for database resource CCORE_PT_CICU_STAY_COMP - SQL statement:
Tue Jul 10 14:08:25: DEBUG delete from PT_CICU_COMPLICATIONS where CICU_COMPLICATION_ID = 18
Tue Jul 10 14:08:25: ERROR Wrapped java.lang.NumberFormatException: For input string: "0_0" (CCORE_PT_CICU_STAY_SAVE#52)
com.ebasetech.ufs.runtime.events.rhinojavascript.RhinoScriptException: Wrapped java.lang.NumberFormatException: For input string: "0_0" (CCORE_PT_CICU_STAY_SAVE#52)
at com.ebasetech.ufs.runtime.events.rhinojavascript.JavascriptExecutionHandler.handleExecutionErrors(JavascriptExecutionHandler.java:355)
at com.ebasetech.ufs.runtime.events.rhinojavascript.JavascriptExecutionHandler.execute(JavascriptExecutionHandler.java:280)
at com.ebasetech.ufs.runtime.events.JVMScriptNode.execute_(JVMScriptNode.java:133)
at com.ebasetech.ufs.runtime.events.JVMScriptNode.execute(JVMScriptNode.java:99)
at com.ebasetech.ufs.runtime.events.RunnableContext.execute(RunnableContext.java:69)
at com.ebasetech.ufs.runtime.events.SuspendableExecutable.execute(SuspendableExecutable.java:47)
at com.ebasetech.ufs.runtime.events.SuspendableContainerExecutable.execute(SuspendableContainerExecutable.java:26)
at com.ebasetech.ufs.runtime.events.BaseEventNode.execute(BaseEventNode.java:32)
at com.ebasetech.ufs.runtime.events.RunnableContext.execute(RunnableContext.java:69)
at com.ebasetech.ufs.runtime.events.SuspendableExecutable.execute(SuspendableExecutable.java:47)
at com.ebasetech.ufs.runtime.events.SuspendableContainerExecutable.execute(SuspendableContainerExecutable.java:26)
at com.ebasetech.ufs.runtime.events.RunnableContext.execute(RunnableContext.java:69)
at com.ebasetech.ufs.runtime.events.SuspendableExecutable.execute(SuspendableExecutable.java:47)
at com.ebasetech.ufs.runtime.events.SuspendableContainerExecutable.execute(SuspendableContainerExecutable.java:26)
at com.ebasetech.ufs.runtime.events.RunnableContext.execute(RunnableContext.java:69)
at com.ebasetech.ufs.runtime.Request.execute(Request.java:448)
at com.ebasetech.ufs.runtime.Request.execute(Request.java:417)
at com.ebasetech.ufs.runtime.Request._execute(Request.java:352)
at com.ebasetech.ufs.runtime.Request.execute(Request.java:317)
at formservlets.FormProcessingUtil.executeRequest(FormProcessingUtil.java:503)
at formservlets.EbaseAjaxServlet.process(EbaseAjaxServlet.java:73)
at formservlets.EbaseAjaxServlet.doPost(EbaseAjaxServlet.java:40)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:648)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at formservlets.EbaseFilter.processRequest(EbaseFilter.java:253)
at formservlets.EbaseFilter.performFilter(EbaseFilter.java:180)
at formservlets.EbaseFilter.doFilter(EbaseFilter.java:100)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:198)
at net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:176)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:203)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:142)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:518)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1091)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:673)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1526)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1482)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.NumberFormatException: For input string: "0_0"
at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
at java.lang.Integer.parseInt(Integer.java:580)
at java.lang.Integer.valueOf(Integer.java:766)
at com.ebasetech.ufs.runtime.ControlUserState.resetStateForRepeaterRow(ControlUserState.java:81)
at com.ebasetech.ufs.runtime.ControlUserState.updateStateForRow(ControlUserState.java:59)
at com.ebasetech.ufs.runtime.runtimeControls.repeating.RepeatingTableRuntimeControl.rowRemoved(RepeatingTableRuntimeControl.java:257)
at com.ebasetech.ufs.runtime.RuntimeTableField.notifyRowRemoved(RuntimeTableField.java:1333)
at com.ebasetech.ufs.runtime.RuntimeTableField.notifyRowsRemoved(RuntimeTableField.java:1414)
at com.ebasetech.ufs.runtime.RuntimeTableField.updateTable(RuntimeTableField.java:280)
at com.ebasetech.ufs.runtime.external.api.impl.ApiTableBase.updateTable(ApiTableBase.java:140)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:126)
at org.mozilla.javascript.NativeJavaMethod.call(NativeJavaMethod.java:225)
at org.mozilla.javascript.Interpreter.interpretLoop(Interpreter.java:1479)
at org.mozilla.javascript.Interpreter.interpret(Interpreter.java:815)
at org.mozilla.javascript.InterpretedFunction.call(InterpretedFunction.java:109)
at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:393)
at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:3280)
at org.mozilla.javascript.Context.callFunctionWithContinuations(Context.java:1284)
at org.mozilla.javascript.Context.executeScriptWithContinuations(Context.java:1251)
at com.ebasetech.ufs.runtime.events.rhinojavascript.JavascriptExecutionHandler.execute(JavascriptExecutionHandler.java:270)
... 51 more
Tue Jul 10 14:08:25: INFO Transaction rolled back
Tue Jul 10 14:08:25: ERROR com.ebasetech.xi.exceptions.FormRuntimeException: com.ebasetech.ufs.runtime.events.rhinojavascript.RhinoScriptException: Wrapped java.lang.NumberFormatException: For input string: "0_0" (CCORE_PT_CICU_STAY_SAVE#52)
Tue Jul 10 14:08:25: Unexpected error occurred - see server log
Tue Jul 10 14:08:25: ERROR Unexpected error occurred
com.ebasetech.xi.exceptions.FormRuntimeException: com.ebasetech.ufs.runtime.events.rhinojavascript.RhinoScriptException: Wrapped java.lang.NumberFormatException: For input string: "0_0" (CCORE_PT_CICU_STAY_SAVE#52)
at com.ebasetech.ufs.runtime.events.JVMScriptNode.handleExecutionErrors(JVMScriptNode.java:213)
at com.ebasetech.ufs.runtime.events.JVMScriptNode.execute(JVMScriptNode.java:114)
at com.ebasetech.ufs.runtime.events.RunnableContext.execute(RunnableContext.java:69)
at com.ebasetech.ufs.runtime.events.SuspendableExecutable.execute(SuspendableExecutable.java:47)
at com.ebasetech.ufs.runtime.events.SuspendableContainerExecutable.execute(SuspendableContainerExecutable.java:26)
at com.ebasetech.ufs.runtime.events.BaseEventNode.execute(BaseEventNode.java:32)
at com.ebasetech.ufs.runtime.events.RunnableContext.execute(RunnableContext.java:69)
at com.ebasetech.ufs.runtime.events.SuspendableExecutable.execute(SuspendableExecutable.java:47)
at com.ebasetech.ufs.runtime.events.SuspendableContainerExecutable.execute(SuspendableContainerExecutable.java:26)
at com.ebasetech.ufs.runtime.events.RunnableContext.execute(RunnableContext.java:69)
at com.ebasetech.ufs.runtime.events.SuspendableExecutable.execute(SuspendableExecutable.java:47)
at com.ebasetech.ufs.runtime.events.SuspendableContainerExecutable.execute(SuspendableContainerExecutable.java:26)
at com.ebasetech.ufs.runtime.events.RunnableContext.execute(RunnableContext.java:69)
at com.ebasetech.ufs.runtime.Request.execute(Request.java:448)
at com.ebasetech.ufs.runtime.Request.execute(Request.java:417)
at com.ebasetech.ufs.runtime.Request._execute(Request.java:352)
at com.ebasetech.ufs.runtime.Request.execute(Request.java:317)
at formservlets.FormProcessingUtil.executeRequest(FormProcessingUtil.java:503)
at formservlets.EbaseAjaxServlet.process(EbaseAjaxServlet.java:73)
at formservlets.EbaseAjaxServlet.doPost(EbaseAjaxServlet.java:40)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:648)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at formservlets.EbaseFilter.processRequest(EbaseFilter.java:253)
at formservlets.EbaseFilter.performFilter(EbaseFilter.java:180)
at formservlets.EbaseFilter.doFilter(EbaseFilter.java:100)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:198)
at net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:176)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:203)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:142)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:518)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1091)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:673)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1526)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1482)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:745)
Caused by: com.ebasetech.ufs.runtime.events.rhinojavascript.RhinoScriptException: Wrapped java.lang.NumberFormatException: For input string: "0_0" (CCORE_PT_CICU_STAY_SAVE#52)
at com.ebasetech.ufs.runtime.events.rhinojavascript.JavascriptExecutionHandler.handleExecutionErrors(JavascriptExecutionHandler.java:355)
at com.ebasetech.ufs.runtime.events.rhinojavascript.JavascriptExecutionHandler.execute(JavascriptExecutionHandler.java:280)
at com.ebasetech.ufs.runtime.events.JVMScriptNode.execute_(JVMScriptNode.java:133)
at com.ebasetech.ufs.runtime.events.JVMScriptNode.execute(JVMScriptNode.java:99)
... 49 more
Caused by: java.lang.NumberFormatException: For input string: "0_0"
at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
at java.lang.Integer.parseInt(Integer.java:580)
at java.lang.Integer.valueOf(Integer.java:766)
at com.ebasetech.ufs.runtime.ControlUserState.resetStateForRepeaterRow(ControlUserState.java:81)
at com.ebasetech.ufs.runtime.ControlUserState.updateStateForRow(ControlUserState.java:59)
at com.ebasetech.ufs.runtime.runtimeControls.repeating.RepeatingTableRuntimeControl.rowRemoved(RepeatingTableRuntimeControl.java:257)
at com.ebasetech.ufs.runtime.RuntimeTableField.notifyRowRemoved(RuntimeTableField.java:1333)
at com.ebasetech.ufs.runtime.RuntimeTableField.notifyRowsRemoved(RuntimeTableField.java:1414)
at com.ebasetech.ufs.runtime.RuntimeTableField.updateTable(RuntimeTableField.java:280)
at com.ebasetech.ufs.runtime.external.api.impl.ApiTableBase.updateTable(ApiTableBase.java:140)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:126)
at org.mozilla.javascript.NativeJavaMethod.call(NativeJavaMethod.java:225)
at org.mozilla.javascript.Interpreter.interpretLoop(Interpreter.java:1479)
at org.mozilla.javascript.Interpreter.interpret(Interpreter.java:815)
at org.mozilla.javascript.InterpretedFunction.call(InterpretedFunction.java:109)
at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:393)
at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:3280)
at org.mozilla.javascript.Context.callFunctionWithContinuations(Context.java:1284)
at org.mozilla.javascript.Context.executeScriptWithContinuations(Context.java:1251)
at com.ebasetech.ufs.runtime.events.rhinojavascript.JavascriptExecutionHandler.execute(JavascriptExecutionHandler.java:270)
... 51 more
Code: Select all
tables.CCORE_PT_CICU_STAY_COMP.updateTable();