- 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
- SAP Adaptive Server Enterprise (ASE) 15.7 SP122 and SP130
- SAP Adaptive Server Enterprise (ASE) 16.0 GA below PL05
SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0
"update statistics", 772670, CR772670 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed
About this pageThis 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.