MACRO SQL ERROR - What is this?

Question

I  noticed that in the last year something has changed where a few of my custom SQL alert variables no longer work, instead I get the below error:

MACRO SQL ERROR - ExecuteScalar requires the command to have a transaction when the connection assigned to the command is in a pending local transaction. The Transaction property of the command has not been initialized.

Some light googling leads me to believe this is a .net issue and could be fixed with like 1 line of code added to the application, but the thing that's odd to me is that it was working before and only recently became an issue for the same queries.

tdanner​ maybe you have some insight?

tdanner · Accepted Answer

Yes, this was inadvertently broken in NPM 12.3. It's fixed in NPM 12.4, which is currently in the release candidate stage.