- 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
"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 ONE Support launchpad (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.