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 for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.