2 Replies Latest reply on May 17, 2013 11:37 AM by Ted Jones

    Receiving Parsing error when using the Generate Relational Models From WSDL

    Drew Kopp Newbie

      I am receiving the following error when using the Generate Relational Models From WSDL.

      ERROR: TEIID31100 Parsing error: Encountered "DirectDepositServiceView.getDirectDeposit_response.xml_in COLUMNS effectiveDate [*]dateTime[*] PATH '/soapBody/nsgetDirectDepositResponse/return/effectiveDate'" at line 6, column 31.

      Was expecting: "string" | "varbinary" | "varchar" | "boolean" | "byte" | "tinyint" | "short" | "smallint" | "char" | "integer" ...

       

      The following virtual procedure was auto generated

      CREATE VIRTUAL PROCEDURE

      BEGIN

                      SELECT t.* FROM

                                      XMLTABLE(XMLNAMESPACES('http://directdeposit.webservice.people.hrii.adp.com/' AS ns, 'http://schemas.xmlsoap.org/soap/envelope/' AS soap) , '/soap:Envelope' PASSING DirectDepositServiceView.getDirectDeposit_response.xml_in

                      COLUMNS

                                      effectiveDate dateTime PATH '/soapBody/nsgetDirectDepositResponse/return/effectiveDate',

                                      newEffectiveDate dateTime PATH '/soapBody/nsgetDirectDepositResponse/return/newEffectiveDate',

                                      AccTypeValue string PATH '/soapBody/nsgetDirectDepositResponse/return/directDepositAccounts/accountType/value',

                                      AcctTypeShortName string PATH '/soapBody/nsgetDirectDepositResponse/return/directDepositAccounts/accountType/shortName',

                                      AcctTypeDescr string PATH '/soapBody/nsgetDirectDepositResponse/return/directDepositAccounts/accountType/description',

                                      NewAcctTypeValue string PATH '/soapBody/nsgetDirectDepositResponse/return/directDepositAccounts/newAccountType/value',

                                      NewAcctTypeShortName1 string PATH '/soapBody/nsgetDirectDepositResponse/return/directDepositAccounts/newAccountType/shortName',

                                      NewAcctTypeDescr string PATH '/soapBody/nsgetDirectDepositResponse/return/directDepositAccounts/newAccountType/description',

                                      BankValue string PATH '/soapBody/nsgetDirectDepositResponse/return/directDepositAccounts/bank/value',

                                      BankShortName string PATH '/soapBody/nsgetDirectDepositResponse/return/directDepositAccounts/bank/shortName',

                                      BankDescr string PATH '/soapBody/nsgetDirectDepositResponse/return/directDepositAccounts/bank/description',

                                      accountNumber string PATH '/soapBody/nsgetDirectDepositResponse/return/directDepositAccounts/accountNumber',

                                      fullDeposit boolean PATH '/soapBody/nsgetDirectDepositResponse/return/directDepositAccounts/fullDeposit',

                                      depositAmount double PATH '/soapBody/nsgetDirectDepositResponse/return/directDepositAccounts/depositAmount',

                                      prenoteRequired boolean PATH '/soapBody/nsgetDirectDepositResponse/return/directDepositAccounts/prenoteRequired',

                                      prenoteDate dateTime PATH '/soapBody/nsgetDirectDepositResponse/return/directDepositAccounts/prenoteDate',

                                      deleted boolean PATH '/soapBody/nsgetDirectDepositResponse/return/directDepositAccounts/deleted',

                                      deleteEffDateRecord boolean PATH '/soapBody/nsgetDirectDepositResponse/return/deleteEffDateRecord',

                                      endEffectiveDate dateTime PATH '/soapBody/nsgetDirectDepositResponse/return/endEffectiveDate') AS t;

      END

       

      I am using Teid Designer 8.1 final with JBOSS 7.1.1 and Teiid 8.3 final server (Windows 7)