I recently had to transfer an Enterprise Architect project from a local EAP file to a MySQL database for sharing purposes. To do so, I opened the menu Tools > Data Management > Project Transfer, and selected the option "EAP to DBMS".
I came across a Lost Connection error:
[MySQL][ODBC 5.2(w) Driver][mysqld-5.6.-16]Lost connection to MySQL server during query [Select * from t_document] field: docdate.
Press OK to continue to next row (this record will be lost). Cancel to abort.
As I thoroughly documented the BPMN activities within business processes using Enterprise Architect Linked Documents (build-in Word processor), I assumed that all these linked documents involved a rather large amount of data, leading to such error.
Update 2/11/2015: this hint also works with the following error message.
[MySQL][ODBC 5.1 Driver][mysqld-5.6.27-log]Got a packet bigger than 'max_allowed_packet' bytes. Context: select * from t_image
As an attempt to resolve the issue, I reverted the version of my ODBC/MySQL connector to the one suggested by Sparx Systems user guide i.e. 5.1.5. This action didn't fix anything, however it prompted a more meaningful error message:
I realized this error was due to a system variable on my MySQL DBMS, so I increased the size of this variable from 4MB to 32MB by updating the 'max_allowed_packet' value in the Options File > Networking :
After restarting the MySQL server, my Project Transfer successfully worked (it took almost 10 minutes to transfer all the data).