Skip to Content

Problem calling HANA PAL function due to very long time running command

Hi,

We have a HANA procedure in SAP Business One system that computes a time series forecast, using PAL functions.

This procedure usually is very fast, and takes between 5 and 10 seconds to compute the forecast, for a set of maximum 1000 entries.

The problem is that sometimes the procedure takes a very long time to compute (approximately 60 to 70 minutes - 500 times more slow!) although the returned result seems correct. When we analyze the process in HANA studio this is the step were it hangs:

CALL"PAL"."SBSS_ARIMA_ADDON_FORECAST...

We need to stop this process if it takes more then 60 seconds, otherwise HANA system becomes very slow. Is there any way to stop the process gracefully via a HANA/SQL command? We tried to CANCEL linked process/thread in HANA studio but it does not work...

Please help,

Thanks

Manuel Dias

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Sep 15, 2017 at 03:14 PM

    Hi Manuel,

    Some algorithms (ag: association analysis) provide a TIMEOUT parameter.

    Otherwise you might try the "ALTER SYSTEM CANCEL [WORK IN] SESSION" statement for the session in question?

    https://help.sap.com/viewer/4fe29514fd584807ac9f2a04f6754767/2.0.02/en-US/20d0eb287519101498c4ecb8114cab17.html

    However I'm not sure how many PAL algorithms support being canceled in this way.

    Philip

    SAP HANA Academy

    Add comment
    10|10000 characters needed characters exceeded