Medium severitydata source
Power BI Refresh Error:
DB2DriverRunFailed
What does this error mean?
The DB2 JDBC driver failed during an ADF copy activity. When the error contains SQLSTATE=51002 SQLCODE=-805, the required DB2 packages are missing or not bound to the database.
Common causes
- 1The DB2 packages required for JDBC connectivity are not bound — indicated by SQLSTATE=51002 SQLCODE=-805
- 2The packageCollection property is not configured, defaulting to a collection that does not have the required packages
- 3The DB2 user account lacks EXECUTE privilege on the required packages
How to fix it
- 1Set the packageCollection property to "NULLID" in the ADF DB2 linked service configuration.
- 2Alternatively, ask the DB2 DBA to bind the required packages to the database: BIND PACKAGE (NULLID) .
- 3Verify the DB2 user account has EXECUTE privilege on the packages in the configured packageCollection.
- 4See the ADF DB2 connector documentation "Linked service properties" section for the packageCollection setting.
Frequently asked questions
Official documentation: https://learn.microsoft.com/en-us/azure/data-factory/connector-troubleshoot-db2