Book a Demo

Author Topic: Not opening project from MySql sever  (Read 3803 times)

MrTrigger

  • EA Novice
  • *
  • Posts: 7
  • Karma: +0/-0
    • View Profile
Not opening project from MySql sever
« on: November 21, 2013, 12:03:15 am »
Hi,
I'm having trouble trying to open a project stored in a MySql database, this has worked for me before but after a harddiska failure I had to reinstall everything.

I add a 32bit ODBC connection and it tests OK from within EA when I set up the database conenction. But when everything is done the only thing that happens when I try to open the project is that EA flickers once and nothing happens, no outpot, no error dialog, nothing.

The only thing I can come up with that differs from before is that it's a newer version of the MySql server (now 5.7).

Any ideas?
Is there a log file somewhere that I can check in?
« Last Edit: November 21, 2013, 12:04:58 am by MrTrigger »

Helmut Ortmann

  • EA User
  • **
  • Posts: 970
  • Karma: +42/-1
    • View Profile
Re: Not opening project from MySql sever
« Reply #1 on: November 21, 2013, 12:07:45 am »
Hi,

have you checked:
  • The EA tables are still in the database
  • The EA tables like t_object contain your elements
You can check this by the SQL Sever Management Studio.

Helmut
Coaching, Training, Workshop (Addins: hoTools, Search&Replace, LineStyle)

MrTrigger

  • EA Novice
  • *
  • Posts: 7
  • Karma: +0/-0
    • View Profile
Re: Not opening project from MySql sever
« Reply #2 on: November 21, 2013, 12:24:49 am »
Yes and yes, I also check that MySQL_InnoDB_EASchema.sql hasn't changed since I created the schema.

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +397/-301
  • I'm no guru at all
    • View Profile
Re: Not opening project from MySql sever
« Reply #3 on: November 21, 2013, 12:39:52 am »
Have you checked %APPDATA%\Sparx Systems\EA\dberror.txt ?

Maybe a version issue: http://www.sparxsystems.com/cgi-bin/yabb/YaBB.cgi?num=1381931816/7#7

q.
« Last Edit: November 21, 2013, 12:41:51 am by qwerty »

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13523
  • Karma: +574/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Not opening project from MySql sever
« Reply #4 on: November 21, 2013, 01:23:13 am »
They've only started supporting MySQL v 5.6 in the latest version, so either something was changed in MySQL between 5.6 and 5.7 which broke the EA connection again, or you are not working with the latest EA version (10.0.1009)

Geert

MrTrigger

  • EA Novice
  • *
  • Posts: 7
  • Karma: +0/-0
    • View Profile
Re: Not opening project from MySql sever
« Reply #5 on: November 21, 2013, 01:53:43 am »
I'm using EA 10.0.1004

I rebooted and after that it just works, tried to reboot once before but then it didn't help. Don't know what was going on here, but I'm happy again for now.   :)

Cheers
« Last Edit: November 21, 2013, 01:54:18 am by MrTrigger »