Error in Print General Ledger Report for specific Fiscal Period

Epicor ERP 10
, ,
1

When click the preview of the report the system monitor show an error like below. However, if i change the Fiscal Period to other, it works well. What is the problem of the report?

Program Ice.Services.Lib.RunTask raised an unexpected exception with the following message: RunTask: System.Web.Services.Protocols.SoapException: Server was unable to process request. —> System.UnauthorizedAccessException: Access to the path ‘D:\Program Files\Microsoft SQL Server\MSRS12.MSSQLSERVER\Reporting Services\RSTempFiles\RSFile_ffa8a962-0a77-48ff-ac9b-1ffd25d3c1d6’ is denied.
at Microsoft.ReportingServices.Library.StreamFactoryBase.CloseAllStreams(IEnumerable1 streams) at Microsoft.ReportingServices.Library.StreamFactoryBase.CloseRegisteredStreams() at Microsoft.ReportingServices.Library.StreamFactoryBase.Dispose() at Microsoft.ReportingServices.Library.WorkspaceManager1.Pop()
at Microsoft.ReportingServices.Library.ReportExecution2005Impl.Render(String Format, String DeviceInfo, PageCountMode pageCountMode, Byte[]& Result, String& Extension, String& MimeType, String& Encoding, Warning[]& Warnings, String[]& StreamIds)
at Microsoft.ReportingServices.WebServer.ReportExecutionService.Render(String Format, String DeviceInfo, Byte[]& Result, String& Extension, String& MimeType, String& Encoding, Warning[]& Warnings, String[]& StreamIds)
— End of inner exception stack trace —
Stack Trace:
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at Ice.Core.SsrsReportService.ReportExecutionService.Render(String Format, String DeviceInfo, String& Extension, String& MimeType, String& Encoding, Warning[]& Warnings, String[]& StreamIds) in C:_Releases\ICE\ICE3.2.200.5\Source\Server\Internal\Lib\TaskLib\Web References\SsrsReportService\Reference.cs:line 633
at Ice.Core.SsrsReporting.SsrsRendererBase.Render(SsrsRenderInformationBase renderInformation) in C:_Releases\ICE\ICE3.2.200.5\Source\Server\Internal\Lib\TaskLib\SsrsReporting\SsrsRendererBase.cs:line 142
at Ice.Core.SsrsReporting.SsrsRendererBase.<>c__DisplayClass12_0.b__0() in C:_Releases\ICE\ICE3.2.200.5\Source\Server\Internal\Lib\TaskLib\SsrsReporting\SsrsRendererBase.cs:line 87
at Epicor.Hosting.Trace.TraceHandle.TimeAction(Action actionToTime) in C:_Releases\ICE\ICE3.2.200.5\Source\Framework\Epicor.System\Hosting\Trace\TraceHandle.cs:line 92
at Epicor.Hosting.Trace.TraceHandle.AddTimedIfEnabled(String traceFlag, Action actionToTime, Func2 messageBuilder) in C:\_Releases\ICE\ICE3.2.200.5\Source\Framework\Epicor.System\Hosting\Trace\TraceHandle.cs:line 39 at Ice.Core.SsrsReporting.SsrsRendererBase.TraceReportRendered(String printProgram, String ssrsRenderFormat, Func1 timedAction) in C:_Releases\ICE\ICE3.2.200.5\Source\Server\Internal\Lib\TaskLib\SsrsReporting\SsrsRendererBase.cs:line 95
at Ice.Core.SsrsReporting.ReportProcessorBase.RenderReportForPreviewOrGenerate(RenderedSsrsReport renderedReport) in C:_Releases\ICE\ICE3.2.200.5\Source\Server\Internal\Lib\TaskLib\SsrsReporting\ReportProcessorBase.cs:line 258
at Ice.Core.SsrsReporting.ReportProcessorBase.ProcessReportPart(String reportLocation) in C:_Releases\ICE\ICE3.2.200.5\Source\Server\Internal\Lib\TaskLib\SsrsReporting\ReportProcessorBase.cs:line 152
at Ice.Core.SsrsReporting.StandardReportProcessor.ProcessReportParts() in C:_Releases\ICE\ICE3.2.200.5\Source\Server\Internal\Lib\TaskLib\SsrsReporting\StandardReportProcessor.cs:line 31
at Ice.Core.RoutingAndBreaking.ReportPersister.Persist(ReportInstanceInformation reportInstance, Func2 reportsRenderer, Action1 fillSysRptLstRow, Action2 processReport) in C:\_Releases\ICE\ICE3.2.200.5\Source\Server\Internal\Lib\TaskLib\RoutingAndBreaking\ReportPersister.cs:line 50 at Ice.Core.RptBase.ReportSsrsDatabaseBuilder.RenderUnroutedSsrsReport() in C:\_Releases\ICE\ICE3.2.200.5\Source\Server\Internal\Lib\TaskLib\RptBase\ReportSsrsDatabaseBuilder.cs:line 301 at Ice.Core.RptBase.ReportSsrsDatabaseBuilder.RunSsrsReportIfEnabled() in C:\_Releases\ICE\ICE3.2.200.5\Source\Server\Internal\Lib\TaskLib\RptBase\ReportSsrsDatabaseBuilder.cs:line 226 at Ice.Core.RptBase.ReportSsrsDatabaseBuilder.ProcessReportWithDataInPlace(Func2 executeCommand, Func`2 executeReader, SqlObjectsCreated sqlObjectsCreated) in C:_Releases\ICE\ICE3.2.200.5\Source\Server\Internal\Lib\TaskLib\RptBase\ReportSsrsDatabaseBuilder.cs:line 111
at Ice.Core.RptBase.ReportDatabaseBuilder.XMLClose() in C:_Releases\ICE\ICE3.2.200.5\Source\Server\Internal\Lib\TaskLib\RptBase\ReportDatabaseBuilder.cs:line 93
at Erp.Internal.GL.GeneralLedger.RunProcess(Int64 instanceTaskNum, String outputFileName) in c:_Releases\ERP\RL10.2.200.0\Source\Server\Internal\GL\GeneralLedger\GeneralLedger.cs:line 482
at Ice.Hosting.TaskCaller.InnerExecuteTask(IceDataContext newContext) in C:_Releases\ICE\RL3.2.200.0\Source\Framework\Epicor.Ice\Hosting\TaskCaller\TaskCaller.cs:line 98
at Ice.Hosting.TaskCaller.ExecuteTask() in C:_Releases\ICE\RL3.2.200.0\Source\Framework\Epicor.Ice\Hosting\TaskCaller\TaskCaller.cs:line 57
at Ice.Lib.RunTask.BpmFriendlyTaskLauncher.Run(String sessionIdPrefix, IceContext db, Action taskRunner) in C:_Releases\ICE\RL3.2.200.0\Source\Server\Services\Lib\RunTask\BpmFriendlyTaskLauncher.cs:line 63
at Ice.Services.Lib.RunTaskSvc.InnerRunTask(Int64 ipTaskNum, Boolean suppressTransaction) in C:_Releases\ICE\RL3.2.200.0\Source\Server\Services\Lib\RunTask\RunTask.cs:line 547

2

Is the report style’s “output” set to Database?

3

yes

4

Here is the actual error. Ensure that SQL has permissions to that folder.

5

i have already granted full right for everyone

6

I am sure that it is related to the report size too large problem since if i print a month with little data. It works well

7

If that is the case, you may want to ensure that unnecessary fields are excluded.

8

But it is the system default GL Report. I have not custom the report.

9

I was basing my assumption from this statement. If you feel it is too large, you can customize the report to minimize the data set.

However, this error says it is a permissions issue:

10

I have check that it is just 32 pages. there are few system reports like this error. Therefore, i need a solution to allow me to print it.

We have already tried to set the folder with full control for everyone. If it is permission problem, it should be solved. Also, i print the same report with other Fiscal Period is no problem(Since there is few data in June) .

11

If this is only happening when running large reports, I would offer that a Support call should be started.
Then, in the process of waiting for support, I would create a copy of the report and try to limit the number of fields returned in the RDD.

12

I tried to call Epicor to solve the problem. Thanks for help