Troubleshoot the DB2 connector in Azure Data Factory and Azure Synapse

APPLIES TO: Azure Data Factory Azure Synapse Analytics

Tip

Try out Data Factory in Microsoft Fabric, an all-in-one analytics solution for enterprises. Microsoft Fabric covers everything from data movement to data science, real-time analytics, business intelligence, and reporting. Learn how to start a new trial for free!

This article provides suggestions to troubleshoot common problems with the Azure Database for PostgreSQL connector in Azure Data Factory and Azure Synapse.

Error code: DB2DriverRunFailed

• Message: Error thrown from driver. Sql code: '%code;'

• Cause: If the error message contains the string "SQLSTATE=51002 SQLCODE=-805", follow the "Tip" in Copy data from DB2.

• Recommendation: Try to set "NULLID" in the packageCollection property.

Related content

For more troubleshooting help, try these resources:

• Connector troubleshooting guide
• Data Factory blog
• Data Factory feature requests
• Azure videos
• Microsoft Q&A page
• Stack Overflow forum for Data Factory
• Twitter information about Data Factory