EAP > DBMS transfer is really really slow

[nick c]

Hi all,

I'm trying to transfer my project from .eap file to DBMS.

I've gone through the steps to connect to the database and everything appears fine.
It's the transfer process that is slow.

By slow, it's taking hours and I'm yet to have it complete successfully.
The HDD light goes crazy for this whole time, so there appears to be a huge amount of HDD IO.  
I even tried creating a new project and transferring it before I added anything to it, and the same problem exists.
According to the log it gets stuck at:  
Copying project information for: t_datatypes

Has anyone else come across this?

I'd love to find a solution for it.

Nick
System information:
Windows8 64-bit
core i5 M 540
4GB RAM
EA 9.3 Corporate edition

[SomersetGraham]

Hi
Check that you have the relevant permissions for t_datatypes table in your database

[qwerty]

t_datatypes itself is a very tiny one. As you are doing this on your laptop (blinking lights) it might be possible that the database/hard disk itself is corrupted. Try copying the db. Then run a consistency check on that very copy.

q.

[Geert Bellekens]

So what happens if you kill it.
Did it actually transfer part of the model, or nothing at all.
How much data is in the t_datatypes table? (shouldn't be too much should it)
Which DBMS are you trying to copy to
Are all tables created correctly on the database
Have you done the Project Integrity Check before you started the transfer
What happens if you try to transfer an empty (new) model
If you can actually transfer an empty model, you could also transfer the model using xmi export/import. (given that your .eap model isn't too large)

Geert

[nick c]

Hi All,

Thanks for your responses.

I have granted insert, update and delete permissions to the db user on the whole EA db.  I'm assuming this should be sufficient.

To clarify, the MySQL database is on a separate server, not on my laptop.
I'd assume this means it's not a database issue as I can't see why the HDD on my laptop would be churning if there was a problem with the database.  (correct me if I'm wrong)

If I kill the process, EA dies.  There's a Windows error that pops up.
Looking in the database, there are 95 rows in the t_datatypes table, so it looks like some of the data is being inserted.
I just performed an Integrity Check and it came up fine.
If I try to transfer an empty model, the same thing happens.


Thanks
Nick

[SomersetGraham]

Hi
In my MySQL database I have granted Select and Insert as well

In addition I had to set the permissions for the dbo schema -
Under the Security->Schemas tab select dbo
In the Schema properties dialog select the permissions tab and add yourself using the 'search' button then grant yourself all permissions

Hope this helps

[qwerty]

Two suggestions: a) send the EAP to Sparx support. b) ex-/import via XMI to make a copy.

q.