You are viewing limited content. For full access, please sign in.

Discussion

Discussion

[Forms] Reports: Error occurred during download (Error 500) - Solution Inside

posted on November 1, 2020

Hey team, I figured since we spent the morning trying to work out why this happened we might as well post the solution that worked for us in case someone else happens to encounter this error.

On our production server we have a lot of reports saved and scheduled. These reports range from tables through to summary, and we have scheduled snapshots set up.

From time to time, and for no apparent or identifiable reason, the ability to generate reports on demand stops working. You'll see an error like this in the window that opens when you attempt to download the data:

 

It doesn't matter what options you select, XLSX, CSV, Include Choices etc - all of them fail.

We're trying to pin point if it is an issue with generating concurrent schedule reports for the exact same time every morning.. so we'll update this post if it keeps recurring.. but more importantly, the only way to fix this issue is to restart the Forms Routing Service.

Specifically, this is what you're looking for:

Right click this and select "Restart". It'll take a few seconds, but once it has completed, you'll be able to download reports again without issue.

For those of you with outsourced IT, you can find this service by logging in remotely to the Web Server where Laserfiche Forms is installed, clicking Start, typing Services, and opening the Services view.

You'll see the Laserfiche Forms Routing Service in the list of services (as shown above). Be careful only to restart that specific service to fix this issue.

Hope this helps others!

3 0
replied on November 1, 2020 Show version history

When you got "An error occurred during download" on the web page, what error did it logged in the event log?

We got several support cases recently reported with following internal error and we haven't figure out how to reproduce it yet:

Message: The username or password is incorrect. [LFF11-WrongUsernameOrPassword]


Server stack trace:
at System.ServiceModel.Channels.ServiceChannel.ThrowIfFaultUnderstood(Message reply, MessageFault fault, String action, MessageVersion version, FaultConverter faultConverter)
at System.ServiceModel.Channels.ServiceChannel.HandleReply(ProxyOperationRuntime operation, ProxyRpc& rpc)
at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout)
at System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(IMethodCallMessage methodCall, ProxyOperationRuntime operation)
at System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message)

Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
at FormsModel.SharedContracts.IFormExportService.ExportProcessData_Sync(ReportingExportParameters para)
at FormsModel.SharedContracts.FormExportServiceProxy.ExportProcessData(ReportingExportParameters para)
at E_Forms.Handlers.BPInstancesExport.ProcessRequest(HttpContext context)

0 0
replied on November 2, 2020 Show version history

Hey Xiuhong,

Actually, we had trouble finding an issue logged in the event viewer. That's what caused a lot of confusion, initially.

In the system log we saw this error triggered from time to time (not always) when we tried to export a report:
Log Name:      System
Source:        Microsoft-Windows-DistributedCOM
Date:          2/11/2020 9:26:58 AM
Event ID:      10016
Task Category: None
Level:         Error
Keywords:      Classic
User:          *DOMAIN-REMOVED*\lfiche
Computer:      *REMOVED*
Description:
The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID 
{2593F8B9-4EAF-457C-B68A-50F6B8EA6B54}
 and APPID 
{15C20B67-12E7-4BB6-92BB-7AFF07997402}
 to the user *DOMAIN-REMOVED*\lfiche SID (S-1-5-21-3194748003-3546792915-2289680884-10235) from address LocalHost (Using LRPC) running in the application container Unavailable SID (Unavailable). This security permission can be modified using the Component Services administrative tool.
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="Microsoft-Windows-DistributedCOM" Guid="{1B562E86-B7AA-4131-BADC-B6F3A001407E}" EventSourceName="DCOM" />
    <EventID Qualifiers="0">10016</EventID>
    <Version>0</Version>
    <Level>2</Level>
    <Task>0</Task>
    <Opcode>0</Opcode>
    <Keywords>0x8080000000000000</Keywords>
    <TimeCreated SystemTime="2020-11-01T20:26:58.214528300Z" />
    <EventRecordID>67550</EventRecordID>
    <Correlation />
    <Execution ProcessID="604" ThreadID="2252" />
    <Channel>System</Channel>
    <Computer>*removed*</Computer>
    <Security UserID="S-1-5-21-3194748003-3546792915-2289680884-10235" />
  </System>
  <EventData>
    <Data Name="param1">application-specific</Data>
    <Data Name="param2">Local</Data>
    <Data Name="param3">Activation</Data>
    <Data Name="param4">{2593F8B9-4EAF-457C-B68A-50F6B8EA6B54}</Data>
    <Data Name="param5">{15C20B67-12E7-4BB6-92BB-7AFF07997402}</Data>
    <Data Name="param6">*REMOVED*</Data>
    <Data Name="param7">lfiche</Data>
    <Data Name="param8">S-1-5-21-3194748003-3546792915-2289680884-10235</Data>
    <Data Name="param9">LocalHost (Using LRPC)</Data>
    <Data Name="param10">Unavailable</Data>
    <Data Name="param11">Unavailable</Data>
  </EventData>
</Event>

Since restarting the service we have only seen that error appear once today.

Another weird issue we notice coming up from time to time (could be unrelated):

It could be related to Chrome?

 

The details of the error for the above are:

Stack Trace:
Caught exception: Laserfiche.Forms.CommonUtils.Exceptions.LFFormsException
Message: An unexpected error has occurred. [LFF502-UnexpectedError]


Inner exception: System.ArgumentException
Message: Illegal characters in path.
   at System.IO.LongPathHelper.Normalize(String path, UInt32 maxPathLength, Boolean checkInvalidCharacters, Boolean expandShortPaths)
   at System.IO.Path.NormalizePath(String path, Boolean fullCheck, Int32 maxPathLength, Boolean expandShortPaths)
   at System.IO.Path.GetFullPathInternal(String path)
   at System.Security.Util.StringExpressionSet.CanonicalizePath(String path, Boolean needFullPath)
   at System.Security.Util.StringExpressionSet.CreateListFromExpressions(String[] str, Boolean needFullPath)
   at System.Security.Permissions.FileIOPermission.AddPathList(FileIOPermissionAccess access, AccessControlActions control, String[] pathListOrig, Boolean checkForDuplicates, Boolean needFullPath, Boolean copyPathList)
   at System.Security.Permissions.FileIOPermission..ctor(FileIOPermissionAccess access, String path)
   at System.Web.InternalSecurityPermissions.PathDiscovery(String path)
   at System.Web.HttpRequest.MapPath(VirtualPath virtualPath, VirtualPath baseVirtualDir, Boolean allowCrossAppMapping)
   at System.Web.HttpServerUtility.Execute(IHttpHandler handler, TextWriter writer, Boolean preserveForm, Boolean setPreviousPage)
   at System.Web.HttpServerUtility.Execute(IHttpHandler handler, TextWriter writer, Boolean preserveForm)
   at System.Web.Mvc.Html.ChildActionExtensions.ActionHelper(HtmlHelper htmlHelper, String actionName, String controllerName, RouteValueDictionary routeValues, TextWriter textWriter)
   at System.Web.Mvc.Html.ChildActionExtensions.Action(HtmlHelper htmlHelper, String actionName, String controllerName, RouteValueDictionary routeValues)
   at ASP._Page_Views_Home_Inbox_cshtml.&lt;Execute&gt;b__1b() in c:\Program Files\Laserfiche\Laserfiche Forms\Forms\Views\Home\Inbox.cshtml:line 121
   at System.Web.WebPages.WebPageBase.&lt;&gt;c__DisplayClass42_0.&lt;RenderSection&gt;b__0(TextWriter tw)
   at System.Web.WebPages.WebPageExecutingBase.WriteTo(TextWriter writer, HelperResult content)
   at ASP._Page_Views_Shared__Layout_app_cshtml.&lt;RenderSectionTopHeader&gt;b__9(TextWriter __razor_helper_writer) in c:\Program Files\Laserfiche\Laserfiche Forms\Forms\Views\Shared\_Layout.app.cshtml:line 104
   at System.Web.WebPages.WebPageBase.Write(HelperResult result)
   at ASP._Page_Views_Shared__Layout_app_cshtml.&lt;Execute&gt;b__32() in c:\Program Files\Laserfiche\Laserfiche Forms\Forms\Views\Shared\_Layout.app.cshtml:line 183
   at System.Web.WebPages.WebPageBase.&lt;&gt;c__DisplayClass42_0.&lt;RenderSection&gt;b__0(TextWriter tw)
   at System.Web.WebPages.WebPageBase.Write(HelperResult result)
   at ASP._Page_Views_Shared__Layout_cshtml.Execute() in c:\Program Files\Laserfiche\Laserfiche Forms\Forms\Views\Shared\_Layout.cshtml:line 127
   at System.Web.WebPages.WebPageBase.ExecutePageHierarchy()
   at System.Web.Mvc.WebViewPage.ExecutePageHierarchy()
   at System.Web.WebPages.WebPageBase.ExecutePageHierarchy(WebPageContext pageContext, TextWriter writer, WebPageRenderingBase startPage)
   at System.Web.WebPages.WebPageBase.&lt;&gt;c__DisplayClass40_0.&lt;RenderPageCore&gt;b__0(TextWriter writer)
   at System.Web.WebPages.WebPageBase.Write(HelperResult result)
   at System.Web.WebPages.WebPageBase.RenderSurrounding(String partialViewName, Action`1 body)
   at System.Web.WebPages.WebPageBase.PopContext()
   at System.Web.WebPages.WebPageBase.&lt;&gt;c__DisplayClass40_0.&lt;RenderPageCore&gt;b__0(TextWriter writer)
   at System.Web.WebPages.WebPageBase.Write(HelperResult result)
   at System.Web.WebPages.WebPageBase.RenderSurrounding(String partialViewName, Action`1 body)
   at System.Web.WebPages.WebPageBase.PopContext()
   at System.Web.Mvc.ViewResultBase.ExecuteResult(ControllerContext context)
   at System.Web.Mvc.ControllerActionInvoker.InvokeActionResultFilterRecursive(IList`1 filters, Int32 filterIndex, ResultExecutingContext preContext, ControllerContext controllerContext, ActionResult actionResult)
   at System.Web.Mvc.ControllerActionInvoker.InvokeActionResultFilterRecursive(IList`1 filters, Int32 filterIndex, ResultExecutingContext preContext, ControllerContext controllerContext, ActionResult actionResult)
   at System.Web.Mvc.ControllerActionInvoker.InvokeActionResultFilterRecursive(IList`1 filters, Int32 filterIndex, ResultExecutingContext preContext, ControllerContext controllerContext, ActionResult actionResult)
   at System.Web.Mvc.ControllerActionInvoker.InvokeActionResultWithFilters(ControllerContext controllerContext, IList`1 filters, ActionResult actionResult)
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.&lt;&gt;c__DisplayClass3_1.&lt;BeginInvokeAction&gt;b__1(IAsyncResult asyncResult)

0 0
replied on November 2, 2020 Show version history

The weird error "Illegal characters in path." message is caused by using Microsoft Edge(HTML) to visit Forms pages, you can confirm this by checking the browser information in the error log, it should be something like following:

Browser: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.102 Safari/537.36 Edge/18.18362

 

Microsoft Edge(HTML) append "{{icon || src || svgUrl}}" to all the links on the pages, but this will not cause any front end error for the end user. 

In Laserfiche 11. we will end the support for Microsoft Edge(HTML).

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.