Solved

Business Objects Server XI R1SP3 Database query time out issue

Posted on 2008-10-07
3
522 Views
Last Modified: 2013-11-15
Hi All, I'm running:
Crystal Reports Server XI, R1, SP3, on Windows 2003 R2. Dedicated server, (Virtual)
This is a newly migrated system, our old system died. For different reasons, we went with our original media install, and not R2. Hindsight is a beautiful thing.

We are receving a timeout issue on some reports run from the portal, that we didn't experience on our old system. If the reports are run from the Crystal thick client they complete almost immediatly, they are not big data sets. The database is Oracle 10g R2 running on Red Hat, and is local to the portal server. Both reports were created from the one .rpt file, that is it was uploaded and the thick client is using the same file.

The second issue is a report failing with 'Unable to retrive Object' error. This error does not occur in the thick client. This report does query a view, I've read some issues on SAP support that this could be an issue of sorts.


Doc2.doc
0
Comment
Question by:TheHankHunter
  • 2
3 Comments
 
LVL 16

Expert Comment

by:wykabryan
ID: 22678526
Because you guys did a fresh install many of the services setting are probably different. Log into your CMC. There is a section called servers. You will need to tune eash one of those servers to help with this issue. There are a number of areas that you can set the timeout, idle time, and database connection timing.

On the other error, I have found that if you delete the object and redo it, it will generally clear it up.
0
 

Author Comment

by:TheHankHunter
ID: 22699688
HI wykabryan, thanks for your comment.
Regarding the time out, I appreciate some tuning may be required. However, from my workstation client the report is produced almost immediatly, (3-5 seconds) whereas on the server it times out after the (current setting) of 2 minutes. This is not a big database (<10GB) and not many concurrent connections (circa 50). So it's not a question of load by any stretch. I have also noticed if I tune the report to prompt for credentials, incorrect credentials are reprompted. So, the connection is being made. Only when the data is requested, it falls over.
I'm new to Business Objects, is there any logging I can turn on to determine step by step the progress of my report from BO perspective? I could perhaps then see the SQL being sent to the DB and monitor same form the DB side. Thanks.
0
 

Accepted Solution

by:
TheHankHunter earned 0 total points
ID: 22737288
Reported question to ask for timeout parameters.
0

Featured Post

Active Directory Webinar

We all know we need to protect and secure our privileges, but where to start? Join Experts Exchange and ManageEngine on Tuesday, April 11, 2017 10:00 AM PDT to learn how to track and secure privileged users in Active Directory.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Hi, I am very much excited today since I'm going to share something very exciting Tool used for Analytical Reporting and that's nothing but MICROSTRATEGY. Actually there are lot of other tools available in the market for Reporting Such as Co…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question