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

Question

Question

Error report export in Forms unexpected error

asked on February 21, 2019

Hello,

These errors appear when we try to export Forms report to excel and in other cases did anyone faced this error before?

[502]: Une erreur inattendue s'est produite. [LFF502-UnexpectedError]

Details:
URL: /Forms/form/avsubmission?instanceId=&routingResumeId=6c4fc736-6fee-4f83-8b5f-7c23dfbcc440&submissionId=&RemoveHead=true&clientHandlesRedirect=true&readonly=false
Error: UnexpectedError
Date: 21/02/2019 09:21:16 (Afr. centrale Ouest)
HTTP Status Code: 500
Business Process ID: 0
User: ADMIN
IP: 10.172.150.7
Browser: Mozilla/5.0 (Windows NT 6.2; Win64; x64; rv:65.0) Gecko/20100101 Firefox/65.0
Business Process Name: 

Stack Trace:
Caught exception: Laserfiche.Forms.CommonUtils.Exceptions.LFFormsException
Message: Une erreur inattendue s'est produite. [LFF502-UnexpectedError]


Inner exception: System.OutOfMemoryException
Message: Une exception de type 'System.OutOfMemoryException' a été levée.
   à System.Data.SqlClient.TdsParserStateObject.TryReadPlpBytes(Byte[]& buff, Int32 offst, Int32 len, Int32& totalBytesRead)
   à System.Data.SqlClient.TdsParser.TryReadSqlValue(SqlBuffer value, SqlMetaDataPriv md, Int32 length, TdsParserStateObject stateObj, SqlCommandColumnEncryptionSetting columnEncryptionOverride, String columnName)
   à System.Data.SqlClient.SqlDataReader.TryReadColumnInternal(Int32 i, Boolean readHeaderOnly)
   à System.Data.SqlClient.SqlDataReader.TryReadColumn(Int32 i, Boolean setTimeout, Boolean allowPartiallyReadColumn)
   à System.Data.SqlClient.SqlDataReader.GetValues(Object[] values)
   à System.Data.Entity.Core.Objects.Internal.ShapelessBufferedDataRecord.Initialize(String providerManifestToken, DbProviderServices providerSerivces, DbDataReader reader)
   à System.Data.Entity.Core.Objects.Internal.BufferedDataReader.Initialize(String providerManifestToken, DbProviderServices providerServices, Type[] columnTypes, Boolean[] nullableColumns)
   à System.Data.Entity.Core.Objects.Internal.ObjectQueryExecutionPlan.Execute[TResultType](ObjectContext context, ObjectParameterCollection parameterValues)
   à System.Data.Entity.Core.Objects.ObjectQuery`1.<>c__DisplayClass7.<GetResults>b__6()
   à System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction[T](Func`1 func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, Boolean releaseConnectionOnSuccess)
   à System.Data.Entity.Core.Objects.ObjectQuery`1.<>c__DisplayClass7.<GetResults>b__5()
   à System.Data.Entity.Infrastructure.DbExecutionStrategy.Execute[TResult](Func`1 operation)
   à System.Data.Entity.Core.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption)
   à System.Data.Entity.Core.Objects.ObjectQuery`1.Execute(MergeOption mergeOption)
   à System.Data.Entity.Core.Objects.DataClasses.EntityCollection`1.Load(List`1 collection, MergeOption mergeOption)
   à System.Data.Entity.Core.Objects.DataClasses.EntityCollection`1.Load(MergeOption mergeOption)
   à System.Data.Entity.Core.Objects.DataClasses.RelatedEnd.DeferredLoad()
   à System.Data.Entity.Core.Objects.Internal.LazyLoadBehavior.LoadProperty[TItem](TItem propertyValue, String relationshipName, String targetRoleName, Boolean mustBeNull, Object wrapperObject)
   à System.Data.Entity.Core.Objects.Internal.LazyLoadBehavior.<>c__DisplayClass7`2.<GetInterceptorDelegate>b__1(TProxy proxy, TItem item)
   à System.Data.Entity.DynamicProxies.cf_bp_data_BCD01D029A344CAB57B5EE2F3ED0A5A92AC6BC5B55DD6DA5F8BE2516AD9BD45E.get_cf_bp_attachment_data()
   à Laserfiche.Forms.Routing.VariableXMLGenerator.<>c.<AddMemberData>b__44_2(cf_bp_data d)
   à System.Linq.Lookup`2.Create[TSource](IEnumerable`1 source, Func`2 keySelector, Func`2 elementSelector, IEqualityComparer`1 comparer)
   à System.Linq.GroupedEnumerable`3.GetEnumerator()
   à System.Linq.Enumerable.WhereSelectEnumerableIterator`2.MoveNext()
   à System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
   à System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
   à Laserfiche.Forms.Routing.VariableXMLGenerator.AddMemberData(XDocument& doc, IEnumerable`1& submissions, Int32 submissionIdInUse, Int32[] IncludedMemberIds, HashSet`1 IncludeAttrIds, Boolean includeSeparators)
   à Laserfiche.Forms.Routing.VariableXMLGenerator.GenerateXml(Int32 bpInstanceId, Nullable`1 formId, cf_user_snapshot initiator, Nullable`1 submissionId, Nullable`1 initiatedTime, Nullable`1 taskTime, Boolean includeSeparators, HashSet`1 includeAttrIds)
   à Laserfiche.Forms.Routing.VariableXMLGenerator.GetLatestDataBySubmission(Int32 mainInstanceId, Int32 formId, Nullable`1 submissionId, cf_user_snapshot initiator, Nullable`1 initiatedTime, Boolean includeSeparators)
   à E_Forms.Models.ViewModels.Form.Approval.PopulateForm()
   à ASP._Page_Views_Form__FormLayout_cshtml.Execute() dans c:\Program Files (x86)\Laserfiche\Laserfiche Forms\Forms\Views\Form\_FormLayout.cshtml:ligne 357
   à System.Web.WebPages.WebPageBase.ExecutePageHierarchy()
   à System.Web.Mvc.WebViewPage.ExecutePageHierarchy()
   à System.Web.WebPages.WebPageBase.ExecutePageHierarchy(WebPageContext pageContext, TextWriter writer, WebPageRenderingBase startPage)
   à System.Web.WebPages.WebPageBase.<>c__DisplayClass3.<RenderPageCore>b__2(TextWriter writer)
   à System.Web.WebPages.HelperResult.WriteTo(TextWriter writer)
   à System.Web.WebPages.WebPageBase.Write(HelperResult result)
   à System.Web.WebPages.WebPageBase.RenderSurrounding(String partialViewName, Action`1 body)
   à System.Web.WebPages.WebPageBase.PopContext()
   à System.Web.WebPages.WebPageBase.ExecutePageHierarchy(WebPageContext pageContext, TextWriter writer, WebPageRenderingBase startPage)
   à System.Web.Mvc.RazorView.RenderView(ViewContext viewContext, TextWriter writer, Object instance)
   à System.Web.Mvc.BuildManagerCompiledView.Render(ViewContext viewContext, TextWriter writer)
   à System.Web.Mvc.ViewResultBase.ExecuteResult(ControllerContext context)
   à System.Web.Mvc.ControllerActionInvoker.InvokeActionResult(ControllerContext controllerContext, ActionResult actionResult)
   à System.Web.Mvc.ControllerActionInvoker.InvokeActionResultFilterRecursive(IList`1 filters, Int32 filterIndex, ResultExecutingContext preContext, ControllerContext controllerContext, ActionResult actionResult)
   à System.Web.Mvc.ControllerActionInvoker.InvokeActionResultFilterRecursive(IList`1 filters, Int32 filterIndex, ResultExecutingContext preContext, ControllerContext controllerContext, ActionResult actionResult)
   à System.Web.Mvc.ControllerActionInvoker.InvokeActionResultFilterRecursive(IList`1 filters, Int32 filterIndex, ResultExecutingContext preContext, ControllerContext controllerContext, ActionResult actionResult)
   à System.Web.Mvc.ControllerActionInvoker.InvokeActionResultWithFilters(ControllerContext controllerContext, IList`1 filters, ActionResult actionResult)
   à System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass21.<>c__DisplayClass2b.<BeginInvokeAction>b__1c()
   à System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass21.<BeginInvokeAction>b__1e(IAsyncResult asyncResult)

 

Export2.PNG
Export2.PNG (118.41 KB)
0 0

Replies

replied on February 21, 2019

Have you tried restarting the routing server and the Forms app pool in IIS?

0 0
replied on February 23, 2019 Show version history

hi miruna,

yes we already did but it doesn't work.

 

0 0
replied on February 21, 2019

Hi Hanane,

 

We did have some memory issues with the download which were addressed in later versions of Forms, although from what I recall this was mainly for larger reports. I would start with Miruna's suggestions. If those don't work, maybe take a look at how much free memory your Forms server has. Since you said you have been seeing errors in "other cases" as well, perhaps the server is running low on memory. If the memory looks fine and the suggestions don't work, I would encourage you to file a support ticket for this.

0 0
replied on February 24, 2019

thank you sean for the reply,

miruna suggestions dont work, and actually we already  looked and still have free memory in our Forms server.

any other suggestion?

0 0
replied on February 25, 2019

Aside from talking to support, I don't have any further suggestions for now.

0 0
replied on February 26, 2019

thank you sean i am talking to support

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

Sign in to reply to this post.