Open Document hyperlink timeout

building reports webintelligence
1

I have an opendocument web page hyperlink, which works much of the time but then I get timeout errors intermittently across the day.

If I edit from InfoView and refresh in Desktop Intelligence, then the hyyperlink seems to run again. Similarly, if I reboot the connection server it also seems to run again. There have been a couple of occurrences where these strategies have not worked however. There is something that then seems to kick in during the day and the report runs once again.

The web.config file has timeout parameters but they are already set to 20 minutes. I would expect a timeout if I ran the report and it took over 20 minutes to run, but the report refreshes within a few seconds.

I can run this report and others without any timeout issues on Infoview and desktop intelligence and I have set the registry timeout (ReceiveTimeout) appropriately.

SAP support are looking at it but don’t seem to be getting anywhere currently.

Can anybody assist please?

Thanks

cormackp (BOB member since 2011-10-10)

2

Welcome to B:bob:B!
Its worth posting the exact timeout message you see.

Nick Daniels :uk: (BOB member since 2002-08-15)

3

Timeout error attached, thanks!
error2.doc (47.0 KB)

cormackp (BOB member since 2011-10-10)

4

Do you also get this error when refreshing non-hyperlinked reports?
What connection settings / parameters do you have set up in the universe, time, array fetch e.t.c.?

Mak 1 :uk: (BOB member since 2005-01-06)

5

I do not get the issue when I run non-hyperlinked reports. I can run complex reports on InfoView and Desktop Intelligence without ever timing out. I used to have timeout issues when we first upgraded to XI but they were due to IE 7 timeouts which have been resolved with the ReceiveTimeout registry entry.

Connection parameters:
Connection Pool Mode = “Keep the connection active for”
Pool timeout = 1 minute
Array fetch Size = 20
Array Bind Size is Null
Login Timeout is Null
(I have tended to ignore these parameters in the past but I am having no issues when running from Infoview etc).

Universe Parameters:
Controls Tab - All Query limits checkboxes unchecked.

Thanks for your help on this.

cormackp (BOB member since 2011-10-10)

6

I believe that you are losing the Oracle session, in between opening the parent and then following the link to the child.
Have you tried disconnect after each transation?

Mak 1 :uk: (BOB member since 2005-01-06)

7

Apologies in the delay getting back.

Sorry, but I don’t know what you mean by :

  1. “between opening the parent and following the link to the child”
  2. “have you tried disconnecting after each transation”.

The hyperlink is from a standard intranet web page. Are you suggesting making an amendment to the web.config file?

Thanks

cormackp (BOB member since 2011-10-10)

8

Sorry, I misunderstood I thought you were opening this within Infoview.

To be honest the error is an Oracle one. I will suggest that there may be poor connectivity between your Intranet Site > Business Objects > Oracle, leading to the connection being dropped.

You do this in the universe, it a connection configuration.

Mak 1 :uk: (BOB member since 2005-01-06)

9

Thanks Mak1. I will try changing the connection parameter.

Any ideas what the pool timeout does (when used in conjunction with Connection Pool Mode = “Keep the connection active for”). Ours is set to 1 minute currently.

Regards

cormackp (BOB member since 2011-10-10)

10

Worth a go. As it works sometimes it leads me to think it may be poor network connectivity. Maybe, the time it doesn’t work your network is at its most busy.
You could send a packet sniffer along that path to see where it is being dropped?

As for your second point, good discussion here:-
https://bobj-board.org/t/150260/4

Mak 1 :uk: (BOB member since 2005-01-06)