2104559 - Error 697 "An attempt was made to fetch logical page ... Wrong logical page ... was found in cache" during parallel CREATE INDEX - SAP ASE | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2104559 - Error 697 "An attempt was made to fetch logical page ... Wrong logical page ... was found in cache" during parallel CREATE INDEX - SAP ASE

Symptom

  • Parallel CREATE INDEX fails with Error 697:

Error 697, severity 21, state 1:
An attempt was made to fetch logical page '<page>' for <ptninfo>_PTNINFO from cache '<cache>'. Wrong logical page '<page>' was found in cache.

  • Configuration parameter "utility statistics hashing" set to '1'
  • Parallel CREATE INDEX commands executed
  • Use of WITH STATISTICS HASHING may have occurred instead of turning on "utility statistics hashing"
  • The 'trunc log on chkpt' database option may be enabled for the database involved
  • Page compression of the involved table may be in use

Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7 SP122 and SP130
  • SAP Adaptive Server Enterprise (ASE) 16.0 GA below PL05

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

"update statistics", 772670, CR772670 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed

About this page

This 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.