SAP Knowledge Base Article - Preview

2081577 - Error 693 is returned when running 'create index' and 'dump database' simultaneously - SAP ASE

Symptom

  • An ASE 15.5 or 15.7 database that is bound to a named cache returns a 693 error when 'create index' and 'dump database' are run simultaneously:

Error: 693, Severity: 20, State: 1
Multiple copies of logical page '121688' from database 'AAA' (6), object 'XXXX_198' (272071242), index 'XXXX_198' (-1), partition 'XXXX_198_272071242' (272071242) reside in more than one cache.
This is an internal system error. Please contact Sybase Technical Support.

  • The Troubleshooting Guide for error 693 recommends further investigating this issue by using the dbcc page command to find the database ID and page number to identify the caches involved in this error:

Msg 15088, Level 16, State 2:
Parameter 'logical' (number 5) to DBCC command 'page' has invalid value/type.
Msg 2526, Level 16, State 106:
Incorrect DBCC command: Please see the ASE Reference Manual for DBCC commands and options.
DBCC execution completed. If DBCC printed error messages, contact a user with System Administrator (SA) role.


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.5 
  • SAP Adaptive Server Enterprise (ASE) 15.7

Product

SAP Adaptive Server Enterprise 15.7 ; Sybase Adaptive Server Enterprise 15.5

Keywords

create index, database dump , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , 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.