Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 533
  • Last Modified:

Business Objects Server XI R1SP3 Database query time out issue

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
TheHankHunter
Asked:
TheHankHunter
  • 2
1 Solution
 
wykabryanCommented:
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
 
TheHankHunterAuthor Commented:
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
 
TheHankHunterAuthor Commented:
Reported question to ask for timeout parameters.
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now