Error 1203 but no DBCC CHECKDB errors

[sarahw]

I have Cold Fusion code which executes stored procs and writes html files based on the results. Application works fine on my server with client's database installed. However, when the client tries to run the app - sql server actually stops and the following error message is written to the event log:

'Server: Msg 1203, Level 20, State 1, Procedure SP_AMOWEB4_QRY5, Line 10
Process ID 8 attempting to unlock unowned resource RID: 7:1:75736:54.'
Connection Broken

I have installed a current backup from the client and run the app again on my server - no problem. Run DBCC CHECKDB again on new data - no errors.

Does anyone have any idea of what might be causing this? Any suggestions will be more than welcome.

Many thanks.

 

[tlbroadbent]

We encountered the same problem and solved it using the suggestions in this Microsoft article.

FIX: Lock Escalation With Parallel Query May Cause 1203 Error And Server Shutdown

http://support.microsoft.com/support/kb/articles/q240/8/53.asp

If you can't solve the problem with info in that article then take a look at this one.

FIX: Update on View Based Cursor to Multiple Rows in Fetch Buffer Fails with 1203 Msg.

http://support.microsoft.com/support/kb/articles/q238/6/37.asp

Terry

X-) "I don't have a solution, but I admire your problem."

 

[sarahw]

Thanks Terry

I am just attempting (took 3 hrs and was then corrupt) to download sp2 as I am on sp1. I will install this to see if I can manage to recreate the problem.

Thanks again

Sarah