message tracking issue in BizTalk 2004
- From: "Ollie Riches" <ollie.riches@xxxxxxxxxxxxxxxxx>
- Date: Wed, 1 Jun 2005 14:07:41 +0100
I am currently working on integration project that is utilising BizTalk
2004. We are receiving intermittent exceptions occurring in the BizTalk
framework which we believe could be down to a network infrastructure issue.
Occasionally we are unable to ping any of the BizTalk servers for about 10
seconds - this is very intermittent and we believe it causes the following
error:
The following stored procedure call failed: " { call
[dbo].[bts_AdminPreemptiveOperateOnInstances_OrchestrationHost]( ?, ?, ?, ?,
?)}". SQL Server returned error string: "The statement has been
terminated.;Cannot insert the value NULL into column 'strDBServer', table
'MsgBox.dbo.TrackingData'; column does not allow nulls. INSERT fails.;The
statement has been terminated.;Cannot insert the value NULL into column
'strDBServer', table 'MsgBox.dbo.TrackingData'; column does not allow nulls.
INSERT fails.;The statement has been terminated.;Cannot insert the value
NULL into column 'strDBServer', table 'MsgBox.dbo.TrackingData'; column does
not allow nulls. INSERT fails.;The statement has been terminated.;Cannot
insert the value NULL into column 'strDBServer', table
'MsgBox.dbo.TrackingData'; column does not allow nulls. INSERT fails.".
It appears from the above entry in the application event log that when the
BizTalk framework attempts to resolve\validate a computer name and stored
the result in the 'strDBServer' parameter - if it fails this value is null.
When the SP on the MsgBox database is called it fails because of the null
value.
I believe the issues we are having are related to connectivity to our
DNS\WINS server. To prove the point to our network infrastructure team I
need to get some better understanding of what exactly causes this issue in
BizTalk. So the questions I have are:
Does anyone know what steps occur in code before the
'[dbo].[bts_AdminPreemptiveOperateOnInstances_OrchestrationHost]( ?, ?, ?,
?, ?)}' stored procedure is called - specifically the code that sets the
'strDBServer' variable?
If the server name is resolved\validated before the
'[dbo].[bts_AdminPreemptiveOperateOnInstances_OrchestrationHost]( ?, ?, ?,
?, ?)}' stored procedure is called is the result of the
resolution\validation cached in BizTalk?
Cheers in advance
Ollie Riches
.
- Follow-Ups:
- Re: message tracking issue in BizTalk 2004
- From: Hugo Rodger-Brown
- Re: message tracking issue in BizTalk 2004
- Next by Date: erp_srv.exe high cpu usage
- Next by thread: Re: message tracking issue in BizTalk 2004
- Index(es):
Relevant Pages
|
