SAP Knowledge Base Article - Preview

3199582 - Upgrade fails in phase MAIN_SWITCH/SQLDB_MSS_MSSPROCSTHROW - NetWeaver

Symptom

  • SUM fails in phase MAIN_SWITCH/SQLDB_MSS_MSSPROCSTHROW.

    SQLSTMTSTD.OUT shows:

    1EETQ008 Error message: DBSL error 99 (db code 50000):
    1EETQ009X Creation of stored procedure 'sap_zz_create_jobs' threw SQL Error 229:
    1EETQ009X The EXECUTE permission was denied on the object
    1EETQ009X 'sp_update_jobschedule', database 'msdb', schema 'dbo'.
    1EETQ003 exit code: "20"

  • Run SE38 report MSSPROCS and then "Execute all" and then "Execute SQL Scripts" fails with the same error:

    Msg 229, Level 14, State 5, Procedure sp_update_jobschedule, Line 1The EXECUTE permission was denied on the object 'sp_update_jobschedule', database 'msdb', schema 'dbo'.


Read more...

Environment

  • SAP systems based on Microsoft SQL Server

Keywords

EXECUTE permission, denied, sap_zz_create_jobs, sp_update_jobschedule, SQL Error 229 , KBA , BC-DB-MSS , SQL Server in SAP NetWeaver Products , 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.