Scheduled error - query failed : error while executing SQL "-- Looker Query Context

[Data_nerd]

I am having a schedule report which has thrown an error failed to deliver and message states that it failed to query result on one of the date dimension. Message is as followed:
Error occurred while generating this dashboard - contact administrator (error: Render job 463fa7da56b5cb5441a1fec12cdde51b[56979] failed [query failed: Error while executing SQL "-- Looker Query Context '{"user_id":109,"history_slug":"c4f1369fd19f87307824dd178fd28b0c","instance_slug":"9f40d64d4ca021b419f79b5f599e456133"}' SELECT (CAST(FLOOR(random.”__time" TO DAY) AS DATE)) AS “random.])

But I checked any changes on the dashboard in which this dimension is used but could not find any changes on the dashboard which is being scheduled. The query - SELECT (CAST(FLOOR(random.”__time" TO DAY) AS DATE)) throws random.Date dimension. Even, I tried to run event attributes from system activity but there was no history against this dashboard.
Can anyone help me what could be a cause to happen this.

Thank,