OBIEE 12.2.1.2 large report runs but does not display result

Khalid Ibrahim

We have a large report (over 63k records) that completes (as seen in  the session manager)  but the results (in the form of a simple table) do not display/render in Answers.  The session manager shows that the sql ran but even after 30 minutes, the report does not display results. 

Any ideas on how to debug/resolve this?

Thanks

[Deleted User]

Do you have different time outs configured across the differnent parts of the application? What do the logs say? Which host OS? Which browser version?

Khalid Ibrahim

Thanks for your reply.
The timeouts have not been changed anywhere.

Which logs should I take a look at? (that was what I was wondering with the "debug" part of the question)

The OS is Redhat Linux

The  browser is IE 11

[Deleted User]

OBIPS logs: .../user_projects/domains/youdomain/servers/obips1/logs

Khalid Ibrahim

Christian,

There was nothing in the log i.e nothing written in for the past few days and then when I tried rebooting the whole system, the bi_server1 went into admin state (I  started a different discussion about that)

[Deleted User]

Ok your problem is something completely different. I.e. your machine actually being messed up

Khalid Ibrahim

this is in a different environment. However, other smaller reports were running.