Solved

Business Objects Server XI R1SP3 Database query time out issue

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

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…
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…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

803 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