Skip to Content
0

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

Sep 15, 2017 at 01:37 PM

43

avatar image

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

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

1 Answer

Best Answer
Philip Mugglestone
Sep 15, 2017 at 03:14 PM
1

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

Share
10 |10000 characters needed characters left characters exceeded