I have a system running with PostgreSQL/Tomcat/Achilles/Atlas, few reports are returning data and others not. I ran every query for each report individually in the PostgreSQL and they all return values, I then tried to look for errors in the logs for webapi, tomcat and there was no errors, I checked the console and there is no error. Although when I was checking the tables and realized that the Achilles creates a achilles_cache table that will feed the reports in Atlas and this table has only few reports with data and most of then without data, I am new to this environment as it is a temporary work assignment. After reading the documentation I tried to use the Achilles Heel that could give me a possible indication about what is happening and I found out that I dont have it installed.
I could not find much about the achilles_table and I have been trying several approaches based on this forum, if someone out there could help me out to narrow the issue would be much appreciated.