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

    Web Service execution error

    virtualdatabase

      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
          tejones

          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

            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
              shawkins

              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

                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
                  shawkins

                  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

                    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

                      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
                        tejones

                        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

                          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
                            tejones

                            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

                              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
                                tejones

                                Can you please attach your MPS and generated WAR?