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 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()
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.".