Cachefiles when your memory cache provider

[Claudia]

Hello,

I use Telerik Reporting to auto create PDF-files and I also use the Html5 user.

During loading the report, thousands of files and folders were created in Path C:\WINDOWS\Temp\Html5App\12.0.18.227\...  although I set cache provider to "Memory" in app.config.

On the systems of my customer, the infrastructure occurs problems on these amount of files. Is it possible to disable the creation of these files and folders?

 

Best regards

Patrick

[Todor]

Hello Patrick,

Please, note that the files stored in a folder like "...\Html5App\12.0.18.227\..." are part of the REST Service Storage - "Html5App" is the default HostAppId of the REST Service application. You may change the storage type - for example to MS SQL database Storage or Redis Storage to avoid the problems related to the currently used File Storage.

If I understood correctly, you have set the cache provider according to Configuring Cache article to Memory. Please, note that this cache is relevant to the Reporting engine only and states where the engine to keep large resources (i.e. those requiring large memory like images) while processing the reports. This cache setting is not related to the Telerik Reporting REST Service and the Html5App folder.

Please, test to change the REST Service Storage and let us know whether this has solved the problem.

Regards,
Todor
Progress Telerik

[Claudia]

Hi Todor,

sorry for my late answer. I was a bit busy the last weeks.

I am trying to get the database cache to work. I try to get it work with a sqlite database and the "Telerik Database Cache Configurator",

I created a sqlite database file and copied the connection string to cache configurator, but when I click "Create schema", I get an error "Database driver installation problem: Cannot use factory for SQLite. Database provider Advantage.Data.Provider.AdsFactory [...] not installed proberly.

I googled for this driver but I didn't find anything what to in this case.

I also can't find any information how to set the parameters (e.g. Backendname) to use sqlite.

Can you please help me to get this work?

 

Kind regards

Patrick

[Todor]

Hello Patrick,

From the exception, I assume that the database provider Advantage.Data.Provider.AdsFactory is not installed and cannot be found in the default place where it will be looked for. You need to either install it on the machine or use the approach described in the How to register SqlDataSource data providers without driver installation KB article.

Note that by configuring the Cache you will set up the cache used internally when rendering the documents. This will not change the REST Service storage. The latter is used for storing the generated report documents. This storage gets cleaned periodically based on the values of the ClientSessionTimeout and ReportSharingTimeout properties - check Cache Management.

If you need to avoid the creation of multiple files in REST File Storage, e.g. folder "C:\WINDOWS\Temp\Html5App\...", you need to use the database storage:

• How To: Configure MS Sql database storage
• How to: Use Redis storage

You may also implement your own IStorage to use an alternative database.

Regards,
Todor
Progress Telerik