SAP Knowledge Base Article - Preview

2906103 - Upgrade step 52 fails with 1902 error on sysusermessages - SAP ASE

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

SAP Adaptive Server Enterprise 12.5 ; SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 15.7 Cluster Edition ; SAP Adaptive Server Enterprise 16.0 ; SAP Adaptive Server Enterprise 16.0 Cluster Edition ; Sybase Adaptive Server Enterprise 12.5 ; Sybase Adaptive Server Enterprise 15.0 ; Sybase Adaptive Server Enterprise 15.5 ; Sybase Adaptive Server Enterprise Cluster Edition 15.0 ; Sybase Adaptive Server Enterprise Cluster Edition 15.5 ; Sybase Adaptive Server Enterprise Cluster Edition 15.7

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.