Time Series Macro Issue

[Billigans]

Hello All, 

I get the following errors when I run a time series batch macro for ARIMA modeling with a covariate. The macro is running each SKU in batches. The error does not appear when I run the same record set in the actual macro, only when I run it in the wrapper. Any help is greatly appreciated. 

ARIMA Covar. Factory Macro (3) Record #1: Tool #14: ARIMA: Error in matrix(covar.vec, nrow = length(covar.vec), ncol = 1, dimnames = list(1:length(covar.vec), :
ARIMA Covar. Factory Macro (3) Record #1: Tool #14: ARIMA: Execution halted
ARIMA Covar. Factory Macro (3) Record #1: Tool #14: Tool #35: Tool #6: No valid fields were selected.
ARIMA Covar. Factory Macro (3) Record #1: Tool #14: Tool #46: Tool #6: No valid fields were selected.
ARIMA Covar. Factory Macro (3) Record #1: Tool #14: Tool #51: Tool #6: No valid fields were selected.
ARIMA Covar. Factory Macro (3) Record #1: Tool #14: ARIMA: The R.exe exit code (1) indicated an error.
ARIMA Covar. Factory Macro (3) Record #1: Tool #18: ARIMA: Error in ts(the.y, frequency = freq, start = strt) :
ARIMA Covar. Factory Macro (3) Record #1: Tool #18: ARIMA: Execution halted
ARIMA Covar. Factory Macro (3) Record #1: Tool #18: Tool #35: Tool #6: No valid fields were selected.
ARIMA Covar. Factory Macro (3) Record #1: Tool #18: Tool #46: Tool #6: No valid fields were selected.
ARIMA Covar. Factory Macro (3) Record #1: Tool #18: Tool #51: Tool #6: No valid fields were selected.
ARIMA Covar. Factory Macro (3) Record #1: Tool #16: An empty or invalid spatial object was found. Consider filtering them out if you are using Spatial Statistics.
ARIMA Covar. Factory Macro (3) Record #1: Tool #17: No valid fields were selected.
ARIMA Covar. Factory Macro (3) Record #1: Tool #16: Tool #25: Tool #6: No valid fields were selected.
ARIMA Covar. Factory Macro (3) Record #1: Tool #16: TS Forecast: The model NA is not an allowed time series model.
ARIMA Covar. Factory Macro (3) Record #1: Tool #18: ARIMA: The R.exe exit code (1) indicated an error.

[rkapoor · Accepted solution]

Hi there

One of your issues were the NULLs present in Sum_Rev and Item#.

I have created a sample workflow as attached with the TS Model Factory tool.  I think it is a better one for you to understand what is happening.

Ultimately you do not have enough data for each item# group to produce a time series or to create a forecast.