Error in bulk insert

Help Activities
, ,
1

hi,

i am trying bulk insert activity for mysql db in UiPath.but getting following error.plz help.

The provided driver version does not support Bulk Insert operations. Please check the driver.

Bulk insert: ERROR [42000] [MySQL][ODBC 8.0(a) Driver][mysqld-5.7.36]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘DEFAULT VALUES’ at line 1

2

@Hemant_Deshmukh

for bulk insert to work properly …first your drivers should be supporting bulk activities

then all the data type and the column names should be exactly matching…any deviation will fail the insert…first try with one single line and then increment the data

cheers

3

all column name are matching with each other.how to check drivers?

4

@Hemant_Deshmukh

Data types are also matching?

Try changing the deivers by changing providers

Cheers

5

This is pretty straightforward. Your MySQL driver doesn’t support Bulk Insert.

You can see if you have the latest version of the MySQL driver and upgrade if necessary. Or you can switch to looping and inserting one row at a time.

6

currently i am inserting single row but it is taking too much time…can any one tell me which version of mysql support bulk activity?

7

@Hemant_Deshmukh

Try woth odbc drivers they generally support bulk insert

Cheers