CR 2010 Report using "File System Data" as source fails in production

[thomas_johnson]

Hello, I've recently upgraded my website from VS 2008 with full CR 2008 to VS 2010 using CR 2010 SP1 runtime (x32). Everything went fine except for one report that uses as a source the "file system data". It points to a share on a samba drive and it worked great before the upgrade. After upgrading my development box the report runs fine, but when I deployed it, it fails with the message:

Failed to load database information. Error in File {report name} {D5D84E7F-54DB-4BCA-B3C3-0A169CDC36D7}.rpt: Failed to load database information.

I made sure the websiteu2019s Application Pool identity was set to use credentials of a user who has access to the share.

The data source has the following properties:

Database DLL: crbd_filesystem.dll

File Mask: .

Include Empty Directories: False

Max Number of Subdirectory Levels: -1

Starting Directory:
{FreeBSD server name}\{share name}

This report uses a sub-report which has the same source. This report works fine from (full) CR 2008 and from the designer inside of VS 2010 works too. I can run it on my development box (in release and debug modes) which is Windows 7 (x64) using IIS 7.

In production, we donu2019t include the runtime in our application deployment, since we run multiple sites and do updates frequently, so we pre-install (one time) the runtime separately on the server. We installed the CR 2010 SP1 x32 runtime on our test and development boxes which both are Windows 2003 with IIS6 and made sure they are setup to use .Net 4 and have the Application Pool identity setup to have access to the share. All my other reports which use ODBC work fine. Just this one report doesnu2019t and Iu2019m at a loss on how to even begin troubleshooting this.

Is CR 2010 still capable of using u201Cfile system datau201D as a source? I couldnu2019t find anything on u201Cfile system datau201D with CR 2010. Though I have seen under Other Sources, it still exist when I created a new report, just to try it out.

[former_member183750 · Accepted solution]

Looks like you've found a bug with the CRVS2010 runtime. I looked for the crbd_filesystem.dll in the CRVS2010 install directory (C:\Program Files (x86)\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Common\SAP BusinessObjects Enterprise XI 4.0\win32_x86) and it is there. I then opened up the 32 bit MSI and MSM with the MS Orca utility to see if the file is included and it is not.

Two things we can do:

1) Add the crdb_filesystem.dll to your install and make sure it installs to the above directory on the runtime computer

2) I will created a fix request for the issue, however next fix will be Service Pack 2 (ETA, sometime after October) and I doubt this will make it there. So we'd be looking at SP 3 - if there will be one (ETA would be in 2012).

Ludek

Follow us on Twitter http://twitter.com/SAPCRNetSup

Got Enhancement ideas? Try the [SAP Idea Place|https://ideas.sap.com/community/products_and_solutions/crystalreports]

[former_member11696 · Accepted solution]

And an FYI for those seeing this and wondering why it doesn't work in 64 bit. We do not have a 64 bit version of file system dll.

This info is from our DB platforms doc for CR for VS 2010:

Don

[thomas_johnson · Accepted solution]

That was the solution. For me, I copied from my development box (which had the dll's as part of the add-in for VS 2010) the following two dll's to the directory you mentioned:

crdb_FileSystem.dll and crdb_FileSystem_res_en.dll

Then I tried to run regsr32 on crdb_FileSystem.dll. It produced an error, so Iu2019m not sure it mattered.

Then I restarted the application pool for my website and it worked. Thank you.

[former_member11696 · Accepted solution]

Hi Thomas,

Correct, our DB driver do not require registering.

Thanks again

Don