Skip to Content
avatar image
Former Member

PA Error: SAP DBTech JDBC [259] invalid table name PROCEDURE_SIGNATURE_T

Hi Experts,

I am getting this error message about PROCEDURE_SIGNATURE_T table being an invalid table name while using the most of PAL functions through Expert Analytics (Some functions work without problem like Decision tree 4.5).  We 're on HANA revision 93, PA version 2.3.

I saw SAP note 2128915 that recommend revision 96 (93 is for test and evaluation only) and in other SCN question that hana revision 96 + PA 2.2 + APL 2.2 will be OK:

I want to know where installing this APL , is it a component of hana database like PAL ?  and which version will be compatible with PA 2.3  ?



Best regards,

Abdess

PAHANAError.JPG (30.5 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Oct 22, 2015 at 05:31 PM

    Please also refer to @Jayanta Roy post here: Solve the APL configuration issue for Expert

    Best regards

    Antoine

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 21, 2015 at 11:19 AM

    Hi Abdess,

    I am not very clear about your problem statement.

    We have to distinguish two different predictive libraries in SAP HANA: APL and PAL.

    APL is the implementation of the Automated Analytic powerful algorithms into SAP HANA. All algorithms with prefix HANA Auto make use of APL.

    PAL is a comprehensive data science algorithm library, providing among others decision tree C4.5 classic algorithm for instance like in your example.

    If I am not mistaken, both of these predictive libraries require a separate installation and configuration of top of the "base" SAP HANA installation.

    A few questions to better understand where you stand:

    - Have you installed both APL & PAL?

    - Have you checked that the configuration is successful?

    For APL, this means following the guide here: https://websmp106.sap-ag.de/~sapidb/012002523100013455472015E/pa23_hana_apl_user_en.pdf from page 9 to page 15.

    For PAL, the online resource available right now is this: http://help.sap.com/hana/SAP_HANA_Predictive_Analysis_Library_PAL_en.pdf that applies to HANA SPS10.

    There is a difference between the error message that you mention : "I am getting this error message about PROCEDURE_SIGNATURE_T table being an invalid table name" and the screenshot. The algorithm you used at least for the screenshot is a APL one, this would lead to suspecting a APL configuration or installation one.


    Can you kindly provide the full logs? they are available here: C:\Users\<your Windows user>\AppData\Local\Temp\sappa\logs, take the more recent one, the name starts with TraceLog.


    The PA 2.3 PAM claims support of SAP HANA SPS9 based on revision 96 which is the revision that is recommended by SAP for productive usage. With PA 2.3 you can use either APL 2.2 or APL 2.3.

    Good luck,

    Best regards


    Antoine

    Add comment
    10|10000 characters needed characters exceeded

    • Additional info that can be useful for you.

      http://service.sap.com/sap/support/notes/2178039

      • Unsupported columns in table types:
        • Processing of data may fail while using Predictive Analysis Library (PAL) components in Expert Analytics since the Application Function Library (AFL) does not support certain columns in table types.
        • The following are the supported CSTYPE (column store type)/SQLTYPE/DIMENSION combinations from AFL:
          • "INT" / "INTEGER"
          • "FIXED8_19_0" / "BIGINT" ("FIXED8_19_0" means fixed with 8 bytes and 19 digits)
          • "DOUBLE" / "DOUBLE"
          • "STRING" / "CLOB"
          • "STRING" / "NCLOB"
          • "STRING" / "VARCHAR" / ...
          • "STRING" / "NVARCHAR" / ...
          • "DAYDATE" / "DATE"
          • "SECONDTIME" / "TIME"
          • "LONGDATE" / "TIMESTAMP"
          • "SECONDDATE" / "SECONDDATE"

      Note: Not all of these columns may be supported with PAL. For more information, see the PAL documentation at http://help.sap.com/hana_one/ -> SAP HANA Predictive Analysis Library (PAL) Reference.