DB PostMigrate Script - Error

Error	Post Migration 	ICE_FKs.sql	The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_ShellLayoutPersonal_ShellLayout". The conflict occurred in database "EpicorERP", table "Ice.ShellLayout".
alter table Ice.ShellLayoutPersonal 
    add cons
   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 Epicor.MigrationModel.DBMigrationTask.RunCommand(Int32 totalObjects, SqlConnection cnx, Int32& lastPct, Int32& itemsProcessed, String sqlCommandText, String scriptFileName, SqlTransaction trans)

Any ideas on this from anyone? Not quite the same as another I found about user tracing.

1 Like