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 Andrey, thanks for answering. You are right, if we knew what the rule is, we would even apply it directly to HANA, but I do not know what the rule is. The funny thing is that apparently the same rule always applies