We have update yellowfin 6.3 to version 7 (on Linux server) ,after login of yellowfin I run dashboard but I got error message
"Error retrieving results An error occurred retrieving the results from the database." .
I have checked yellowfin.log . The log ERROR :
- YF:2014-01-27 11:44:19:ERROR (DBAction:doSelect) - Error occured selecting data: org.postgresql.util.PSQLException: Maximum number of rows must be a value grater than or equal to 0.
org.postgresql.util.PSQLException: Maximum number of rows must be a value grater than or equal to 0.
- YF:2014-01-27 11:44:19:ERROR (ReportRunner:M) - Error retrieving results: java.lang.Exception: Exception selecting data from database
java.lang.Exception: Exception selecting data from database
Also, I test run report ,the report error "An error occurred retrieving the results from the database.Please check the SQL syntax and try again."
and I checked SQL syntax by run query on postgres when I tested run query on postgres, the query can run correctly.