Skip to Content

Problem with CALL "P_ARIMA" in HANA 2.0 PAL

Aug 29, 2017 at 01:08 PM


avatar image

Hi all,

We have a sales map that generates sales estimations based on a HANA 1.0 and we need to upgrade it to version HANA 2.0.

During the upgrade process of our sales map, we are facing an error when training an ARIMA model via this call:


In HANA 2.0 SP2, we get the following error:

"SAP DBTech JDBC: [328]: invalid name of function or procedure: no procedure with name P_ARIMA found".

Part of map computation process is based on the ARIMA algorithm, explained SAP HANA Academy example "PAL 110 Time Series - Auto ARIMA Model".

Does anybody know how to convert this process to HANA 2.0?

Kind Regards


10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Florian Pfeffer
Aug 29, 2017 at 08:32 PM

In HANA system <= HANA 2.0 SPS01 wrapper PAL procedures had to be created with procedure SYS.AFLLANG_WRAPPER_PROCEDURE_CREATE. So the procedure P_ARIMA is a such a generated wrapper procedure. The question is if you have updated your HANA 1.0 system to a HANA 2.0 system or do you work on a new HANA 2.0 installation on which the generated wrapper procedure is not available. Please check this.

If you are you have to regenerate it - on HANA system <= 2.0 SPS01 -, you have to do that using the procedure "SYS".AFLLANG_WRAPPER_PROCEDURE_CREATE (check the documentation here). In HANA system >= 2.0 SPS02 you can use the available procedure _SYS_AFL.PAL_ARIMA (check the documetnation here). There is no need anymore on such systems to generate a wrapper procedure.


10 |10000 characters needed characters left characters exceeded