Timeout setting

I work with Birt Designer Pro on my laptop. I have several database servers that I might write a report to run against.

The problem I'm having is that if I'm not connected to the correct vpn and I try to open a dataset that is pointing to a server that I can't see, the wait while Birt tries to find the server is several minutes. Then I get the error that the server could not be found. After clicking 'OK' I have to wait another couple of minutes.

I need to find out if there is a configuration setting I can change to set the amount of time BDP looks for a server that doesn't exist.

Thanks.

Find more posts tagged with

Comments

mwilliams

There's a SERVER_QUERY_TIMEOUT setting in the web.xml that can be set for a time to wait for the iServer response. By default, mine is set to 8 seconds, though. Are you using the iServer?

nelsont

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="107956" data-time="1344031915" data-date="03 August 2012 - 03:11 PM">
There's a SERVER_QUERY_TIMEOUT setting in the web.xml that can be set for a time to wait for the iServer response. By default, mine is set to 8 seconds, though. Are you using the iServer? </blockquote>
 
 
Sorry, I should have been more specific. I do use the iServer, but the problem occurs when I try to access a Data Source that my machine can't see. Usually while I am writing a report, I have the Data Source point directly to a SQL server / database. I write locally on my machine and test locally. But then I will log on the network and try the report running against another SQL server to see how it looks. 
 
If I have the Data Source pointing to the network server and am not logged in, the timeout problem occurs. 
 
I know, I am getting better at checking the Data Source first, but sometimes I forget and sometimes I just want to look at the query I have written in the Dataset. It happens to other people on my team, too.

mwilliams

My mistake. Sorry for the confusion. In the designer, try going to Window -> Preferences -> Report Design -> Data Set Editor -> JDBC Data Set and set the time out limit to a value lower than 60 seconds. Maybe that'll help. Let me know.

nelsont

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="108220" data-time="1344282217" data-date="06 August 2012 - 12:43 PM">
My mistake. Sorry for the confusion. In the designer, try going to Window -> Preferences -> Report Design -> Data Set Editor -> JDBC Data Set and set the time out limit to a value lower than 60 seconds. Maybe that'll help. Let me know. </blockquote>
 
That didn't do it. I edited a data source to point to a remote machine that is not accessible and when I hit 'test connection' it still takes at least a minute to timeout. I tried existing and restarting Birt. The setting sticks (I changed it to 10 seconds) but it seems to have no effect.