Skip to Content
avatar image
Former Member

Error activating HDBTI with empty table


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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

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!

    Add comment
    10|10000 characters needed characters exceeded