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