Capturing Error on Alteryx Flow

[amsrivastav]

Hello everyone!

I've encountered an issue while executing the flow—it fails and returns the message "File is in use."

I aim to provide a customized error message whenever Alteryx fails due to a file being open. I attempted to use the Test Tool, Message Tool, and Field Info, but unfortunately, I couldn't achieve the desired outcome.

Any suggestions would be greatly appreciated!

Thank you,

Amit

[jdminton]

Hello @amsrivastav , you can do this with a control container. Add the input tool into a control container and filter for the messages you are needing. Once you have those, you should be able to share the output with a user.

 

[amsrivastav]

HI @jdminton 

Thanks for the reply.

I have used BLOCK UNTIL DONE tool etc. which are not supported to use with CONTROL CONTAINER, so I will not be able to use Control Container.

Is there any other way as well via which we can accomplish this.

Thanks

Amit 

[jdminton]

The control container contains the functionality of block until done. You can modify your workflow to use this instead of block until done. There is a way to get the results pane data out, but it would involve using another tool, I believe. Since Alteryx added the control container functionality though, I'm guessing that method has been abandoned by users.

[amsrivastav]

Hi @jdminton ,

I acknowledge your point that using a CONTROL CONTROLLER will achieve the same functionality as Block Until Done.

However, my Alteryx flow is considerably complex and extensive, making it impractical to rewrite the entire flow based on a Control Container.

Thus, I find myself unable to incorporate a Control Container into my workflow.

Could you please suggest any alternative workaround that would fulfill my requirements?

Thank you for your assistance.

Best regards,

Amit

[jdminton]

The only other way would involve reading the results pane after the workflow completes. To do that, you would need to edit your user settings to output a log for each workflow and bring those results back into a workflow or some other tool to provide the user message:

 

The problem I see with this is that if the user is running on another machine, you would need them to change their user settings. I'm not sure how if it's running from Alteryx Server. Hopefully that helps!

 

[amsrivastav]

Hi @jdminton 

Thank you for your response.

Indeed, this could pose a challenge. Additionally, it would result in receiving the error message generated by Alteryx once more, whereas I require a customized error message.

Please suggest!!

Best regards,

Amit

[jdminton]

I'm not sure what you mean by "receiving the error message generated by Alteryx once more". Can you provide anything that helps explain your situation? Is this an app or workflow? Where is the user running it, desktop or server? Why do you need to generate the message? Why customized? 

[amsrivastav]

Hi @jdminton

What I mean here: "receiving the error message generated by Alteryx once more" : If we change the setting and capture the error message, it will again be the error message generated by the Alteryx.

My requirement is when Alteryx failed, I want to display error message as " FILE IS OPENED" this is what I meant for customized message and I know, it's weird but its a client request.

Other info: This workflow will be executed on DESKTOP and its a Standard Workflow.

Regards
Amit

[jdminton]

 the user is unable to understand the error message that the file is in use? If the user is running the workflow, I don't understand the need for a different error message.

That aside. I was pointing out a way for you to read in the message that there is an error. You can pull the latest log date and read for that error message and output the translation "File is opened" for the user in the same workflow. The trick will be getting it to run at the same time. 

I just tested this method below and it does work, but I'm not sure if it will update the directory tool while the workflow is running. Try setting it up on your end and test.