SAP Knowledge Base Article - Preview

2713636 - SUM upgrade fails with database error 4630 "must be in the the default database" - SAP ASE with Business Suite

Symptom

  • Upgrading NetWeaver version fails in Phase: PREP_INIT/SYB_CHK_PRIVILEGES
  • With database error 4630:

    "You must be in the the default database for the user 'SAPSR3' (the 'master' database) in order to GRANT or REVOKE builtin"
  • Entries in SYB_PRP_SESSVAR.LOG show:

1 ETQ399 Executing SQL script '../var/SYB_PRP_SESSVAR.TSQL'.
....
4 ETQ394 "Changed database context to 'SID'."
...
3 ETQ398XSQL: 'grant select on builtin set_appcontext to SAPSR3 grant select on builtin get_appcontext to SAPSR3 grant select on builtin rm_appcontext to
3 ETQ398XSQL: SAPSR3 ')
1EETQ008 Error message: DBSL error 99 (db code 4630):
1EETQ009X[ASE Error SQL4630][SAP][ASE ODBC Driver][Adaptive Server
1EETQ009XEnterprise]You must be in the the default database for the user
1EETQ009X'SAPSR3' (the 'master' database) in order to GRANT or REVOKE builtin
1EETQ009Xaccess.
1EETQ003 exit code: "20"
4 ETQ399 Rollback.


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
  • SAP Adaptive Server Enterprise (ASE) 15.7 for Business Suite
  • SAP NetWeaver (NW) - All versions

Product

SAP NetWeaver 7.5

Keywords

error 4630 , SQL4630 , permission , default database , SAPSR3 , SYB_CHK_PRIVILEGES , SYB_PRP_SESSVAR.TSQL , SYB_PRP_SESSVAR.LOG , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , 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.