MySQL Migration Wizard results in 'Found record bigger than max_allowed_packet'

[Pratik Gandhi]

I am trying to migrate a database from MSSQL 2014 to MySQL 5.7 using Workbench 6.3 (CE) on a Windows machine. I have already set the value of max_allowed_packet to 1G in my.ini file. However, I'm still getting the error while trying to migrate the data. The table for which I am getting this error has only one record, and even the field, which I suspect is causing the issue, doesn't have that big of a value
'<results><result documentId="1" queryCode="AZ100" queryValue="I"/></results>'.

The field has nvarchar(max) as its data type in MSSQL which gets converted to LONGTEXT by MySQL wizard. Also, in the migration log it indicates that it has detected the new max_allowed_packet value
'copytable]: Detected max_allowed_packet=1073741824'.


Thanks,
Pratik