Click HERE to see how Saviynt Intelligence is transforming the industry. |
05/11/2022 11:26 AM
When creating a New Analytics Configuration, I fill in all required fields including the query. Clicking the preview button pulls the correct data but when I click Create, it wont let me save it and I get error message "Warning! Query returned no columns". Im not sure what the issue is because it pulls all the data into the preview but just wont let me save it. Has anyone had this same problem?
Solved! Go to Solution.
05/11/2022 12:14 PM
Are you creating Report under Analytics / ES Analytics.
if you are creating under ES Analytics (v2) make sure ES Analytics Server is Running
05/11/2022 12:18 PM
Its just an SQL query
05/11/2022 12:24 PM
Please provide query to check further or Please confirm which type of report you are trying to create
1. Analytics (v1)
2. ES Analytics (v2)
if you are unsure about then check if any existing report if they are running
05/11/2022 12:30 PM
Its an Analytics (v1) query
05/11/2022 01:12 PM
I was able to fix the issue myself, it didnt like the following part of the code because when I removed it the query ran and I was able to save.
AND A.STATUS<>'2'
AND A.LASTLOGONDATE<NOW()-INTERVAL 3 WEEK
05/11/2022 09:05 PM
If you are using > or < or >= or <= in the SQL query, give a space before and after the character, that would allow you to use those symbols in the SQL query and also allow you to save the query.