Dojo,
Having recently migrated to STaaS, GQI queries to data stored in logger tables are showing this error.
Is this due to the known limitations on logger tables ?
Brecht Seys [SLC] [DevOps Advocate] Selected answer as best 7th February 2025
Hi Brecht,
The table in question keeps an audit of all users that login to a DMS.
Subsequent queries build on this to extract Stats like Top users, Numbers of Users per day/week/month etc.
As the dataset can grow quite large the data is kept in logger tables.
Hi Wale,
Indeed as documented in the Limitations section, GQI queries on indexed logger tables are not supported on STaaS.
If you don’t have any other questions, you can select this answer to complete this thread
Brecht Seys [SLC] [DevOps Advocate] Selected answer as best 7th February 2025
Hi Wale,
We are interested to learn about your use case.
Could you share some details about the use case for your query?
We'd like to have a better understanding about the impact of this limitation, and verify if there is a workaround or what could be done to solve it.
Feel free to reply here, or reach us via https://skyline.be/contact/tech-support