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

Question

Question

Unable to login to Laserfiche Forms Failed to register the Laserfiche repository: An error occurred while updating the entries

asked on February 18, 2015 Show version history

Unable to login to Laserfiche Forms using Named or Windows user accounts.  Checking the Forms Configuration and clicking save yields this error: Failed to register the Laserfiche repository: An error occurred while updating the entries

 

THIS JUST STARTED HAPPENING 10 MINUTES AGO.  Restarted LF Forms Service, then restarted the server.  Errors still present.

 

Message: An error occurred while updating the entries. See the inner exception for details.   at System.Data.Entity.Internal.InternalContext.SaveChanges()
   at FormsConfig.Infrastructure.AuthenticationInfo.SaveAuthenticationInfo(Boolean alreadyVerifiedServer)

 

Log Name:      Application
Source:        Laserfiche Forms
Date:          2/18/2015 2:24:57 PM
Event ID:      0
Task Category: None
Level:         Error
Keywords:      Classic
User:          N/A
Computer:      
Description:
Message: Failed to register the Laserfiche repository: An error occurred while updating the entries. See the inner exception for details.   at FormsConfig.Infrastructure.AuthenticationInfo.SaveAuthenticationInfo(Boolean alreadyVerifiedServer)
   at FormsConfig.Controllers.ConfigurationController.SetAuthenticationInfo(AuthenticationInfo authenticationInfo)
   at System.Web.Mvc.ActionMethodDispatcher.<>c__DisplayClass1.<WrapVoidAction>b__0(ControllerBase controller, Object[] parameters)
   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.AsyncInvocationWithFilters.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3f()
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c__DisplayClass48.<InvokeActionMethodFilterAsynchronouslyRecursive>b__41()
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass33.<BeginInvokeActionMethodWithFilters>b__32(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)
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="Laserfiche Forms" />
    <EventID Qualifiers="0">0</EventID>
    <Level>2</Level>
    <Task>0</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="2015-02-18T22:24:57.000000000Z" />
    <EventRecordID>8575160</EventRecordID>
    <Channel>Application</Channel>
    <Computer>xxxx</Computer>
    <Security />
  </System>
  <EventData>
    <Data>Message: Failed to register the Laserfiche repository: An error occurred while updating the entries. See the inner exception for details.   at FormsConfig.Infrastructure.AuthenticationInfo.SaveAuthenticationInfo(Boolean alreadyVerifiedServer)
   at FormsConfig.Controllers.ConfigurationController.SetAuthenticationInfo(AuthenticationInfo authenticationInfo)
   at System.Web.Mvc.ActionMethodDispatcher.&lt;&gt;c__DisplayClass1.&lt;WrapVoidAction&gt;b__0(ControllerBase controller, Object[] parameters)
   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.&lt;BeginInvokeSynchronousActionMethod&gt;b__39(IAsyncResult asyncResult, ActionInvocation innerInvokeState)
   at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResult`2.CallEndDelegate(IAsyncResult asyncResult)
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.&lt;InvokeActionMethodFilterAsynchronouslyRecursive&gt;b__3f()
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.&lt;&gt;c__DisplayClass48.&lt;InvokeActionMethodFilterAsynchronouslyRecursive&gt;b__41()
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.&lt;&gt;c__DisplayClass33.&lt;BeginInvokeActionMethodWithFilters&gt;b__32(IAsyncResult asyncResult)
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.&lt;&gt;c__DisplayClass21.&lt;&gt;c__DisplayClass2b.&lt;BeginInvokeAction&gt;b__1c()
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.&lt;&gt;c__DisplayClass21.&lt;BeginInvokeAction&gt;b__1e(IAsyncResult asyncResult)</Data>
  </EventData>
</Event>

 

 

0 0

Replies

replied on February 18, 2015 Show version history

I believe the "An error occurred while updating the entries" is the key to this. It sounds like the forms server is having issues connecting to it's database. Make sure you check the sql database connection and make sure you can still access it yourself.

 

I don't have my server in front of me but if I remember correctly on the database page you can specify how you login and then what database you are using. I'd make sure that this info is correct and try to pull down on the database name to see if you can see choices in the dropdown (i.e. that it's actually connecting, because if it's not it won't show you a list!). Make sure you don't actually change or save it though, you don't want to start a new DB with no info. This is just a test to see if you really do have a connection.

 

If you don't have a connection, I'd first make sure the SQL server is up and running. I'd then make sure that the account you are using to connect to the SQL database works. I've seen similar issues to this where a windows account associated with it has a password expiration that no one ever saw since no one ever logs into it interactively.

 

I'd also check for errors in the event log on the SQL server. Obviously if you can't see anything there I'd open a case with your VAR.

 

Good Luck!

0 0
replied on February 18, 2015

Hi Eddie, 

you can try to restart your Laserfiche server (which your repository is on) and re-type username/password on Formsconfig/Repository page under "Repository", make sure that the user has "Manage Trustees privilege" to that repository.

 

if this is still not working, run this script in your Forms database

update cf_users set password ='' where username='FORMSUSER$'

then click 'save' button on your Formsconfig/Repository page 

0 0
replied on February 19, 2015

Hi Lifei,

Could you show me a screenshot of how to try your suggestion of FORMSUSER$?

0 0
replied on February 18, 2015

Chris & Lifei... Thank you for your suggestions.  I was able to see an entry in the drop down list.  I was able to confirm that the accounts listed below have Manage Trustee Rights.

 

There are conflicting messages after I click Save... see below.

 

0 0
replied on February 18, 2015

Hello Eddie,

 

Can you see if your Forms Routing Server Service is running as a domain account that has local admin rights and also can access into the SQL instance in  which the repository is located? Please also ensure that same domain account mentioned above is used for the FormsAppPool in the IIS manager( Server > Application Pools > FormsAppPool > Right-click into Advanced settings > Identity). Also please make sure you are meeting the system and browser requirements from the white paper. 

 

Regards,

Andrew

0 0
replied on February 19, 2015

The issue has returned... Please assist since I am unsure what to try next.

0 0
replied on February 19, 2015

Please open a case with your Laserfiche reseller.

0 0
replied on February 18, 2015 Show version history

I just verified the account is still a member of the local Administrators group.

I was able to use SSMS & connect to the databases (LFServer & LFForms) using the domain account referenced

FormsAppPool is also configured in the IIS Manager

System & browser requirements are to spec and we're running 9.2.0.908

 

0 0
replied on February 18, 2015 Show version history

The issue has returned... Please assist since I am unsure what to try next.

0 0
replied on February 24, 2015

If you are able to open the repository tab, then there should be no problem to connect to the database. Please open an support case with the full error message from events log, there should be some detail error from SQL when get error "An error occurred while updating the entries".

0 0
replied on January 6, 2020

I know this post is old but posting for anyone else who has this issue....we had a customer who was receiving this error when trying to update drop-down options in Forms. It was due to them reaching their Database size limit in SQL Express. You are limited to 10GB per Database. If you are getting this error and are using SQL Express, it may be worth checking the size of your DB.

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

Sign in to reply to this post.