Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

FIX: "Cannot insert the value NULL" error occurs when you use sequential convoy in BizTalk Server 2013


View products that this article applies to.

Symptoms

When you use a sequential convoy and a filter on a receive shape in a Microsoft BizTalk Server 2013 orchestration, and the receive shape activates the orchestration, the orchestration is suspended, the implementation of the sequential convoy fails, and you receive the following error message:
Uncaught exception (see the 'inner exception' below) has suspended an instance of service ‘ServiceInstanceName'.
The service instance will remain suspended until administratively resumed or terminated.
If resumed the instance will continue from its last persisted state and may re-throw the same unexpected exception.
InstanceId: InstanceID
Shape name: ShapeName
ShapeId: ShapeID
Exception thrown from: segment 2, progress 4
Inner exception: Exception occurred when persisting state to the database.
Exception type: PersistenceException
Source: Microsoft.XLANGs.BizTalk.Engine
Target Site: Void Commit()
Additionally, the following "BizTalk Server" entry is logged in the Application log:
The following stored procedure call failed: " { call [dbo].[bts_AddConvoySetInstance]( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)}". SQL Server returned error string: "The statement has been terminated.;Cannot insert the value NULL into column '<column name>', table '<table name>'; column does not allow nulls. INSERT fails.".

↑ Back to the top


Resolution

Cumulative update information

This issue was first fixed in the following cumulative update of BizTalk Server:

↑ Back to the top


Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

↑ Back to the top


References

For information about the service packs and cumulative update list for BizTalk Server, see KB 2555976: Service pack and cumulative update list for BizTalk Server .

For more information about BizTalk Server hotfixes, see KB 2003907: Information about BizTalk hotfixes and cumulative update support .

↑ Back to the top


Keywords: kbqfe, kbfix, kbsurveynew, kbexpertiseadvanced, kb

↑ Back to the top

Article Info
Article ID : 2936805
Revision : 1
Created on : 1/7/2017
Published on : 10/10/2016
Exists online : False
Views : 369