SAP Knowledge Base Article - Preview

2327964 - SQL0551N Error for DB2 Modules

Symptom

During system maintenance operations like an SAP upgrade, you see errors like the following:

SM21 System log:

*****************************************

SQL0551N The statement failed because the authorization ID does not have the required authorization or privilege to perform the operation. Authorization ID: "SAPXXX". Operation: "REPLACE MODULE". Object: "xxx.<module_name>". LINE NUMBER=1. SQLSTATE=42501
Database error -551 at EXE

********************************************************************************************************************************************************************************

In the correspondent developer trace (dev_w*.log):

******************************************

C *** ERROR in ExecuteDirect (BEGIN)

C &+ dsql_db6_exec_immediate( SQLExecDirect ): [IBM][CLI Driver][DB2/LINUXX8664] SQL0204N "SAPXXX.<function_name>"
C &+ is an undefined name. SQLSTATE=42704
C &+
C &+ DROP SPECIFIC FUNCTION <function_name>
C &+
C &+
C &+ ABAP location info 'CL_SQL_STATEMENT==============CP', 74
C &+
C *** ERROR in ExecuteDirect[] (END)
C *** ERROR in ExecuteDirect[] CON = 0 (BEGIN)
C &+ dsql_db6_exec_immediate( SQLExecDirect ): [IBM][CLI Driver][DB2/LINUXX8664] SQL0551N The statement failed because
C &+ the authorization ID does not have the required authorization or privilege to perform the operation. Authorizati
C &+ on ID: "SAPXXX". Operation: "REPLACE MODULE". Object: "XXX.<module_name>". LINE NUMBER=1. SQLSTATE=42501
C &+
C &+ CREATE OR REPLACE MODULE <module_name>
C &+
C &+
C &+ ABAP location info 'CL_SQL_STATEMENT==============CP', 74
C &+
C *** ERROR in ExecuteDirect[] (END)
B ***LOG => sql error -551 performing EXE [dbds 670]
B ***LOG => SQL0551N The statement failed because the authorization ID does not have the required authorization or privilege to

*****************************************


Read more...

Environment

DB2 on LUW, SAP NetWeaver 7.4 or higher

Keywords

RUTCNVFUNCCRE1, Transfer Ownership, DDIC, ABAP Dictionary. CURRCONV , DB6CDS , KBA , 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.