Stored procedure erroring out...

[bessebo]

I have month-end stored procedures (that I wrote) that I run that update a custom table of an application. The routine runs for about 20 minutes and then Fails with the following error:

Unknown token received from SQL Server [SQLSTATE HY000] (Error 0). The step failed.

I have had this same thing happen with other procedures but could never figure out the cause. Google search doesn't help much on this one. Anyone out there get this error and have a resolution?

Regards,
Bessebo

 

[Catadmin]

Does this happen with every SP or only with specific ones or does it happen randomly?

What other things are going on when this happens?

Have you run Profiler when one of these jobs is going to see what SQL is doing when this error comes up? Have you checked the SQL and SQL Server Agent error logs? What about the Windows Event Viewer?

I would suggest, if you haven't done it already, running Profiler the next few times the job is scheduled to see if you can catch the error and track exactly what SQL is doing when this error occurs.



Catadmin - MCDBA, MCSA
"If a person is Microsoft Certified, does that mean that Microsoft pays the bills for the funny white jackets that tie in the back???

 

[bessebo]

This will happen with procedures that tend to run for a while and are updating tables. I just thought of something. It appears to fail right when the full backup of that same database kicks off. So I'm going to try to move that time so it does not coincide with the full backup and we will see what happens next month.

 

[Catadmin]

Sounds good. I know I've had problems with jobs failing during backup attempts. I've never seen that specific error, though.

Let us know if you continue to experience issues.



Catadmin - MCDBA, MCSA
"If a person is Microsoft Certified, does that mean that Microsoft pays the bills for the funny white jackets that tie in the back???

 

[bessebo]

Will do. I'll post what happens next month.

Thanks...