Scatterplot tool - R.exe exit code indicated an error

[hdesai7]

Hello,

The scatterplot tools that are a part of my workflow are not working. They throw out a R.exe exit code error. To see if something was wrong with my data, I tried to check the official Alteryx scatterplot example. However, even this example isn’t working and giving the same error upon running the workflow. So, there seems to be nothing wrong with my data as the offiical Alteryx example also isn't working. 

I found some more information on this error in the Alteryx Community, and it seems to be experienced by quite a few people. The experts are saying it’s a fake error and can be resolved by ending the R-code with a gc() function. However, I couldn't find appropriate steps to take to go ahead with it.

knowledge.alteryx.com/index/s/article/Error-The-R-exe-exit-code-n-indicated-an-error 

community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/R-tool-Fake-Errors/td-p/25163 

Could someone give step-by-step instructions on how to add a gc() function to the R-code for the Scatterplot tool? I found this part extremely complicated and didn't know how to go about it. 

FYI - I use Alteryx on my Mac with Parallels since the Designer cloud platform doesn't have any Data investigation tools yet.

Alteryx version: Admin 2022.1, Predictive tool package for the same version has been installed.

[caltang]

The link you sent: https://knowledge.alteryx.com/index/s/article/Error-The-R-exe-exit-code-n-indicated-an-error

If you scroll down, you can see that if a tool has the R Tool logo on the bottom left indicates that it has R behind the scenes. Right click on your tool and click on Open Macro like so:

[caltang]

If you scroll down from there, you can see the R Tool backing this Scatterplot tool.

[hdesai7]

@caltang, yes I opened the Macro. But, how to add the gc() function to the R-code? Where do you input that? Thanks for your help.

[hdesai7]

@caltangI found the R tool below. Where do I include gc()?

 

I tried to include it at the end. But, it's not working when I reran the workflow.

[caltang]

You're right. you can include gc() at the end, then save the workflow. Go back to your original workflow, and your Scatterplot should work.

Don't run the workflow on the macro workflow - run it on your mainworkflow before you opened the macro. Make sure you saved your changes!

[hdesai7]

@caltang I am unable to save the .yxmc workflow when I include gc() at the end. See the message I get when I try to save it. It says Access to path is denied. Do you have a suggestion on how I can save it?

 

[caltang]

Did you download the R Tools using admin installer or non-admin installer? In addition, are you on your company machine or personal machine?

Depending on your answer, the resolution can be quite different.

[hdesai7]

@caltang admin installer. I am on a personal machine.

[caltang]

Okay - then follow this:

As per this: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/R-tool-is-not-added/td-p/82289 

If you installed admin version of alteryx: C:\Program Files\Alteryx\Settings\AdditionalPlugins 
If you installed non-admin version of alteryx: C:\Users\<<USERID>>\AppData\Local\Alteryx\Settings\AdditionalPlugins

 This is where you can find your path: