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...

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 , SAP Business Suite on Sybase ASE Database Platform , 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.