4 Replies Latest reply on Dec 29, 2012 3:16 PM by Steve Darnowsky

    Teiid Parser Error Trying to Create Transformation For Web Service to Relational Table

    Steve Darnowsky Newbie

      Using TEIID 7.8

      Created project based on example in the following article: https://community.jboss.org/wiki/ConvertXMLDataIntoRelationalTableDataUsingTeiid

      Entered following transformation and received error below:

       

      SELECT

      client.*

                  FROM

                              (EXEC relational_ws.invoke(binding => 'SOAP11', action => 'WINQN2', request => '<soapenv:Envelope xmlns:soapenv=\"http://schemas.xmlsoap.org/soap/envelope/\" xmlns:nyc=\"http://otda.ny.gov/wms/nyc\"><soapenv:Header/><soapenv:Body><nyc:WINQN2-XPARM><STDHDR-PARMS><HEADER-VERSION>02</HEADER-VERSION><CLIENT-USER-ID>Your id</CLIENT-USER-ID><CLIENT-MACHINE-ID>Your PC name</CLIENT-MACHINE-ID><CLIENT-APPLICATION-ID>ESB</CLIENT-APPLICATION-ID><CLIENT-COMPONENT-NAME>ESB</CLIENT-COMPONENT-NAME><CLIENT-REQUESTED-SVC>WINQN2</CLIENT-REQUESTED-SVC><HEADER-DEBUG-FLAG>F</HEADER-DEBUG-FLAG><CLIENT-ENVIRONMENT>D</CLIENT-ENVIRONMENT><CLIENT-TIMESTAMP>12081111</CLIENT-TIMESTAMP><HEADER-RESERVED></HEADER-RESERVED></STDHDR-PARMS><WINQN2-REQUEST-DATA><!--You may enter the following 3 items in any order--><START-RESULT-NUMBER>1</START-RESULT-NUMBER><MAX-RESULTS-REQUESTED>1</MAX-RESULTS-REQUESTED><SEARCH-FILTER-CRITERIA><!--You may enter the following 9 items in any order--><!--Optional:--><FILTER-BY-LASTNAME-FLAG></FILTER-BY-LASTNAME-FLAG><!--Optional:--><FILTER-BY-DOB-FLAG>N</FILTER-BY-DOB-FLAG><!--Optional:--><FILTER-SSN-FLAG>N</FILTER-SSN-FLAG><!--Optional:--><INCLUDE-OTHER-NAME-FLAG>N</INCLUDE-OTHER-NAME-FLAG><!--Optional:--><SEARCH-RESULT-SORT-CODE>N</SEARCH-RESULT-SORT-CODE><!--Optional:--><NAME-SEARCH-KEY><X03-030-NAME><!--You may enter the following 3 items in any order--><X24-110-SURNAME>doe</X24-110-SURNAME><X24-120-GIVNAME>joe</X24-120-GIVNAME><X24-130-MIDINIT>x</X24-130-MIDINIT></X03-030-NAME></NAME-SEARCH-KEY><!--Optional:--><X03-050-SEX>M</X03-050-SEX><!--Optional:--><X03-201-ACCT-NO></X03-201-ACCT-NO><!--Optional:--><X03-060-DOB>19480917</X03-060-DOB></SEARCH-FILTER-CRITERIA></WINQN2-REQUEST-DATA></nyc:WINQN2-XPARM>/soapenv:Body></soapenv:Envelope>', endpoint => 'http://mbtda051itrcaa.hsen:7800/wms/nyc')) AS f, XMLTABLE(XMLNAMESPACES('http://schemas.xmlsoap.org/soap/envelope/' AS env), '$d/env:WINQ2-XDATA/WINQN2-RESULT-DATA/CLIENT-DATA/' PASSING f.result AS d COLUMNS dob string PATH 'X03-060-DOB') AS client

       

      ERROR: Error Code:ERR.015.008.0041 Message:Unable to convert procedural parameter of type string to expected type xml