12 Replies Latest reply on Apr 19, 2013 12:46 PM by Ted Jones

    Web Service execution error

    virtualdatabase Apprentice

      I get the following (via SoapUI) when trying to execute a simple service created in TeiiD...

       

      HTTP/1.1 500 Internal Server Error

      Server: Apache-Coyote/1.1

      X-Powered-By: Servlet 2.5; JBoss-5.0/JBossWeb-2.1

      Content-Type: text/xml;charset=UTF-8

      Transfer-Encoding: chunked

      Date: Mon, 15 Apr 2013 15:37:59 GMT

      Connection: close

       

       

      <env:Envelope xmlns:env='http://schemas.xmlsoap.org/soap/envelope/'><env:Header></env:Header><env:Body><env:Fault xmlns:env='http://schemas.xmlsoap.org/soap/envelope/'><faultcode xmlns:codeNS='http://schemas.xmlsoap.org/soap/envelope/'>codeNS:Client</faultcode><faultstring>Remote org.teiid.api.exception.query.QueryParserException: Parsing error: Encountered &quot;null&quot; at line 1, column 6.

      Was expecting:

          &lt;ID&gt; ...

          </faultstring></env:Fault></env:Body></env:Envelope>

       

       

      Any suggestions?

        • 1. Re: Web Service execution error
          Ted Jones Master

          Tom,

           

          This is a KI and fixed in Teiid Designer 8.1 latest. The issue crops up with generated web services without parameters. The fix is to add a parameter to the WS procedure (if there is a primary key on the table for which the web service is generated, this will be done for you). FYI - The fix will be backported to 7.7.x and and will be made available in a future SOA 5.3.* rollup.

           

          Thanks,

          Ted

          • 2. Re: Web Service execution error
            virtualdatabase Apprentice

            I already added a PK to the view prior to 'gnerating' web service....

             

            However I have since gone back and noticed that the virtual procedure that is created for me had the "input" commented out:

             

            example:

             

            • VARIABLES.IN_MPI = xPathValue(Final_Penrad_WS.Final_Penrad_People.getPeople.People_InputMsg, '/*:People_Input/*:MPI');

             

             

            I've edited that procedure , saved/redeployed the vdb as well as re-generated the .war file but then when I execute I kept getting  "The specified session ID "anobCsgWGy5u" is invalid." so I stopped/started the server undeployed the VDB and RE-deployed the VDB, re-generated .War (and replaced it on server) but still get the invalid session error....

             

            What steps did I miss?

            • 3. Re: Web Service execution error
              Steven Hawkins Master

              The datasource you are using to connect into Teiid with likely needs to be flushed.  You can add a test query such as "SELECT 1" to do this automatically - http://docs.jboss.org/ironjacamar/userguide/1.0/en-US/html/deployment.html#deployingds_descriptor via the check-valid-connection-sql

              • 4. Re: Web Service execution error
                virtualdatabase Apprentice

                so I've obviously misunderstood the KI.

                Is there a workaround..

                what version should this have been fixed in?..

                Assuming now it's a Designer bug?

                • 5. Re: Web Service execution error
                  Steven Hawkins Master

                  I don't think you misunderstood the KI, I'm just trying to help you resolve the "The specified session ID "anobCsgWGy5u" is invalid." error, which is likely occurring because of stale connections in your Teiid connection pool.

                  • 6. Re: Web Service execution error
                    virtualdatabase Apprentice

                    Sorry for confusion.. Yes I understood and know about the need to flush the cache... but the workaround [modeling] that *I* thought would work is not the case... so I'm back to square 1.

                    • 7. Re: Web Service execution error
                      virtualdatabase Apprentice

                      I checked and there were some TeiiD updates avail... I updated and attempted to re-generate...

                      When I try to generate the WAR now I get this stack trace..

                       

                      java.lang.RuntimeException: Unable to generate WSDL

                                at org.teiid.designer.dqp.webservice.war.DefaultWebArchiveBuilderImpl.generateWsdl(DefaultWebArchiveBuilderImpl.java:736)

                                at org.teiid.designer.dqp.webservice.war.DefaultWebArchiveBuilderImpl.createWebArchive(DefaultWebArchiveBuilderImpl.java:239)

                                at org.teiid.designer.dqp.webservice.war.ui.wizards.WarDeploymentInfoDialog.execute(WarDeploymentInfoDialog.java:195)

                                at org.teiid.designer.dqp.webservice.war.ui.wizards.WarDeploymentInfoDialog$1.run(WarDeploymentInfoDialog.java:150)

                                at org.eclipse.jface.operation.ModalContext.runInCurrentThread(ModalContext.java:464)

                                at org.eclipse.jface.operation.ModalContext.run(ModalContext.java:372)

                                at org.eclipse.jface.dialogs.ProgressMonitorDialog.run(ProgressMonitorDialog.java:507)

                                at org.teiid.designer.dqp.webservice.war.ui.wizards.WarDeploymentInfoDialog.okPressed(WarDeploymentInfoDialog.java:159)

                                at org.eclipse.jface.dialogs.Dialog.buttonPressed(Dialog.java:472)

                                at org.eclipse.jface.dialogs.Dialog$2.widgetSelected(Dialog.java:624)

                                at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:240)

                                at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)

                                at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1053)

                                at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4165)

                                at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3754)

                                at org.eclipse.jface.window.Window.runEventLoop(Window.java:825)

                                at org.eclipse.jface.window.Window.open(Window.java:801)

                                at org.teiid.designer.dqp.webservice.war.ui.wizards.WarDeploymentInfoDialog.open(WarDeploymentInfoDialog.java:171)

                                at org.teiid.designer.runtime.ui.actions.GenerateWarAction.run(GenerateWarAction.java:111)

                                at org.eclipse.jface.action.Action.runWithEvent(Action.java:498)

                                at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:584)

                                at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:501)

                                at org.eclipse.jface.action.ActionContributionItem$5.handleEvent(ActionContributionItem.java:411)

                                at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)

                                at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1053)

                                at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4165)

                                at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3754)

                                at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2701)

                                at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2665)

                                at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2499)

                                at org.eclipse.ui.internal.Workbench$7.run(Workbench.java:679)

                                at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)

                                at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:668)

                                at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)

                                at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:123)

                                at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)

                                at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)

                                at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)

                                at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:344)

                                at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179)

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

                                at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

                                at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

                                at java.lang.reflect.Method.invoke(Method.java:597)

                                at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:622)

                                at org.eclipse.equinox.launcher.Main.basicRun(Main.java:577)

                                at org.eclipse.equinox.launcher.Main.run(Main.java:1410)

                                at org.eclipse.equinox.launcher.Main.main(Main.java:1386)

                      • 8. Re: Web Service execution error
                        Ted Jones Master

                        Here is the Jira I was talking about: https://issues.jboss.org/browse/TEIIDDES-1498

                         

                        What version of Designer are you running? Is there any more to that stack trace?

                        • 9. Re: Web Service execution error
                          virtualdatabase Apprentice

                          So, should the update posted today resolve this?

                          I grabbed it and re did everything bu still get the error..

                           

                          I'm running: 

                            Teiid Designer7.7.3.v20130328-2153-H3-Finalorg.teiid.designer.feature.feature.groupJBoss by Red Hat, Inc.

                           

                          and get still get this erro from soapUI

                           

                          <env:Envelope xmlns:env="http://schemas.xmlsoap.org/soap/envelope/">

                             <env:Header/>

                             <env:Body>

                                <env:Fault>

                                   <faultcode xmlns:codeNS="http://schemas.xmlsoap.org/soap/envelope/">codeNS:Client</faultcode>

                                   <faultstring>Remote org.teiid.api.exception.query.QueryParserException: Parsing error: Encountered "null" at line 1, column 6.

                          Was expecting:

                              &lt;ID> ...</faultstring>

                                </env:Fault>

                             </env:Body>

                          </env:Envelope>

                          • 10. Re: Web Service execution error
                            Ted Jones Master

                            No, the fix will be in the next rollup (~6 weeks). You can add a soapAction attribute to the soap:operation node of the generated WSDL, as the Jira mentions, and re-deploy the WAR. The soapAction can be any value, such as the operation name.

                            • 11. Re: Web Service execution error
                              virtualdatabase Apprentice

                              Ok after more careful review of the jira you reference I just wanted to point out that in my case I'm not using a procedure but a  view model table that has a PK defined prior to generating the webservice/cxf file.

                              • 12. Re: Web Service execution error
                                Ted Jones Master

                                Can you please attach your MPS and generated WAR?