Advanced Designer Learning Path is now live! Read More

Error while executing Forecast Recipe

Level 1
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
3 Replies
Dataiker
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
Level 1
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
Dataiker
Dataiker

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
Labels (2)
A banner prompting to get Dataiku DSS