search

shzlw / poli

An easy-to-use BI server built for SQL lovers. Power data analysis in SQL and gain faster business insights.
https://shzlw.github.io/poli
MIT License
1.97k stars 330 forks source link

Blank screen when a query runs #73

Closed jtclaib closed 4 years ago

jtclaib commented 4 years ago

I have a simple query being used when adding a new component. When the count(PoolID) is added and I run the query the screen goes blank. There are other queries in the report that use count as well, they do not have this issue. I created a view and stuffed the query in it, and thay seems to work.

Here is the component configuration PoliComponent

here is the error - PoliError

shzlw commented 4 years ago

Looks like the back end is returning 500 error for some reasons. Could you check if the log file located at log/server.log has additional error information?

In addition, your query seems to have an error. You select PolID but group by PoolID?