SAP Knowledge Base Article - Public

3275354 - Error Message "SQL error during data preparation: invalid datatype: LOB type in distinct select clause: line 1 col 5067 (at pos 5066)"

Symptom

The data model fails when Loading Data in Machine Learning Cockpit with below error

SQL error during data preparation: invalid datatype: LOB type in distinct select clause: line 1 col 5067 (at pos 5066)

Environment

SAP Business Bydesign

Reproducing the Issue

  1. Go to Machine Learning Cockpit work center
  2. My Models view
  3. Create a New model
  4. Click Data Load button

Cause

The data load step is failing because there are some fields that were included in training that are of datatype string and text which are not supported by the framework as they have unlimited length.

Resolution

 Framework can only support fields with a max length of 60.

Keywords

data load, data model, mlc, model, training , KBA , AP-ML-EML , Embedded ML , Problem

Product

SAP Business ByDesign all versions