Skip to Content
author's profile photo Former Member
Former Member

Failed to load database error - sp2 runtime

Hi All,

I have an ASP.Net application that uses the CRViewer control to display reports that get their data from web services located on the same machine. The reports run on my development machine (XP) which has the full SP2 version of crystal installed (upgraded from V1 install). When deploying just the SP2 runtime redistributable to a Win2003 server I get the "failed to load database error. Error in file MyReport {guid ...}.rpt" error message. If I install the full version on the deployment machine (V1 and then SP2) on top of the SP2 redist the report runs as expected. The same issue happens for SP1 runtime redist as it does for SP2. It seems to me that the full install is adding something needed that is missing from the runtime redist that is causing the problem.

The VS2008 project has the following references which are all located in the GAC on the deployment machine:

C:\Program Files\Business Objects\Common\4.0\managed\CystalDecisions.Enterprise.Framework.dll - version 12.0.1100.0

C:\Program Files\Business Objects\Common\4.0\managed\CystalDecisions.Enterprise.InfoStore.dll - version 12.0.1100.0

C:\Program Files\Business Objects\Common\4.0\managed\dotnet2\CystalDecisions.CystalReports.Engine.dll - version 12.0.2000.0

C:\Program Files\Business Objects\Common\4.0\managed\dotnet2\CystalDecisions.ReportSource.dll - version 12.0.2000.0

C:\Program Files\Business Objects\Common\4.0\managed\dotnet2\CystalDecisions.Shared.dll - version 12.0.2000.0

C:\Program Files\Business Objects\Common\4.0\managed\dotnet2\CystalDecisions.Web.dll - version 12.0.2000.0

I'd really appreciate some help in getting CR deployed correctly. The project is getting close to GA and this is a critical problem for us. BTW the runtime is being deployed using a silent install with the keycode passed as an argument. I've also tried directly installing the runtime with the same results.

Regards,

Jim

Add a comment
10|10000 characters needed characters exceeded

Related questions

6 Answers

  • Best Answer
    Posted on Aug 25, 2009 at 03:08 PM

    I'm not sure what the issue is, but a few troubleshooting ideas:

    1) Use the Modules utility and compare the DLLs loading on a computer that has the full CR install and the one that only has the runtime. Modules is here:

    https://smpdl.sap-ag.de/~sapidp/012002523100006252802008E/modules.zip

    Run modules on both the working computer and non working computer (on the non working system, leave the error on the screen when running modules) then compare the two logs. Use Modules (Modules menu | differences)

    2) On the non working computer, use Process Monitor to see where the app stops. Look for messages such as File not found, Access Denied, etc. Process Monitor is here:

    http://technet.microsoft.com/en-ca/sysinternals/bb896645.aspx

    Ludek

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 25, 2009 at 03:22 PM

    Hi Ludek,

    Thanks for the reply. I'll try the modules suggestion although I don't know what how to use it yet.

    The web application doesn't stop - the viewer control simply prints the load failure message on the page. Do you mean a Crystal component stopping? BTW, there is nothing in the event logs and nothing in any crystal logs that I can find to point to what is happening. I am catching exceptions on the Load() method of the ReportDocument object and logging them but there aren't any showing up. I'm also handling un-handled exceptions in the web app and nothing shows up there either.

    One thing I've seen mentioned while looking for causes of this type of problem is access rights to the \windows\temp folder. I have assigned modify rights for both NETWORK SERVICE and ASPNET accounts as suggested in a number of forum posts. The folders in the web app also have modify rights for those accounts including the Reports folder which is where the report files are located. The path for the Load() method is Server.MapPath( @"~\Reports\" + rptFileName + ".rpt" ).

    Regards,

    Jim

    Add a comment
    10|10000 characters needed characters exceeded

    • Re. modules. Use these steps:

      1) Run the app on a box that works. Process a report. Leave the app running.

      2) Start Modules, and go to the File menu

      3) Select New List -> Memory modules

      4) Save as works.mdl

      5) Run the app on a box that does not work. Attempt to process a report. Leave the app running.

      6) Start Modules, and go to the File menu

      7) Select New List -> Memory modules

      8) Save as bad.mdl

      9) Open both mdl files in Modules

      10) Go to the Module menu and select "Differences"

      See what Modules tells you.

      I am not so sure that this is a permissions issue as installing the CR designer, should not grant permissions in and of it's self. I suspect it's either a missing file or a missing registry entry. Process Monitor should be very good for missing reg entries. (BTW.; make sure you filter Process Monitor for your process as it's a beast as far as huge log files are concerned.)

      Ludek

  • author's profile photo Former Member
    Former Member
    Posted on Aug 25, 2009 at 04:48 PM

    Hi Ludek,

    I ran the application, got the error, ran modules and saved the file. Then I installed V1, ran the application got the report and again ran modules. I don't see a way to attach the files but here's what the differences were:

    Different:

    usp10.dll

    Only in error file:

    crheapalloc.dll

    crtslv.dll

    implode.dll

    rptcontrollers_res_en.dll

    setupapi.dll

    sscsdk80.dll

    Only in good file:

    app_web_defaultwsdlhelpgenerator.aspx.cdcab7d2.u9c5wkhv.dll

    crdb_xml.dll

    crdb_xml_res_en.dll

    datadefmodel_res_en.dll

    jvmmanager.dll

    log_xn_system.dll

    mlang.dll

    msxml4.dll

    querybuilder.dll

    querybuilder_res_en.dll

    urlmon.dll

    wininet.dll

    Since the reports use a web service as a datasource I would think the xml related dll's that are there might be the issue. I'm going to remove everything and re-install just the SP2 runtime to see if the xml dll's are in the win32_x86 folder.

    Thanks,

    Jim

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 25, 2009 at 05:27 PM

    Hi Ludek,

    I confirmed that the SP2 runtime redist does not install the files CRDB_XML.DLL, CRDB_XML_RES_EN.DL, JVMMANAGER.DLL and LOG_XN_SYSTEM.DLL while the V1 install does.

    To install the SP2 runtime I am only installing CRRuntime_12_2_mlb.msi. Is that all I need to install for the runtime files? Or is the SP2 runtime like other CR installs that require a sequence of installation files (e.g V1 before SP2)?

    Regards,

    Jim

    Add a comment
    10|10000 characters needed characters exceeded

    • OK. Got an answer, but probably not one that is too good. The files missing from the msi are missing by design. Reason for this is that the crdb_xml.dll uses Java runtime and thus in order for it to be functional upon an msi install, the msi would have to ensure that the Java framework is also installed, adding size and complexity. I have a blog [How to deploy Crystal Reports 2008 runtime for .NET when the report is connecting to XML files|https://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/13732] [original link is broken] [original link is broken] [original link is broken]; that discusses the deployment of crdb_xml.dll in detail. So, unfortunately the short of it is that you have two options to do the install (none of which is particularly attractive - not to me anyhow):

      1) Create your own msi using the CR 200 8 msm and then follow the blog above re. configuring the crdb_xml.dll on that deployed box

      2) Use the Crystal Reports install CD to get the runtime on that box. Once the install is done, remove the crw32.exe and this should keep us within the licensing boundaries.

      Ludek

  • author's profile photo Former Member
    Former Member
    Posted on Aug 27, 2009 at 10:56 AM

    Hi Ludek,

    Thanks for the answer! I'm really surprised that the runtime install does not include full support for the product. There is no reason it couldn't just fail if the pre-requisites are not in place if the fact that it requires java is known up front. If it is installed normally it could just pop up a message box to the user. Anyway I'll take a look at the blog and decide how to proceed. Actually I originally tried to use the merge modules with my setup program but couldn't get them to work so I went with the MSI which was actually better for my app which only takes a few seconds to install by itself. Also it would better for product updates down the road.

    Regards,

    Jim

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 06, 2009 at 04:00 PM

    In our company we have the same problem with CR2008 SP2, but we connected the report with XML (Dataset) and if it works with SP1. The runtime of CR2008 SP2 causes an error in all reports with date fields

    Add a comment
    10|10000 characters needed characters exceeded

    • Situation understood - I think. Unfortunately, your only option at this time is to stay with CR 2008 SP 1 and not use click once deployment. The expired certificate issue is known and will not be addressed. The date time - if you are using .NET datasets(which I am not sure of) as I attempted to point out to you in one of the threads, is a tracked issue but it may be 6+ months before a fix is posted. So the choices are;

      1) Wait up 6 months for a fix

      2) Use CR 2008 SP 1, but do not use click once deployment

      3) Do not use .NET datasets

      I understand that none of the above are ideal solutions and probably (2) is the best of the lot.

      Ludek

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.