BizTalk Server Orchestration - Probs with SQL used in Rules Engine when called from Orchestration

This is Interesting: Free IT Magazines  
Home > Archive > BizTalk Server Orchestration > October 2004 > Probs with SQL used in Rules Engine when called from Orchestration





You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author Probs with SQL used in Rules Engine when called from Orchestration
racs

2004-08-16, 5:55 pm

Hi, I have the following problem:

I created a small Orchestration where a XML-File comes in and is sent then to the Rules Engine using the CallRules shape.

The rule decides on two parameters, one is in the XML-File, the other should be looked up in a SQL-Database, so the rule looks like:

IF "XML-Price" is bigger than "SQL-Price" then do "Action"

When I test the Rule with the build-in Test-Engine, all works fine.

But if I let the Orchestration run, the rule is not executed.

For the XML part a Vocabulary is created, which works.

But neither a vocabulary for the SQL part nor the direct binding in the rules enginge composer (referring to the Database) work in this form of statement.

I tried a lot around and all works, if no DataBase-statement is involved.

So, for example: If XML-Price is bigger than 5 works fine.

My guess is, that as in the test tool of the Rules Composer I have to specify an instance of the Database, an instance has to be passed as a parameter in the CallRules Shape ??? But I have no clue how to manage this...

So, if anyone could help me, this woul be really fine..
brunchey

2004-10-18, 9:42 pm

You need to declare a variable of SqlConnection and DataConnection.

Please see this link...

http://msdn.microsoft.com/library/d..._rules_huft.asp
Sponsored Links






Free braindumps | Software forum | Database administration forum

Copyright 2003 - 2008 webservertalk.com