PAK: Internal PE error

[Former Member]

Hi Gurus,

i am facing some issues using the HANA PAK.

When i create a SQLscipt procedure as advised in SAP help

http://help.sap.com/saphelp_nw73/helpdata/de/d8/8c62391de045cb936ca2afd2a84c9a/content.htm

and the srcipt does nothing except:

E_T_TABLE = SELECT * FROM :I_VIEW;

Everything works, i.e. the scipt is getting executed and all key figures included in my agg. Level are doubled everytime i execute the planning function.

When i alter the above Statement slightly, for instance to

CREATE PROCEDURE SAPBT2.SP_YPAK_CL_DEMO_3( IN I_VIEW SAPBT2.TT_YPAKA003,

DECIMAL (000017, 000003) , 

OUT E_T_TABLE  SAPBT2.TT_YPAKA003 ) LANGUAGE SQLSCRIPT READS SQL DATA AS

BEGIN

DECLARE a INT ;

SELECT * FROM :I_VIEW ;

END

and execute in RSPLAN, i get the following Errors:

and

Same issue when removing the part

READS SQL DATA AS.

For creating a local temporary table. I always get some internal PE Errors.

While Debugging the SAP Planning Framework, i found out, that at runtime several views belonging to the planning session a created at HANA DB Level, which are queryable. But only when i have a procedure doing nothing but select.

There might be some issues with authorizations of the SAP<SID> user.

Do you have any ideas how i could proceed on that issue?

That would be highly appreciated.

THX in advance

Jonas

[former_member223971]

Hi Jonas,

Did you find a way to solve your issue

I encounter the same problem and cannot find a solution.

Thanks in advance.

Best regards,

Juan Pablo.