Book a Demo

Author Topic: EAP to DBMS Project Transfer crashed  (Read 4014 times)

Guillaume

  • EA Practitioner
  • ***
  • Posts: 1405
  • Karma: +42/-2
    • View Profile
    • www.umlchannel.com
EAP to DBMS Project Transfer crashed
« on: March 13, 2014, 09:03:15 pm »
Hi

I tried to transfer an EA project stored in a local EAP file to a MySQL DB using the Project Transfer feature.
As I have quite a lot of Linked Documents, the data in the t_document table is rather large I guess. After a couple of minutes, I get the following error message:
[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.

Having clicked on OK, this error is followed by an EA crash (runtime error).

Do I need to change any settings in the MySQL ODBC connector or in EA to get this transfer to work?

Thanks
Guillaume
Guillaume

Blog: www.umlchannel.com | Free utilities addin: www.eautils.com


qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +397/-301
  • I'm no guru at all
    • View Profile
Re: EAP to DBMS Project Transfer crashed
« Reply #1 on: March 13, 2014, 09:59:15 pm »
Not all MySQL drivers are supported. There are a couple of threads here (I can't remember which was the supported version). Basically MySQL seems to differ internally with its versions.

q.

Guillaume

  • EA Practitioner
  • ***
  • Posts: 1405
  • Karma: +42/-2
    • View Profile
    • www.umlchannel.com
Re: EAP to DBMS Project Transfer crashed
« Reply #2 on: March 14, 2014, 08:27:16 am »
I managed to sort the issue by updating the max_allowed_packet system variable on the MySQL server. I changed it to 32MB (original value : 4MB)

Guillaume

Blog: www.umlchannel.com | Free utilities addin: www.eautils.com