Powershel nuget config missing

I got this message:

error NU1100: Unable to resolve ‘CommandLineParser (>= 2.8.0)’ for ‘net6.0’.

You need to put your nuget provider inside :   \Users\<username>\AppData\Roaming\NuGet

<?xml version="1.0"?>
<configuration>
  <packageSources>
    <add key="nuget.org" value="https://api.nuget.org/v3/index.json" protocolVersion="3" />
  </packageSources>
</configuration>

 

BizTalk Pipeline Component- Careful with static methods

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.

Remove BizTalk orphans from tracking

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)
    )