Solved

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

Posted on 2013-06-05
8
2,537 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
 

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
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 
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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

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…
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…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

708 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now