Symptom
Upgrade from pre-15.0 may fail on upgrade step 52 with errors 1902 and 3469 on the sysusermessages table:
Database 'DBNAME ': beginning upgrade step [ID 53]: creating index (table sysusermessages, index csysusermessages)
Msg 1902, Level 16, State 1:
Server 'servername ', Line 1:
Cannot create more than one clustered index on table 'sysusermessages'.
Drop the existing clustered index 'sysusermessages' before creating another
Msg 3469, Level 20, State 1:
Server 'servername', Line 1:
Database 'DBNAME': upgrade failed to create index 1 on table 'csysusermessages'.
Please refer to previous error messages to determine the problem. Fix the problem, then try again.
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE)
- Upgrade
- Database being upgraded was originally created on version 4.9.1 or earlier.
Product
Keywords
Sybase, ASEServer, SAPASE, dataserver, CR653938, CR#653938, 653938, upgrade, step, 53, sysusermessages, 1902 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-SYB-ASE-CE , ASE Cluster Edition (Standalone) , 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.
SAP Knowledge Base Article - Preview