Symptom
The SWPM tool cannot continue as the developer trace files for all work processes fail with a DB-connection issue.
The DB connection fails for the <SID>adm user from the application server instance.
Errors like the following are observed. Note :some objects can be Virtual Tables. This is identified by SQL0551N error.
The object should then be checked in the DBAcockpit - Virtual tables overview and where needed the object(table) should be
materialsed in the same view.
dev_w0:
ERROR in prepareStatement[/bas/753_REL/src/dbs/db6/dbdb6.c, 15242]
DbSlConnectDB6( SQLExtendedPrepare ): [IBM][CLI Driver][DB2/LINUXX8664]
SQL0551N The statement failed because the authorization ID does not have the required authorization or privilege to perform the operation. Authorization ID: "<SID>ADM". Operation: "SELECT". Object: "SAP<SID>.<tab_name>".
Note: the above operation can include SELECT, EXECUTE etc.
Read more...
Environment
Db2 LUW IBM
Product
Keywords
installation, application server, SCHEMA, Deferred table creation, view, DB6_OPTPROFILE, ENV_GET_REG_VARIABLES,- sapinst_dev.log,
keydb.xml, summary.html
, KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , BC-INS-SWPM , Installation with Software Provisioning Manager , 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.
SAP Knowledge Base Article - Preview