[EA16] Failed QEA to EAPX or FEAP Project Transfer

[Guillaume]

Hi,

I have a large local EA project on a QEA file (500MB) that I need to convert to an EAPx or FEAP file so it can be opened in EA15.
Running a File to File Project Transfer using EA 16.1 build 1625 doesn't work:
- with an EAPx, the transfer cannot be run as the following error is displayed: all EA tables are missing. Note that I can open this file in EA 15 and 16
- with a firebird FEAP, I'm getting SQL errors so I have to cancel.

Note that I also tried to use an export/import XEA but it's very slow and it eventually fails with the following (excuse the french):
Microsoft Cursor Engine [0x80004005] Un état E_FAIL a été renvoyé par le fournisseur de données ou par un autre service.
Context:    select * from t_object where 1 = 0.

[Paolo F Cantoni]

Hi Guillaume,
I presume you've checked that ALL the repositories are at Schema v1558?  Also, are you using 64-bit or 32-bit EA?

HTH,
Paolo

[Guillaume]

Hi Paolo,

I created all files with EA 16 so I presume they use the latest schema.
I'm using EA16 64 bits.

Thanks
Guillaume

[Paolo F Cantoni]

Hi Paolo,

I created all files with EA 16, so I presume they use the latest schema.
I'm using EA16 64 bits.

Thanks
Guillaume

The log file will tell you whether the schema version is correct.
Also, I'd try the 32-bit version.

Paolo

[Sunshine]

There appears to be a number of options in the menu for project transfer.
I tried full transfer via connection from qea file to feap file and it worked fine. Using Sparx EA v16.1 build 1625, 64-bit edition
What option were you using?

[Guillaume]

Hi,

Thank you for your feedback. I created an EAPx file with EA16.1 64 bits and checked the DB schema with the About menu: 1558
Opened menu Settings > Transfer> Full transfer via Connection
Transfer type = File to File
Source = QEA project file
Target = new EAPx project file
Enabled the log file
Disabled the Strip GUID option

Clicked on Transfer and got the following blocking error: Repository Error: Model 'C:\EA\test.eapx' is missing all EA tables.

Tried again with EA16.1 32 bits. It worked except I got the following error several times:
10/05/2023 15:07:50  DAO.Field [0x00000c5b]
Le champ est trop petit pour accepter la quantité de données que vous voulez ajouter. Essayez d'insérer ou de coller moins de données.
Context:   SQL: Select * from t_object

The transfer seemed to have worked however as I managed to open the EAPx without any error.

I don't understand why the 64-bit doesn't work like the 32-bit. By default clients opt for the 64-bit as a "better" version for performance matters ; does it mean that they face issues when it is fully deployed ?

[jfzouain]

Hi Guys

I just did a Google translate, this what I got back.
Some of the columns is a memo, and it got truncated.

The field is too small to accommodate the amount of data you want to add. Try to insert or paste less data. (transalation)

Additionally, the query may run without an error message. However, the data returned in the memo field is truncated at 255 characters (the transalation suggested)