cancel
Showing results for 
Search instead for 
Did you mean: 

Order of the primary key columns in Datasphere Tables

jlopezm
Participant
0 Kudos
143

 

Hi Datasphere Experts,

I am creating a replication flow to bring SAP HANA data into Datasphere and dump it into a table I created. When I deploy the replication flow I get this error:

jlopezm_0-1726759423982.png

I have found that:

  1. the order of the table key in SAP is exactly the same as the order of the created table.
  2. The data type is exactly the same.
  3. The rest of the selected fields keep the same order as the original table.
  4. The fields are named the same and are automatically mapped in the replication flow projection.

El error lo da en el momento en el que despliego el flujo de replicación.

jlopezm_1-1726759601683.png

jlopezm_2-1726759633270.png

What other checks could you make to solve the problem?

Thank you very much for your help!

View Entire Topic
Martin_Kuma
Active Participant
0 Kudos

Hi, let the replication flow create the target table. Do not create it on your own. I always leave the replication flow to build the table, then I use it in data views or data / transformation flow.