Question

forms upgrade from 10.1 to 10.3.1 installer SQL error

Forms Installation and Upgrades

Updated December 23, 2018

asked on December 1, 2018

We tried to run the 10.3.1 Forms installer and when we browse to the Forms config and it requests to Update the database. It returns an error. The event log shows:

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

Details:
URL:
Error: GeneralMigrationError
Date: 11/30/2018 12:20:06 PM (Eastern 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: Violation of UNIQUE KEY constraint 'IX_bp_data_constraints_u'. Cannot insert duplicate key in object 'dbo.cf_bp_data'.
at System.Data.SqlClient.SqlConnection.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 FormsConfig.Util.DatabaseHelper.UpgradeDBSchema(SqlConnection conn, String schemFolder, Int32 curStep)
at FormsConfig.Infrastructure.DatabaseInfo.UpgradeDatabase()

0 0

Answer

SELECTED ANSWER

replied on December 3, 2018

Yes we have, I assume its the same case then. We have provided a few .rpt files that were requested.

Its narrowed down to the Step 481 in the upgrade is where it breaks.

1 0

Replies

replied on December 2, 2018

Have you opened support case with your VAR? We got a support case with ID 198653 reported with same error. Please provide a backup of your database to the support case and we need to investigate what data cause it and how to fix the data.

1 0

SELECTED ANSWER

replied on December 3, 2018

Yes we have, I assume its the same case then. We have provided a few .rpt files that were requested.

Its narrowed down to the Step 481 in the upgrade is where it breaks.

1 0

replied on December 11, 2018

Thanks, we ran the suggested SQL and it allowed the upgrade to continue. Excellent :)

Delete from [dbo].[cf_bp_data] where submission_id=530 and member_path like '%[_]'

Not sure how the application allowed us to create or did create entries that all ended with _ but that seemed to be the issue. Its all good now

0 0

replied on December 23, 2018

We are not sure the cause of such data as well. If you run into it again or there are other customers have similar issue, we will do further investigation.

1 0

You are not allowed to follow up in this post.

Question

Question

forms upgrade from 10.1 to 10.3.1 installer SQL error

Answer

Replies

Sign in to reply to this post.