Plugin Forecasting : 'ts' object must have one or more observations

Ares777

Hi,

I am using the Forecasting plugin and when I run the first step of cleaning I am receiving the next error:

[2019/06/19-13:58:42.205] [FRT-34-FlowRunnable] [INFO] [dku.flow.activity] - Run thread failed for activity compute_clean_NP
com.dataiku.common.server.APIError$SerializedErrorException: Error in R process: simpleError :  'ts' object must have one or more observations
	at com.dataiku.dip.dataflow.exec.AbstractCodeBasedActivityRunner.handleErrorFile(AbstractCodeBasedActivityRunner.java:186)
	at com.dataiku.dip.dataflow.exec.AbstractCodeBasedActivityRunner.handleExecutionResult(AbstractCodeBasedActivityRunner.java:166)
	at com.dataiku.dip.dataflow.exec.AbstractCodeBasedActivityRunner.execute(AbstractCodeBasedActivityRunner.java:102)
	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:366)
[2019/06/19-13:58:42.401] [ActivityExecutor-29] [INFO] [dku.flow.activity] running compute_clean_NP - activity is finished
[2019/06/19-13:58:42.402] [ActivityExecutor-29] [ERROR] [dku.flow.activity] running compute_clean_NP - Activity failed
com.dataiku.common.server.APIError$SerializedErrorException: Error in R process: simpleError :  'ts' object must have one or more observations
	at com.dataiku.dip.dataflow.exec.AbstractCodeBasedActivityRunner.handleErrorFile(AbstractCodeBasedActivityRunner.java:186)
	at com.dataiku.dip.dataflow.exec.AbstractCodeBasedActivityRunner.handleExecutionResult(AbstractCodeBasedActivityRunner.java:166)
	at com.dataiku.dip.dataflow.exec.AbstractCodeBasedActivityRunner.execute(AbstractCodeBasedActivityRunner.java:102)
	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:366)

My data follows the next structure:

Date_Parsed | Products

1949-01-01T00:00:00.000Z 200

1949-02-01T00:00:00.000Z 150

...........

144 more rows

The specify the plugin Forecasting that I am using, it is the plugin "Forecasting Dataiku (Alex Combessie)"

Thank so much

Ares

Alex_Combessie

Hi,

(public answer after exchanges on the customer support channel)

This issue is specific to your data. There was a special character in one of your columns, which changes the name of the column comared to the one you specified in the recipe.

We advise to rename the column beforehand using a Prepare recipe, to remove all special characters as documented on: https://stat.ethz.ch/R-manual/R-devel/library/base/html/make.names.html

Best regards,

Alex