User Directory Controller using MS AD - failed to execute query in database

Flo_Kopp — Wed, 29 Jan 2025 17:03:10 GMT

Hey there,

i've got a problem when trying to set up user import via AD. Within the qmc everything looks good but some Users were missing so i searched the log file and found this Error.

I hope someone can help..

18293 20210526T151230.517+0100 ERROR SERVERNAME UserManagement.Repository.Repository.Users.UserSyncEngine 34 00eb60d8-d60c-4890-a29b-e076d5d3fd8d DOMAINNAME\svc.qlik synchronizing all users for 3ac9ed1e-9e38-4dc7-9140-cbccde8a4278 was not successful doppelter Schlüsselwert verletzt Unique-Constraint »ix_usersuserid_userdirectory«↵↓Failed to execute query in database: INSERT INTO "Users" ↵↓("ID","CreatedDate","ModifiedDate","ModifiedByUserName","UserId","UserDirectory","UserDirectoryConnectorName","Name","RolesString","Inactive","RemovedExternally","Blacklisted","DeleteProhibited")↵↓VALUES (:p__ID,:p__CreatedDate,:p__ModifiedDate,:p__ModifiedByUserName,:p__UserId,:p__UserDirectory,:p__UserDirectoryConnectorName,:p__Name,:p__RolesString,:p__Inactive,:p__RemovedExternally,:p__Blacklisted,:p__DeleteProhibited);↵↓Failed to save data into database↵↓Eine Ausnahme vom Typ "Repository.Core.Exceptions.TransactionException" wurde ausgelöst.↵↓The operation failed.↵↓The "Add" operation failed. bei Devart.Data.PostgreSql.PgSqlDataReader.f(Int32 A_0)↵↓ bei Devart.Data.PostgreSql.PgSqlCommand.InternalExecute(CommandBehavior behavior, IDisposable stmt, Int32 startRecord, Int32 maxRecords)↵↓ bei Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior, Boolean nonQuery)↵↓ bei Devart.Common.DbCommandBase.ExecuteNonQuery()↵↓ bei Repository.Core.Repository.Database.Common.AbstractDatabaseContext.ExecuteDbCommand(Query query, List`1 valuesList)↵↓ bei Repository.Core.Repository.Database.Common.AbstractDatabaseContext.ExecuteDbCommand(Query query, List`1 valuesList)↵↓ bei Repository.Core.Repository.Database.Common.AbstractDatabaseContext.ProcessEntityQuerySet(EntityQuerySet entityQuerySet)↵↓ bei Repository.Core.Repository.Database.Common.AbstractDatabaseContext.SaveChanges()↵↓ bei Repository.Core.Repository.Database.Common.AbstractDatabaseContext.SaveChanges()↵↓ bei Repository.Core.Repository.Common.EntityTransactionRepository.ExecuteMany(Dictionary`2 queries, DateTime commitTime)↵↓ bei Repository.Core.Repository.Common.Transaction.InnerCommit()↵↓ bei Repository.Core.Repository.Common.Transaction.Commit()↵↓ bei Repository.Core.Repository.Common.Transaction.Commit()↵↓ bei Repository.Core.Repository.Common.TransactionStack.Commit(ITransaction transaction)↵↓ bei Repository.Core.Repository.Common.TransactionUtility.RunInTransaction(ITransaction transaction, IEnumerable`1 actions)↵↓ bei Repository.Core.Repository.Common.TransactionUtility.RunInTransaction(ITransaction transaction, IEnumerable`1 actions)↵↓ bei Repository.Core.Repository.Common.TransactionUtility.RunInTransaction(Action[] actions)↵↓ bei Repository.Core.Repository.UserRepository.AddAndSyncMany(Stack`1 userStack, Action`3 updateAction)↵↓ bei Repository.Core.Repository.UserRepository.AddAndSyncMany(Stack`1 userStack, Action`3 updateAction)↵↓ bei Repository.Users.Support.SyncUserRepository.AddOrUpdateUsers(String ud, IDictionary`2 oldQrsUsers, IEnumerable`1 udcUsers)↵↓ bei Repository.Users.Support.SyncUserRepository.StoreUsers(IDictionary`2 newUsersPerUd, String[] usersToFilterOn)↵↓ bei Repository.Users.SyncUsersWorker.SaveUsers(IDictionary`2 configuredUdcs, String[] usersToFilterOn)↵↓ bei Repository.Users.SyncUsersWorker.Work(Guid[] userDirectoryIds)↵↓ bei Repository.Users.UserSyncEngine.<>c__DisplayClass21_0.<RunEngine>b__1(ISyncUsersWorker syncUsers)↵↓ bei Repository.Users.UserSyncEngine.InvokeAndLogWork[T](Action`1 workAction, String operationToLog, T worker)↵↓ bei Repository.Users.UserSyncEngine.<>c__DisplayClass23_0`1.<UserSyncEngineWork>b__0(T worker, IPrivileges privileges)↵↓ bei Qlik.Sense.Common.Ioc.WorkScope.Work[T,T2](Action`2 action)↵↓ bei Repository.Users.UserSyncEngine.UserSyncEngineWork[T](Action`1 workAction, String operationToLog, ICallContext callContext) 00eb60d8-d60c-4890-a29b-e076d5d3fd8d

topic User Directory Controller using MS AD - failed to execute query in database in Management & Governance

User Directory Controller using MS AD - failed to execute query in database