Skip to Content
0

Error activating HDBTI with empty table

Oct 27, 2016 at 02:50 PM

95

avatar image
Former Member

Hi,

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:

fcId,fId,amount,dummy
999999,999999,1,1

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
0

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

"_SYS_RT"."TI_IMPORT_KEYS" 

After this, everything working as before!

Share
10 |10000 characters needed characters left characters exceeded