cancel
Showing results for 
Search instead for 
Did you mean: 

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

sanjoypoddar10
Discoverer
0 Kudos

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!

View Entire Topic
MKreitlein
Active Contributor
0 Kudos

Hello @sanjoypoddar10 

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

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