Datasphere- Unique constrain violation in G/L Hierarchy data replication

[sanjoypoddar1051]

Hi Experts,

Have you guys face unique constraint violation while  datasphere G/L Hierarchy data replication ?

I am using standard G/L hierarchy CDS view , when I look at the table I can see few extra fields (datasphere generated fields)and a key field named as “Hash ID for hierarchy “ which stop me to replicate data into datasphere.

Need your input to fix this issue.

Thanks in advance!

[MKreitlein]

Hello @sanjoypoddar1051 

It is possible that your target table is missing the key setting in the "Dateto" field?

In this way it might be possible that you cause "duplicate keys" when inserting data into it.

BR, Martin

[sanjoypoddar1051]

Hi Martin, whatever keys I defined in CDS views are not reflecting in datasphere remote table.