Error while executing Forecast Recipe

[rennyjosetm]

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 

[ATsao]

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

[rennyjosetm]

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 . 

[Alex_Combessie]

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