1850613 - SAP Predictive Analysis Fatal Exception using HANA Online

Symptom

Error "FatalException::InternalFatal:Invalid column type:Column types do not match the specification!" is thrown when using HANA algorithms when connected to HANA Online.

Reproducing the Issue

Create a New Document with a HANA online connection.
Add and configure a HANA algorithm.
Execute Algorithym.

Cause

You may have a column with Decimal data type in the independent columns that you passed to the algorithm.
HANA PAL is very sensitive to the data type that is passed to an algorithm.
The precisions of the decimal data types are not supported in the PAL layer.

Resolution

As a workaround you can use a double datatype column instead of the decimal.

Please see the attached file

Tips to use SAP Predictive Analysis with SAP HANA SPS5.pdf

 

Keywords

Predictive Analysis, HANA, FatalException, algorithm, Invalid column