When running reports/views in against Amazon Redshift, I'm getting 'Error: org.postgresql.util.PSQLException: ERROR: type "e" does not exist'

Yellowfin FAQ shared this problem 3 months ago
Resolved

The error in the Yellowfin.log shows:

ERROR (MIReportProcess:runAction) - Error: org.postgresql.util.PSQLException: ERROR: type "e" does not exist
org.postgresql.util.PSQLException: ERROR: type "e" does not exist
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
...

Comments (1)

photo
1

This issue is due to incompatibilities with the more recent Postrgres JDBC drivers. To resolve this issue, just use the 4.1 Amazon Redshift driver here.


Please download the latest Redshift driver from the link above and load into Yellowfin via the Yellowfin Plugin Management.

Once you've done this you will be able to choose the Redshift driver from the drop down list.ecd435d5cf44f412f974c99c6b48c740

If you have any questions on this, or are still running into issues, please let us know.


Regards,

David

Comments have been locked on this page!