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.