SAP Knowledge Base Article - Preview

3153745 - Error 697 in tempdb when running complex query with "order by" - SAP ASE

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.