Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
wguerrero
Contributor III
Contributor III

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

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

 

 

Labels (2)
1 Reply
john_wang
Support
Support

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:

john_wang_0-1668654477106.png

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.

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!