Microsoft SQL Server Error Code 824 Incorrect checksum
book
Article ID: 111574
calendar_today
Updated On:
Products
CA Service Management - Asset Portfolio ManagementCA Service Management - Service Desk Manager
Issue/Introduction
Error message in stdlog:
[Microsoft OLE DB Provider for SQL Server] [SQL Code = 824 SQL State = HY000] / Error: Incorrect checksum (expected: 0x20007400; current: 0xa652b23d). Additional messages (1: 2966535) in database ID 23 at offset 0x000005a880e000 in file 'L: \ Data \ mdb8.mdf'. in the SQL Server error log or system event log may provide more detail.This is a severe error condition that threatens database integrity and must be corrected immediately. ; for more information, see SQL Server Books Online.
Cause
Since data consistency is a crucial aspect for every user, the server has in-built mechanism which helps to maintain the data consistency at every step. Sometimes, the user may face SQL Server Error 824 while making any SQL query or data modification. It is mainly inconsistency based error that reports an inconsistency during the I/O operation being carried out in the database. When such error is reported by the server, the control automatically comes to the application and the database connection is terminated.
Possible reasons:
Insufficient disk storage leading to data inconsistency
Faulty hardware associated with the I/O devices
Highly damaged or corrupted database files
Faulty filter drivers in the path of I/O operation
Corrupted file system leading to data inconsistency
Environment
CA Service Desk 17.1 CA Service Desk 17.0 CA Service Desk 14.1
Resolution
Consider talking to the database administrator in order to understand what is going on. You as a CA Service Desk administrator does not have tools to fix this issue in the database side. According to the error message, it is a critical issue and should be addressed immediately by the database administrator.