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'.