-
Failed job reason
I created a job to distribute (once a day) daily data from one big table to some smaller tables (very simple job- cursor to get particular secondary table’ s Id and execute stored procedure for this Id). Mainly everything is going well with this job but sometimes (once in 3-4 days)I had an error indicating job failure . For example, first time I’ve got
“[SQLSTATE HY000] (Error 3624) Location: recbase.cpp:1378
Expression: m_offBeginVar < m_SizeRec SPID: 55 Process ID: 1404 ”,
second time-
“[SQLSTATE HY000] (Error 3624) Location: p:\sql\ntdbms\storeng\drs\include\record.inl:1447
Expression: m_SizeRec > 0 && m_SizeRec <= MAXDATAROW SPID: 55.”
When I checked the result’s tables I found that for some tables data were distributed, for the rest- no. But when I started distributing stored procedure for these tables result was OK.
I was wondering if you could explain what could be the reason of received errors (I couldn't find description of these errors.
Thanks
-
What version of sql server are you running? and what is the latest patch you have applied?
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|