DBLookup functioids not working

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › DBLookup functioids not working

Viewing 1 reply thread
  • Author
    Posts
    • March 17, 2013 at 11:43 PM #26017
      community-content

        I have used an inbound and outbound schema and the basic mapping is working fine.

        When I add a dblookup along with value extractor functoid it is not working.

        Both database and biztalk runs on the same computer. The connection string is a valid string and I used SQLOLEDB provider with Persist Security Info=false and provided all other credentials.

        I had validated inbound, outbound and maps no errors were thrown.

        Any help would be much appreciated.

      • March 19, 2013 at 7:03 AM #26021
        community-content

          can you let me know the error in more detail

          • March 19, 2013 at 8:18 AM #26022
            community-content

              I don't know what's the problem! schemas and maps are tested and validated with no issues

              • March 31, 2013 at 4:51 PM #26028
                community-content

                  There might be some configuration issue. The problem is ValueExtractor functoid wont return you any Error if any. It will return blank.

                  So what you can do is use a Error Return Functoid and see if any Error is returned. Most probably it is access issue with databases.

                  msdn.microsoft.com/…/aa559365(v=bts.20).aspx

          • Author
            Posts
          Viewing 1 reply thread
          • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.