Skip to Content
avatar image
Former Member

Error while delegating Predictive Analytics model learning to HANA server

Hi Team,

I am trying to run Time series algorithm using SAP Predictive Analytics 3.1 using HANA tables for source data.

I am getting below error when i try delegating the model learning to HANA server.

---

Checking internal state.

ODBC Block insertion into "MYSCHEMA"."TO_LEARN_MODEL_314504" has been activated and prepared.

Global performances of bulk insertion into "MYSCHEMA"."TO_LEARN_MODEL_314504":

Global import time: 3678

Global transaction time: 224

Global records insertion time: 2818

Table "MYSCHEMA"."TO_LEARN_MODEL_314504" finalization time : 0

Global records generation time: 636

Number of inserted records: 1266

Global number of records/s: 344

Global number of insertions/s: 344

Delegating the learning phase to APL...

Message from ODBC: SQLExecDirect: [42S02][SAP AG][LIBODBCHDB DLL][HDBODBC] Base table or view not found;259 invalid table name: search table error: "SAP_PA_APL"."sap.pa.apl.base.internal::DO_LEARN": line 32 col 4 (at pos 1433): [259] (range 3) invalid table name exception: invalid table name: Could not find table/view #L_FUNCTION_HEADER in schema MYSCHEMA: line 1 col 142 (at pos 141) (please check lines: 32)

The learning phase could not be delegated to APL. Please check the full searchable help available online for additional information.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Apr 25, 2017 at 09:19 AM

    Hi,

    You are using a pretty old version of the APL and a recent version of the Predictive tools, which I think is not right as per the PAM.

    Regarding the location of "your" table, you can set them wherever you want. But the APL will create temporary objects, and these object should be created in the SAP_PA_APL schema, and not yours or any other.

    What version of HANA are you running?

    You should definitely upgrade your APL version if you want to continue using the 3.1 version of the predictive tool.

    @bdel

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 21, 2017 at 12:20 PM

    Hi,

    Might be a silly question but did you install the SAP HANA APL on your HANA box?

    If yes then you should see a schema named SAP_PA_APL.

    If not you may not have the proper role assigned to your user. As per the documentation, you should have your user setup with the sap.pa.apl.base.roles::APL_EXECUTE role.

    Hope this helps.

    Add comment
    10|10000 characters needed characters exceeded