Schema related error when calling AFL (PAL) function from hdbprocedure

[former_member710183]

Hi everyone,

I want to write a procedure (as .hdbprocedure file) that itself calls AFL procedures (specifically PAL procedures). My code looks something like this:

PROCEDURE "randomforesttrain" ()
	LANGUAGE SQLSCRIPT AS
BEGIN
        /* Creating tables and stuff */
	CALL _SYS_AFL.PAL_RANDOM_DECISION_TREES (PAL_RDT_DATA_TBL, #PAL_PARAMETER_TBL, PAL_RDT_MODEL_TBL, ?, ?, ?) WITH OVERVIEW;
END

But when I try to build the hdbprocedure I get the following error:

Error: com.sap.hana.di.procedure: "_SYS_AFL"."PAL_RANDOM_DECISION_TREES": the reference has to be schema-local in "PROCEDURE" "randomforesttrain" [8250002]

I am inside a HDI Container so my schema is not SYS which might be related to the problem.

Any ideas what exactly this error means and/or how I could possibly fix it?

Thanks a lot in advance!

Best Regards,

Alex

[pfefferf · Accepted solution]

The blog post XS Advanced – how to access the predictive analysis library? covers that topic. In the blog post videos are linked explaining everything in detail.

[former_member710183 · Accepted solution]

Thanks a lot, this was exactly what I was looking for!