BizTalk 2016 (CU 5) Cannot register this PIP activity since it is a duplicate

Srikanth Kancharla 1 Reputation point
2021-04-02T01:00:30.153+00:00

BizTalk 2016 (CU 5) with BizTalk installed on one VM and SQL server on another VM.

While trying to send a file (3A4) to our partner I am seeing the below error, somehow the file was sent to the partner but I am seeing the below error.

xlang/s engine event log entry: Uncaught exception (see the 'inner exception' below) has suspended an instance of service 'Microsoft.Solutions.BTARN.PrivateInitiator.PrivateInitiatorProcess(37839097-9a99-4e59-e23c-ddff8539302f)'.
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: a18b0996-ee92-42a1-a91d-331516e4f6c4
Shape name: UpdateStatus
ShapeId: 81e59f34-b305-4b85-b66e-41cc595e25b3
Exception thrown from: segment 3, progress 9
Inner exception: Cannot register this PIP activity since it is a duplicate.

Exception type: ApplicationException
Source: Microsoft.Solutions.BTARN.Shared
Target Site: System.String RegisterActivity(System.String, System.String, System.String, System.String, System.String, Boolean)
The following is a stack trace that identifies the location where the exception occured

at Microsoft.Solutions.BTARN.Shared.ActivityTracking.RegisterActivity(String pipCode, String pipVersion, String pipInstanceID, String sourcePartnerName, String destinationPartnerName, Boolean isInitiatorActivity)
at Microsoft.Solutions.BTARN.PrivateInitiator.PrivateInitiatorProcess.segment3(StopConditions stopOn)
at Microsoft.XLANGs.Core.SegmentScheduler.RunASegment(Segment s, StopConditions stopCond, Exception& exp)
Additional error information:

    Violation of UNIQUE KEY constraint 'IX_ActivityTracking'. Cannot insert duplicate key in object 'dbo.ActivityTracking'. The duplicate key value is (3A4, V02.03, 2, 1, 7508561, 1).

The statement has been terminated.

Exception type: SqlException
Source: .Net SqlClient Data Provider
Target Site: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action])
The following is a stack trace that identifies the location where the exception occured

at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.Solutions.BTARN.Shared.SqlHelper.ExecuteReader(SqlConnection connection, SqlTransaction transaction, CommandType commandType, String commandText, SqlParameter[] commandParameters, SqlConnectionOwnership connectionOwnership)
at Microsoft.Solutions.BTARN.Shared.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)
at Microsoft.Solutions.BTARN.Shared.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues)
at Microsoft.Solutions.BTARN.Shared.ActivityTracking.RegisterActivity(String pipCode, String pipVersion, String pipInstanceID, String sourcePartnerName, String destinationPartnerName, Boolean isInitiatorActivity)

any inputs are greatly appreciated.

Microsoft BizTalk Server
Microsoft BizTalk Server
A family of Microsoft server products that support large-scale implementation management of enterprise application integration processes.
358 questions
0 comments No comments
{count} votes