?
Solved

Crystal Reports Server Failed to load database information

Posted on 2009-07-09
5
Medium Priority
?
2,604 Views
Last Modified: 2012-05-07
I have a Crystal Report that works just fine as designed in Crystal XI connecting to my Oracle database.  I have installed and configured Crystal Reports Server and uploaded the report to the CMC into a new folder.  When I try to run or preview the report, I get the message "Failed to Load Database Information".  In the process/database settings I have tried both using the original database login information from the report, supplying the correct username and password and I have also tried using the custom settings for Oracle.  Both return the same error.  I have Oracle 9i client installed on my Crystal Server (Windows Server 2003) and can connect without a problem to my Oracle database using SqlPlus.  Please help me in finding why my report will not run via Crystal Server.  I am trying to get it to run so that I can schedule this report to run on a daily basis.  I have read other questions and answers on Experts Exchange but they either do not pertain to my issue or I tried the resolution provided but it did not help.  Thanks in advance.
0
Comment
Question by:LRI1
[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
  • 3
5 Comments
 
LVL 14

Assisted Solution

by:LinInDenver
LinInDenver earned 200 total points
ID: 24824585
The only thing I can think of - is the ODBC connection created on the CE Server, and named the same as the machine the report was built on? You mentioned you have the ability to connect on it through SQL Plus, but I can't remember if that means your ODBC is set (I've been away from Oracle for 1.5 years now).

Even though your ODBC connections will display in the CMC on the Database properties (which in the past made me think I didn't have to do anything!) you still need to create an ODBC on the actual CE server.

Hope this helps some how - good luck!
Lin
0
 

Author Comment

by:LRI1
ID: 24824711
Hi,

I am not connecting with ODBC on the report so I should not need it on the CE server.  I connect via the Oracle Server connection packaged with Crystal Reports.  However, yesterday I did set up an ODBC connection from my CE server and chose that in the process/database properties of the report.  Same error.  Thanks for trying.  Anyone else have any insight?
0
 
LVL 101

Assisted Solution

by:mlmcc
mlmcc earned 200 total points
ID: 24832371
Did you install the Oracle database driver from Crystal on the server?

mlmcc
0
 

Author Comment

by:LRI1
ID: 24843791
Not quite sure what you mean.  The Oracle driver was installed when I installed Crystal Reports Server.  It shows that I have the Oracle driver as an option under custom database login information.
0
 

Accepted Solution

by:
LRI1 earned 0 total points
ID: 24850961
I was able to get it to work!  For anyone else who has this issue, try the following.

From the Crystal Server. Go to Start-->Programs--> Business Objects-->Crystal Report Server-->Central Configuration Manager.

Now for Crystal Reports Job Server and Crystal Reports Page Server right click and select properties. Both the accounts should be running under an admin account and not LocalAdmin. I changed them to run under my domain admin account since my domain admin has full access to my Oracle Database server.

That worked for me!
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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…
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
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: …
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

762 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