Error: Null Pointer Exception

Issue

The connector is failing with the error:

Null Pointer Exception

Environment

Database Connectors

Resolution

Follow the steps below to resolve the error:

1. (Optional) If you, indeed, have added new tables to the schema or made any changes to the schema, check that the Fivetran user has all the necessary permissions to make these changes. You can find out more about granting appropriate access here.

   GRANT SELECT ANY TABLE TO FIVETRAN;

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

Cause

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