Solved

Crystal Reports Server 2011 - Error in File *.rpt: Failed to load database information.

Posted on 2013-06-05
8
2,731 Views
Last Modified: 2013-06-18
Hi Experts,

I'm replacing an older CR Server with a new one and ran into an error when trying to run various reports.

CR Server: Windows 2008 64bit, Oracle 11g 64 bit and now 32 bit
Server where the database resides - Windows 2003, and Oracle 9i 32 bit

I installed CRS 2011 and installed Oracle 64 bit, and then uninstalled that version of Oracle with a 32 bit version.  

In Net Manager, I was able to create the entries for the tnsnames.ora file and was able to authenticate using the test with Net Manager.  When I run a report in CMC, I keep getting the error: Error in File ~tmp1fec78b204a83c0.rpt: Failed to load database information.

Any ideas on further troubleshooting steps?  I'm copying the install files of the Crystal Reports app itself as another troubleshooting step to see if that functionality is working.

Thanks!
0
Comment
Question by:byd2k
  • 4
  • 4
8 Comments
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
ID: 39223523
How are you connecting to the database?

Not sure if CR 2011 supports 64-bit or not.

mlmcc
0
 

Author Comment

by:byd2k
ID: 39224265
I'm connecting to the database using Oracle.  I was thinking that the 64 bit version wasn't compatible so I installed 32 bit.  Is there a log or anything I can look at on the server to show more detail?

Thanks!
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 39224591
Did you install the Oracle database dirvers?
 
You can look at the system logs.

mlmcc
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

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.

 

Author Comment

by:byd2k
ID: 39225662
In regards to the Oracle driver, I did install Oracle 11g on the server.  Would these drivers be a separate install?  I looked in the ODBC settings and I did see an Oracle 11g 32 bit driver, however online I noticed some admins are stating to install the 64 bit driver as well.
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 39225916
DO  you use ODBC to connect to the reports?

Did you build the ODBC connection?

mlmcc
0
 

Author Comment

by:byd2k
ID: 39226129
No.  From my last server configuration...  I installed CRS or just regular Crystal Reports and then the Oracle software.  Setup the tnsnames.ora and it worked from there.  Did I miss a step?
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 39226268
We use ODBC connections so we have to set those up but if you are using a native driver that is available then that should work unless the install of Crystal doesn't install the Oracle native clients by default.

mlmcc
0
 

Author Closing Comment

by:byd2k
ID: 39257621
Thanks for your help.  I rebuilt a new server and thanks to VMware, I was able to try each step until I ended up getting things right.  

So I:
Installed Windows 2008 64 bit server
Installed 32 bit version of Oracle - Ran tnsping, and made sure everything connected as expected
Installed Crystal Reports Writer - Thanks for other admins posting this tip.  Ran a report and ensured that data appeared
Installed 64 bit version of Oracle - Had to add the database name into NetManager for the 2nd time, and ran tnsping, etc
Installed CR Server

Of course I made the mistake of using a password with a punctuation mark in CR Server.  
Thanks again to VMware Snapshots!
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

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…
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…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

679 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