When I Run an Analytics, I get an error

[JohnDoe]

Hello.

I ran OOTB Analytics called Detected-Provisioning tasks found in Error State.
But when I hit the Run Now button, it fails with "Alert: Failure."
On the other hand, when I hit the Dry Run button, it shows the number of records without any problem, so I don't think there is a problem with Analytics Query.
How can I run Analytics from the Run Now button and create reports correctly?

↑Run Now

↑Dry Run

[sudeshjaiswal]

Hello @JohnDoe,

Use the same query and create the new analytics and check if it is working or not.

Thanks,

[JohnDoe]

Hello sudeshjaiswal, 

I've already tried using "Create Similar Analytics" to create another Analytics with the same SQL query.
But it failed.

[sudeshjaiswal]

Hello @JohnDoe,

This required an FD ticket for further troubleshooting.

Thanks,

[rushikeshvartak]

any columns ends with date is not allowed change alias of taskdate to taskdat

Please find below the details.

• In the query attached we the word DATE used in Alias. 
• Since V2 Analytics is based on Elastic search, certain key words cannot be used in Alias. The words "DATE" & "TIME" cannot be used in the Alias.

• The following keywords cannot be used as column names when constructing an SQL query for v2 controls:

  • status

  • comments

  • fulrun

  • basecountrun

  • updatedate

  • analyticshistorykey

  • analyticsconfig

  • hashcode

https://docs.saviyntcloud.com/bundle/EIC-Admin-v2020x/page/Content/Chapter17-EIC-Analytics/Analytics...