Return
-
Title
error_code=502 state=01S02 msg=[MySQL][ODBC 5.1 Driver][mysqld-5.7.18]Param arrays not supported -
Description
Open target for mySQL is getting below error in xpst*.log when array insert or batch operations are being replicated and some data are missing on target.
xpst 2017-06-13 10:34:26.145158 4694 3443492608 error_code=502 state=01S02 msg=[MySQL][ODBC 5.1 Driver][mysqld-5.7.18]Param arrays not supported
-
Cause
ODBC driver 5.1 for mySQL is installed which does not support array operations -
Resolution
SOLUTION:
Install MySQL ODBC driver 5.3.2 and above to support array operations.