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 > August 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
Ralph Sauer

2004-08-16, 5:54 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..


Sponsored Links






Free braindumps | Software forum | Database administration forum

Copyright 2003 - 2008 webservertalk.com