Alteryx Designer

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Prophet error

Highlighted
7 - Meteor

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

Highlighted
7 - Meteor

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

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

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. 

Highlighted
7 - Meteor

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?

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

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

Highlighted
7 - Meteor

please see below.

 

1.PNG

2.PNG

 

 

Highlighted
7 - Meteor

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.

Highlighted
Alteryx Partner

Hi @avialaluf 

 

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

 

Highlighted
7 - Meteor

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

Highlighted
Alteryx Partner

Hi @avialaluf 

 

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

Labels