MySQL : Packets larger than max_allowed_packet are not allowed

You can see this error importing or checking large files (>2MB) in WIP.

Symptom

You will have an issue during check-out and then the WIP file status will change from OK to Check-in error.

In the log file you can see

Could not find file 'C:\ProgramData\ebiexperts\TEMP\VmTemp\TeddvdYYFESuBjcaFO97zg\bf3f16bce1dd47e5a58e65b09b72eced\Report (1).qvf'

The problem is in fact MySQL packet size too small to save big BLOBS

Resolution

Change the file C:\ProgramData\ebiexperts\WIP Web Server\repository\my.ini and add max_allowed_packet=1G

[mysqld]
datadir=C:/ProgramData/ebiexperts/WIP Web Server/repository
named-pipe=ON
socket=wip
port=59290
max_allowed_packet=1G
[client]
socket=wip
port=59290
plugin-dir=C:/ProgramData/ebiexperts/WIP Web Server/mariadb/lib/plugin

Then restart the service WIP Repository