[16.4] Lots of SQL errors in log: Must declare the scalar variable "@ROWCOUNT"

[arknu]

Which component is this issue related to?

Umbraco Commerce (Core)

Which Umbraco Commerce version are you using? (Please write the exact version, example: 10.1.0)

16.4.0

Bug summary

I'm seeing loads of these errors in the Umbraco log after upgrading to 16.4 on Umbraco 16.3.4:

Microsoft.Data.SqlClient.SqlException (0x80131904): Must declare the scalar variable "@ROWCOUNT".
   at Umbraco.Commerce.Infrastructure.Resiliency.PollyExecutionStrategyBase.ExecuteAsync[TResult](Func`2 operation, Func`2 verifySucceeded, CancellationToken cancellationToken)
   at Umbraco.Commerce.Core.Services.NodeLeaseService.ClaimAsync(CancellationToken ct)
   at Umbraco.Commerce.Cms.Scheduling.NodeLeaseHostedService.EnsureNodeIdAsync(CancellationToken cancellationToken)
   at Umbraco.Commerce.Cms.Scheduling.NodeLeaseHostedService.PerformExecuteAsync(Object state)
   at Umbraco.Cms.Infrastructure.HostedServices.RecurringHostedServiceBase.ExecuteAsync(Object state)
ClientConnectionId:30b4efc4-4ed5-43e2-ba25-e5501787fe02
Error Number:137,State:2,Class:15

Specifics

No response

Steps to reproduce

Install Umbraco Commerce 16.4. Watch the log for errors

Expected result / actual result

No response

Dependencies

No response

[acoumb]

Hi @arknu ,

Thank you for bringing this to our attention. We are working on a fix and the issue will be addressed with next patch version 16.4.1.

Adrian

[acoumb]

@arknu You can test it before with 16.4.1-preview.7 from nightly.

[arknu]

@acoumb Thanks. Can confirm this build fixes the issue. Any idea of an ETA for 16.4.1?

[acoumb]

We'll try to release it tomorrow.