Job Fails

[ptheriault]

Has anyone seen where a SQL Server job will have its connection terminated by the server localy? I have a job that has 16 steps. This is on SQL server 2005 sp1. 64 bit Ent edition. This step just moves data from one db to another on the same server. Another dba was able to recreate the same error by killing the spid while the job is running.



Date 10/4/2006 1:04:53 AM
Log Job History (Policy Management Transformation)

Step ID 12
Server HOST13
Job Name Policy Management Transformation
Step Name Claims Table
Duration 00:09:19
Sql Severity 20
Sql Message ID 1203
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0

Message
Executed as user: HOST13\SQL. Hospitals Complete [SQLSTATE 01000] (Message 0) Unspecified error occurred on SQL Server. Connection may have been terminated by the server. [SQLSTATE HY000] (Error 0) Process ID 183 attempted to unlock a resource it does not own: OBJECT: 8:739533718:0 . Retry the transaction, because this error may be caused by a timing condition. If the problem persists, contact the database administrator. [SQLSTATE HY000] (Error 1203)

 

[mrdenny]

Here is the MS Doc about the error you are getting.

http://msdn2.microsoft.com/en-us/library/aa337285.aspx

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[ptheriault]

Thank again Denny.

--- Paul
-- The Database server looks fine, it must be the Network!

 

[mrdenny]

no problem.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com