Solved

Business Objects Server XI R1SP3 Database query time out issue

Posted on 2008-10-07
3
525 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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, In my previous Article  (http://www.experts-exchange.com/Database/Reporting/A_15199-Introduction-to-Microstrategy.html)I discussed some basic understanding of Microstrategy that how we can get in Intro of Microstrategy (MSTR). Now it's tim…
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

717 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