SYMPTOM:
When a user chooses "View SQL" for a report, the Structured Query Language (SQL) generation takes much longer than anticipated. At this time, the Job Monitor displays a report status of "Waiting for cache."
CAUSE:
The report executing in "SQL View" is waiting for the cache file to be returned from another executing job. This behavior is working as designed. Every executed report type (Grid, Graph or SQL View) creates a job first. This job then checks to see if a cache file exists. If a matching report is already executing against the database, the Strategy Intelligence Server will then wait for the executing job to return and use the cache file. At this portion of the execution cycle, there is no recognized difference between Grid Reports, Graph Reports and SQL View reports.
WORKAROUND:
If the SQL is required immediately, it can be obtained from the Job Monitor. To retrieve it, perform the following steps:
The SQL will be present in the job monitor window.
