NAV 2009 - SQL Error During Check Database Integrity

postsaurav

Hi all,

stuck with one SQL Related Issue in NAV 2009 SP1. ](*,)

Below is the error message appear as a result of Test Database -

---

Microsoft Dynamics NAV Classic

---

The following SQL Server error or errors occurred:

8909,"42000",[Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 0, index ID -1,
partition ID 0, alloc unit ID 0 (type Unknown), page ID (3:1125161) contains an incorrect page ID in its page header. The PageId in the page header = (0:0).
8928,"42000",[Microsoft][ODBC SQL Server Driver][SQL Server]Object ID 1865773704, index ID 1,
partition ID 72057594077904896, alloc unit ID 72057594081050624 (type In-row data): Page (3:1125160) could not be processed. See other errors for details.
8939,"42000",[Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 1865773704, index ID 1,
partition ID 72057594077904896, alloc unit ID 72057594081050624 (type In-row data), page (3:1125160).
Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 12716041 and -4.
8976,"42000",[Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 1865773704,
index ID 1, partition ID 72057594077904896, alloc unit ID 72057594081050624 (type In-row data). Page (3:1125160) was not seen in the scan although its parent (3:1124945) and previous (3:1124991) refer to it. Check any previous errors.
8928,"42000",[Microsoft][ODBC SQL Server Driver][SQL Server]Object ID 1865773704, index ID 1,
partition ID 72057594077904896, alloc unit ID 72057594081050624 (type In-row data): Page (3:1125161) could not be processed. See other errors for details.
8980,"42000",[Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 1865773704, index ID 1,
partition ID 72057594077904896, alloc unit ID 72057594081050624 (type In-row data).
Index node page (3:1124945), slot 368 refers to child page (3:1125161) and previous child (3:1125160), but they were not encountered.
8978,"42000",[Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 1865773704, index ID 1,
partition ID 72057594077904896, alloc unit ID 72057594081050624 (type In-row data).
Page (3:1125162) is missing a reference from previous page (3:1125161). Possible chain linkage problem.
8954,"01000",[Microsoft][ODBC SQL Server Driver][SQL Serve

---

OK

---

I Tried to Run Check Database Integrity from SQL and below is the error appeared -

Microsoft(R) Server Maintenance Utility (Unicode) Version 10.50.2500
Report was generated on "".
Maintenance Plan: MaintenancePlan
Duration: 00:07:03
Status: Warning: One or more tasks failed.
Details:
Check Database Integrity ()
Check Database integrity on Local server connection
Databases: Test
Include indexes
Task start: 2015-05-26T21:05:29.
Task end: 2015-05-26T21:12:31.
Failed:(-1073548784) Executing the query "DBCC CHECKDB(N'Test') WITH NO_INFOMSGS
" failed with the following error: "Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 0 (type Unknown), page ID (3:1125161) contains an incorrect page ID in its page header. The PageId in the page header = (0:0).
Object ID 1865773704, index ID 1, partition ID 72057594077904896, alloc unit ID 72057594081050624 (type In-row data): Page (3:1125160) could not be processed. See other errors for details.
Table error: Object ID 1865773704, index ID 1, partition ID 72057594077904896, alloc unit ID 72057594081050624 (type In-row data), page (3:1125160). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 12716041 and -4.
Table error: Object ID 1865773704, index ID 1, partition ID 72057594077904896, alloc unit ID 72057594081050624 (type In-row data). Page (3:1125160) was not seen in the scan although its parent (3:1124945) and previous (3:1124991) refer to it. Check any previous errors.
Object ID 1865773704, index ID 1, partition ID 72057594077904896, alloc unit ID 72057594081050624 (type In-row data): Page (3:1125161) could not be processed. See other errors for details.
Table error: Object ID 1865773704, index ID 1, partition ID 72057594077904896, alloc unit ID 72057594081050624 (type In-row data). Index node page (3:1124945), slot 368 refers to child page (3:1125161) and previous child (3:1125160), but they were not encountered.
Table error: Object ID 1865773704, index ID 1, partition ID 72057594077904896, alloc unit ID 72057594081050624 (type In-row data). Page (3:1125162) is missing a reference from previous page (3:1125161). Possible chain linkage problem.
CHECKDB found 0 allocation errors and 1 consistency errors not associated with any single object.
CHECKDB found 0 allocation errors and 6 consistency errors in table 'Test Company$Value Entry' (object ID 1865773704).
CHECKDB found 0 allocation errors and 7 consistency errors in database 'test'.
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (test).". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.


Did anyone faced something like this and how to resolve it?

Thanks in advance...