Prophet error

[albert_alaluf]

Hello,

I'm getting an error on Prophet in R on Alteryx 2019.4.

I'm using the sample model in https://gallery.alteryx.com/#!app/Rossmann-Sales-Forecast-with-Prophet/5df62d020462d70ec8089903

and I have the same version installed on my personal computer which it works fine.

Please see the error below.

Start: Designer x64: Started running D:\Downloads\alteryx\Rossmann+Sales+Forecast+with+Prophet\Rossmann Sales Forecast with Prophet.yxmd at 03/16/2020 10:08:48
Error: Prophet (23): Tool #15: Error in compileCode(f, code, language = language, verbose = verbose) :
Error: Prophet (23): Tool #15: Error in sink(type = "output") : invalid connection
Error: Prophet (23): Tool #15: Execution halted
Error: Prophet (23): Tool #15: The R.exe exit code (1) indicated an error.
Error: Prophet (22): Tool #15: Error in compileCode(f, code, language = language, verbose = verbose) :
Error: Prophet (22): Tool #15: Error in sink(type = "output") : invalid connection
Error: Prophet (22): Tool #15: Execution halted
Error: Prophet (22): Tool #15: The R.exe exit code (1) indicated an error.
Error: Prophet (19): Tool #15: Error in compileCode(f, code, language = language, verbose = verbose) :
Error: Prophet (19): Tool #15: Error in sink(type = "output") : invalid connection
Error: Prophet (19): Tool #15: Execution halted
Error: Prophet (19): Tool #15: The R.exe exit code (1) indicated an error.
End: Designer x64: Finished running Rossmann Sales Forecast with Prophet.yxmd in 2:56 minutes with 12 errors and 11 warnings

I do not change or modify anything, just open and run and got these errors. I couldn't find how to fix it. Any suggestions?

I believe it doesn't like something on my computer. I have R installed on my computer too, but I see the compiling messages and be sure it is running the R from Alteryx.

Thanks

Albert

[albert_alaluf]

I just run a clean install, didn't fix, I still getting the errors.

[CharlieS]

In case you didn't see the corresponding post on the Community, here's a link with more information about that macro:

https://community.alteryx.com/t5/Data-Science-Blog/Expand-Your-Predictive-Palette-III-I-Sales-Foreca... 

Hopefully that gives some useful configuration information. 

[albert_alaluf]

Hi Charlie,

The link you provided has Prophet macro which I'm not able to run and getting error. I also checked with my Alteryx server admin, he run on both his server and desktop, and getting the same error. Is there anything we miss?

[CharlieS]

Could you share screenshots of your workflow? Perhaps the original author, @TimothyL can be of service. 

[albert_alaluf]

please see below.

 

 

[albert_alaluf]

I believe there is something wrong with prophet. I tried with a very basic table and connect with R and use prophet library, always it returns an arrow. However any other R scripts work fine. Error is similar what I get there.

[WellyLiyanto]

Hi @albert_alaluf 

Just got the same problem with you and successfully solved it by :

Install Rtools to build R library at https://cran.r-project.org/bin/windows/Rtools/ (i use Rtools35.exe )

Install this list of R library (you can try using R package installer from here https://gallery.alteryx.com/#!app/Install-R-Packages/5d9264328a933711e447387c) or install it using R tools directly (for example, run this on R tools install.packages('rlang', repos='http://cran.us.r-project.org'))

• forecast
• prophet
• rBayesianOptimization
• dplyr
• lubridate
• rlang 

After that, the R prophet normally

[albert_alaluf]

Hi @WellyLiyanto 

Thank you for your suggestion, but I still get the same error. I previously installed R to this computer and I have a suspicion that the installation goes to the wrong folder. Can you please tell me the location of the library of R folder of Alteryx? I will try to install there within the tool.

Thanks

Albert

[WellyLiyanto]

Hi @albert_alaluf 

Hmm...Interesting, can you try to run the workflow I have attached and show the details log to me?

Also for Alteryx R install folder, you can find it at C:\Program Files\Alteryx\R-3.5.3

Cheers