Continue workflow after input error

I'm building a workflow that should always continue if the error File used by other process occurs.

Error: Input Data (34): Error opening the file "[location/name]": The process cannot access the file because it is being used by another process. (32)

the file i'm accessing is a log file that if it is being written to (by other proces) the workflow i'm building should continue with default values if the log file is still in use by the other process.

I'm wondering if this is possible.

Workflow

Accepted answers

atcodedog05

Hi @MartWClimber

Since it's an input file it is not possible for the workflow to proceed without the input data loaded in.

Hope this helps : )

All comments

atcodedog05

Hi @MartWClimber

Since it's an input file it is not possible for the workflow to proceed without the input data loaded in.

Hope this helps : )

MartWClimber

@atcodedog05 yea, that was what i'm afraid of. Thanks for the quick response

Well that means I need to schedule this workflow right after the log workflow.

Seems a great job for the crew runner macro

ChrisTX

Here's a somewhat related post: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Input-Data-resume-on-error/m-p/839100#M206374

You could determine if the file is locked, then pass either the unlocked file or a default file to a Dynamic Input tool. Attached is a sample workflow.

Here's some code from another language that writes out and runs a Powershell script, to check for a file lock:

"LIST UNFORMATTED" translates to "write to a text file"

com ************************************************************************************
com Determine if file is locked
com ************************************************************************************

LIST UNFORMATTED "try {" APPEND TO "%folder_name%powershell_script.ps1"
LIST UNFORMATTED " [IO.File]::OpenWrite($InputFolderAndFile).Close();" APPEND TO "%folder_name%powershell_script.ps1"
LIST UNFORMATTED " $host.SetShouldExit(100); # file is NOT locked by a process" APPEND TO "%folder_name%powershell_script.ps1"
LIST UNFORMATTED "}catch {" APPEND TO "%folder_name%powershell_script.ps1"
LIST UNFORMATTED " $host.SetShouldExit(101); # file IS locked by a process" APPEND TO "%folder_name%powershell_script.ps1"
LIST UNFORMATTED "};" APPEND TO "%folder_name%powershell_script.ps1"

com ************************************************************************************
com Run the Powershell script and set the output variable
com ************************************************************************************

EXECUTE "powershell.exe -ExecutionPolicy Bypass -NoLogo -NonInteractive -NoProfile -WindowStyle Hidden ""& '%folder_name%powershell_script.ps1'"""

ASSIGN v_Return_Code = RETURN_CODE

Chris

Continue workflow after input error.yxzp

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15879

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703