Skip to main content

Variable (do_trace) has undefined value

No replies
Anonymous

Hello

I am running Glassfish 3.1.2.2 (build 5) on our server. We have a Web Application on Glassfish which inserts values into an Informix database. In our office environment this works 100%. However on site this same setup does not work and returns the following error

java.sql.SQLException: Variable (do_trace) has undefined value. at com.informix.jdbc.IfxSqli.a(IfxSqli.java:3631) at com.informix.jdbc.IfxSqli.E(IfxSqli.java:3963) at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java :2693) at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.j ava:2609) at com.informix.jdbc.IfxSqli.executeCommand(IfxSqli.j ava:939) at com.informix.jdbc.IfxResultSet.b(IfxResultSet.java :303) at com.informix.jdbc.IfxStatement.c(IfxStatement.java :1276) at com.informix.jdbc.IfxPreparedStatement.executeUpda te(IfxPreparedStatement.java:421) at org.tollink.TrafficEvent.InsertTrafficEvent(Traffi cEvent.java:348) at org.tollink.TrafficEvent.CreateTrafficEvent(Traffi cEvent.java:271) at sun.reflect.GeneratedMethodAccessor88.invoke(Unkno wn Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:601) at org.glassfish.webservices.InstanceResolverImpl$1.i nvoke(InstanceResolverImpl.java:143) at com.sun.xml.ws.server.InvokerTube$2.invoke(Invoker Tube.java:149) at com.sun.xml.ws.server.sei.SEIInvokerTube.processRe quest(SEIInvokerTube.java:94) at com.sun.xml.ws.api.pipe.Fiber.__doRun(Fiber.java:9 61) at com.sun.xml.ws.api.pipe.Fiber._doRun(Fiber.java:91 0) at com.sun.xml.ws.api.pipe.Fiber.doRun(Fiber.java:873 ) at com.sun.xml.ws.api.pipe.Fiber.runSync(Fiber.java:7 75) at com.sun.xml.ws.api.pipe.helper.AbstractTubeImpl.pr ocess(AbstractTubeImpl.java:116) at org.glassfish.webservices.MonitoringPipe.process(M onitoringPipe.java:142) at com.sun.xml.ws.api.pipe.helper.PipeAdapter.process Request(PipeAdapter.java:119) at com.sun.xml.ws.api.pipe.Fiber.__doRun(Fiber.java:9 61) at com.sun.xml.ws.api.pipe.Fiber._doRun(Fiber.java:91 0) at com.sun.xml.ws.api.pipe.Fiber.doRun(Fiber.java:873 ) at com.sun.xml.ws.api.pipe.Fiber.runSync(Fiber.java:7 75) at com.sun.xml.ws.api.pipe.helper.AbstractTubeImpl.pr ocess(AbstractTubeImpl.java:116) at com.sun.enterprise.security.webservices.CommonServ erSecurityPipe.processRequest(CommonServerSecurity Pipe.java:212) at com.sun.enterprise.security.webservices.CommonServ erSecurityPipe.process(CommonServerSecurityPipe.ja va:144) at com.sun.xml.ws.api.pipe.helper.PipeAdapter.process Request(PipeAdapter.java:119) at com.sun.xml.ws.api.pipe.Fiber.__doRun(Fiber.java:9 61) at com.sun.xml.ws.api.pipe.Fiber._doRun(Fiber.java:91 0) at com.sun.xml.ws.api.pipe.Fiber.doRun(Fiber.java:873 ) at com.sun.xml.ws.api.pipe.Fiber.runSync(Fiber.java:7 75) at com.sun.xml.ws.server.WSEndpointImpl$2.process(WSE ndpointImpl.java:386) at com.sun.xml.ws.transport.http.HttpAdapter$HttpTool kit.handle(HttpAdapter.java:640) at com.sun.xml.ws.transport.http.HttpAdapter.handle(H ttpAdapter.java:263) at com.sun.xml.ws.transport.http.servlet.ServletAdapt er.handle(ServletAdapter.java:163) at org.glassfish.webservices.JAXWSServlet.doPost(JAXW SServlet.java:145) at javax.servlet.http.HttpServlet.service(HttpServlet .java:688) at javax.servlet.http.HttpServlet.service(HttpServlet .java:770) at org.apache.catalina.core.StandardWrapper.service(S tandardWrapper.java:1550) at org.apache.catalina.core.StandardWrapperValve.invo ke(StandardWrapperValve.java:281) at org.apache.catalina.core.StandardContextValve.invo ke(StandardContextValve.java:175) at org.apache.catalina.core.StandardPipeline.doInvoke (StandardPipeline.java:655) at org.apache.catalina.core.StandardPipeline.invoke(S tandardPipeline.java:595) at org.apache.catalina.core.StandardHostValve.invoke( StandardHostValve.java:161) at org.apache.catalina.connector.CoyoteAdapter.doServ ice(CoyoteAdapter.java:331) at org.apache.catalina.connector.CoyoteAdapter.servic e(CoyoteAdapter.java:231) at com.sun.enterprise.v3.services.impl.ContainerMappe r$AdapterCallable.call(ContainerMapper.java:317) at com.sun.enterprise.v3.services.impl.ContainerMappe r.service(ContainerMapper.java:195) at com.sun.grizzly.http.ProcessorTask.invokeAdapter(P rocessorTask.java:860) at com.sun.grizzly.http.ProcessorTask.doProcess(Proce ssorTask.java:757) at com.sun.grizzly.http.ProcessorTask.process(Process orTask.java:1056) at com.sun.grizzly.http.DefaultProtocolFilter.execute (DefaultProtocolFilter.java:229) at com.sun.grizzly.DefaultProtocolChain.executeProtoc olFilter(DefaultProtocolChain.java:137) at com.sun.grizzly.DefaultProtocolChain.execute(Defau ltProtocolChain.java:104) at com.sun.grizzly.DefaultProtocolChain.execute(Defau ltProtocolChain.java:90) at com.sun.grizzly.http.HttpProtocolChain.execute(Htt pProtocolChain.java:79) at com.sun.grizzly.ProtocolChainContextTask.doCall(Pr otocolChainContextTask.java:54) at com.sun.grizzly.SelectionKeyContextTask.call(Selec tionKeyContextTask.java:59) at com.sun.grizzly.ContextTask.run(ContextTask.java:7 1) at com.sun.grizzly.util.AbstractThreadPool$Worker.doW ork(AbstractThreadPool.java:532) at com.sun.grizzly.util.AbstractThreadPool$Worker.run (AbstractThreadPool.java:513) at java.lang.Thread.run(Thread.java:722) Caused by: java.sql.SQLException at com.informix.util.IfxErrMsg.getSQLException(IfxErr Msg.java:413) at com.informix.jdbc.IfxSqli.E(IfxSqli.java:3968)

I have tried to research this error but can not find much information on the problem and was hoping that someone on the forums could assist

I have tested the web service call through SOAPUI as well and get the same error on site but not in the test environment. The web service itself appears to be working fine, I have traced the XML packets in Wireshark, its just the insert into the database that appears to fail.

I also see this message in the glassfish log files : Unable to get ClientInfo for connection. Not sure if this is related and what the problem is

Any help greatly appreciated