BizTalk Server General - BAM DirectEventStream or BufferedEventStream error

Author

BAM DirectEventStream or BufferedEventStream error

Fred

2006-01-17, 5:58 pm

I have an orchestration that I use both the DirectEventStream and
BufferendEventStream using the following connection strings to which the
service account has access to both databases. Is there an easy way to find
out why I am getting this error?

new Microsoft.BizTalk.Bam.EventObservation.DirectEventStream("Integrated
Security=SSPI;Data Source=.;Initial Catalog=BAMPrimaryImport",0);
and
new Microsoft.BizTalk.Bam.EventObservation.BufferedEventStream("Integrated
Security=SSPI;Data Source=.;Initial Catalog=BizTalkMsgBoxDB",0);

I am getting the following error in the Event Log:
Event Type: Error
Event Source: XLANG/s
Event Category: None
Event ID: 10034
Date: 1/17/2006
Time: 8:13:08 AM
User: N/A
Computer: SERVER2003
Description:
Uncaught exception terminated service
InterchangeRouter.Router(ffa63609-6f1a-0af9-4f5b-fed5a97dc866), instance
29ed9da2-7769-4b83-bae9-aa9d321516ab

Failed to execute event.

Exception type: BAMTraceException
Source: Microsoft.BizTalk.Bam.EventObservation
Target Site: Void PersistNoBatches(System.Data.SqlClient.SqlConnection,
Int32)
Help Link:
Additional error information:

Parameter is not valid.

Exception type: BAMRuntimeException
Source: Microsoft.BizTalk.Bam.EventObservation
Target Site: System.String GetArgsSQL(System.Data.SqlClient.SqlConnection,
System.Data.SqlClient.SqlTransaction)
Help Link:
Additional error information:

For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.

Keith Lim

2006-01-18, 5:52 pm

Hi Fred,

From the constructor parameters for both DirectEventStream and
BufferedEventStream instances that you have created, where you use 0 as the
flush-threshold, can I pressume that you have called
ES.Flush() somewhere after you have called ES.BeginActiivty, UpdateActivity
and EndActivity.

To help us narrow down the problem, could you spice in the Flush after
each of the above calls.

Also, if you have many dataitems mapped from one shape, perhaps you could
test them by having one item mapped at a time. I suspect that there is an
incompatible type (between item in message and item in activity) for one of
the item mapped.

Please let me know how it goes.

Thanks,
Keith Lim [MSFT]

--------------------[vbcol=seagreen]
find[vbcol=seagreen]
Microsoft.BizTalk.Bam.EventObservation.BufferedEventStream("Integrated[vbcol=seagreen]
GetArgsSQL(System.Data.SqlClient.SqlConnection,[vbcol=seagreen]

Thanks,
Keith Lim [MSFT]
My BizTalk BAM Blog: http://blogs.msdn.com/keithlim/default.aspx
--

This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

Note: For the benefit of the community-at-large, all responses to this
message are best directed to the newsgroup/thread from which they
originated.

Fred

2006-01-20, 5:55 pm

Yes I am using the Flush() right before I do the EndActivity() like is
demo'd in the SDK.
"To help us narrow down the problem, could you spice in the Flush after
each of the above calls."

Please explain spice?

Is there a log somewhere that tells me what Argument is not being
satisified?
">>>Target Site: System.String
> GetArgsSQL(System.Data.SqlClient.SqlConnection,

"Keith Lim (MSFT)" <keithlim2020@online.microsoft.com> wrote in message
news:17GR0zHHGHA.3696@TK2MSFTNGXA02.phx.gbl...[vbcol=seagreen]
>
> Hi Fred,
>
> From the constructor parameters for both DirectEventStream and
> BufferedEventStream instances that you have created, where you use 0 as
> the
> flush-threshold, can I pressume that you have called
> ES.Flush() somewhere after you have called ES.BeginActiivty,
> UpdateActivity
> and EndActivity.
>
> To help us narrow down the problem, could you spice in the Flush after
> each of the above calls.
>
> Also, if you have many dataitems mapped from one shape, perhaps you could
> test them by having one item mapped at a time. I suspect that there is an
> incompatible type (between item in message and item in activity) for one
> of
> the item mapped.
>
> Please let me know how it goes.
>
> Thanks,
> Keith Lim [MSFT]
>
> --------------------
> find
> Microsoft.BizTalk.Bam.EventObservation.BufferedEventStream("Integrated
> GetArgsSQL(System.Data.SqlClient.SqlConnection,
>
> Thanks,
> Keith Lim [MSFT]
> My BizTalk BAM Blog: http://blogs.msdn.com/keithlim/default.aspx
> --
>
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
>
> Note: For the benefit of the community-at-large, all responses to this
> message are best directed to the newsgroup/thread from which they
> originated.
>

Fred

2006-01-24, 7:50 am

I put an entry into the event log on each point, and it is causing this
error when I do the flush.

Why would that be, I have the example all zipped. Is there a way to get it
to you?

Thanks,
Eric
"Fred" <fred@aol.com> wrote in message
news:OQzPjehHGHA.3100@tk2msftngp13.phx.gbl...
> Yes I am using the Flush() right before I do the EndActivity() like is
> demo'd in the SDK.
> "To help us narrow down the problem, could you spice in the Flush after
> each of the above calls."
>
> Please explain spice?
>
> Is there a log somewhere that tells me what Argument is not being
> satisified?
> ">>>Target Site: System.String
>
>
> "Keith Lim (MSFT)" <keithlim2020@online.microsoft.com> wrote in message
> news:17GR0zHHGHA.3696@TK2MSFTNGXA02.phx.gbl...
>
>

Keith Lim

2006-01-24, 6:04 pm

Hi Fred,

Take a look at the record in TDDS_FailedTrackingData table in
BAMPrimaryImport* database. The record should give you some clues as to
what went wrong (i.e. which column is having problem).
Sorry about the typo on the spice thing, it should be "splice". Since you
already have a Flush at the end of EndActivity, could you splice additional
Flush calls after BeginActiivty and every UpdateActivity calls.

Also, let me know what you see in these tables*:

bam_<activityname>_active
bam_<activityname>_completed
bam_<activityname>_* (relationship & continuation)

Let me know how it goes.

Thanks,
Keith Lim [MSFT]

* I pressume these are in BAMPrimaryImport db.

--------------------[vbcol=seagreen]
<17GR0zHHGHA.3696@TK2MSFTNGXA02.phx.gbl>[vbcol=seagreen]
could[vbcol=seagreen]
an[vbcol=seagreen]
one[vbcol=seagreen]
the[vbcol=seagreen]
Microsoft.BizTalk.Bam.EventObservation.DirectEventStream("Integrated[vbcol=seagreen]
instance[vbcol=seagreen]

Thanks,
Keith Lim [MSFT]
My BizTalk BAM Blog: http://blogs.msdn.com/keithlim/default.aspx
--

This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

Note: For the benefit of the community-at-large, all responses to this
message are best directed to the newsgroup/thread from which they
originated.

kiwigafa

2006-01-31, 2:48 am

Fred wrote:
> I have an orchestration that I use both the DirectEventStream and
> BufferendEventStream using the following connection strings to which the
> service account has access to both databases. Is there an easy way to find
> out why I am getting this error?
>
> new Microsoft.BizTalk.Bam.EventObservation.DirectEventStream("Integrated
> Security=SSPI;Data Source=.;Initial Catalog=BAMPrimaryImport",0);
> and
> new Microsoft.BizTalk.Bam.EventObservation.BufferedEventStream("Integrated
> Security=SSPI;Data Source=.;Initial Catalog=BizTalkMsgBoxDB",0);
>
> I am getting the following error in the Event Log:
> Event Type: Error
> Event Source: XLANG/s
> Event Category: None
> Event ID: 10034
> Date: 1/17/2006
> Time: 8:13:08 AM
> User: N/A
> Computer: SERVER2003
> Description:
> Uncaught exception terminated service
> InterchangeRouter.Router(ffa63609-6f1a-0af9-4f5b-fed5a97dc866), instance
> 29ed9da2-7769-4b83-bae9-aa9d321516ab
>
> Failed to execute event.
>
> Exception type: BAMTraceException
> Source: Microsoft.BizTalk.Bam.EventObservation
> Target Site: Void PersistNoBatches(System.Data.SqlClient.SqlConnection,
> Int32)
> Help Link:
> Additional error information:
>
> Parameter is not valid.
>
> Exception type: BAMRuntimeException
> Source: Microsoft.BizTalk.Bam.EventObservation
> Target Site: System.String GetArgsSQL(System.Data.SqlClient.SqlConnection,
> System.Data.SqlClient.SqlTransaction)
> Help Link:
> Additional error information:
>
>
>
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.

Hi, I just stumbled across and found the cause of an error with exactly
the same symptoms in terms of event log bahaviour. I hope the cause is
the same and that this solves your, or someone elses problem.

The problem for me was that in my calls to the DirectEventStream object
as below:

objEventStream.BeginActivity("Activity Name",varItemId);

objEventStream.UpdateActivity("Activity Name",varItemId,
"Item",varItem);

I was referring to the activty by the name I created in excel - that
name included a space.

This space is lost when moving the activtiy definition into the
BAMPrimaryImport database, so all the stored procedures and other
artifacts created are prefixed by the name of the activity without the
space.

So changing my code as below, without the space, fixed my problem.

objEventStream.BeginActivity("ActivityName",varItemId);

objEventStream.UpdateActivity("ActivityName",varItemId,
"Item",varPremium);

For some reason, these failures do not get logged in the
TDDS_FailedTrackingData table.

Hope the above helps,
Regards,
David Hall