UML & SysML modelling languages

Expertise and blog articles on UML, SysML, and Enterprise Architect modelling tool

version francaiseTwitterVideos UMLChannel SparxSystems EA YouTubeLinkedIn
Thursday, 13 March 2014 00:00

Enterprise Architect Hint : fix a project transfer error from an EAP project file to a MySQL DB

Written by
Rate this item
(0 votes)

enterprise architect hint on project transfer error EAP to DBMS

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:

enterprise architect mysql error hint

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 :

sparx systems /enterprise architect mysql max_allowed_packet

After restarting the MySQL server, my Project Transfer successfully worked (it took almost 10 minutes to transfer all the data).