Not able to add column into the existing import set table

[SenthilkumarRaj]

we are trying adding a new column into the existing import set table .so when we trying to upload the execel with updated column we getting error message as below

Existing import set table as :Bulk_ci_load

SEVERE *** ERROR *** FAILED TRYING TO EXECUTE ON CONNECTION 2: INSERT INTO sys_dictionary (`choice_table`, `virtual`, `max_length`, `create_roles`, `unique`, `read_only`, `reference_floats`, `choice`, `dependent`, `table_reference`, `dynamic_creation`, `sys_created_on`, `reference_type`, `calculation`, `spell_check`, `internal_type`, `sys_updated_by`, `primary`, `reference_qual`, `name`, `choice_field`, `sys_mod_count`, `write_roles`, `delete_roles`, `widget`, `element`, `read_roles`, `mandatory`, `sys_id`, `sys_updated_on`, `audit`, `display`, `element_reference`, `text_index`, `reference_cascade_rule`, `reference`, `sys_created_by`, `dynamic_creation_script`, `default_value`, `sys_class_name`, `active`, `foreign_database`, `attributes`, `xml_view`, `array`) VALUES(NULL, 0, 40, '', 0, 0, 0, 0, NULL, 0, 0, '2011-12-05 05:32:33', NULL, NULL, 0, 'string', '502002487', 0, NULL, 'u_bulk_ci_load', NULL, 0, '', '', NULL, 'u_sox_change_approval_group', '', 0, '36d535bc87fe50004e971f404a434d15', '2011-12-05 05:32:33', 0, 0, 0, 0, NULL, NULL, '502002487', NULL, NULL, 'sys_dictionary', 1, NULL, '', 0, 0)
Unique Key violation detected by database (Duplicate entry 'u_bulk_ci_load-u_sox_change_approval_group' for key 'sys_dictionary_index1')

please find the attachement for the error log & update column name

please guide us to resolve the issue .

[Krischan]

How did you add the column? Can you spare the data in the staging table? Then I'd sugest to cleanup the table and remove the check on the "preserve table structure" checkbox. When you then reupload your excle file the necessary columns are created automatically.