Solved

Business Objects Server XI R1SP3 Database query time out issue

Posted on 2008-10-07
3
519 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SSRS 2012 Report building- Expressions 3 78
Group Header Repeating on every page 4 39
Crystal Reports 2008 6 24
Crystal Reports - group header 2 39
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.

867 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now