I saw someone post this resolution in the LabTech Geek Slack and thought it was worth posting!
This occurs because triggers that are in the SQL database sometimes don’t get transferred across, these “trigger” on each add or update of a row and add variables like LTRUNBYUSER.
-Stop LabTech Database Agent service
-Open SQLYog (from the CWA server itself or the CWA Web/Application server if you have a split config)
-Select the labtech database in tree explorer on left
-Select Tools > Execute SQL Script
-Browse to C:\Program Files\LabTech\Setup
-UNCHECK THE ABORT ON ERROR CHECK BOX
-Repeat steps 7-9 but select the following .sql next (in this order)
-Start LabTech Database agent service
Leave A Comment