October 8, 2008 at 4:30 am
Hi.
The following sporadic error occurs within an sql procedure when it does a simple update to a table.
"Internal Query Processor Error: The query processor encountered an unexpected error during execution" with an error number 8630.
The trouble is, the procedure is run every night on a schedule, but the error does not occur every night, and when I run the procedure during the day it works.
We are using SQL server 2005 SP2 64 bit on windows 2003 SP2 64 bit server.
Has anyone come across this type of error before? Any help appreciated.
October 8, 2008 at 7:32 am
I think there that you are using sub queries in your update statements. This error happens when there is a problem in your sub-queries. Check the query please.
October 10, 2008 at 2:04 am
Thanks for the response.
The update does not have a sub query in, it is a straight forward statement :
updatetable1
set fld1= ltrim(rtrim(table3.title)+' '+ rtrim(table3.forenames)+' ' + rtrim(table3.surname))
from table1
join table2
on table1.EnquiryRefNo = table2.[ENQUIRY-REFNO]
join table3
ontable2.[PERSON-REF] = table3.person_ref
wheretable2.[RELATION-CODE] = ''
The error is intermittent, it hasn't occurred for the last couple of days.
Is there any reason why you suspect a sub-query could be the cause of this error? Could this be a bug?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply