Failed to load database error - sp2 runtime

[Former Member]

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

[former_member183750 · Accepted solution]

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

[Former Member]

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

[former_member183750]

Please stop spamming all kinds of threads. This is the 3rd thread you have posted the same question. In none of your posts do you actually give the error. Post your query - with as much info as possible and wait of an answer. Spamming is certainly not going to improve the speed of resolution...

Ludek

[Former Member]

First of all sorry I am Spanish and I do not know much English, I try my best to translate.

He told me that do not start multiple threads, but all responded to close as the only solution to wait.

This issue is linked to other incidents in SP2

I do not know if you understand we're at an impasse, can not do installations with SP1 because there is no certificate and with can not do installations with SP2 because they all error reporting date type fields.

I have read in another thread where you answer that will be fixed in early 2010 in the SP3, so if you do not understand. There are also questions as to Crystal 2008 was supposed to operate in 64bit, however does not work and we need to compile applications in 32bit and we need to configure Internet Information Services (IIS) to run in 32 bits, this would not understand.

Now you can understand that we try to keep the issue alive while you give the thread how to respond, but not solved.

[former_member183750]

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

[Former Member]

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

[Former Member]

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

[former_member183750]

CRRuntime_12_2_mlb.msi should be all you need. CRDB_XML.DLL missing is most certainly bad. CRDB_XML_RES_EN.DL is just a resource dll so I would not worry about is. And I'll have to check JVMMANAGER.DLL and LOG_XN_SYSTEM.DLL. Let me look at the msi in Orca and see if these are indeed missing from the install.

Ludek

[former_member183750]

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

[Former Member]

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

[Former Member]

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

[former_member183750]

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

😎 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