Error: The information from the database could not be loaded..

[cadelrey]

We have a project that works perfectly on the development machine.

On the server it returns the error:

Servidor: 00.00.00.000; Sesion: vial4jawru4vdjdydx5; Usuario: 99999999R; Empresa: 1; 999347; Pagina: DeclaracionController.cs; Metodo:Previsualizar); Error: Error en el archivo Responsable 1420_15184_{8C206F51-F7F2-472A-869C-7A7C4F333754}.rpt:

No se pudo cargar la información de la base de datos.; Excepción:System.Runtime.InteropServices.COMException (0x800002CD): Error en el archivo Responsable 1420_15184_{8C206F51-F7F2-472A-869C-7A7C4F333754}.rpt:

No se pudo cargar la información de la base de datos.

at CrystalDecisions.ReportAppServer.Controllers.DatabaseControllerClass.ReplaceConnection(Object oldConnection, Object newConnection, Object parameterFields, Object crDBOptionUseDefault)

at CrystalDecisions.CrystalReports.Engine.Table.SetDataSource(Object val, Type type)

at CrystalDecisions.CrystalReports.Engine.ReportDocument.SetDataSourceInternal(Object val, Type type); Traza: at CrystalDecisions.ReportAppServer.ConvertDotNetToErom.ThrowDotNetException(Exception e)

at CrystalDecisions.CrystalReports.Engine.ReportDocument.SetDataSourceInternal(Object val, Type type)

at CrystalDecisions.CrystalReports.Engine.ReportDocument.SetDataSource(DataSet dataSet)

at MvcCosmet.Controllers.DeclaracionController.PrevisualizarDeclaracion(String previo) in D:\Proyecto\Vs2019\Responsable\Controllers\VisualizarController.cs:line 24410

We use visual studio 2019

CR Version:

CR Runtime Version:

We have the same versions on the server.

The dll's that are not loaded in the running CR installation have been loaded on the server, in some chats.

But it doesn't work.

[DonWilliams · Accepted solution]

OK, need more details.

What Database are you reporting off of?

32 or 64 bit client?

App set to 32 or 64 bit?

ODBC or OLE or ????

Does the connection work in CR 2020?

What did ProcessMonitor show where it's throwing the error?

When viewing without setting log on info in code, when you hit the refresh button does it prompt for log on info, and are all log on info lines available to enter info?

Any subreports and are you specifically setting logon info for each subreport?

Is the data source based on Tables or stored procedure etc.?

Try enabling CR's database logging component on the server and see what it catches:

Userapps.support.sap.com

https://userapps.support.sap.com/sap/support/knowledge/en/1603398

1603398 - How to trace data source connections in Crystal Re...

How to perform a database trace in Crystal Reports? How to trace what's happening when refreshing a report in Crystal Reports? How to use crlogger to ...

[cadelrey · Accepted solution]

We have managed to solve the error!

The data source is an XML.

The target platform of the application is "Any CPU"

The solution was to put the application's target platform "x86"

and also change the pool of the application server: Enable 32-Bit applications to true

and works!

[cadelrey]

We have checked everything you told us in the response and it still does not work.

thank you very much

[DonWilliams]

CR for VS does NOT install the Database Client so it must be installed and configured previous to running reports.

Easiest way is view the report, if you see any info other than the password missing it indicates CR can't find the client used in the Report.

A good way to see what is missing is use Fiddler for WEB App's and ProcessMonitor for Desktop app's.

Search the logs for errors, missing dll's etc.

Also, CR for VS is configured for your application platform, so if it's a WEB app be sure to set the AnyCPU to 64 bit and the AppPool to 64 bit as well.

For Desktop app's you must set AnyCPU to x64.

Also requires 32 or 64 bit DB Client to be installed to match your app's platform.