Skip to Content
0
Jun 14, 2010 at 02:23 PM

Microsoft sql client deadlocked on lock resources with another process

504 Views

Hi

I wrote a forecasting report for a customer which creates an excel spreadsheet with the information

Depending on how they run the report it can take between 5 to 15 minutes to run

We have just upgraded the customer to SAP 8.8 PL10 and Microsoft SQL Server 2008 and they seem to be getting an error -

Microsoft sql client deadlocked on lock resources with another process .......

The error seems intermittent, they may get the error once and the next time they run it, it is fine.

I have never seen this error before and they never had it before on SAP 2005

Can anyone suggest anything please?

Thanks

Regards Andy