April 25, 2003 at 1:54 am
I have a job which checks a table for a new row, processes some data based on the row and then sets a status flag to show that the row is processed.
This has been working fine for ages but I have one particular row which now always fails with the following errors:
In the Job history:
- ConnectionCheckForData (CheckforData()). [SQLSTATE 01000] (Message 10054) General network error. Check your network documentation. [SQLSTATE 08S01] (Error 11)
In the SQL Server Log:
- Sleeping until external dump process completes.
- Resuming after waiting on external debug process for 2 seconds.
- Stack Signature for the dump is 0xAC221213
- SQL Server Assertion: File: <recbase.cpp>, line=1378
Failed Assertion = 'm_offBeginVar < m_SizeRec'.
- Error: 3624, Severity: 20, State: 1.
There is nothing particularly different about this row. It only differs from the row above and below in the value of one column (the year) and other rows with this value run OK.
Any ideas?
Jeremy
April 28, 2003 at 8:00 am
This was removed by the editor as SPAM
April 28, 2003 at 8:10 am
I've got the answer.
Apparently I had a corrput index on a table (found it using DBCC checkdb). Recreated the index and it now works fine.
Strange error message for a corrupt index.
Jeremy
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply