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

    WebService generation problems

    ramarajudvs

      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

          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
            rareddy

            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
              tejones

              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

                Its also not working Ted. I had tried it.

                • 5. Re: WebService generation problems
                  ramarajudvs

                  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?