tDBBulkExec not working for updating bulk data

[Dhanoop]

Hi Team
I have a bulk data stored in a txt file with the primary keys and the columns which I need to update in the table.

The primary key column is ID which is of VARCHAR(50) data type.

I am trying to update the records into DB using tDBBulkExec but the job is getting failed with the below error. 

"The used storage engine can't index column 'ID'"
Please help in rectifying the issue. The storage engine used for this table is InnoDB Engine.

Thanks
DBS

[quentin-vigne]

Hi @Dhanoop 

Make sure the "Action on table" is set to None / Default and also that your ID column doesn't contain null value.

Maybe try to enable "innodb_large_prefix" on your ID column.

You can check that by doing SHOW CREATE TABLE your_table;

Make sure that ID is VARCHAR(50) NOT NULL and part of your index / primary key

If it still doesn't work could you share screenshots of your component view ?