Article ID: 884532 - View products that this article applies to.
In Microsoft BizTalk Server 2004, the Microsoft SQL Server Agent job TrackedMessages_Copy_BizTalkMsgBoxDb fails and you receive an error message that is similar to the following:
Cannot insert the value NULL into column 'uidBodyPartID', table 'BizTalkMsgBoxDb.dbo.Tracking_Spool1'; column does not allow nulls.
This problem occurs because the uidBodyPartID column in the Tracking_Spool1 and Tracking_Spool2 tables in the BizTalk Server MessageBox database should allow NULL values because this value may be null under some conditions.
Service pack informationTo resolve this problem, obtain the latest service pack for Microsoft BizTalk Server 2004. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/888751/ )How to obtain the latest BizTalk Server 2004 service pack
Other resolution informationTo resolve this problem, configure the uidBodyPartID column in the Tracking_Spool1 and Tracking_Spool2 tables in the BizTalk Server MessageBox database to allow NULL values. To do this, follow these steps:
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section. This problem was corrected in BizTalk Server 2004 Service Pack 1.
BizTalk Server 2004 creates several SQL Server Agent jobs that maintain BizTalk Server databases. These jobs are scheduled to run automatically at different intervals. By default, the TrackedMessages_Copy_BizTalkMsgBoxDb job is scheduled to run every 60 seconds.
Article ID: 884532 - Last Review: June 28, 2005 - Revision: 3.2