Skip to Content
avatar image
Former Member

SAP Expert Analytics 3.3.0 Trial: Problem with Hana Model Statistics

Hello everyone,

I have a problem with the "HANA Model Statistics" component when running my analysis in SAP Expert Analytics with HANA connection. Here is a screenshot of the modeling.

The error is the following:

SAP DBTech JDBC: [256]: sql processing error: search table error: sql processing error: exception 71000256: "USER"."PAS71_18_PROC": line 50 col 1 (at pos 7829): sql processing error: Llang Runtime Error: Exception::TypeMismatch: Column 'VARIABLE' does not exist

at main (line 610)

export Void main(T_result_in "resultIn" resultIn, T_indicators "indicators" indicators, T_summary "summary" summary, T_indicators "indicatorsValidate" indicatorsValidate, T_profitcurves "profitcurvesOut" profitcurvesOut, T_profitcurves "profitcurvesOutValidate" profitcurvesOutValidate, T_profitcurves "profitcurvesOutTest" profitcurvesOutTest, T_indicators "indicatorsTest" indicatorsTest, T_result_out "resultOut" &resultOut){

(please check lines: )
undefined


I am using version 3.3.0 with the 30-day trial license.

Can someone help me out here?

Thank you very much.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • Best Answer
    avatar image
    Former Member
    Mar 23 at 10:32 AM

    I installed the new Version 3.3.2 and now erverything works without Errors.
    Many thanks for the fast responses and the fix.

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 08 at 01:50 PM

    Hi Elias, we currently have identified a bug that's affecting the use of HANA Auto algorithms and Statistics nodes when Expert Analytics 3.3 is being used in conjunction with HANA2 SPS2. Now the good news is that we have a patch in the works (version 3.3.2) that is going to resolve this issue. Which trial version are you currently using? Is is the PA Desktop trial or the Professional Edition? Kind regards & thanks Antoine

    Add comment
    10|10000 characters needed characters exceeded

    • Thanks Elias, so we are going to release the patch 2 of our 3.3 version. Two options: you wait for the trial to be updated, or if you can download software from SAP, you can download & upgrade your trial installation once the patch 2 is released. Kind regards Antoine

  • Mar 22 at 02:06 PM

    Former Member forgot to update you - our 3.3.2 patch has been released!

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 22 at 02:06 PM

    Former Member forgot to update you - our 3.3.2 patch has been released!

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 06 at 08:55 AM

    Hi Elias, in your screenshot, the error seems to be caused by the HANA Naive Bayes component. Is that correct?

    Can you please double check that the types of the columns in the HANA view are compliant with the ones we support?

    https://launchpad.support.sap.com/#/notes/2490039

    Quoting the note:

    "

    • Unsupported columns in table types:
      • Processing of data may fail while using Predictive Analysis Library (PAL), Automated Predictive Library (APL) and components in Expert Analytics because 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 https://help.sap.com/viewer/p/SAP_HANA_PLATFORM -> SAP HANA Predictive Analysis Library (PAL) Reference.

    Kind regards

    Antoine

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 07 at 10:44 AM

    Thanks - one last ask - what's the configuration of the various components? What happens if you do the same test but downloading data from SAP HANA (instead of using the live connection)?

    Add comment
    10|10000 characters needed characters exceeded