SQL Error while executing insert statement for Delta Loading

[Former Member]

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.

[stefan_sessner]

Hi Joydeep,

we currently get the same error while execute these statements.

Error message:

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

How did you solve this (e.g. with the hint of Fernando)?

Thx in advance.

Best regards, Stefan

[Former Member]

Follow Tobias's document..Entire delta recording process through HANA Studio is explained.