Strongly Typed Dataset In Orchestration - Problems

The activity that you are trying to access is for the current orchestration or already finished orchestration? If it is for the current orchestration I don't think you can access until the orchestration commits the transaction....

Thanks,

Sarbillgates

SaravanaKumar_1977 at 2007-10-2 >

Just to clear up why I am doing this.

I have 2 orchestrations running. "Shipment" and "Item".

When a new item is added to shipment, I need to do a lookup in BAM to find the activity id of the item so that I can add the relationship between the 2 entities.

TM

etones at 2007-10-2 >

Hi guys,

I am using BAM to track my business process, as i believe it is meant to be used. Not to correlation messages.

I need to create a relationship between entities in 2 running orchestrations. I have the activity id of the orchestration that the message arrives at, however I need to lookup the activityid of the other orchestration. Why do my SQL lookups not work? I can see that the data has been populated into the database. If I run the query in SQL management studio, I get the data back that I need.

If I run this code via the expression shape, it tells me there are no rows. I'm confused.

Any help appreciated.

Kind regards

Tarun

etones at 2007-10-2 >

There is nothing magical about accessing the BAM Dbs. This should work like querying any other SQL view and then you are just using this data..

So let's review: Looking at the thread it seems that:

• First a instance goes one orch and is given an activity ID (AutoGenerated)
• Then an instance goes through another Orch and in this orch you want to query the the BAM views for the original view to find an instance ID, and crearte a relationship

I agree this should work and is certainly within the functionality of BAM

Is that about right? I have a funny feeling that the issue you are facing may one of rights.

• First are you querying the topmost view? BAM is designed for access to the unified views and not the subviews and tables.
• Secondly, hace you added the User Context for that host running the orchestration (BTS_Host..) to have rights to the view with the BM?

• bm.exe add-account

  bm.exe add-account -AccountNameomain\user -ViewalesManagerView

• When you run in query in the SQL Management studio you are probably running as DBO. WHen running in the orchestration the query is being executed in a different user context.

Does that make sense? Let me know if it works.

Thx - brad

BradParis(MSFT) at 2007-10-2 >

Could you provide us more information as to the BizTalk version you are using, whether the BAM tracking is through TPE only or a mixed of TPE-enabled tracking and EventStream API? If using EventStream, which one are you using? What kind of orchestration scope you have, how are the two orchestration linked - exec/call or independent?

In most common cases I have seen, where there are relationships between activities, the best pratice is to use a piece of data from the payload message and not the auto-generated one. This piece of data used as activity id must be unique.

Now, let's say you have Shipping Orchestration and Item Orchestration. Message going to one of them must contain the id of the other one. E.g. it does not matter when the relationship is established, you can either Item101 addrelationship to shipping UPS005 or vice versa. Internally, the system will do a reverse lookup of the relationship.

Event if you can get the dataset running without error, I would not recommend it. Depending of the orchestration scope you are using and the kind of BAM persistency used (my initial questions), the BAM event you wanted may not have been persisted yet.

KeithLim at 2007-10-2 >