“Database integrity checking failed. Stopping backup operation. Reason: Table error: table 'POSBill' (ID 373576369). Data row does not have a matching index row in the index 'POSBill_L03' (ID 4)." - Error message is shown while taking a full backup.

SYMPTOMS

Database Backup was stopped and the following error message was shown:

“Database integrity checking failed. Stopping backup operation. Reason: Table error: table 'POSBill' (ID 373576369). Data row does not have a matching index row in the index 'POSBill_L03' (ID 4)."

CAUSE

One of the possible reasons for this integrity check failure is some issue with the database structure. The result is the table being accessed has mismatched data due to improper indexing.

 RESOLUTION

Rebuild the indexes to resolve the above issue.

This should resolve your issue, in case you face it again please contact our Ginesys Care portal - https://care.ginesys.in/