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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.