Skip to Content

Error activating HDBTI with empty table

Oct 27, 2016 at 02:50 PM


avatar image
Former Member


I'm trying to activate an HDBTI file and I get the error:

Importing data into table failed.  The data contains duplicate rows or the the table already contains a subset of the data

my csv:


my hdbti

  table = "data::FFC"; 
schema = "XXXX"; file = "data.load:ffc.csv"; header = true; }

my table is empty, a SELECT * FROM "data::FFC" returns zero records.

It seems some old import is impacting this table, any clues on how to fix this issue?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
avatar image
Former Member Oct 31, 2016 at 03:52 PM

Actually I found the root cause of my issue. Before, I was playing with the hdbti keys functionality. I had this on my hdbti

  keys = [ "fcId" : "0" ]

When I removed the "keys" from the hdbti the system went to some inconsistent state, and I was not able to activate any more the hdbti, even with empty csv files. To fix it I had to manually delete the hdbti key row from the table


After this, everything working as before!

10 |10000 characters needed characters left characters exceeded