This is a migrated thread and some comments may be shown as answers.

Dynamic Report - Access denied error

7 Answers 193 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Koren
Top achievements
Rank 1
Koren asked on 20 Apr 2013, 02:35 AM
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)

7 Answers, 1 is accepted

Sort by
0
Stef
Telerik team
answered on 24 Apr 2013, 02:46 PM
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

Have you tried the new visualization options in Telerik Reporting Q1 2013? You can get them from your account.

0
Koren
Top achievements
Rank 1
answered on 24 Apr 2013, 04:01 PM
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
0
Koren
Top achievements
Rank 1
answered on 26 Apr 2013, 06:33 PM
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!
0
Stef
Telerik team
answered on 29 Apr 2013, 03:40 PM
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

Have you tried the new visualization options in Telerik Reporting Q1 2013? You can get them from your account.

0
Bohdan
Top achievements
Rank 1
answered on 20 Jul 2015, 08:43 AM

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.

0
Stef
Telerik team
answered on 20 Jul 2015, 02:54 PM
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
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
0
Jans
Top achievements
Rank 1
answered on 01 Nov 2017, 05:00 PM
This solution worked for me :-)
Tags
General Discussions
Asked by
Koren
Top achievements
Rank 1
Answers by
Stef
Telerik team
Koren
Top achievements
Rank 1
Bohdan
Top achievements
Rank 1
Jans
Top achievements
Rank 1
Share this question
or