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

Question

Question

Forms DB Upgrade - LFF3200-GeneralMigrationError

asked on January 9, 2022

I have upgraded Forms from 10.4 to 11 and when I launch /FormsConfig to upgrade the DB it runs for quite a while then I receive this:

 

An error was encountered while updating the database. [LFF3200-GeneralMigrationError]

Details:
URL: 
Error: GeneralMigrationError
Date: 1/9/2022 8:19:47 AM (Central Standard Time)
HTTP Status Code: 400
Business Process ID: 0
Business Process Name: 

Stack Trace:
Caught exception: Laserfiche.Forms.CommonUtils.Exceptions.LFFormsException
Message: An error was encountered while updating the database. [LFF3200-GeneralMigrationError]
   at FormsConfig.Infrastructure.DatabaseInfo.UpgradeDatabase()
   at FormsConfig.Controllers.ConfigurationController.RunDatabaseUpgrade(DatabaseInfo databaseInfo, String Identity)

Inner exception: System.Data.SqlClient.SqlException
Message: Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at Laserfiche.Forms.CommonUtils.DatabaseHelper.UpgradeDBSchema(SqlConnection conn, String schemFolder, Int32 curStep)
   at FormsConfig.Infrastructure.DatabaseInfo.UpgradeDatabase()

Inner exception: System.ComponentModel.Win32Exception
Message: The wait operation timed out

 

In SQL I do see this in the mgmt logs as soon as the upgrade starts but nothing after it:

 

 

Source        spid515

Message
Setting database option ALLOW_SNAPSHOT_ISOLATION to ON for database 'LF_Forms'.
 

0 0

Replies

replied on January 10, 2022

Hi Josh,

Looks like you've encounter some performance issue during database upgrade. Could you kindly open up support case to Laserfiche through your VAR and provide error logs and database for further troubleshooting?

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

Sign in to reply to this post.