HANA PAL : required data for execution not found

[schfer_christian]

Hello, i have this Error, if execute our PAL function first time after HANA starting.:

search table error:  [2620] ...

InternalFatal exception: executor: plan operation failed;required data for execution not found

This Error is only appears one time. Do have someone a solution or the same problem ?

Info: Scriptserver is running.

Thx for Help

[Former Member]

Hi Christian,

From the PAL Dokumentation (http://help.sap.com/hana/hana_dev_pal_en.pdf)

Step 1 – Create the AFL_WRAPPER_GENERATOR Procedure

Before using any AFL function, you need to create the AFL_WRAPPER_GENERATOR procedure. It is used to generate a wrapper for the AFL functions that take tables with a variable number of columns as inputs. This procedure only needs to be created once by the user SYSTEM.

1. Go to /hanamnt/<SID>/HDB <instance_number>/exe/plugins/afl/ and execute the afl_wrapper_generator.sql script file.

Note

This step needs to be performed each time after the HANA instance is restarted

HTH

--Juergen

[schfer_christian]

Hi Juergen, thx for your answer.

Our function runs correct after run once with this error.

Our steps:

1. Start HANA on AWS

2. Call Function from PAL  (.... READS SQL DATA WITH RESULT VIEW V_FORECAST...)

3. The Error appears

4. Call Function from PAL  (.... READS SQL DATA WITH RESULT VIEW V_FORECAST...)

5. All works fine.

All without running AFL_WRAPPER_GENERATOR Procedure on HANA Startup

Because this Function i think is only needed if you want to create and use new PAL - Functions

But why ?

We use SQL Script as input for the PAL- Function an use the result as a View to get actual forecasts. Is that a problem ?

thx for Help