|
Posted by Akber Alwani on March 24, 2007, 4:58 am
Please log in for more thread options
HI, Tell me one thing are you importing the data to HQ through MARS PO
planner, second thing which seems to problem is database collation at store
and HQ which seems to me different. please let me know what is collation of
database at HQ and what is at store.
"Luminox" wrote:
> 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
> 340
>
> Information 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 <<ExecuteCommand>> 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
| 
Yahoo! 
Google 
Windows Live 
del.icio.us 
digg 
Netscape 
XML Sitemap