SAP Knowledge Base Article - Preview

2502070 - DB6: SQL1092N error occurs during upgrade SAP system from 7.30 to 7.50

Symptom

  • Symptom 1

    In the process of upgrading system from Netweaver 7.30 to 7.50. following SQL1092N error appears:

    tp_exec_statement: SELECT A,B,C,D FROM ( SELECT 'StoInfo:' A, DB_NAME B, DB_STORAGE_PATH C, STO_PATH_FREE_SIZE/1024/1024 D FROMTABLE( SNAP_GET_STORAGE_PATHS( '' , -2 )) AS STO_SNAP ORDER BY DB_NAME, DB_STORAGE_PATH ) AS Y

    TPERR- SQL1092N The requested command or operation failed because the user * does not have the authority to perform the requested command or operation. User * "SAP<sid>"

  • Symptom 2

    Work process trace file contains error SQL1092N:

        dsql_db6_fetch( SQLFetch ): [IBM][CLI Driver][DB2/AIX64] SQL1092N The requested command or operation failed because the user ID does not have the authority to perform
        the requested command or operation. User ID: "SAPR3".


Read more...

Environment

SAP on IBM DB2 for Linux, UNIX, and Windows

Keywords

SCHEMA USER, sap<sid>, sapr3, db<sid>mnt, id sap<dbsid>, user group , KBA , db2 , schema user, sap, dbmnt, id sa , BC-DB-DB6 , DB2 Universal Database for Unix / NT , 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.