topic Re: tDBBulkExec not working for updating bulk data in Talend Studio

tDBBulkExec not working for updating bulk data

Dhanoop — Wed, 19 Feb 2025 09:11:03 GMT

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

Re: tDBBulkExec not working for updating bulk data

quentin-vigne — Mon, 24 Feb 2025 13:48:43 GMT

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 ?