ASE upgrade failing with following error
Database 'master': beginning upgrade step [ID 1650]: executing SQL statement ("dbcc upgd_grantrev_sysrole_perms('g...")
Error: 2601, Severity: 14, State: 6
Attempt to insert duplicate key row in object 'sysroles' with unique index 'csysroles'
Error: 11137, Severity: 18, State: 1
Failed to add the role 'sa_serverprivs_role' into the current database catalogs.
Error: 15967, Severity: 16, State: 1
The 'GRANT' command failed when updating permissions to system roles in database 'master'.
The roles in the database may not have the correct permissions.
server Error: 3461, Severity: 20, State: 1
- SAP Adaptive Server Enterprise (ASE) 15.7/ESD#2 and above releases on all platforms
- SAP Adaptive Server Enterprise (ASE) 16.0
duplicate, role, sa_serverprivs_role, upgrade , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem
About this pageThis 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.