Solved

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

Posted on 2013-06-05
8
2,781 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
[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
  • 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: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering 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

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

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
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…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

752 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