Server Timeout Issue

234 Views Last edit Jan 03, 2018 at 05:51 PM 2 rev

Before I begin my question, I want to make it abundantly clear that I don't have access to the BO server in my environment, and my knowledge of Business Objects is limited. I'm just a loley IT guy trying to help users and the only reason I've come here is because the analyst in charge of BO for my agency will not contact SAP support for this issue.

Environment info:

BOXI SP7

side-by-side install of BI Client tools 4.1 SP6

Oracle 11e

Windows 7 client side

Question:

I have a user who is able to run reports in SQL Developer without any issues, but if she runs the same reports in Webi or Deski, the server times out on her and the report just keeps running forever until she force closes the program in Task manager.

This user was able to run a query for the whole year of 2016 in 11-12 minutes, but when she changed the date for 2017, the connection to the server times out and the report just keeps spinning in both webi and deski until she finally results to putting the sql code into sql developer and running the report that way.

There is a domain trust with my agency and the company that hosts the BO server, oracle db, etc. The network is wide open on our end so firewalls shouldn't be a problem. Yet the analyst who has access to the server is persistent in saying the issue is on our end of the network. Is there something I am missing on my end?

If not, can I set up a task that pings the server every 5 minutes to keep the connection open on the user's computer as a work around? Is there something I can suggest to the analyst to check? I'm at a loss on this and could use any help I could get. If needed I can upload the logs from the client computer.

Thanks in advance for any help.