Failed to run load statement 'load data local infile "D:

wguerrero — Thu, 17 Nov 2022 02:40:14 GMT

Hello

We have this error in our replica:

Failed to run load statement 'load data local infile "D:\\Program Files\\Attunity\\Replicate\\data\\tasks\\LOGSTREAM-TO-VUL-AWS-01_b\\data_files\\2\\LOAD0000000C.csv" into table `INSUDB`.`CLIENT_IDDOC` CHARACTER SET UTF8MB4 fields terminated by ',' enclosed by '"' lines terminated by '\n'( `SCLIENT`,`NIDDOC_TYPE`,`SIDDOC`,`SIDDOC_DIGIT`,`DCOMPDATE`,`NUSERCODE` ) ;' [1022502] (csv_target.c:497)

Attached the error message in image

Please your help

Re: Failed to run load statement 'load data local infile "D:

john_wang — Thu, 17 Nov 2022 03:16:54 GMT

Hello @wguerrero ,

We hope we can solve the issue by 3 steps:

1- From the picture we see the timeout occurs after 61 seconds. I'd like to suggest you modify the MySQL target endpoint settings by open target endpoint --> Advanced tab --> internal Parameters and add the below:

executeTimeout (default 60) <-- increase it to eg 300

loadTimeout (default 1200) <-- try it with high value later

Save the endpoint and try again. A sample:

2- If above setting does not help, then we recommended to increase innodb_lock_wait_timeout from 50 to 300 or 900

innodb_lock_wait_timeout=300

and

innodb_deadlock_detect=off;

Detailed info see:

https://dev.mysql.com/doc/refman/5.7/en/innodb-parameters.html#sysvar_innodb_lock_wait_timeout

also please check with your DBA to see what could cause the timeout ,eg server loaded, DDL conflict etc.

3- If Both above options do not help, open a support ticket with TARGET_LOAD set to Verbose, reproduce the issue and attach the task Diag Packages.

Hope this helps.

Regards,

John.

topic Failed to run load statement 'load data local infile "D: in Qlik Replicate

Failed to run load statement 'load data local infile "D:

Re: Failed to run load statement 'load data local infile "D: