Time out expired problem

building reports crystal reports
1

Hello,

Sorry if I post a similar problem to somebody else but the thing is nobody answer and I’ virtualy stuck with this.

I’m running a huge report with a very hard query with CASE…WHEN statetments,etc,etc…This report was running fine with a small fact table (around 6 millions rows) but now we update the fact table with the real data and real size (around 20 millions rows) and now after 20 mins fails with the following error:

Database error: [Microsoft][ODBC SQL Server Driver]Timeout expired. Contact your administrator or database supplier for more information. (Error: WIS 10901)

The same query runs in 25 minutes from the Query Analyzer(run directly against SQL Server database, from outside of Businnnes Objects

I did the following stuff:

  1. I changed the setting in the web.xml file in:

    • Program File/BusinessObjects/tomcat/adminlaunch/
    • Program File/BusinessObjects/tomcat/desktoplaunch/
    • Program File/BusinessObjects/tomcat/businessobjects/
      from 20 mins to 240 mins in the setting for timeout

  2. I close the application and start it again

  3. I ran the report again

But finally it doesn’t work still show me the same error after around 20 mins.

The question is where this setting is located?

Environment:
Windows Server 2003 Enterprise Editions
SQL Server 2000 SP 3
MDAC 2.82
BOEXI JAVA deployment (TOMCAT 5.0 is act as both Web and Application Server)

Any idea what could be causing this timeout?

Please help!!!,

PP.

papear (BOB member since 2005-07-05)

2

Hi Patricia,

I had to cope with a similar problem under Webi 6. Have a look to this post.

I hope this will help you.

Regards

3

Hi Goiffon,

I didn’t change the settings in
Program File/BusinessObjects/tomcat/conf/web.xml

Because in theory you have to chance in your specific application because of that I tried with the rest of the files…I can change that in this files but when you say that you changed some settings in your IE (Internet Expleror I assume) what kind changes I have to do in there???

And you talk something about sockets server???

What were the changes there…

Thanks in advance…

PP.

papear (BOB member since 2005-07-05)

4

Indeed i was talking about Internet Explorer.

Here we need to by pass the proxy server cause it had his own internal timeout parameter !

Regards

5

Hi Goiffon,

I already changed the settings of web.xml in:
-Program File/BusinessObjects/tomcat/conf/
-Program File/BusinessObjects/tomcat/adminlaunch/

  • Program File/BusinessObjects/tomcat/desktoplaunch/
  • Program File/BusinessObjects/tomcat/businessobjects/

from 30 to 240 mins in the first case (…/tomcat/conf)
and from 20 to 240 mins in the rest of files

I restart the server
I ran the report again but It doesn’t work

Did you do any extra thing???

Thanks again I’m really desperated,

PP. :cry:

papear (BOB member since 2005-07-05)

6

Hi Patricia,

Yes as i told you by pass the proxy server. To know if it’s exactly that try to run ie directly under your webi server i mean connect to the webi server (using pc anywhere or tse …) and then launch ie on your server.

If you have no timeout problem that’s it proxy policy !

Regards

7

Goiffon,

In my case I have BO and the Web server in the same machine…sorry AGAIN if I sound silly but How can I connect to my webi server?

Cheers,

PP.

papear (BOB member since 2005-07-05)

8

Patricia,

I also have webi,tomcat and apache on the same server : XX.YYY.ZZZZ.FFF is his IP adress.

You to connect directly on this server (XX.YYY.ZZZZ.FFF).
To do this you need to use a software like PCAnyWhere or Terminal services … Check this with your server admin. I’ll give you an admin account to connect to it !
to administrate it he certainly uses such a software

Regards

9

Goiffon,

Actually I’m working on the server through a remote desktop connection as a Adminitrator with full permissions…I can change whatever I want this is a Server only for the project t the moment.

This is what I need?..so what will be the next step?

PP.

papear (BOB member since 2005-07-05)

10

I think yes.

It’s as if you were on the server in front of his terminal !

If you can launch your browser connect to webi and launch the refresh of your doc.

Regards

11

Hi,

sorry that i broke in the thread but isn’t the dbase connection who has the time out?
I know that you can set time out of the BOEXI services to the database.
This seems to me the problem.

Regards,

Jan

RapidJvD :netherlands: (BOB member since 2005-09-10)