E_rulez
Hello,
Since we started using another sales program (1C Enterprise), SQL Server started "crashing" (connection between our program and SQL Server breaks)
with this assertion error:
Event ID: 17066
SQL Server Assertion: File: <"xrange.cpp">, line=399 Failed Assertion = '0 == pxteRangeHrow->m_pxteFetch'. This error may be timing-related. If the error persists after rerunning the statement, use DBCC CHECKDB to check the database for structural integrity, or restart the server to ensure in-memory data structures are not corrupted.
After this error DBCC CHECKDB doesn't find any priblems.
I can't find what exactly causes it, sometimes we get it only once a week, but today I got it four times in a row.
We had the same error on all versions of SQL Server 2005, SQL Server SP1, SQL Server SP1+Hot fixes, etc.
select @@version
Microsoft SQL Server 2005 - 9.00.3042.00 (X64) Feb 10 2007 00:59:02 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 1)
Re: Periodic "SQL Server Assertion" error
Jerome Halmans
Please provide feedback on this message through http://connect.microsoft.com/sql.
When filing the issue upload one of your errorlogs with the error, and any corresponding *.mdmp files that might be present in your errorlog directory.
Re: Periodic "SQL Server Assertion" error
E_rulez
I reported this on Microsoft Connect:
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx FeedbackID=264653
I reported this on Microsoft Connect:
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx FeedbackID=264653
Re: Periodic "SQL Server Assertion" error
E_rulez
Yes, we keep working with this error.
I just periodically run "Test and Repair" on 1C database from 1C Designer, it seems to help a bit (10 days without this error).
Yes, we keep working with this error.
I just periodically run "Test and Repair" on 1C database from 1C Designer, it seems to help a bit (10 days without this error).
Re: Periodic "SQL Server Assertion" error
Alexey
Nothing helps
We tried to do "Test and Repair", backup/restore with SQL, backup/restore with 1C. No rusults.
Nothing helps
We tried to do "Test and Repair", backup/restore with SQL, backup/restore with 1C. No rusults.
Re: Periodic "SQL Server Assertion" error
E_rulez
Try giving feedback on Microsoft Connect. Maybe they'll try to fix it sooner.
Try giving feedback on Microsoft Connect. Maybe they'll try to fix it sooner.
Re: Periodic "SQL Server Assertion" error
Alexey
I've found what this problem appears when user put the selection at both datetime and client field, if the date is the beginning of a day (like 27/05/2007-00:00:00).
I've corrected the date in SQL table using this code:
UPDATE _Document42
SET _Document42._Date_Time = DATEADD(SECOND,1,_Document42._Date_Time)
where DATEADD(DAY, DATEPART(DAY, _Document42._Date_Time) - 1, DATEADD(MONTH, DATEPART(MONTH, _Document42._Date_Time) - 1, DATEADD(YEAR, DATEPART(YEAR, _Document42._Date_Time) - 2000, {ts '2000-01-01 00:00:00'}))) = _Document42._Date_Time
and the problem has gone
I've found what this problem appears when user put the selection at both datetime and client field, if the date is the beginning of a day (like 27/05/2007-00:00:00).
I've corrected the date in SQL table using this code:
UPDATE _Document42
SET _Document42._Date_Time = DATEADD(SECOND,1,_Document42._Date_Time)
where DATEADD(DAY, DATEPART(DAY, _Document42._Date_Time) - 1, DATEADD(MONTH, DATEPART(MONTH, _Document42._Date_Time) - 1, DATEADD(YEAR, DATEPART(YEAR, _Document42._Date_Time) - 2000, {ts '2000-01-01 00:00:00'}))) = _Document42._Date_Time
and the problem has gone
Re: Periodic "SQL Server Assertion" error
Jens K. Suessmeyer
This is an english forum, you should better post in English to get an answer, if you are not the original poster, please open a separate thread for it.
Jens K. Suessmeyer
---