Microsoft SQL Server Error Code 824 Incorrect checksum

Products

• CA Service Management - Asset Portfolio Management
• CA 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.

Environment

CA Service Desk 17.1
CA Service Desk 17.0
CA Service Desk 14.1

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

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.

Additional Information

Resolve Microsoft SQL Server Error Code 824