Issue

The connector is failing with the error, Null Pointer Exception.

Environment

Connector: Databases

Resolution

Please follow the steps below to resolve the error:

• Please check if you recently added any new tables to the schema or made any changes to the schema.
• If yes, check that the Fivetran user has all the necessary permissions to make these changes. You can find out more about granting appropriate access in our Documentation.

GRANT SELECT ANY TABLE TO FIVETRAN;

• If you still continue to see the error, please contact Fivetran Support.

Cause

The NullPointerException (NPE) occurs when a declared variable is trying to find a value to use but is receiving null.