Skip to Content
avatar image
Former Member

HANA autoARIMA max_order error

Trying to run autoarima on HANA SPS12

With SEARCH_STRATEGY = 1 (stepwise) the call fails on invalid max_order, even though manual says max_order is not used if SEARCH_STRATEGY = 1.

I've tried many parm combinations but have not been able to get this passed the error. There are over 800 of these series', and maybe 15 fail. Others with similar data points pass (quantity and values).

Thanks for any input.

Error:

Could not execute 'CALL "X"."Z::auto_arima"("X"."YY")' in 243 ms 828 µs .

SAP DBTech JDBC: [423]: AFL error: search table error: "X"."Z::auto_arima"(": line 5 col 1 (at pos 206): [423] (range 3) AFL error exception: _SYS_AFL.AFLPAL:AUTOARIMA: [423] (range 3) AFL error exception: exception 73001043: PAL error[73001043]:Value [14] of parameter MAX_ORDER is invalid.

Data:

SERIES MEASURE_AMT 2017213 839,711 2017214 1,365,617 2017221 864,472 2017222 863,536 2017230 744,655 2017233 675,595 2017234 689,503 2017235 692,291 2017236 694,935 2017237 697,275 2017240 689,447 2017242 703,435 2017243 706,407 2017244

777,455

PARMS:

NAME INTARGS DOUBLEARGS STRINGARGS SEASONAL_PERIOD 0 ? ? SEASONALITY_CRITERION 0 0.2 ? D -1 ? ? KPSS_SIGNIFICANCE_LEVEL ? 0.05 ? MAX_D 2 ? ? SEASONAL_D -1 ? ? CH_SIGNIFICANCE_LEVEL ? 0.05 ? MAX_SEASONAL_D 1 ? ? MAX_P 5 ? ? MAX_Q 5 ? ? MAX_SEASONAL_P 2 ? ? MAX_SEASONAL_Q 2 ? ? INFORMATION_CRITERION 0 ? ? SEARCH_STRATEGY 1 ? ? MAX_ORDER 14 ? ? INITIAL_P 0 ? ? INITIAL_Q 0 ? ? INITIAL_SEASONAL_P 0 ? ? INITIAL_SEASONAL_Q 0 ? ? GUESS_STATES 1 ? ? ALLOW_LINEAR 1 ? ? FORECAST_METHOD 1 ? ? MAX_SEARCH_ITERATIONS 324 ? ? METHOD 1 ? ? THREAD_RATIO -1 ? ?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers