Troubleshooting
Problem
The Warehouse Proxy Agent (WPA) fails to insert data into various tables while writing errors to the Warehouse Proxy Agent logs.
Errors seen in the WPA logs ($CANDLEHOME/logs/
Cause
The DB2 error indicates the user does not have the INSERT privilege to add data to the tables.
SQL0551N "<authorization-ID>" does not have the privilege to perform operation "<operation>" on object "<name>". SQLSTATE=42501
Resolving The Problem
A DB2 DBA can resolve this problem by granting the INSERT privilege to the userid for the Table listed in the WPA log.
ex:
Error in WPA log shows:
+5408697C.2982 Caused by: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-551, SQLSTATE=42501, SQLERRMC=ITMUSER;INSERT;ITMUSER.KLZ_Sockets_Status, DRIVER=3.63.123
The error indicates the DB2 user ITMUSER does not have the INSERT privilege for the table ITMUSER.KLZ_Sockets_Status.
A DB2 DBA would resolve this problem using this statement:
db2 "GRANT INSERT ON TABLE ITMUSER.KLZ_Sockets_Status TO USER itmuser"
Related Information
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
swg21683562