The PDES (open partition descriptor) hash table becomes invalid after running a REORG REBUILD command against a DOL (row level locked) table.
Subsequent queries may result in ASE picking up an old OAM (object allocation map) page, and this results in a 605 error similar to the following:Error: 605, Severity: 21, State: 1
An attempt was made to fetch logical page '1184' from cache 'default data cache'. Page belongs to database 'pubs2' (6), object 'authors' (576002052),
index '<Unknown>' (0), partition 'auidind_576002052' (576002052) and not to database 'pubs2' (6), object 'salesdetail' (704002508), index 'salesdetail' (0),
partition 'salesdetail_704002508' (704002508).
SAP Adaptive Server Enterprise (ASE) 15.7
SAP Adaptive Server Enterprise (ASE) 16.0
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.