Error while executing Forecast Recipe

rennyjosetm
Level 1
Error while executing Forecast Recipe

I get the following error when trying to execute Forecast Plugin - Any Idea where I am going wrong ?

 

[2020/12/05-23:09:41.809] [FRT-33-FlowRunnable] [INFO] [dku.flow.activity] - Run thread failed for activity compute_Citi-Impacting-R-Forecast_NP
com.dataiku.common.server.APIError$SerializedErrorException: Error in R process: simpleError :  missing value where TRUE/FALSE needed
	at com.dataiku.dip.dataflow.exec.AbstractCodeBasedActivityRunner.handleErrorFile(AbstractCodeBasedActivityRunner.java:208)
	at com.dataiku.dip.dataflow.exec.AbstractCodeBasedActivityRunner.handleExecutionResult(AbstractCodeBasedActivityRunner.java:173)
	at com.dataiku.dip.dataflow.exec.AbstractCodeBasedActivityRunner.execute(AbstractCodeBasedActivityRunner.java:109)
	at com.dataiku.dip.recipes.code.r.AbstractRRecipeRunner.executeScript(AbstractRRecipeRunner.java:39)
	at com.dataiku.dip.recipes.customcode.CustomRRecipeRunner.run(CustomRRecipeRunner.java:66)
	at com.dataiku.dip.dataflow.jobrunner.ActivityRunner$FlowRunnableThread.run(ActivityRunner.java:380)
[2020/12/05-23:09:42.004] [ActivityExecutor-28] [INFO] [dku.flow.activity] running compute_Citi-Impacting-R-Forecast_NP - activity is finished
[2020/12/05-23:09:42.005] [ActivityExecutor-28] [ERROR] [dku.flow.activity] running compute_Citi-Impacting-R-Forecast_NP - Activity failed
com.dataiku.common.server.APIError$SerializedErrorException: Error in R process: simpleError :  missing value where TRUE/FALSE needed
	at com.dataiku.dip.dataflow.exec.AbstractCodeBasedActivityRunner.handleErrorFile(AbstractCodeBasedActivityRunner.java:208)
	at com.dataiku.dip.dataflow.exec.AbstractCodeBasedActivityRunner.handleExecutionResult(AbstractCodeBasedActivityRunner.java:173)
	at com.dataiku.dip.dataflow.exec.AbstractCodeBasedActivityRunner.execute(AbstractCodeBasedActivityRunner.java:109)
	at com.dataiku.dip.recipes.code.r.AbstractRRecipeRunner.executeScript(AbstractRRecipeRunner.java:39)
	at com.dataiku.dip.recipes.customcode.CustomRRecipeRunner.run(CustomRRecipeRunner.java:66)
	at com.dataiku.dip.dataflow.jobrunner.ActivityRunner$FlowRunnableThread.run(ActivityRunner.java:380)
[2020/12/05-23:09:42.005] [ActivityExecutor-28] [INFO] [dku.flow.activity] running compute_Citi-Impacting-R-Forecast_NP - Executing default post-activity lifecycle hook
[2020/12/05-23:09:42.007] [ActivityExecutor-28] [INFO] [dku.flow.activity] running compute_Citi-Impacting-R-Forecast_NP - Removing samples for TICKETANALYTICSFORECASTING.Citi-Impacting-R-Forecast 

 

0 Kudos
4 Replies
ATsao
Dataiker

Hi rennyjosetm,

Could you clarify which of the three recipes you are trying to use from the Forecast plugin when you get this error? Also, can you share a screenshot of your recipe settings page? 

From the error provided, it's expecting a true/false value from one of your columns but getting a null value instead. You may want to review your input datasets to make sure that the data is all correct. 

Thanks,

Andrew

0 Kudos
rennyjosetm
Level 1
Author

I was using the Forecast Recipe -  Forecast future values and get historical residuals. There are only two Fields - Date and Total Ticket Count , Date has been parsed in ISO Date format during preparation

 

Attached Document has the Forecast Setting . 

0 Kudos
Alex_Combessie
Dataiker Alumni

Hi,

Unfortunately, a PDF with a screenshot of the recipe settings is not sufficient for us to diagnose the issue.

Could you please send us a job diagnosis by following this procedure?

If the resulting file is too large for mail (> 15 MB), you can use https://dl.dataiku.com to send it to us. Please don't forget to send the link that is generated when you upload the file.

Best regards,

Alex

0 Kudos
Alex_Combessie
Dataiker Alumni

Hi @rennyjosetm

We are proud to announce that we just released a new Forecast plugin. It is based in Python, so its installation is much simpler 😎

On top of this, you will benefit from the latest Deep Learning models from GluonTS such as DeepAR and Transformer.

Give it a try, let us know what you think, and reshare if you like it ❤️

Cheers,

Alex