Dynamic Report - Access denied error

[Koren]

I am working on a report that is creating a table dynamically in the details section.  Everything is good up to 39 columns and then I get the following error.  This particular run of the report only has seven records so it doesn't seem like it would be too large.  It worked if I did not use a table but just put textboxes in the detail section but the excel download was too jumbled. 

Is there a limit to the number of columns in a table?  Is this something else?  Any help appreciated.

Access to the path 'C:\Documents and Settings\xxx\ASPNET\LOCALS~1\Temp\9a48e4f88d36442381c16e503333fcdc' is denied.
   at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
   at System.IO.Directory.InternalCreateDirectory(String fullPath, String path, DirectorySecurity dirSecurity)
   at System.IO.Directory.CreateDirectory(String path, DirectorySecurity directorySecurity)
   at Telerik.Reporting.Cache.File.FileCache.EnsureDirectoryCreated()
   at Telerik.Reporting.Cache.File.FileCache.SetValue(String key, Byte[] value)
   at Telerik.Reporting.Cache.SmartCache.SetValue(String key, Byte[] value)
   at Telerik.ReportViewer.WebForms.StreamManager.StreamReady(RenderStream renderStream)
   at Telerik.ReportViewer.WebForms.RenderStream.Finish()
   at Telerik.Reporting.Html5Rendering.Writers.Page.WritePageEndDocument()
   at Telerik.Reporting.Html5Rendering.Writers.Page.WriteEndPage()
   at Telerik.Reporting.Html5Rendering.Writers.Report.WriteEndPage()
   at Telerik.Reporting.BaseRendering.PageHandler.Telerik.Reporting.Paging.IPageHandler.EndPage()
   at Telerik.Reporting.Paging.PageCompositionBase.SendPhysicalPages()
   at Telerik.Reporting.Paging.PageCompositionBase.OutputPage()
   at Telerik.Reporting.Paging.PageCompositionBase.CreatePages()
   at Telerik.Reporting.Paging.PagerBase.Telerik.Reporting.Paging.IPager.CreatePages(IPageHandler handler, Report report)
   at Telerik.Reporting.BaseRendering.RenderingExtensionBase.Render(Report report, Hashtable renderingContext, Hashtable deviceInfo, CreateStream createStreamCallback, EvaluateHeaderFooterExpressions evalHeaderFooterCallback)
   at Telerik.Reporting.Processing.ReportProcessor.RenderCore(ExtensionInfo extensionInfo, IList`1 reports, Hashtable deviceInfo, IRenderingContext renderingContext, CreateStream createStreamCallback)
   at Telerik.Reporting.Processing.ReportProcessor.RenderCore(String format, IList`1 reports, Hashtable deviceInfo, IRenderingContext renderingContext, CreateStream createStreamCallback)
   at Telerik.ReportViewer.WebForms.ReportPageOperation.RenderReport(String format, IList`1 processingReports, Hashtable deviceInfo, IRenderingContext renderingContext)
   at Telerik.ReportViewer.WebForms.ReportRenderOperation.PerformOperationOverride()
   at Telerik.ReportViewer.WebForms.ReportPageOperation.PerformOperationOverride()
   at Telerik.ReportViewer.WebForms.HandlerOperation.PerformOperation(HttpContext context, ICacheManager cacheManager)
   at Telerik.ReportViewer.WebForms.BasicHandler.ProcessRequest(HttpContext context)
   at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
   at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

[Stef]

Hello Koren,

The issue does not seem to be related to your dynamic report creation but rather to some write permissions required from your caching settings. Please try giving full access permissions to your application or change your cache settings.

If none of the above helps, let us know which Telerik Reporting version is used and post your configuration settings.

Regards,
Stef
the Telerik team

[Koren]

I am running this report on my local machine still and don't have any cache settings set up yet.  What permissions would be missing?

If I change it to a file cache, can I set the file to a virtual directory in the web site?  This project is included in a web site that is load balanced on multiple servers so I want to make sure it will work in production.

thanks, Koren

[Koren]

Has anyone else run into limits on the dynamic tables?  I know it isn't too much data as I only have seven records in my test dataview.  Any other ideas on how to build a dynamic report that exports well into Excel?

thanks!

[Stef]

Hello Koren,

Try to set the cache provider for the reporting engine to Memory provider and let us know whether the problem still persists. The default cache provider (Auto) caches the larger pages to the local user's temp folder but for some reason the web application process does not have enough permissions to access it. Additionally you may try with the File cache provider and set a specific location (BasePath) for the cached files.

Hope this helps.

Regards,
Stef
the Telerik team

[Bohdan]

Hello!

I'm experiencing the same issue with the access to the cache files during report generation using HTML web viewer. Here is the error message:

Internal Server Error:
An error has occurred.
Access to the path 'C:\Windows\TEMP\ReportService\b6145f5e\8.2.14.1022\Clients\value.dat' is denied.

As soon as existing folder ("Clients") is deleted issue doesn't reproduce. Actually new folder and file is created. So I assume there might be some issue with the file content reading.

I've put this file (...Clients\value.dat) to another machine then the issue starts to reproduce on that machine.

Could you please investigate it on your side (I can provide you with the file).

 Thank you in advance.

[Stef]

Hello Bohdan,

Based on the error message you are using the HTML5 viewer and Reporting REST service, Telerik Reporting version Q3 2014. The issue is related to synchronization of the access to the cache storage, where the solutions are:

1. Switch to an IStorage implementation;
2. Upgrade the application to use the latest available Telerik Reporting Q2 2015 v9.1.15.702.

I hope the provided information is helpful.

Regards,
Stef
Telerik

[Jans]

This solution worked for me :-)