topic Re: failing Replication from Sqlserver to MYsql in Qlik Replicate

failing Replication from Sqlserver to MYsql

Denial — Wed, 15 Mar 2023 08:06:17 GMT

Hi ,

We are getting below error while replicating data from sqlserver to my sql

error :-

Handling End of table 'collage'.'Employee' loading failed by subtask 1 thread 1
Failed to load data from csv file.
Failed to load file '1'
Failed to start load process for file '1'
RetCode: SQL_ERROR SqlState: HY000 NativeError: 3948 Message: [MySQL][ODBC 8.0(w) Driver][mysqld-8.0.32]Loading local data is disabled; this must be enabled on both the client and server sides
Failed (retcode -1) to execute statement: 'load data local infile "C:\\Program Files\\Attunity\\Replicate\\data\\tasks\\test1\\data_files\\1\\LOAD00000001.csv" into table `collage`.`Employee` CHARACTER SET UTF8MB4 fields terminated by ',' enclosed by '"' lines terminated by '\n'( `EmployeeID`,`FirstName` )

Please let us know the solution .

Thanks,

Re: failing Replication from Sqlserver to MYsql

john_wang — Wed, 15 Mar 2023 08:17:20 GMT

Hello @Denial ,

Thanks for reaching out!

If you are running Full Load, or CDC with Batch Apply Mode then load method is called , the local_infile is required by MySQL Server. You can set it in MySQL setting file (need restart the MySQL service), or set it dynamically (the setting will lost if MySQL Service restart):

mysql> show global variables like 'local_infile';

+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| local_infile | OFF |
+---------------+-------+
1 row in set (0.00 sec)
mysql> set global local_infile = 'ON';

Hope this helps.

Regards,

John.

Re: failing Replication from Sqlserver to MYsql

Denial — Wed, 15 Mar 2023 09:48:35 GMT

Hi John,

Thank you it is working

Thanks,

Re: failing Replication from Sqlserver to MYsql

john_wang — Wed, 15 Mar 2023 09:51:25 GMT

Glad to hear that, @Denial .

Please click "Accept as Solution" if possible.