This documentation is for an older version of HVR.

Error: F_JD22CA: Skipping Table - Only Table or Database Owner Can Analyze It

Issue

While replicating to a Redshift target, the refresh fails with the following error:

F_JD22CA: DBMS error [ERROR: skipping table --- only table or database owner can analyze it. INFO: Load into table completed, nnnn record(s) loaded successfully]. DBMS error number [30]. SQL State [HY000]. DBMS version [PostgreSQL 8.0.2 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.4.2 20041017 (Red Hat 3.4.2-6.fc3), Redshift 1.0.5749]

Environment

HVR 5

Resolution

To resolve this error, make sure the user connecting to Redshift is a superuser. See Amazon's documentation for more information on superusers.