SAP Knowledge Base Article - Preview

2123202 - Upgrading user database to 15.7sp131 fails with error 2601 "insert duplicate key row in object 'sysusers'" - ASE

Symptom

Upgrading a user database to ASE 15.7sp130 or higher by using 'in place upgrade' (binary overlay) or loading a dump fails.
ASE error log shows:

  Database '<user_db>': beginning upgrade step [ID   245]: Update system roles in system tables. 

  Initialization of sysusers in database <user_db> changed the system role name from '<group_name>' to 'dtm_tm_role'.
  Error: 2601, Severity: 14, State: 6
  Attempt to insert duplicate key row in object 'sysusers' with unique index 'ncsysusers1'
  Error: 3461, Severity: 20, State: 1
  Database '<user_db>': upgrade could not install required upgrade item '245'.
Please refer to previous error messages to determine the problem. Fix the problem, then try again.
  Error: 3462, Severity: 18, State: 1
  Database '<user_db>': upgrade could not install optional upgrade item '1720'.
Please refer to previous error messages to determine the problem. Upgrade will continue.
  Error: 3451, Severity: 20, State: 1
  Database '<user_db>': upgrade has failed for this database. 
Please refer to previous messages for the cause of the failure, correct the problem and try again.
  Error: 3454, Severity: 20, State: 1
  Database '<user_db>': ASE could not completely upgrade this database; upgrade item 1720 could not be installed.
  The transaction log in the database '<user_db>' will use I/O size of 2 Kb.
  ASE could not completely upgrade database '<user_db>', but the database was online when upgrade began, so it will be left online.

Read more...

Environment

SAP Adaptive Server Enterprise (ASE) All Versions 

Product

SAP Adaptive Server Enterprise all versions

Keywords

KBA , webservices_role , sp_helprotects , replication_main , syssrvroles , dtm_tm_role , hadr_admin_role_ , ha_role , keycustodian_rol , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , SAP Business Suite on Sybase ASE Database Platform , BC-SYB-ASE-CE , ASE Cluster Edition (Standalone) , BW-SYS-DB-SYB , BW on Sybase ASE Database Platform , 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.