ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
Microsoft SQL Server Error Code 824 Incorrect checksum
Article ID: 111574
CA Service Management - Asset Portfolio ManagementCA Service Management - Service Desk Manager
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.
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.
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
CA Service Desk 17.1 CA Service Desk 17.0 CA Service Desk 14.1
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.