We're running Worksheet 401-Request Data Upload between HQ and one of the remote stores. This is working properly for several months now until we encountered this error message in the log file:
"Error 2147467259: Transaction (Process ID 54) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Re-run the transaction. SETNOCOUNT ON Select * Into#Upload_Transaction E"
As a result, the succeeding Worksheet 401 was not created automatically. Anybody encountered this before? What's this all about?
Tnx.
\Franco Email: snipped-for-privacy@gisimplement.com