SAP Knowledge Base Article - Preview

3201649 - Convert CLUSTD data from LRAW to string or other type

Symptom

Attempting to convert the data from the column CLUSTD results in and error similar to the following:

SELECT clustd ,BINTOSTR(TO_BINARY(cast(CLUSTD as varbinary))) clustd_TEXTFROM sapabap1.AMDR WHERE  mandt = 100 AND TDOBJECT ='EBAN' AND TDNAME = '001000281700090';

Could not complete result operation. com.sap.db.jdbc.exceptions.Cesu8ConversionException Invalid CESU-8 sequence: [-1, 6, 2, 1, 2, 2, -128, 0, 52, 49, 48, 51, 0, 0, 0, 0, 99, 1, 0, 0, 18, 31, -99, 2, -116, 
-103, -113, -127, -127, -127, -111, 7, 72, 48, -80, 50, 96, 1, 33, 12, 62, 12, -98, 12, 126, 12, -82, 12, 107, 33, 42, 87, -127, -123, 89, -64, 20, 35, -57, 58, -120, -32, 62, -88, 25, -116, 123, 64, 12, 45, 6, 5, -122, 32, 
-96, 14, 55, 6, 61, 6, 23, 6, 127, 6, 93, 6, 19, 6, 3, 6, 35, -122, 112, -96, -8, 72, -125, 123, -9, -77, 0, 0, 0]

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.   


Read more...

Environment

  • SAP HANA PLATFORM EDITION 1.0
  • SAP HANA PLATFORM EDITION 2.0

Product

SAP HANA 1.0, platform edition ; SAP HANA, platform edition 2.0

Keywords

CLUSTD, LRAW, convert, export/import table, hexadecimal, data cluster , KBA , HAN-DB , SAP HANA Database , 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.