Tracking Guid

Tracking Guid

Post by Chri » Thu, 22 Jan 2004 09:46:23

We have a tracking tool that we created that would log our custom
Preprocessor, BTS Mapping and AIC events. The preprocessor splits HIPAA EDI
at the ST level then submits them to Biztalk propper. The database we
created retrieves the Biztalk Tracking GUID and stores that with each
transaction it splits. At Mapping, we want to inject that Tracking GUID
into the outbound document so that we can use it with reconciling outbound

Is there a way to retrieve the Biztalk Tracking GUID while in mapping of the
curent document being processed?

I need an answer ASAP and am trying other avenues.


Tracking Guid

Post by Jan Eliase » Thu, 22 Jan 2004 16:55:50

On Tue, 20 Jan 2004 17:46:23 -0700, "Chris"

Well, first of all, the following links have information about your
basic problem;

Secondly, The only suggestion I have is to let the preprocessor not
only save the tracking_guid in the database, but also some unique
field from the document if there exists one. Then in the mapper, look
that unique field from the document up in the database and find the

I am not sure what you mean by "avenues", but I am assumig that you
somehow think that by "threatening" to use other products than BizTalk
Server, you can get a faster answer. If I am assuming wrong, then
please accept my appologies for the remainder of this post.

As far as I know, MS does not promise to watch these newsgroups (but I
find it very usefull that they do :-). So you can't expect an answer
from them. If you really want to use MS support, then you should use
the appropriate channels of support. Threatening in a
non-official-support-site is not the way.

As for the rest of us, we are voulenteers that try to help when we
can. We are doing this in our sparetime, and need not read threats
like this, nor do we care which product you choose.

I hope your problem will be solved.
Jan Eliasen, representing himself and not the company he works for.
MCP in Microsoft BizTalk Server


Tracking Guid

Post by Nick Mali » Fri, 23 Jan 2004 00:18:46

Hello Chris.

Jan's suggestion is a reasoable one. If you store the ST01, the GS02, and
the Interchange Control Number in your tracking database, you could,
theoretically, do this from within the mapper.

Personally I avoid doing database lookups from within the mapper for
performance reasons.

I have a solution which does much the same as yours. I break up inbound 837
documents at the ST level and create multiple submissions, storing the
Submission GUID in a local database along with header information. I then
pull together the 997s generated to create a single outbound 997. I also
bring together the mapped data in a single flat file representative of the
input document.

I use an AIC on the 997 port and on the mapping port. In the AIC, I access
the submission GUID from the pipeline and look up the record in my database,
performing my correlation. Are you using AICs? If so, what language are
you writing your AIC components in? (the syntax for accessing these
properties differs slightly from language to language).

I wait until all submissions are mapped and produce a single output file.
(bit of magic there... you may or may not be interested, depending on what
you are attempting to accomplish on your end).

I hope this reply was timely and helpful.
--- Nick
Biztalk Bum