SAP Knowledge Base Article - Preview

3251962 - Operator Table Producer generate only CLOB Objects instead of VARCHAR

Symptom

When writing a table to SAP HANA using Generation 2 operators, string columns are saved as NCLOB instead of the expected VARCHAR data type.

The graph will get error like:

Data type mismatch: In query <LoadMapper_******_tableproducer1>, an expression of type <LONG> is mapped to column <***> of type <VARCHAR>. Specify an expression of compatible type or change the type of the output column. | error with process "": Process(es) terminated with error(s). restartOnFailure==false


Read more...

Environment

SAP Data Intelligence (all versions)

Product

SAP Business Technology Platform all versions

Keywords

nclob, clob, str, di , KBA , CA-DI , Data Intelligence , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.