Home > Forum > Database > 2025 error - Problem with Default Dashbords

2025 error - Problem with Default Dashbords
0

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.d__21.MoveNext()

Did you know that with WEBCON you can automate virtually any process? Even baking cookies 🍪
 
Speaking of cookies: we use the ones that are essential for our website to function properly, as well as additional ones that help us customize our content to your preferences. If you don’t mind cookies, click Accept. If you want to learn more, explore settings.
Settings