cancel
Showing results for 
Search instead for 
Did you mean: 

[PAL] Trying to change PAL Procedure from Academy from older SPS to SPS9 - Error

Former Member
0 Kudos

Hey Experts,

PAL/PAL 36 Social Network Analysis - Link Prediction.sql at master · saphanaacademy/PAL · GitHub

I am trying to work with the social network analysis copied from above. I tried to change the callings because of the changes of SPS9.

I changed:

CALL SYSTEM.AFL_WRAPPER_GENERATOR ('PAL_LP', 'AFLPAL', 'LINKPREDICTION', PAL_LP_SIGNATURE);

to

CALL "SYS"."AFLLANG_WRAPPER_PROCEDURE_CREATE" ('AFLPAL', 'LINKPREDICTION', 'MYSCHEMA', 'PAL_LP', PAL_LP_SIGNATURE);

Now i get this error here:

Could not execute 'CALL "SYS"."AFLLANG_WRAPPER_PROCEDURE_CREATE"('AFLPAL', 'LINKPREDICTION', 'MYSCHEMA', 'PAL_LP', ...' in 30 ms 332 µs .

SAP DBTech JDBC: [260]: invalid column name:  [260] invalid column name: POSITION: line 1 col 9 (at pos 8)Please check lines:

Do i have to change something else? I checked the documentation but couldn't solve my issue.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

I also have the same problem, and get this error. There is still no way to solve the Problem?

Former Member
0 Kudos

i didn't get a solution yet. I am using the PAL Documentation example codes, but the hana academy code would be a way better.

Former Member
0 Kudos

I'm having the same problem, and getting the same result.  Did you find any way to make it work?

Former Member
0 Kudos

Nope 😕