An interesting event occured today ... several PO Planners where submitted through HQ (v1.3r). The processing failed with the following EVENT LOG message:
Information Store 3/23/2007 12:30:06 PM ======= CONNECTION STARTED =====Information Store 3/23/2007 12:30:07 PM Opening of local datasource '(local).RetailStore01' was successful.
Information Store 3/23/2007 12:30:10 PM Local and HQ databases are synchronized.
Information Store 3/23/2007 12:30:10 PM Store-HQ Time Zone Difference: 0 minutes
Information Store 3/23/2007 12:30:12 PM Number of worksheets to process: 4
Information Store 3/23/2007 12:30:12 PM 1. Processing worksheet style
340Information Store 3/23/2007 12:30:12 PM Title: PO Planner from Mars
Information Store 3/23/2007 12:30:12 PM Ref. No.: 1636
Error Store 3/23/2007 12:30:43 PM Error
-2147467259: Transaction (Process ID 59) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
UPDATE #POEntryTemp
SET LastUpdated = GETDATE
Error Store 3/23/2007 12:30:43 PM An error occurred while processing the purchase order worksheet.
Error Store 3/23/2007 12:30:43 PM Not completed due to errors encountered during processing.
Can anyone tell me why this happened and how I might avoid the problem in the future?
Scott