Problem with data type uniqueidentifier from MS SQL SERVER using SAP SLT to SAP HANA

[former_member533736]

Hello friends, i need help

Data inconsistency is occurring from Microsoft SQL Server to SAP HANA through the SLT.

CASE: The table with name: EstadosConsolidadosPedidos located in the Microsoft SQL Server database with name: ControlDespachos. The fields in the table are:

The error is presented in the field ListId_State, the data type is uniqueidentifier, when the table is replicated in SAP HANA by means of the SLT, the field data is changed.

Sample data from Microsoft SQL Server:

In origin the data is: 0F6F400A-C63F-4918-9DA0-AD080CB1CAB2

The table fields in SAP HANA are:

The field ListId_State arrives with data type VARBINARY, but the data changes:

In the destination the data is: 0A406F0F3FC618499DA0AD080CB1CAB2

Note: A test was performed, the data type was changed to NVARCHAR in HANA, but the result was the same

Environments:

SAP HANA: 1.00.122.16.1520578817

SAP SLT 7.5

MS SQL: SQL Server 2012 Standard SP4

[Andrey_M]

By default the data type UNIQUEIDENTIFIER is converted to RAW(16). If you need to keep the this field as a string you should not change it directly in HDB. The converstion happens already on SLT cerntal system. You have to customize the table in LTRS, where you can set the desirable data type for every field. I think that in this case the conversion witll work correctly.

[former_member533736]

Hello, thanks for answering. We made the change as you indicate, but the data keeps coming different.