I'm using workbench 5 and my current query looks like
SELECT Unique_ID, Incident_Date, Incident_Time, Incident_Description
FROM Incidents
WHERE Unique_ID > !{lastvalue:Unique_ID}!
ORDER BY Unique_ID
In my replacement variables, I have the column set as "Unique_ID" and the value as "!{lastvalue:Unique_ID}!
I've run this query using both the append and the replace update method and everytime it gets stuck returning the message "Replacing Last Value query at position 146" 3 - 5 times a second, sometimes freezing workbench altogether. What am I doing wrong? How do I get the job to run successfully and update the value in my replacement variable?