SAP Knowledge Base Article - Preview

2470858 - Error on SYS_UPGRADE_ROLE_ROLE when rebuilding SQL Anywhere database

Symptom

Attempting to rebuild a SQL Anywhere database results in the error messages:

  • SQL error: Invalid user ID or role name 'SYS_UPGRADE_ROLE_ROLE' specified
  • An error occurred while attempting to unload the database
  • Cannot perform specific operation, number of administrators for role 'SYS_VERIFY_ODATA_ROLE' falls below min_role_admins option value
    SQLCODE=-1525, ODBC 3 State="HY000"

Read more...

Environment

  • SAP SQL Anywhere 16
  • SAP SQL Anywhere 17

Product

SAP SQL Anywhere 16.0 ; SAP SQL Anywhere 17.0

Keywords

SQL Anyhwere, reload, rebuild, upgrade, failed, error, sys_upgrade_role_role , KBA , BC-SYB-SQA , SQL Anywhere (on premise, on demand) , Problem

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.