12.12.2024
12:49
Hi,
When moving an application between DEV and TEST environments, an error prevents the application from being moved to another environment.
I found out that after updating DEV and TEST I have a DEFAULT Dashboard in dbo.AppDashboards with different ADS_Guid numbers.
Probably in 2023 versions of the processes there were two different dashboards set as Default.
Does anyone know how to fix this?
Error:
System.Exception: Exception occurred while importing table AppDashboards ---> Microsoft.Data.SqlClient.SqlException: Cannot insert duplicate key row in object 'dbo.AppDashboards' with unique index 'UQ_AppDashboards_IsDefault'. The duplicate key value is (8).
The statement has been terminated.
w System.Data.Common.DbDataAdapter.UpdatedRowStatusErrors(RowUpdatedEventArgs rowUpdatedEvent, BatchCommandInfo[] batchCommands, Int32 commandCount)
w System.Data.Common.DbDataAdapter.UpdatedRowStatus(RowUpdatedEventArgs rowUpdatedEvent, BatchCommandInfo[] batchCommands, Int32 commandCount)
w System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows, DataTableMapping tableMapping)
w System.Data.Common.DbDataAdapter.UpdateFromDataTable(DataTable dataTable, DataTableMapping tableMapping)
w System.Data.Common.DbDataAdapter.Update(DataTable dataTable)
w MyGeneration.dOOdads.BusinessEntity.Save()
w WebCon.WorkFlow.Data.ImportExport.Graph.DbNode`2.AddOrUpdate(IDictionary`2 dictionary, TEntity saveEntity)
w WebCon.WorkFlow.Data.ImportExport.Graph.DbNode`2.SaveEntities(IList`1 data)
w WebCon.WorkFlow.BusinessLogic.ImportExport.Import.TableImporter.ImportRows(IDbNode node, ForeignKeyFinder foreignKeyFinder, List`1 entitiesToImport, ICustomImport customImport, ImportVerificationResult verificationResult, ConcurrentDictionary`2 saveResultDictionary)
w WebCon.WorkFlow.BusinessLogic.ImportExport.Import.TableImporter.ImportTable(IDbNode node, ImportVerificationResult verificationResult, ConcurrentDictionary`2 saveResultDictionary)
--- Koniec śladu stosu wyjątków wewnętrznych ---
w WebCon.WorkFlow.BusinessLogic.ImportExport.Import.TableImporter.ImportTable(IDbNode node, ImportVerificationResult verificationResult, ConcurrentDictionary`2 saveResultDictionary)
w System.Linq.DataEnumerable.ForEach[T](IEnumerable`1 _this, Action`1 action)
w WebCon.WorkFlow.BusinessLogic.ImportExport.Import.ImportManager.Import(ImportVerificationResult verificationResult, IImportLogger importLogger, IImportExcluderFactory importExcluder, Boolean importAsTemplate, List`1 bpsGroups)
w WebCon.WorkFlow.Service.ActivityExecutors.QueueActivityExecutors.ImportActivityExecutor.DoImport(IImportQueueElement queueElement, List`1 importProgressStudioLog, IActivityEvents activityEvents, ImportExportData importExportData)
w WebCon.WorkFlow.Service.ActivityExecutors.QueueActivityExecutors.ImportActivityExecutor.<ImportActionAsync>d__21.MoveNext()
