This post attempts at helping you diagnose and fix problem with executing APL components in Expert Analytics.

Symptom: Executing an analysis on HANA with Model Compare, Model Statistics and/or components prefixed with HANA Auto fails with errors relating to PROCEDURE_SIGNATURE_T.

Solution:

Step 1: Check the user you log in which has been configured to use APL.

Go to HANA server instance in HANA studio and try to find the table PROCEDURE_SIGNATURE_T.

Find PROCEDURE_SIGNATURE_T.png

In the snapshot above, the user TEST is the only user configured to use APL and any other user trying to use APL will get the table related error. If the search doesn’t return the table, it indicates the configuration is incomplete and follow the Step 2 below to fix it.

Step 2: Configure APL for every user that will use it from Expert Analytics

The HANA APL user guide explains the steps to install and configure APL (http://help.sap.com/pa) under section 2.1.5. There is a set of SQL scripts that need to be run for every user that needs access to APL. Here is a snippet:

connect USER_APL password Password1;

drop type PROCEDURE_SIGNATURE_T;

create type PROCEDURE_SIGNATURE_T as table (

    “POSITION” INT CS_INT,….

The USER_APL should be replaced by individual user ids that will use APL and entire script should be re-executed.

Once done, login with that user to HANA from Expert Analytics and all APL components including Model Compare and Statistics should run fine.

To report this post you need to login first.

9 Comments

You must be Logged on to comment or reply to a post.

  1. Abdessamad EL-BAHY

    Hi Jayanta Roy,

    When i search on hana studio, i don’t find the table PROCEDURE_SIGNATURE_T. what can i do to create it.

    Can you develop the creation of that table please:

    create type PROCEDURE_SIGNATURE_T as table (

        “POSITION” INT CS_INT,….


    Best regards,

    Abdess

    (0) 
      1. Abdessamad EL-BAHY

        Hi Antoine,

        Under the section 2.1.5 there is this syntax :

        create type PROCEDURE_SIGNATURE_T as table ( “POSITION” INT CS_INT, “SCHEMA_NAME” NVARCHAR(256) CS_STRING, “TYPE_NAME” NVARCHAR(256) CS_STRING, “PARAMETER_TYPE” VARCHAR(7) CS_STRING );

        is that compatible with all the cases ? or i should replace “POSITION”, “SCHEMA_NAME”, “TYPE_NAME” … by other values.

        Thanks,

        Abdess

        (0) 
        1. Antoine CHABERT

          Keep it like it is and execute it with your target HANA user. Of course The USER_APL should be replaced by individual user ids that will use APL beforehand.

          (0) 
  2. Ingo Peter

    Hello,

    The SAP HANA APL Reference Guide v2.4 says at the beginning of ch. 2.8 “Creating the Table Types for the Function Library” the following: “This procedure is not necessary if you are using SAP HANA APL v2.4.10.x …. and if you are using the new stored procedures from the APL Delivery Unit”.

    Since I installed APL 2.4 on HANA Rev. 102.02 I did not start the script which creates these table types and there is actually no PROCEDURE_SIGNATURE_T in my system, but I have the corresponding BASE.T.PROCEDURE_SIGNATURE in my system (see table 6 in ch. 2.9 of the APL Ref. Guide v2.4).

    However calling HANA Auto Classification from PA Expert Analytics nevertheless throws the error “SAP DBTech JDBC(259) … invalid table name … PROCEDURE_SIGNATURE_T …”. So it seems that Expert Analytics does NOT use the new stored procedures from the APL Delivery Unit.

    Is this true?

    Regards,

    Ingo

    (0) 
    1. Antoine CHABERT

      Hi Ingo,

      I am confirming that Expert Analytics 2.4 is not making use of the new stored procedures of the APL delivery unit. So you still have to create the table types.

      Best regards

      Antoine

      (0) 

Leave a Reply