Troubleshoot the QuickBooks connector

Important

This feature is in Beta. To use it, a workspace admin must turn on Lakeflow Connect for QuickBooks from the Previews page. See Manage Azure Databricks previews.

This page describes common errors you might encounter with the managed QuickBooks connector and how to resolve them.

For general troubleshooting guidance that applies to all managed ingestion pipelines, see Troubleshoot managed ingestion pipelines.

QuickBooks API fault

Error message:

QuickBooks Fault (<fault-type>) code <error-code>: <error-message>

Cause: The QuickBooks API rejected a request. The fault type, code, and message come from QuickBooks and describe the reason, such as missing permissions or a company that isn't available to the app.

Solution:

1. Look up the error code in the QuickBooks Online API error codes.
2. Verify that the Client ID, Client Secret, Your QuickBooks Company ID (Realm ID), and Environment in the Unity Catalog connection match your Intuit app and company. See Create a QuickBooks connection.
3. If the authenticating user no longer has access to the company, sign in again with a user that does.