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

Question

Question

[LFF502-UnexpectedError] Unexpected error after 10.2 upgrade

asked on March 20, 2017 Show version history

I upgraded to 10.2 and we have received error "Laserfiche has encountered a problem. An unexpected error has occured. [LFF502-UnexpectedError]" on few of our forms - in the approval task step. Both forms have worked perfectly fine before the upgrade.

Any idea why this is happening and how to fix it? Here is the Event Viewer error message:

An unexpected error has occurred. [LFF502-UnexpectedError]

Details:
URL: /Forms/Form/Submit?source=formiframe
Error: UnexpectedError
Date: 3/20/2017 11:35:24 AM (Central Standard Time)
HTTP Status Code: 500
Business Process ID: 3
User: Registrar1
IP: 10.0.207.61
Browser: Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/56.0.2924.87 Safari/537.36
Business Process Name: AGS Add/Drop Form

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


Inner exception: System.NullReferenceException
Message: Object reference not set to an instance of an object.
   at E_Forms.Models.ViewModels.Form.Submit.CheckIsDateTimeFormat(String Format)
   at E_Forms.Models.ViewModels.Form.Submit.RetrieveDataFromForm(HttpRequestBase request, Dictionary`2 formdata, Boolean SaveAll)
   at E_Forms.Controllers.FormController.Submit(FormCollection collection)
   at lambda_method(Closure , ControllerBase , Object[] )
   at System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary`2 parameters)
   at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters)
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.<BeginInvokeSynchronousActionMethod>b__39(IAsyncResult asyncResult, ActionInvocation innerInvokeState)
   at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResult`2.CallEndDelegate(IAsyncResult asyncResult)
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethod(IAsyncResult asyncResult)
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3d()
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c__DisplayClass46.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3f()
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c__DisplayClass46.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3f()
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethodWithFilters(IAsyncResult asyncResult)
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass21.<>c__DisplayClass2b.<BeginInvokeAction>b__1c()
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass21.<BeginInvokeAction>b__1e(IAsyncResult asyncResult)

1 0

Answer

SELECTED ANSWER
replied on March 22, 2017

You can run following query on your database to filter the fields in all:

  select * from [dbo].[cf_fields] where [type]='date' and [format]is NULL

The run following query to fix them:

update [dbo].[cf_fields] set format='MM/dd/yyyy' where [type]='date' and [format]is NULL 
2 0
replied on March 22, 2017

Thanks Xiuhong, this fixed the issue. It seems like the date format wasn't fixable by GUI, only through SQL. Thanks again so much!!

1 0
replied on March 22, 2017

Thanks for the feedback, we will fix the root cause in next release.

1 0

Replies

replied on March 20, 2017

From the log, it may be because the date format is null in database. You may want to try to apply the hotfix 1013831 (the null date format is 153935) for Forms 10.2.

0 0
replied on March 21, 2017

Thanks Ming, how do I know if I already have that hotfix - I think it came with the version I downloaded (on March 15th).

0 0
replied on March 21, 2017

The hotfix is version 10.2.0.789, since your Forms version is later than the version, it should have already included the hotfix. So I suppose you need to open a support case like Xiang said.

1 0
replied on March 20, 2017 Show version history

What is the exact version of Forms are you using? It seems you have applied the Forms 10.2 Update 1 from the other post: https://answers.laserfiche.com/questions/117430/102-Forms-changed-date-format#117485

If you are already on 10.2.0.834, please open a support case with your VAR by providing the download process.

 

0 0
replied on March 21, 2017

Thanks Xiuhong - I am on Version 10.2.0.834. I will open a support case with my VAR and post back when we find a resolution.

0 0
replied on March 21, 2017

We had the same issue. LF Support assisted and now fixed:

 

Open the formsconfig web page

Click on the Database page

Rename the database to any random name

Click Save

Rename the database back to the original name

Click Save

Restart the Forms Service

0 0
replied on March 21, 2017

I was hoping this would help but unfortunately it didn't :( Thanks for sharing though!!!

0 0
replied on March 22, 2017 Show version history

Hi Lidija,

I got the same error when submitting a form that contained a read-only date field with null format.

Can you check your process if there is such a date field, and correct the format setting?

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

Sign in to reply to this post.