After bulk testing of an interface, we got some weird result from a PL Component. I found this blog post:

BizTalk Pipeline Component- Careful with static variables

Describing more or less the same issues we had. The only difference is the method was static and the variables inside the method non-static. After removing the static from the method the problem did not occur anymore.

Conclusion, non static variables are static in a static method.

While installing Motion Eye on the raspberry pi 3. Try the following that worked for me:

sudo apt install libcurl4-openssl-dev libssl-dev

Here a SQL Script to remove orphans from your BizTalk tracking. It sets an end date so they can be removed.

USE [biztalkDTADb]


UPDATE
    [dbo].[dta_ServiceInstances]

SET
    [dtEndTime] = GetUTCDate()
WHERE
    dtEndTime is NULL
    AND
    [uidServiceInstanceId] NOT IN
    (
    SELECT
        [uidInstanceID]
    FROM
        BizTalkMsgBoxDb.[dbo].[Instances] WITH (NOLOCK)
    UNION
    SELECT
        [StreamID]
    FROM
        BizTalkMsgBoxDb.[dbo].[TrackingData] WITH (NOLOCK)
    )

If you somehow lost your admin right on your dev SQL Server, here’s how you can add the logged in user account again.

You will have to start SQL Server in single user mode and than add the local account in the sysadmin role.

Start SQL Single user:
SQLServr.Exe –m

Add your account:
SQLCMD
1> SP_ADDSRVROLEMEMBER ‘’,’SYSADMIN’
2>go