Symptom
- When running complex query with "order by", it may fail with below error:
server Error: 697, Severity: 21, State: 1
server An attempt was made to fetch logical page 'xxx' for database 'xxx' (2), object '' (99), index '<Unknown>' (0), partition '<Unknown>' (99) from cache 'xxx'. Wrong logical page 'xxx' was found in cache.
- Error happens on worktable of tempdb.
- Queries which triggered the issue are always not the same.
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 16.0 SP03 PL09 and higher
Keywords
Error: 697, 697, tempdb worktable. , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Known Error
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.