Urgent: Telerik Report Cache Difficulty On Migrating From SQL Server To PostgreSQL DB

[Graham]

This is VERY URGENT: a business database migration from SQL Server to PostgreSQL, due to happen this weekend, is dependant on it.  I'll ask the question in 2 parts:

1. We have a SQL Server database called TelerikReportingCache, containing tables tr_AppLock, tr_Object, tr_Set and tr_String, which is used by Telerik Reporting. I have been told that this database cannot exist on a PostgreSQL server. Can you confirm that this is correct, please?

2. We have been told to use a file for the cache instead of a database. However, we have many users, and the file gets locked, causing an error message in reports - see image in attached file. If we cannot use a file as a cache, then what other alternatives do we have?

 

Error Message Text: Error creating report instance (Report = 'ConnectReports. Finance.CustomerInvoiceSummary, ConnectReports"). An error has occurred. The process cannot access the file '\\172.21.23.75\Telerik ReportingCache\ConnectReports 16.0.22.225\Is\A\value.dat' because it is being used by another process.

 

[Lance | Senior Manager Technical Support]

Hi Graham,

This is one of the reasons we discourage using File storage for production use in a high multi-user environment when the REST service can't distinguish between user sessions and attempts to use the same cache for different users.

I see you've also opened a priority Support ticket for the same question, the Reporting team will follow up with you in more detail about your specific situation's needs.

In the meantime, I wanted to at least provide a general public answer in the forums, here are the relevant documentation articles in the meantime:

• The Communication between the Viewer and the REST Service Explained - Telerik Reporting
• REST Service Storage at a Glance - Telerik Reporting
• Configuring an MSSQL Database Storage - Telerik Reporting
• Configuring a Redis Storage - Telerik Reporting

Regards,
Lance | Senior Manager Technical Support
Progress Telerik