cancel
Showing results for 
Search instead for 
Did you mean: 

SQL Error while executing insert statement for Delta Loading

Former Member
0 Kudos
233

Hi Experts,

As per the guideline I started to replicate the table in HANA Studio directly without any initial load.But I am getting while executing the SQL statements.

insert into ECCSCH.RS_ORDER values('AT16',0,'T')

insert into ECCSCH.RS_ORDER values('AT16',0,'M')

insert into ECCSCH.RS_ORDER values('AT16',0,'Q')

Error --

Could not execute 'insert into ECCSCH.RS_ORDER values('AT16',0,'T')' in 2 ms 596 µs .

[301]: unique constraint violated: Table(RS_ORDER), Index(_SYS_TREE_RS_#139657_#0_#P0)

Could not execute 'insert into ECCSCH.RS_ORDER values('AT16',0,'M')' in 2 ms 370 µs .

[301]: unique constraint violated: Table(RS_ORDER), Index(_SYS_TREE_RS_#139657_#0_#P0)

My main intention is to replicate this table in HANA without initial load.Let me know where I am getting wrong.

View Entire Topic
former_member182114
Active Contributor
0 Kudos

Hi Joy,

The error is correct as you are missing the key.

For you luck provided a awesome document about this.

Best regards, Fernando Da Rós