Solved

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

Posted on 2013-06-05
8
2,647 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
Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

 

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

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

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…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.

776 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