Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Prophet error

albert_alaluf
9 - Comet

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

16 REPLIES 16
albert_alaluf
9 - Comet

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

CharlieS
17 - Castor
17 - Castor

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
9 - Comet

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
17 - Castor
17 - Castor

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

albert_alaluf
9 - Comet

please see below.

 

1.PNG

2.PNG

 

 

albert_alaluf
9 - Comet

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
8 - Asteroid

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
9 - Comet

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
8 - Asteroid

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

Labels