Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
BuTbka
Creator
Creator

Qlik Sense "Error when committing"

We encountered a problem when the repository service on the central node consumed 90% of the processor resources and, as a result, the system slowed down and hung. This situation is repeated several times, and we found these 2 lines in the logs. These lines appeared right before the problem occurred.

21525	20230417T133024.759+0300	INFO	QS01	System.Repository.Repository.Core.Repository.ProfessionalAccessTypeRepository	207	d0c68dc0-9219-495e-bbc6-815bddec00b7	DOMAIN\srv.qliksense	Database object has newer timestamp than object being modified; pim4: 63817324220493, itms: 63817322458742, ityp: Repository.Domain.Model.LicenseProfessionalAccessType			c0de92f5-b910-f842-c9b8-e1e00697d0dc	d0c68dc0-9219-495e-bbc6-815bddec00b7
21526	20230417T133024.768+0300	ERROR	QS01	System.Repository.Repository.Core.Repository.Common.TransactionUtility	207	306318f3-7b2b-426a-a74c-31ca074d771c	DOMAIN\srv.qliksense	Error when committing		   at Repository.Core.Repository.Common.AbstractModelRepository.CheckConflicts(IRepositoryObject persistedItem, DateTime itemModifiedDate)↵↓   at Repository.Core.Repository.Common.ModelRepository`1.UpdateMany(IEnumerable`1 items, Boolean appendPrivileges, Int64 privilegesFilter)↵↓   at Repository.Core.Repository.Common.ModelRepository`1.Update(T item, Boolean appendPrivileges, Int64 privilegesFilter)↵↓   at Repository.Core.Licensing.AccessTypes.ProfessionalAccessTypeHandler.<>c__DisplayClass15_1.<TryUseExistingAccess>b__7()↵↓   at Repository.Core.Repository.Common.TransactionUtility.RunInTransaction(ITransaction transaction, IEnumerable`1 actions)	c0de92f5-b910-f842-c9b8-e1e00697d0dc	306318f3-7b2b-426a-a74c-31ca074d771c

What can we do to prevent this issue? We use Qlik Sense Feb 2022 SP 13

Labels (1)
12 Replies
seblabalyerr
Partner - Contributor III
Partner - Contributor III

Hello @BuTbka ,

Is there any progress on resolving this issue? Can you inform?

BuTbka
Creator
Creator
Author

Hi @seblabalyerr !
We followed instructions from there https://community.qlik.com/t5/Official-Support-Articles/Qlik-Sense-Repository-Service-suddenly-using...
Also we created PS script(to reduce objects count) that delete unused user sheets(before delete it send e-mail to user), delete all stories and snapshots(because we don't use them).

Albert_Candelario

Hello @seblabalyerr ,

What is the issue that you are having, could you please add more context and details?

Cheers,

Albert

Please, remember to mark the thread as solved once getting the correct answer