We’ve just released NServiceBus.SqlServer 4.3.1
- #504 Not possible to delay a message more than int.Max milliseconds
- #509 Always delay moving of delayed messages even when exceptions occur to honor the ProcessingInterval
How to know if you are affected
You are affected if you are using Version 4.3.0 of the SQL Transport and try to defer messages or saga timeouts with a duration of more than 2,147,483,647 milliseconds (int.MaxRange) or approximately 25 days from the system time. The following exception will be raised:
System.Data.SqlClient.SqlException: 'Arithmetic overflow error converting expression to data type int.
Should you upgrade immediately
It is not required to immediately update if the system is not using saga timeouts or message deferring for more than 25 days.
Where to get it
You can download the updated version directly from NuGet: https://www.nuget.org/packages/NServiceBus.SqlServer/
The team in Particular