How to Resolve Refresh Redshift target fails with F_JD22CA: DBMS error [ERROR: skipping “” — only table or database owner can analyze it. How do I fix?   

Viewing 1 post (of 1 total)
  • Author
    Posts
  • #22201
    Donna Zehl
    Keymaster

    Problem Summary:

          How to Resolve Refresh Redshift target fails with F_JD22CA: DBMS error [ERROR: skipping “<tablename>” — only table or database owner can analyze it. How do I fix?

     

    Description 

         The client experienced one of these issues while replicating to a Redshift target. The refresh fails with the message:  

          F_JD22CA: DBMS error [ERROR: skipping "<tablename>" --- only table or database owner can analyze it. 
          INFO: Load into table '<tablename>' 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]  

    Target table remains empty. 

     

    Answer: 

           Resolution is to make sure the HVR user connecting to Redshift is a superuser. 

     

Viewing 1 post (of 1 total)
  • You must be logged in to reply to this topic.

© 2020 HVR

Test drive Contact us