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.
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.
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.