Forum Discussion

bpeikes's avatar
bpeikes
Cloud Apps
04-11-2023

View queries that Sisense is sending to a live source?

Not sure if this is the right "Location", as this community boards "Locations" make no sense. Had a question regarding viewing the queries that Sisense is sending to a live source. I have a dashboard which is returning no data available, and I have no idea why. Querying the data directly in RedShift works fine.

Is there a log I can tail to view the queries?

To add some additional data, the filters on this dashboard, although set in the url via "filter" parameter and JAQL, are showing a "busy" animation. I'm not sure what they are trying to do.

Linux

4 Replies

Replies have been turned off for this discussion
    • bpeikes's avatar
      bpeikes
      Cloud Apps
      04-12-2023

      I was hoping for a log on the server somewhere. The reason I’m looking for that, is I also want to know what the filters are doing. They often have “working” animations.

  • irismaessen's avatar
    irismaessen
    Data Pipeline
    04-12-2023

    You can try the combined.log or the query.log (in var/log/sisense/sisense on your main app node) from, that should have most log records in it.

    An actually *failed* query due to an error should have its sql somewhere in query.log.

    I think the busy animation on the filters tends to happen when the data security/available rows in the filter queries are running. If you have a lot of data security settings or a lot of rows in your dimension tables, those might be things to check. 

  • irismaessen's avatar
    irismaessen
    Data Pipeline
    04-12-2023

    You could also check the galaxy.log. According to this article, the filter behaviour you describe could be from the queries trying to contact the data source. 

     

    Good Luck!

    Iris