Re: BizTalk 2004 :: Fact retriever :: more than 1 data connection?
- From: "Matt Milner" <matt.milner@m3technologypartners dot com>
- Date: Thu, 2 Jun 2005 15:44:47 -0500
I'm wondering what newXML is in this scenario? What does your rule or rules
look like? Can you post those?
Matt
"BlueDolphin" <BlueDolphin@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:430638D6-D27B-4D03-A1C4-611AE6DA9642@xxxxxxxxxxxxxxxx
> Hello Matt,
> I tried executing the assert statement twice so that my rules policy can
> go
> to different tables in the database to grab the data, but I encountered
> the
> error:
>
> Microsoft.RuleEngine.PolicyExecutionException: An exception occurred
> inside
> the rule engine instance executing policy
> "EMRXServiceInterchangeEngineRulesPolicy". --->
> Microsoft.RuleEngine.RuleEngineArgumentNullException: The value of
> argument
> "newXml" cannot be null.
> at Microsoft.RuleEngine.Rete.Rete.ProcessException(Exception ex)
> at Microsoft.RuleEngine.Rete.Rete.ExecuteInternal(Object facts, Object
> data)
> at Microsoft.RuleEngine.Rete.Rete.ProcessingLoop(Operation operation,
> Object facts, Object data, EngineState nextState)
> at Microsoft.RuleEngine.Rete.Rete.Execute(Object facts)
> at Microsoft.RuleEngine.Policy.ExecuteInternal(Object facts)
> --- End of inner exception stack trace ---
> at Microsoft.RuleEngine.Policy.ExecuteInternal(Object facts)
> at Microsoft.RuleEngine.Policy.Execute(Object facts)
> at Microsoft.RuleEngine.Policy.Execute(Object[] facts)
> at
> EMRX.Orchestration.ServiceInterchangeEngine.EMRXServiceInterchangeOrchestration.segment3(StopConditions
> stopOn)
> at Microsoft.XLANGs.Core.SegmentScheduler.RunASegment(Segment s,
> StopConditions stopCond, Exception& exp)
> Microsoft.RuleEngine.PolicyExecutionException
>
> Below is the updatefact method that I try to simulate what you've
> mentioned.
>
> public object UpdateFacts (RuleSetInfo ruleSetInfo, RuleEngine engine,
> object factsHndlIn)
> {
> object factsHndlOut = null;
> // The following logic asserts the required DB rows only once.
> // The initial values (cached during the first retrieval) are returned in
> subsequent execution cycles
> if (factsHndlIn == null)
> {
> SqlConnection con1;
> DataConnection dc1, dc2;
>
> con1 = new SqlConnection( "Data Source=(local);Initial
> Catalog=EMRX;UID=sa;Pwd=pass@word1;");
> dc1 = new DataConnection( "EMRX", "PublishedServicesList", con1);
> engine.Assert( dc1);
> dc2 = new DataConnection( "EMRX", "ServicesSubscription", con1);
> engine.Assert( dc2);
> factsHndlOut = dc2;
> }
> else
> {
> factsHndlOut = factsHndlIn;
> }
> return factsHndlOut;
> }
>
> But if I remove away the two lines
> dc2 = new DataConnection( "EMRX", "ServicesSubscription", con1);
> engine.Assert( dc2);
> the policy would runs properly.
>
> Appreciate if you could enlighten me on the missing link.
> I'm new to BizTalk, any help is greatly appreciated.
> Thanks.
>
> Regards,
> Desmond
>
>
>
> "Matt Milner" wrote:
>
>> Simply create and assert more than one dataconnection. If you are using
>> the
>> same database, you can reuse the SqlConnection like so:
>>
>> DataConnection dc1 =
>> > new DataConnection("foo", "fum", con1);
>> > Dataconnection dc2 = new DataConnection("bar", "bum", con1);
>> > engine.Assert(dc1);
>> engine.Assert(dc2);
>>
>> It is not the return value that gets entered intot the engine for
>> execution,
>> the factsHandleOut is your handle to know whether to refresh the facts.
>> This
>> is a little confusing, I know and it is a shame that most samples show
>> the
>> connection being handed back.
>>
>> You can also create another sql connection, wrap it with the second data
>> connection and assert that. Similarly, if you are asserting
>> datatable/datarow facts, you can use the sql connection to retrieve those
>> and assert them.
>>
>> Matt
>>
>>
>>
>> "BA" <biztalk.architect@xxxxxxxxx> wrote in message
>> news:1116329399.521056.291710@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>> > Hello,
>> >
>> > In the code below you set a single data connection for a single DB
>> > table.
>> >
>> > I have many data connections to add, how do you extend this sample to
>> > add more than 1 data connection?
>> > public class DbFactRetriever : IFactRetriever
>> > {
>> >
>> > public object UpdateFacts(RuleSetInfo rulesetInfo,
>> > Microsoft.RuleEngine.RuleEngine engine,
>> > object factsHandleIn)
>> >
>> > {
>> > object factsHandleOut;
>> >
>> > SqlConnection con1 = new
>> > SqlConnection("Initial Catalog=foo;
>> > Data Source=(local);Integrated Security=SSPI;");
>> >
>> > DataConnection dc1 =
>> > new DataConnection("foo", "fum", con1);
>> >
>> > engine.Assert(dc1);
>> > factsHandleOut = dc1;
>> > }
>> > return factsHandleOut;
>> > }
>> >
>> >
>> > I'm still learning C# so any help would be greatly appreciated.
>> >
>> > Thanks!
>> >
>> > BA
>> >
>>
>>
>>
.
- Follow-Ups:
- Re: BizTalk 2004 :: Fact retriever :: more than 1 data connection?
- From: BlueDolphin
- Re: BizTalk 2004 :: Fact retriever :: more than 1 data connection?
- Prev by Date: Re: BizTalk 2004 Rule Engine Fact Retriever Problem
- Next by Date: Re: Orchestrations vs. Traditional programming
- Previous by thread: Re: BizTalk 2004 Rule Engine Fact Retriever Problem
- Next by thread: Re: BizTalk 2004 :: Fact retriever :: more than 1 data connection?
- Index(es):
Relevant Pages
|
