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