Skip to Content
Mar 25, 2015 at 10:25 AM

Error: 644 and 605


Hi Team,

Glad if you can advice me on the following

Errors received

Error: 605, Severity: 21, State: 1

An attempt was made to fetch logical page '13424' from cache 'default data cache'. Page belongs to database 'saptools' (5), object 'DBH_STG_TABLES' (1161052141), index 'DBH_STG_TABLES' (0), partition 'DBH_STG_TABLES_1161052141' (1161052141) and not to database 'saptools' (5), object 'DBH_SNAP_TABLES' (1097051913), index 'DBH_SNAP_TABLES' (0), partition 'DBH_SNAP_TABLES_1097051913' (1097051913).

Error: 644, Severity: 21, State: 5

Index row entry for data row id (13424, 128) is missing from index page 1643 of index id 2 of table 'DBH_SNAP_TABLES' in database 'saptools'. Xactid is (140654,45). Drop and re-create the index

Error 1: First of all I could not understand "exactly" what caused the error to occur

I'm planning to run dbcc tablealloc for this error to find out more details

Error 2: I'm planning to run reorg rebuild on the table 'DBH_SNAP_TABLES', but I want to know what caused the index row to be missing.

Am I heading in a right way? Your insights are much appreciated in this regard

Attachment: ASE errorlog