2 Replies Latest reply on Mar 4, 2013 1:59 PM by Steven Hawkins

    Calling Procedure on Teiid 8.3 CR1 for multi-source gives exception

    Onkar Dhuri Newbie

      Hi,

       

      I am trying to execute a procedure using teiid 8.3 CR1 for multi-source vdb. I am getting the result but at the same time, the exception is logged on server.

       

      The interesting thing to note here is, the exception is logged only for first call to the procedure. For subsequent calls to same procedure, the exeception is not logged.

       

      In every case, I am getting the result back to client.

       

      Here is the test code I used -

       

      -------------------------------------------------------------------------------------------------------------------------------------------------------------------------

       

              String getSystenGeneratedValueSQL = "{call nextval(?,?)}";

              try {

                  Class.forName("org.teiid.jdbc.TeiidDriver");

                  connection = DriverManager.getConnection("jdbc:teiid:OW_TEIID@mm://localhost:31000", "user", "user");

              } catch (SQLException e) {

                  e.printStackTrace();

              }

              callableStatement = connection.prepareCall(getSystenGeneratedValueSQL);

              callableStatement.setString(1, "GridSet");

              callableStatement.setString(2, "FLOUNDER");

              ResultSet rs = callableStatement.executeQuery();

              while (rs.next()) {

                  systemGeneratedId = rs.getString(1);

                  Logger.getLogger(this.getClass().getCanonicalName()).info(systemGeneratedId.toString());

              }

       

      -------------------------------------------------------------------------------------------------------------------------------------------------------------------------

       

      Here is the server log -

       

       

      -------------------------------------------------------------------------------------------------------------------------------------------------------------------------

       

      18:08:21,116 ERROR [stderr] (New I/O server worker #1-1) java.util.logging.ErrorManager: 5: Formatting error

       

      18:08:21,117 ERROR [stderr] (New I/O server worker #1-1) java.lang.IllegalArgumentException: can't parse argument number call nextval(?

       

      18:08:21,119 ERROR [stderr] (New I/O server worker #1-1)     at java.text.MessageFormat.makeFormat(MessageFormat.java:1339)

       

      18:08:21,121 ERROR [stderr] (New I/O server worker #1-1)     at java.text.MessageFormat.applyPattern(MessageFormat.java:458)

       

      18:08:21,123 ERROR [stderr] (New I/O server worker #1-1)     at java.text.MessageFormat.<init>(MessageFormat.java:350)

       

      18:08:21,125 ERROR [stderr] (New I/O server worker #1-1)     at java.text.MessageFormat.format(MessageFormat.java:811)

       

      18:08:21,127 ERROR [stderr] (New I/O server worker #1-1)     at org.jboss.logmanager.ExtLogRecord.formatRecord(ExtLogRecord.java:382)

       

      18:08:21,130 ERROR [stderr] (New I/O server worker #1-1)     at org.jboss.logmanager.ExtLogRecord.getFormattedMessage(ExtLogRecord.java:344)

       

      18:08:21,132 ERROR [stderr] (New I/O server worker #1-1)     at org.jboss.logmanager.formatters.Formatters$10.renderRaw(Formatters.java:357)

       

      18:08:21,134 ERROR [stderr] (New I/O server worker #1-1)     at org.jboss.logmanager.formatters.Formatters$JustifyingFormatStep.render(Formatters.java:148)

       

      18:08:21,136 ERROR [stderr] (New I/O server worker #1-1)     at org.jboss.logmanager.formatters.MultistepFormatter.format(MultistepFormatter.java:86)

       

      18:08:21,139 ERROR [stderr] (New I/O server worker #1-1)     at org.jboss.logmanager.ExtFormatter.format(ExtFormatter.java:35)

       

      18:08:21,141 ERROR [stderr] (New I/O server worker #1-1)     at org.jboss.logmanager.handlers.WriterHandler.doPublish(WriterHandler.java:49)

       

      18:08:21,143 ERROR [stderr] (New I/O server worker #1-1)     at org.jboss.logmanager.ExtHandler.publish(ExtHandler.java:64)

       

      18:08:21,145 ERROR [stderr] (New I/O server worker #1-1)     at org.jboss.logmanager.LoggerNode.publish(LoggerNode.java:283)

       

      18:08:21,148 ERROR [stderr] (New I/O server worker #1-1)     at org.jboss.logmanager.LoggerNode.publish(LoggerNode.java:291)

       

      18:08:21,150 ERROR [stderr] (New I/O server worker #1-1)     at org.jboss.logmanager.Logger.logRaw(Logger.java:649)

       

      18:08:21,152 ERROR [stderr] (New I/O server worker #1-1)     at org.jboss.logmanager.Logger.log(Logger.java:600)

       

      18:08:21,154 ERROR [stderr] (New I/O server worker #1-1)     at org.jboss.logging.JBossLogManagerLogger.doLog(JBossLogManagerLogger.java:46)

       

      18:08:21,157 ERROR [stderr] (New I/O server worker #1-1)     at org.jboss.logging.Logger.log(Logger.java:1775)

       

      18:08:21,159 ERROR [stderr] (New I/O server worker #1-1)     at org.teiid.jboss.JBossLogger.log(JBossLogger.java:53)

       

      18:08:21,161 ERROR [stderr] (New I/O server worker #1-1)     at org.teiid.logging.LogManager.logMessage(LogManager.java:386)

       

      18:08:21,163 ERROR [stderr] (New I/O server worker #1-1)     at org.teiid.logging.LogManager.log(LogManager.java:335)

       

      18:08:21,165 ERROR [stderr] (New I/O server worker #1-1)     at org.teiid.dqp.internal.process.DQPCore.logMMCommand(DQPCore.java:649)

       

      18:08:21,167 ERROR [stderr] (New I/O server worker #1-1)     at org.teiid.dqp.internal.process.DQPCore.executeRequest(DQPCore.java:346)

       

      18:08:21,170 ERROR [stderr] (New I/O server worker #1-1)     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

       

      18:08:21,172 ERROR [stderr] (New I/O server worker #1-1)     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

       

      18:08:21,174 ERROR [stderr] (New I/O server worker #1-1)     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

       

      18:08:21,177 ERROR [stderr] (New I/O server worker #1-1)     at java.lang.reflect.Method.invoke(Method.java:597)

       

      18:08:21,179 ERROR [stderr] (New I/O server worker #1-1)     at org.teiid.logging.LogManager$LoggingProxy.invoke(LogManager.java:121)

       

      18:08:21,181 ERROR [stderr] (New I/O server worker #1-1)     at org.teiid.jboss.TransportService$3.invoke(TransportService.java:254)

       

      18:08:21,183 ERROR [stderr] (New I/O server worker #1-1)     at $Proxy18.executeRequest(Unknown Source)

       

      18:08:21,185 ERROR [stderr] (New I/O server worker #1-1)     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

       

      18:08:21,188 ERROR [stderr] (New I/O server worker #1-1)     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

       

      18:08:21,190 ERROR [stderr] (New I/O server worker #1-1)     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

       

      18:08:21,192 ERROR [stderr] (New I/O server worker #1-1)     at java.lang.reflect.Method.invoke(Method.java:597)

       

      18:08:21,194 ERROR [stderr] (New I/O server worker #1-1)     at org.teiid.transport.ServerWorkItem.run(ServerWorkItem.java:87)

       

      18:08:21,197 ERROR [stderr] (New I/O server worker #1-1)     at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:253)

       

      18:08:21,199 ERROR [stderr] (New I/O server worker #1-1)     at org.teiid.transport.SocketClientInstance.processMessagePacket(SocketClientInstance.java:166)

       

      18:08:21,201 ERROR [stderr] (New I/O server worker #1-1)     at org.teiid.transport.SocketClientInstance.receivedMessage(SocketClientInstance.java:152)

       

      18:08:21,204 ERROR [stderr] (New I/O server worker #1-1)     at org.teiid.transport.SSLAwareChannelHandler.messageReceived(SSLAwareChannelHandler.java:210)

       

      18:08:21,206 ERROR [stderr] (New I/O server worker #1-1)     at org.jboss.netty.channel.SimpleChannelHandler.handleUpstream(SimpleChannelHandler.java:100)

       

      18:08:21,208 ERROR [stderr] (New I/O server worker #1-1)     at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:564)

       

      18:08:21,211 ERROR [stderr] (New I/O server worker #1-1)     at org.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:783)

       

      18:08:21,213 ERROR [stderr] (New I/O server worker #1-1)     at org.jboss.netty.handler.stream.ChunkedWriteHandler.handleUpstream(ChunkedWriteHandler.java:149)

       

      18:08:21,215 ERROR [stderr] (New I/O server worker #1-1)     at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:564)

       

      18:08:21,217 ERROR [stderr] (New I/O server worker #1-1)     at org.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:783)

       

      18:08:21,220 ERROR [stderr] (New I/O server worker #1-1)     at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:302)

       

      18:08:21,222 ERROR [stderr] (New I/O server worker #1-1)     at org.jboss.netty.handler.codec.frame.FrameDecoder.unfoldAndFireMessageReceived(FrameDecoder.java:317)

       

      18:08:21,224 ERROR [stderr] (New I/O server worker #1-1)     at org.jboss.netty.handler.codec.frame.FrameDecoder.callDecode(FrameDecoder.java:299)

       

      18:08:21,226 ERROR [stderr] (New I/O server worker #1-1)     at org.jboss.netty.handler.codec.frame.FrameDecoder.messageReceived(FrameDecoder.java:216)

       

      18:08:21,229 ERROR [stderr] (New I/O server worker #1-1)     at org.jboss.netty.channel.SimpleChannelUpstreamHandler.handleUpstream(SimpleChannelUpstreamHandler.java:80)

       

      18:08:21,232 ERROR [stderr] (New I/O server worker #1-1)     at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:564)

       

      18:08:21,233 ERROR [stderr] (New I/O server worker #1-1)     at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:559)

       

      18:08:21,236 ERROR [stderr] (New I/O server worker #1-1)     at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:274)

       

      18:08:21,238 ERROR [stderr] (New I/O server worker #1-1)     at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:261)

       

      18:08:21,240 ERROR [stderr] (New I/O server worker #1-1)     at org.jboss.netty.channel.socket.nio.NioWorker.read(NioWorker.java:351)

       

      18:08:21,242 ERROR [stderr] (New I/O server worker #1-1)     at org.jboss.netty.channel.socket.nio.NioWorker.processSelectedKeys(NioWorker.java:282)

       

      18:08:21,244 ERROR [stderr] (New I/O server worker #1-1)     at org.jboss.netty.channel.socket.nio.NioWorker.run(NioWorker.java:202)

       

      18:08:21,246 ERROR [stderr] (New I/O server worker #1-1)     at org.jboss.netty.util.ThreadRenamingRunnable.run(ThreadRenamingRunnable.java:108)

       

      18:08:21,248 ERROR [stderr] (New I/O server worker #1-1)     at org.jboss.netty.util.internal.DeadLockProofWorker$1.run(DeadLockProofWorker.java:44)

       

      18:08:21,250 ERROR [stderr] (New I/O server worker #1-1)     at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)

       

      18:08:21,251 ERROR [stderr] (New I/O server worker #1-1)     at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)

       

      18:08:21,253 ERROR [stderr] (New I/O server worker #1-1)     at java.lang.Thread.run(Thread.java:662)

       

      18:08:21,255 ERROR [stderr] (New I/O server worker #1-1) java.util.logging.ErrorManager: 5: Formatting error

       

      18:08:21,257 ERROR [stderr] (New I/O server worker #1-1) java.lang.IllegalArgumentException: can't parse argument number call nextval(?

       

      18:08:21,259 ERROR [stderr] (New I/O server worker #1-1)     at java.text.MessageFormat.makeFormat(MessageFormat.java:1339)

       

      18:08:21,260 ERROR [stderr] (New I/O server worker #1-1)     at java.text.MessageFormat.applyPattern(MessageFormat.java:458)

       

      18:08:21,262 ERROR [stderr] (New I/O server worker #1-1)     at java.text.MessageFormat.<init>(MessageFormat.java:350)

       

      18:08:21,264 ERROR [stderr] (New I/O server worker #1-1)     at java.text.MessageFormat.format(MessageFormat.java:811)

       

      18:08:21,266 ERROR [stderr] (New I/O server worker #1-1)     at org.jboss.logmanager.ExtLogRecord.formatRecord(ExtLogRecord.java:382)

       

      18:08:21,268 ERROR [stderr] (New I/O server worker #1-1)     at org.jboss.logmanager.ExtLogRecord.getFormattedMessage(ExtLogRecord.java:344)

       

      18:08:21,269 ERROR [stderr] (New I/O server worker #1-1)     at org.jboss.logmanager.formatters.Formatters$10.renderRaw(Formatters.java:357)

       

      18:08:21,271 ERROR [stderr] (New I/O server worker #1-1)     at org.jboss.logmanager.formatters.Formatters$JustifyingFormatStep.render(Formatters.java:148)

       

      18:08:21,273 ERROR [stderr] (New I/O server worker #1-1)     at org.jboss.logmanager.formatters.MultistepFormatter.format(MultistepFormatter.java:86)

       

      18:08:21,274 ERROR [stderr] (New I/O server worker #1-1)     at org.jboss.logmanager.ExtFormatter.format(ExtFormatter.java:35)

       

      18:08:21,276 ERROR [stderr] (New I/O server worker #1-1)     at org.jboss.logmanager.handlers.WriterHandler.doPublish(WriterHandler.java:49)

       

      18:08:21,279 ERROR [stderr] (New I/O server worker #1-1)     at org.jboss.logmanager.ExtHandler.publish(ExtHandler.java:64)

       

      18:08:21,280 ERROR [stderr] (New I/O server worker #1-1)     at org.jboss.logmanager.LoggerNode.publish(LoggerNode.java:283)

       

      18:08:21,281 ERROR [stderr] (New I/O server worker #1-1)     at org.jboss.logmanager.LoggerNode.publish(LoggerNode.java:291)

       

      18:08:21,283 ERROR [stderr] (New I/O server worker #1-1)     at org.jboss.logmanager.Logger.logRaw(Logger.java:649)

       

      18:08:21,285 ERROR [stderr] (New I/O server worker #1-1)     at org.jboss.logmanager.Logger.log(Logger.java:600)

       

      18:08:21,287 ERROR [stderr] (New I/O server worker #1-1)     at org.jboss.logging.JBossLogManagerLogger.doLog(JBossLogManagerLogger.java:46)

       

      18:08:21,289 ERROR [stderr] (New I/O server worker #1-1)     at org.jboss.logging.Logger.log(Logger.java:1775)

       

      18:08:21,290 ERROR [stderr] (New I/O server worker #1-1)     at org.teiid.jboss.JBossLogger.log(JBossLogger.java:53)

       

      18:08:21,292 ERROR [stderr] (New I/O server worker #1-1)     at org.teiid.logging.LogManager.logMessage(LogManager.java:386)

       

      18:08:21,294 ERROR [stderr] (New I/O server worker #1-1)     at org.teiid.logging.LogManager.log(LogManager.java:335)

       

      18:08:21,296 ERROR [stderr] (New I/O server worker #1-1)     at org.teiid.dqp.internal.process.DQPCore.logMMCommand(DQPCore.java:649)

       

      18:08:21,298 ERROR [stderr] (New I/O server worker #1-1)     at org.teiid.dqp.internal.process.DQPCore.executeRequest(DQPCore.java:346)

       

      18:08:21,299 ERROR [stderr] (New I/O server worker #1-1)     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

       

      18:08:21,301 ERROR [stderr] (New I/O server worker #1-1)     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

       

      18:08:21,303 ERROR [stderr] (New I/O server worker #1-1)     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

       

      18:08:21,305 ERROR [stderr] (New I/O server worker #1-1)     at java.lang.reflect.Method.invoke(Method.java:597)

       

      18:08:21,306 ERROR [stderr] (New I/O server worker #1-1)     at org.teiid.logging.LogManager$LoggingProxy.invoke(LogManager.java:121)

       

      18:08:21,308 ERROR [stderr] (New I/O server worker #1-1)     at org.teiid.jboss.TransportService$3.invoke(TransportService.java:254)

       

      18:08:21,310 ERROR [stderr] (New I/O server worker #1-1)     at $Proxy18.executeRequest(Unknown Source)

       

      18:08:21,311 ERROR [stderr] (New I/O server worker #1-1)     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

       

      18:08:21,313 ERROR [stderr] (New I/O server worker #1-1)     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

       

      18:08:21,315 ERROR [stderr] (New I/O server worker #1-1)     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

       

      18:08:21,317 ERROR [stderr] (New I/O server worker #1-1)     at java.lang.reflect.Method.invoke(Method.java:597)

       

      18:08:21,318 ERROR [stderr] (New I/O server worker #1-1)     at org.teiid.transport.ServerWorkItem.run(ServerWorkItem.java:87)

       

      18:08:21,320 ERROR [stderr] (New I/O server worker #1-1)     at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:253)

       

      18:08:21,322 ERROR [stderr] (New I/O server worker #1-1)     at org.teiid.transport.SocketClientInstance.processMessagePacket(SocketClientInstance.java:166)

       

      18:08:21,323 ERROR [stderr] (New I/O server worker #1-1)     at org.teiid.transport.SocketClientInstance.receivedMessage(SocketClientInstance.java:152)

       

      18:08:21,325 ERROR [stderr] (New I/O server worker #1-1)     at org.teiid.transport.SSLAwareChannelHandler.messageReceived(SSLAwareChannelHandler.java:210)

       

      18:08:21,326 ERROR [stderr] (New I/O server worker #1-1)     at org.jboss.netty.channel.SimpleChannelHandler.handleUpstream(SimpleChannelHandler.java:100)

       

      18:08:21,329 ERROR [stderr] (New I/O server worker #1-1)     at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:564)

       

      18:08:21,330 ERROR [stderr] (New I/O server worker #1-1)     at org.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:783)

       

      18:08:21,332 ERROR [stderr] (New I/O server worker #1-1)     at org.jboss.netty.handler.stream.ChunkedWriteHandler.handleUpstream(ChunkedWriteHandler.java:149)

       

      18:08:21,333 ERROR [stderr] (New I/O server worker #1-1)     at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:564)

       

      18:08:21,335 ERROR [stderr] (New I/O server worker #1-1)     at org.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:783)

       

      18:08:21,337 ERROR [stderr] (New I/O server worker #1-1)     at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:302)

       

      18:08:21,338 ERROR [stderr] (New I/O server worker #1-1)     at org.jboss.netty.handler.codec.frame.FrameDecoder.unfoldAndFireMessageReceived(FrameDecoder.java:317)

       

      18:08:21,340 ERROR [stderr] (New I/O server worker #1-1)     at org.jboss.netty.handler.codec.frame.FrameDecoder.callDecode(FrameDecoder.java:299)

       

      18:08:21,342 ERROR [stderr] (New I/O server worker #1-1)     at org.jboss.netty.handler.codec.frame.FrameDecoder.messageReceived(FrameDecoder.java:216)

       

      18:08:21,344 ERROR [stderr] (New I/O server worker #1-1)     at org.jboss.netty.channel.SimpleChannelUpstreamHandler.handleUpstream(SimpleChannelUpstreamHandler.java:80)

       

      18:08:21,345 ERROR [stderr] (New I/O server worker #1-1)     at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:564)

       

      18:08:21,347 ERROR [stderr] (New I/O server worker #1-1)     at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:559)

       

      18:08:21,349 ERROR [stderr] (New I/O server worker #1-1)     at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:274)

       

      18:08:21,350 ERROR [stderr] (New I/O server worker #1-1)     at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:261)

       

      18:08:21,352 ERROR [stderr] (New I/O server worker #1-1)     at org.jboss.netty.channel.socket.nio.NioWorker.read(NioWorker.java:351)

       

      18:08:21,355 ERROR [stderr] (New I/O server worker #1-1)     at org.jboss.netty.channel.socket.nio.NioWorker.processSelectedKeys(NioWorker.java:282)

       

      18:08:21,356 ERROR [stderr] (New I/O server worker #1-1)     at org.jboss.netty.channel.socket.nio.NioWorker.run(NioWorker.java:202)

       

      18:08:21,359 ERROR [stderr] (New I/O server worker #1-1)     at org.jboss.netty.util.ThreadRenamingRunnable.run(ThreadRenamingRunnable.java:108)

       

      18:08:21,360 ERROR [stderr] (New I/O server worker #1-1)     at org.jboss.netty.util.internal.DeadLockProofWorker$1.run(DeadLockProofWorker.java:44)

       

      18:08:21,361 ERROR [stderr] (New I/O server worker #1-1)     at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)

       

      18:08:21,363 ERROR [stderr] (New I/O server worker #1-1)     at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)

       

      18:08:21,365 ERROR [stderr] (New I/O server worker #1-1)     at java.lang.Thread.run(Thread.java:662)

       

      -------------------------------------------------------------------------------------------------------------------------------------------------------------------------

       

      Can you please let me know what could be the issue ?

       

      Thanks,

      Onkar