Help!!! calling a database accessing component from biztalk rules engine

Home Page Forums BizTalk 2004 – BizTalk 2010 Help!!! calling a database accessing component from biztalk rules engine

Viewing 1 reply thread
  • Author
    Posts
    • #15688

      Hi,

      I have a BRE policy whic access a .net component for performing some actions. The C# Component has two different functions.. one is simple, to get the current date, and the second one access the database to get some information.

      When I test the policy, I can execute the GetCurrentDate function from the .net component without any problems. But when I call my second method, which access a SQL database, it fails with a generic error (Given below).  I tried to call this method from a small test windows application and it works fine..

      Can anyone please tell me is there any restriction in accessing a .net component which access database..?

      ERROR:

      An exception occurred when invoking class member MyClass.MyDBAccessFunction in assembly MyBusinessRules, Version=1.0.0.0, Culture=neutral, PublicKeyToken=8c3fec8e866b74b1.
      Exception has been thrown by the target of an invocation.
      Object reference not set to an instance of an object.
      ——————————————————————————–

       

       

    • #15697

      Sorry for the above post.. Apparently BRE caching was creating the problem..

      The cache was not refreshing no matter what I do.. A restart of my computer does the trick.. all the rules are working fine..

      BTW, is there any was to clean up the cashe, when u update one of the fact..  eg: a .net component..? 

       

      • #18578

        Hi Shan,
        I’m new to BRE and I’m also trying to access database using a static function in the C# component.However I cant even get to it test the policy as it gives me an error as below

        “No user object is associated to the rule <ruleName>”

        Have you seen this problem before?
        I’m doubting the credibility of my sqlConnection connectionString, what should be the syntax that’s required to establish a connection with the desired server\database??

        Regards,
        Kevin

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