Re: Avoid synchronization while an synchronization is already in progress.
Posted: September 9th, 2020, 11:00 am
Well ok, i have not much more ideas about the cause for now. I need the client log to see what is happening as you recommending. Thanks.
I created a report to measure when we ended up having in the queryable tables a different revision than the revision that is present in CSWeb for the same guid and caseid. This happens exactly in the case where we received more than one revision for a finished case, as we only save in the queryable tables the first finished and not deleted case that we received form the same caseid. This is because we don't allow duplicate cases in the queryable tables and also don't allow override a case without to have authorization.
In more than 10000 revisions for all questionnaires we have 4 cases of duplicate revisions. But how in one revision we can have more than one case we end up having about 25 false positive duplicate interviews.Is this something that happens consistently or is it only happening for certain users or is it intermittent?
I created a report to measure when we ended up having in the queryable tables a different revision than the revision that is present in CSWeb for the same guid and caseid. This happens exactly in the case where we received more than one revision for a finished case, as we only save in the queryable tables the first finished and not deleted case that we received form the same caseid. This is because we don't allow duplicate cases in the queryable tables and also don't allow override a case without to have authorization.