Hi Martin :

The following four files are still admin "locked" by Gary and require override when he in fact has not been in the file for over 2 hours (at the time of this post, it has been over 20 hours).

image.png 20.8 KB • Download

image.png 21.5 KB • Download

After 2 hours, inactive (without active saving) UIN files should be released and not require other admin users to override.

Thanks,

Paul

Hi Harsh ,

Please investigate this issue as soon as you can, since the locks will probably still be there when you start your day.

I have created task https://dev.azure.com/tologix/ISLGRebuild/_workitems/edit/2386 to track this.

Thanks,
-Martin

Hi Paul ,

I checked and found that there is no issue from code side. Might be Gary was used the application before 2 hours completed that's why his name was shown to those disputes.

I will keep monitoring this thing for few days. If you face same issue again then let us know.

Cc : Martin  

Hi Harsh :

No, I checked with Gary before this message, and he wasn't editing any of them. This problem seems to occur whenever we deploy sprint items from staging.islg and app.islg if that gives you any other way to check.

I'll mark it complete for now, as I don't see the issue currently.

Paul

Hi Harsh :

Please see the latest example below. Gary hasn't been in SC/0052 over 24 hours now.

Admin Override error 10 (30-Dec-22).mp4 693 KB • Download

I had to override to make changes, but this shouldn't be happening anymore.

Thanks,

Paul

Hi Harsh ,

Please continue your investigation based on Paul 's latest comment in this thread.
I have re-opened https://dev.azure.com/tologix/ISLGRebuild/_workitems/edit/2386 and moved it under Unplanned issues of Sprint 28.

Thanks,
-Martin

Hi Paul ,

Harsh will provide me with a database script which I will be able to run whenever we encounter this issue again. This script will help us troubleshoot the issue further.

Please let us know in this thread when this issue occurs again.

Thanks,
-Martin

Hi Martin :

Right now, UN/0442/01 shows Gary is still editing it even though he finished step 2 Analyze: Data Capture 2 days ago server time. Could you look into this?

image.png 41.6 KB • Download

Séverine : please wait until Martin investigates this document and do not admin override.

Thank you,

Paul

Hi Paul , Harsh has not yet provided me with the script I need to collect more details, so I will not be able to troubleshoot until tomorrow at best.

Are we able to leave the document as-is until tomorrow? If so, Harsh could also attempt to directly investigate the issue when he comes in the office in about 12 hours from now.

Thanks,
-Martin

Understood Paul. I am reviewing another decision. 

Séverine

Hi Martin :

Yes, we can leave the document as-is until tomorrow, thanks.

Paul

Hi Martin ,

Following is the scrit which you checked on ISLGRebuildProduction Database.

Select ContentTypeDataMasterId, ContentTypeDataMAster.ModifiedOn, ViewerUserId, IsViewing, au.FirstName as UserName
From ContentTypeDataMAster 
Left Join AdminUsers au on au.AdminUserId = ContentTypeDataMAster.ViewerUserId
Where ContentTypeDataMasterId 
in (Select ContentTypeDataMasterId From ContentTypeData Where value = 'UN/0442/01')

You can replace UIN value which you need to check.

You need to Verify that Following columns should blank  or null. 

If columns will not blank/null then the ModifiedOn columnd datetime should be lesst then 2 hours. 

if Modifiedon is more than 2 hours and still the ViewUserId column will not null then it is issue.

I hope you get all things. if no then you can ask me in skype.

Hi Paul ,

We found the issue and it was in SQL Job query which is running every day. We have updated the query for Job and run the job manually by today.

Martin  will also set up that will get notification when Job will fail to run. 

Hi Harsh and Paul ,

The SQL job - which runs every 15 minutes - is now setup to send an email alert on failure.

Paul : The issue should be fully resolved, and documents should now be released as expected moving forward.

Thanks,
-Martin

Sounds good, Martin and Harsh .

Séverine : you can proceed with UN/0442/01.

Thanks,

Paul