-
1. Re: Web Service execution error
tejones Apr 15, 2013 12:07 PM (in response to virtualdatabase)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 Apr 15, 2013 12:24 PM (in response to tejones)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 Apr 15, 2013 12:40 PM (in response to virtualdatabase)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 Apr 15, 2013 3:25 PM (in response to 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 Apr 15, 2013 3:38 PM (in response to virtualdatabase)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 Apr 15, 2013 3:43 PM (in response to shawkins)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 Apr 15, 2013 4:25 PM (in response to 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 Apr 15, 2013 4:40 PM (in response to virtualdatabase)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 Apr 19, 2013 12:08 PM (in response to tejones)So, should the update posted today resolve this?
I grabbed it and re did everything bu still get the error..
I'm running:
Teiid Designer 7.7.3.v20130328-2153-H3-Final org.teiid.designer.feature.feature.group JBoss 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:
<ID> ...</faultstring>
</env:Fault>
</env:Body>
</env:Envelope>
-
10. Re: Web Service execution error
tejones Apr 19, 2013 12:17 PM (in response to virtualdatabase)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 Apr 19, 2013 12:40 PM (in response to tejones)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 Apr 19, 2013 12:46 PM (in response to virtualdatabase)Can you please attach your MPS and generated WAR?