5 Replies Latest reply on Jul 17, 2013 7:52 AM by ramarajudvs

    WebService generation problems

    ramarajudvs Newbie

      CREATE VIRTUAL PROCEDURE

      BEGIN

      DECLARE string VARIABLES.IN_cardholderNumber;

      VARIABLES.IN_cardholderNumber = xpathValue(CardholderDB.CardholderDBService.getCardholder.getCardholder, '/*:getCardholder/*:arg0/*:cardholderNumber');

      DECLARE string VARIABLES.IN_storeNumber;

      VARIABLES.IN_storeNumber = xpathValue(CardholderDB.CardholderDBService.getCardholder.getCardholder, '/*:getCardholder/*:arg0/*:storeNumber');

      DECLARE string VARIABLES.IN_customerNumber;

      VARIABLES.IN_customerNumber = xpathValue(CardholderDB.CardholderDBService.getCardholder.getCardholder, '/*:getCardholder/*:arg0/*:customerNumber');

      DECLARE string VARIABLES.IN_countryCode;

      VARIABLES.IN_countryCode = xpathValue(CardholderDB.CardholderDBService.getCardholder.getCardholder, '/*:getCardholder/*:arg0/*:countryCode');

      SELECT * FROM Cardholder WHERE (New_Oracle_3_.CARDHOLDER.CARDHOLDER_NUMBER = VARIABLES.IN_cardholderNumber) AND (New_Oracle_3_.CARDHOLDER.CUSTOMER_HOME_STORE_NUMBER = VARIABLES.IN_storeNumber) AND (New_Oracle_3_.CARDHOLDER.CUSTOMER_NUMBER = VARIABLES.IN_customerNumber) AND (New_Oracle_3_.CARDHOLDER.COUNTRY_ID = VARIABLES.IN_countryCode);

      END

       

       

      Error is:

       

      The SELECT transformation is valid, but NOT fully reconciled:

      - The number of transformation output symbols does not match the number of target columns.

       

       

      Can anyone help me in resolving the problem?

        • 1. Re: WebService generation problems
          ramarajudvs Newbie

          and also i am getting error for this also

           

           

           

          CREATE VIRTUAL PROCEDURE
          BEGIN
          DECLARE string VARIABLES.IN_cardholderNumber;
          VARIABLES.IN_cardholderNumber = xpathValue(Cardholder.CardholderDBService.getCardholder.getCardholder, '/*:getCardholder/*:arg0/*:cardholderNumber');
          DECLARE string VARIABLES.IN_storeNumber;
          VARIABLES.IN_storeNumber = xpathValue(Cardholder.CardholderDBService.getCardholder.getCardholder, '/*:getCardholder/*:arg0/*:storeNumber');
          DECLARE string VARIABLES.IN_customerNumber;
          VARIABLES.IN_customerNumber = xpathValue(Cardholder.CardholderDBService.getCardholder.getCardholder, '/*:getCardholder/*:arg0/*:customerNumber');
          DECLARE string VARIABLES.IN_countryCode;
          VARIABLES.IN_countryCode = xpathValue(Cardholder.CardholderDBService.getCardholder.getCardholder, '/*:getCardholder/*:arg0/*:countryCode');
          SELECT * FROM CardholderResponses.CardholderDBService_getCardholder_getCardholderResponse WHERE (CardholderResponses.CardholderDBService_getCardholder_getCardholderResponse.REPLACE_WITH_ELEMENT_OR_COLUMN = VARIABLES.IN_cardholderNumber) AND (CardholderResponses.CardholderDBService_getCardholder_getCardholderResponse.REPLACE_WITH_ELEMENT_OR_COLUMN = VARIABLES.IN_storeNumber) AND (CardholderResponses.CardholderDBService_getCardholder_getCardholderResponse.REPLACE_WITH_ELEMENT_OR_COLUMN = VARIABLES.IN_customerNumber) AND (CardholderResponses.CardholderDBService_getCardholder_getCardholderResponse.REPLACE_WITH_ELEMENT_OR_COLUMN = VARIABLES.IN_countryCode);
          END

           

          error is:

           

          ERROR: TEIID30136 Unable to resolve element: CardholderResponses.CardholderDBService_getCardholder_getCardholderResponse.REPLACE_WITH_ELEMENT_OR_COLUMN

          • 2. Re: WebService generation problems
            Ramesh Reddy Master

            What you are exposing in output must match with your transformation. Click on reconciler tool bar icon and see and resolve the error. See http://docs.jboss.org/teiid/designer/8.1/user-guide/en-US/html_single/#using-reconciler-section

             

            Ramesh..

            • 3. Re: WebService generation problems
              Ted Jones Master

              REPLACE_WITH_ELEMENT_OR_COLUMN is just a placeholder for the actual column you want to use. Replace it with the actual value.

               

              (CardholderResponses.CardholderDBService_getCardholder_getCardholderResponse.REPLACE_WITH_ELEMENT_OR_COLUMN = VARIABLES.IN_cardholderNumber) AND (CardholderResponses.CardholderDBService_getCardholder_getCardholderResponse.REPLACE_WITH_ELEMENT_OR_COLUMN = VARIABLES.IN_storeNumber) AND (CardholderResponses.CardholderDBService_getCardholder_getCardholderResponse.REPLACE_WITH_ELEMENT_OR_COLUMN = VARIABLES.IN_customerNumber) AND (CardholderResponses.CardholderDBService_getCardholder_getCardholderResponse.REPLACE_WITH_ELEMENT_OR_COLUMN = VARIABLES.IN_countryCode);

               

              would be something like:

               

              (CardholderResponses.CardholderDBService_getCardholder_getCardholderResponse.CardHolderNo = VARIABLES.IN_cardholderNumber) AND (CardholderResponses.CardholderDBService_getCardholder_getCardholderResponse.StoreNo = VARIABLES.IN_storeNumber) AND (CardholderResponses.CardholderDBService_getCardholder_getCardholderResponse.CustNo = VARIABLES.IN_customerNumber) AND (CardholderResponses.CardholderDBService_getCardholder_getCardholderResponse.CountryCode = VARIABLES.IN_countryCode);

               

              Thanks,

              Ted

              • 4. Re: WebService generation problems
                ramarajudvs Newbie

                Its also not working Ted. I had tried it.

                • 5. Re: WebService generation problems
                  ramarajudvs Newbie

                  when i click the reconcile transformation icon, no dialouge box is opening ramesh.I am in Teiid Designer Perspective only. what should i do then?