I have a system running with PostgreSQL/Tomcat/Achilles/Atlas, few reports are returning data and others not in ATLAS. 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. Truncated Achilles_cache and re-run the results and still the issue persists.
any help is appreciated.