We have a report that will not complete, eventually it comes back with 'The report could not run because a server error occurred'. The 'details' are
The web request failed.
0 -
URL: ../v1/disp/../reports
When looking in the admin console the report sits there in 'preview' for 30+ minutes before finally getting the above error. We can't see where the system or database is doing anything special, nor can we find any helpful information in the logs. Basically have no idea what it is doing during all of this time.
What are we missing on how to track down what is happening with this report?
Thanks for any ideas. -j
Hi,
Is the report running interactively?
How complex is the report?
Is it relational or Dimensional?
Are you getting the tabular data from the query?
Does the report have a prompt page and are you able to submit the prompt page?
Did you check the generated sql from the query?
Does it show in the status tab of the administration as pending or executing?
Check with DBA if a session is being created for this query and let us know.
Try to simplify the report by taking off some columns and see if it makes a difference.
Good luck
New guy