DatabaseCacheConfigurator.exe and PostgreSQL target backend

[Bryan]

Greetings! 

I'm trying to run the DatabaseCacheConfigurator.exe, select a PostgreSQL target backend, and create schema. I first ran into an issue where the Npgsql database provider was "not installed properly". I seem to have resolved that by installing what appears to be the last version of the Npgsql MSI (GAC) provider version 4.1.8.

This gets me past the not "installed properly" message, but now I receive the following:

Database driver installation problem: Cannot use factory for PostgreSql. Could not load type 'NpgsqlTypes.NpgsqlTimeZone' from assembly 'Npgsql, version=4.1.8.0.....

The full stack trace is in the attached screenshot.

Any suggestions?

Many Thanks!
Bryan

 

[Dimitar]

Hello Bryan,

Thank you for the screenshot.

Indeed, it seems that the NpgsqlTimeZone type is not present with the newer versions of Npgsql. I looked through the different Npgsql versions and, from what I can tell, it is present in versions 2 and earlier (for example Npgsql 2.2.7). 

That said, the "Configure engine/viewers cache database" option is only for desktop report viewers with an embedded reporting engine and is not mandatory to configure.

Do you use one of the REST Service-based report viewers, such as the HTML5 Report Viewer? If that is the case, are you looking to configure the Storage of the Reporting REST Service?

This can be done through the "Configure REST service storage database" option and it requires MSSQL Server.

Regards,
Dimitar
Progress Telerik