Transfer from EAP to DBMS Crashes

[jeff plummer]

We are attempting to move from a replicated master setup to a MYSQL database, and EA keeps crashing during the transfer.

It crashes on Images (t_image) and if I remove all images it crashes on rtf templates.  Deleting all those it will finally import.

My thinking it has something to do with size.  Have you seen this before?  Is there some setting so that those larger items will transfer.  Templates are easy to recover from, but losing all our images will be a pain to reconstruct.

[Paolo F Cantoni]

[size=18]...[/size]
My thinking it has something to do with size.  Have you seen this before?  Is there some setting so that those larger items will transfer.  Templates are easy to recover from, but losing all our images will be a pain to reconstruct.

Hi Jeff,

Yes, we found incompatibilities between the various repository specifications in the various technologies.  If you search for "Technologies" in the forum you 'll see some indications of what we found.

In addition, EA is self-inconsistent on how it processes certain data types (principally Booleans) in the various technologies and also within the same repository.

We created our own (consistent) specifications for the repository in the various technologies we use.  Unfortunately MYSQL wasn't one of them.

In this case, however, it may be related to the fact that you have a replication master.  If you can remove the replication stuff first it may transfer.

HTH,
Paolo

[Thomas Mercer-Hursh]

I had the same experience as Paulo, but with OpenEdge.  There are two types of problems.  One is the Sparx provided SQL script for creating the repository in the other database.  I found that it didn't always pick the ideal datatype, but a few edits and that problem was easily solved.  The other type of problem was actual datatype incompatabilies.  E.g., for Jet, a memo field can be up to 64K, but in OpenEdge we have Character, which is 32K or CLOB which is essentially unlimited ... but the EA code won't support the CLOB.  Consequently, anything in the Jet repository greater than 32K crashes on transfer.  Not much one can do about that.

So, check the datatypes in the problem tables and see if there is some adjustment you can make.