-
1. Re: SOAP Exception When Trying to Use WS Translator In Message Mode.
shawkins Feb 20, 2013 10:29 PM (in response to darnowsi)What you have looks fine, but you'll want to check the server side log to see the details of what is happening. It appears that the exeception is coming from below Teiid, so I'm not immediately familiar with it.
Steve
-
2. Re: SOAP Exception When Trying to Use WS Translator In Message Mode.
rareddy Feb 21, 2013 9:47 AM (in response to darnowsi)SteveD,
I also suggest submitting the same payload using tool like SOAP-UI, that should weed out Teiid. Similar issue http://forum.springsource.org/showthread.php?76832-Change-namespace-of-SOAP-messages that guy had small mistake in his namespace URL.
Ramesh..
-
3. Re: SOAP Exception When Trying to Use WS Translator In Message Mode.
darnowsi Feb 21, 2013 2:57 PM (in response to rareddy)Ramesh,
I have run the following test:
Deployed a dynamic VDB for the web service setting Message and SOAP11 as translator properties.
I then am able to connect from Squirrel Clent and successfully invoke a call using the same parameters as the ones specified for the transformation in the original post. I cut and pasted these parameters from the sucessful call in invoked for client into the Teiid Designer transformation editor and it still fails.
Steve
-
4. Re: SOAP Exception When Trying to Use WS Translator In Message Mode.
rareddy Feb 21, 2013 3:39 PM (in response to darnowsi)So you are doing preview in Designer? Or did you build the VDB and deployed into server and use squirrel to execute the query?
-
5. Re: SOAP Exception When Trying to Use WS Translator In Message Mode.
darnowsi Feb 22, 2013 9:44 AM (in response to rareddy)Ramesh,
For troubleshooting puposes to see if the problem, I created the VDB with an editor and deployed into the server. Then used squirrel client to execute a query using the same parmenters as the ones entered into the transformation editor in Teiid. This was done to test the soap parameters as you suggested..
-
6. Re: SOAP Exception When Trying to Use WS Translator In Message Mode.
rareddy Feb 22, 2013 3:55 PM (in response to darnowsi)Steve,
That sounds like a bug somewhere with Designer specific VDB. Did you follow the same translator overrides to put the ws translator to use the "message" mode? see https://docs.jboss.org/author/display/TEIID/Web+Services+Translator and see how to override the "DefaultServiceMode" using the example here
https://docs.jboss.org/author/display/TEIID/Translators see Override Execution Properties.Ramesh..
-
7. Re: SOAP Exception When Trying to Use WS Translator In Message Mode.
darnowsi Feb 25, 2013 10:55 AM (in response to rareddy)Ramesh.
I am following the instructions from those links for translator overrides.
Attached is a detailed log.
Should I post this problem on teiid designer forum and as a possible bug?
Steve
-
server trace soap error.log.zip 59.4 KB
-
-
8. Re: SOAP Exception When Trying to Use WS Translator In Message Mode.
rareddy Feb 25, 2013 2:40 PM (in response to darnowsi)Can you open your Designer built VDB (this is simple ZIP file), and see the contents of the "vdb.xml" file in the META-INF directory to make sure the translator-override is set in there in accordance to the links?
Ramesh..
-
9. Re: SOAP Exception When Trying to Use WS Translator In Message Mode.
darnowsi Feb 26, 2013 11:06 AM (in response to rareddy)Ramesh,
I have done this test using 3 different vdbs now:
1. dynamic vdb for ws - built with editor and deployed manually. In this case it works and returns expected result.
2. designer built vdb for oracle and ws sources combined - this is the case where I get the namespace error.
3. designer built vdb for ws only - in this case I do not get the namespace error. The detailed server log indicates a result row retruned from the source but no rows returned to the client. this maybe a problem with xquery in the transformation used to parse the result. From Squrrel client prospectve the simple SQL query returned without an error but no rows.
I have attached the vdb for each case. The ws translator properties are the same in each and consistent with the documentation. It looks like the namespace error is related to combining a relational and ws soruce in one vdb.
-
dynamic -ws vdb.xml 717 bytes
-
-
10. Re: SOAP Exception When Trying to Use WS Translator In Message Mode.
rareddy Feb 26, 2013 1:49 PM (in response to darnowsi)Steve,
That seems highly unlikely. The next step is you can configure the CXF logging http://docs.jboss.org/teiid/7.7.0.Final/admin-guide/en-US/html_single/#ws-ds to see what is the payload being sent from Teiid in the case of Designer based VDB. They should all be same.
Ramesh..
-
11. Re: SOAP Exception When Trying to Use WS Translator In Message Mode.
darnowsi Feb 27, 2013 4:22 PM (in response to rareddy)Ramesh,
Success!
After enabled CXF logging I was abel to find the error in the XMLTable parameters for case number 3 above (designer built ws only) above so that it returned data to the client. I then took the corrected XMLTable call and replaced the one in the combined query (case number 2 above). The client query against this vdb now completes without the excpetion and returns the expected data to the client.
Thank you for all your help!!!
For the record below is the corrected transformation for case 2. The question still remains why the namespace exception went away by correcting the XMLTable call in bold below???
Anyway, I can exhale and go on with my life. Thanks again. Steve
SELECT
*
FROMWRTDBA.WRT_NY_CIN_APPS, WRTDBA.WRT_CIN, (
EXEC qn4_ws.invoke(binding => 'SOAP11', action => 'WINQIN4', request => '<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:nyc="http://otda.ny.gov/wms/nyc"><soapenv:Header/><soapenv:Body><nyc:WINQN4-XPARM><!--You may enter the following 2 items in any order--><STDHDR-PARMS><!--You may enter the following 10 items in any order--><HEADER-VERSION>02</HEADER-VERSION><CLIENT-USER-ID>TY4083</CLIENT-USER-ID><CLIENT-MACHINE-ID>ESB</CLIENT-MACHINE-ID><CLIENT-APPLICATION-ID>ESB</CLIENT-APPLICATION-ID><CLIENT-COMPONENT-NAME>SOAP-UI</CLIENT-COMPONENT-NAME><CLIENT-REQUESTED-SVC>WINQN4</CLIENT-REQUESTED-SVC><HEADER-DEBUG-FLAG>F</HEADER-DEBUG-FLAG><CLIENT-ENVIRONMENT>D</CLIENT-ENVIRONMENT><CLIENT-TIMESTAMP>20120612</CLIENT-TIMESTAMP><HEADER-RESERVED></HEADER-RESERVED></STDHDR-PARMS><WINQS4-REQUEST-DATA><!--You may enter the following 3 items in any order--><X03-010-RECIP-ID>ZX53150G</X03-010-RECIP-ID><MA-COV-START-RESULT-NUM>1</MA-COV-START-RESULT-NUM><MA-COV-MAX-RESULTS-REQ>25</MA-COV-MAX-RESULTS-REQ></WINQS4-REQUEST-DATA></nyc:WINQN4-XPARM></soapenv:Body></soapenv:Envelope>', endpoint => 'http://mbtda051itrcaa.hsen:7800/wms/nyc')) AS f, XMLTABLE(XMLNAMESPACES('http://schemas.xmlsoap.org/soap/envelope/' AS soapenv), '/soapenv:Envelope/soapenv:Body/WINQN4-XDATA/WINQN4-RESULT-DATA/CLIENT-DATA' PASSING result COLUMNS dob string PATH 'X03-060-DOB') ASqn4_base -
12. Re: SOAP Exception When Trying to Use WS Translator In Message Mode.
rareddy Feb 27, 2013 5:10 PM (in response to darnowsi)great! I believe it was because it was expecting the 'soapenv' namespace, it did could not find it before.