Agents
Category
Data Sources
Product Version
8.0
When running reports/views in against Amazon Redshift, I'm getting 'Error: org.postgresql.util.PSQLException: ERROR: type "e" does not exist'
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) ...
The same problem 
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.
If you have any questions on this, or are still running into issues, please let us know.
Regards,
David
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.
If you have any questions on this, or are still running into issues, please let us know.
Regards,
David
Replies have been locked on this page!