cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MatthewGrantAU
Level: Powered On

Flow causing error code 423 file locked by user

Hi,

 

I keep getting error 423 locked by user in a flow since Aug 31 5:13am.

The log shows consistent successful flows until this date, and then it is only successful once every couple of hours.

 

eg:

Sep 10, 10:28 AM (16 min ago)
00:00:04
Succeeded
Sep 10, 9:58 AM (46 min ago)
00:00:04
Failed
Sep 10, 9:28 AM (1 h ago)
00:00:04
Failed
Sep 10, 8:58 AM (1 h ago)
00:00:03
Failed
Sep 10, 8:28 AM (2 h ago)
00:00:02
Succeeded
Sep 10, 7:58 AM (2 h ago)
00:00:02
Failed
Sep 10, 7:28 AM (3 h ago)
00:00:03
Failed
Sep 10, 6:58 AM (3 h ago)
00:00:02
Failed
Sep 10, 6:28 AM (4 h ago)
00:00:02
Failed
Sep 10, 5:58 AM (4 h ago)
00:00:02
Failed
Sep 10, 5:28 AM (5 h ago)
00:00:01
Failed
Sep 9, 9:58 PM (12 h ago)
00:00:02
Failed
Sep 9, 9:28 PM (13 h ago)
00:00:02
Failed
Sep 9, 8:58 PM (13 h ago)
00:00:03
Failed
Sep 9, 8:28 PM (14 h ago)
00:00:02
Succeeded
Sep 9, 7:58 PM (14 h ago)
00:00:03
Failed
Sep 9, 7:28 PM (15 h ago)
00:00:02
Succeeded
Sep 9, 6:58 PM (15 h ago)
00:00:02
Failed
Sep 9, 6:28 PM (16 h ago)
00:00:02
Failed
Sep 9, 5:58 PM (16 h ago)
00:00:03
Failed
Sep 9, 5:28 PM (17 h ago)
00:00:02
Failed
Sep 9, 4:58 PM (17 h ago)
00:00:05
Failed
Sep 9, 4:28 PM (18 h ago)
00:00:03
Succeeded

 

 

The Flow copies an excel file from an FTP source and writes it in Onedrive for Business.  This triggers every 30 minutes.

 

 

The Excel file in Onedrive is NEVER opened by any user.  Only Flow writes to the file.

I can test open and save it from Excel application and I get no lock error.

 

There is no logic problem in the flow, as the flow can work successfully intermittently, and was always successful until Aug 31.

 

 

thanks for your help, Matt.

 

 

I think the Flow ID is 299ee131-ca96-4027-bb90-1e9c949f04f2

 

Screen Shot 2018-09-10 at 10.28.42.pngScreen Shot 2018-09-09 at 08.04.01.png

JBHorne
Level: Power Up

Re: Flow causing error code 423 file locked by user

Same issue here. I have a Create Table action and then immediately need to Get Rows from that table. The Create Table action though doesn't release the lock on the file when it's done with it. Files are on OneDrive.

 

Previously I was using the "List rows present in a table" action, which was working, but found out the hard way this is (stupidly) limited to 256 rows with no workaround.

JBHorne
Level: Power Up

Re: Flow causing error code 423 file locked by user

Same issue here. I have a Create Table action and then immediately need to Get Rows from that table. The Create Table action though doesn't release the lock on the file when it's done with it. Files are on OneDrive.

 

Previously I was using the "List rows present in a table" action, which was working, but found out the hard way this is (stupidly) limited to 256 rows with no workaround.

Community Support Team
Community Support Team

Re: Flow causing error code 423 file locked by user

Hi @MatthewGrantAU,

 

 

I used to encounter the same issue when I used Excel Online.

 

This is a mechanism of Excel Online, which will check out or lock when others edit content. Sometimes the file is locked by another user, and other times the "another user" is actually you.

 

Here Flow can be seen as a user. Its request can be seen as the user's operation.

 

Generally, I have to operate for a while, so that it will automatically check in.

 

Maybe the link below could help you a little:

 

https://powerusers.microsoft.com/t5/Using-Flows/Microsoft-Flow-Excel-File-Locked-While-Not-Open/m-p/...

 

https://support.office.com/en-us/article/excel-file-is-locked-for-editing-by-another-user-6fa93887-2...

 

Best Regards,

Barry

adhuko
Level: Powered On

Re: Flow causing error code 423 file locked by user

I'm also experiencing issues with 423 errors which are driving me mad.

I'm using a Flow to fill in a "template" Excel file, then copy it to another location before resetting the template. Everything was working perfectly until two weeks ago: my template file is now locked 24/7 and every single flow fails.

 

I've made a copy of the template in another folder which I've been using since. This worked for about a week, and now this second file is also locked permanently.

 

I should add that absolutely no one has access to the files besides the Flow.

 

I haven't been able to find a solution yet...

 

 

MatthewGrantAU
Level: Powered On

Re: Flow causing error code 423 file locked by user

Thanks Barry,

 

Unfortunately, there is nothing to help me in these links.

Suggesting things like 'close the file', 'notify the locking user', 'wait an (unspecified amount) of time', are good initial troubleshooting steps, but this is an issue with FLOW not closing EXCEL files stored in ONEDRIVE FOR BUSINESS.

  • Flow opens and closes the file - we have no control over this function.
  • Flow is the only 'user' that accesses the file - there is no one else to notify about the issue.
  • This is three Microsoft cloud services that are not working together correctly - It is a Microsoft problem.
  • Waiting for the file to unlock is not a useful suggestion, when we are not told how long the lock holds for.  eg. My flow only triggers every 30 minutes and the lock error occurs 75-85% of runs; mostly, but not always.  If a flow can only trigger a file write to OneDrive once an hour, or even less, then the function is basically unusable.
  • This flow was running – without failures– for weeks and weeks, and then on Aug 31, suddenly began failing over 75% of runs, with no user intervention - there must be a flow-onedrive connector fault somewhere.

We (me and the many other users in the forum with these flow-related 423 errors) need Microsoft to please have a deeper look at this file lock problem and sort it out.

 

regards,
Matt

 

adhuko
Level: Powered On

Re: Flow causing error code 423 file locked by user

Hi Matt,

 

Are you, by any chance, using different Excel connectors inside the same flow? I.e. Excel, then Excel (OneDrive) or Excel (Business)?

 

Adrien

Highlighted
Super User
Super User

Re: Flow causing error code 423 file locked by user

How are you running your create table? Is your create table always run and then on failure you just continue with the next step? Or are you avoiding the create table if the table already exists?

 

 

JBHorne
Level: Power Up

Re: Flow causing error code 423 file locked by user

@Pieter_Veenstra, I do not know if @MatthewGrantAU is using a Create Table action, but I am. These excel files will never have a table, and there's no way to get rows without one, so we create one first. Basically, the failure now brings the entire flow to a compelte halt. We have ZERO work around.

JBHorne
Level: Power Up

Re: Flow causing error code 423 file locked by user

@adhuko here's the part where this fails. Even a delay of 1 hour doesn't work...

 

2018-09-13_13-13-10.png

>