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 for Me (Login required).

Search for additional results

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