Skip to Content
0
Former Member
Aug 01, 2013 at 06:47 AM

Exception: unique constraint violated: Table (xxxxx)

1896 Views

Dear all, I hope someone can help

When I attempt to load data into my table, i receive this message, and also now get it when performing a check on the .hdbtim file

ERROR playpen/db/ZGS.hdbtim

Repository: Internal error during statement execution, please see the database error traces for additional details An error occurred when inserting data from csvfile to table. CSV-file: playpen.db:ZGS. Target Table: playpen.db::ZGS Exception:: unique constraint violated: Table(playpen.db::ZGS) at ptime/query/plan_executor/trex_wrapper/trex_wrapper_body/trex_update.cc:1391

I know what is causing it.

I have an Att View which uses my table ZGS, with a join to M_TIME_DIMENSION. Without the join, it works fine.

My table is defined as this, in a .hdbtable

table.columns = [

{name = "MANDT"; sqlType = NVARCHAR; length = 3; nullable = false; comment = "Client"; },

{name = "MATNR"; sqlType = NVARCHAR; nullable = false; length = 18; comment = "Material Number"; },

{name = "CHARG"; sqlType = NVARCHAR; nullable = false; length = 10; comment = "Batch Number"; },

{name = "ADBTH"; sqlType = DATE; nullable = true; comment = "Actual RDR Delivery Date"; }

];

table.primaryKey.pkcolumns = ["MATNR","CHARG"];

My Att View contains the fields from ZGS: MATNR and CHARG, and the field CALMONTH from M_TIME_DIMENSION. The Att View, has MATNR and CHARG as Key Attributes.

It is joined using ZGS-ADBTH to M_TIME_DIMENSION-DATE_SQL.

The Join is Referention, with no Cardinality (the default).

Anyone ?

Thanks

G