XEA Import error

[Guillaume]

Hello,

I tried to import a large XEA file with a GUID reset to a new EA repository (shared on Postgres, available via the PCS 6.1.166) and I eventually get an Application Error.
Opening the DBError file, I have the following:

Enterprise Architect (Build: 1628 - 64 bit)
Sparx Systems Database API [0x00001086]
Native Update FAILED with error:
23503 ERROR:  insert or update on table "t_connector" violates foreign key constraint "fkam9fr64t66r6dgjgo3mfoji2a"
DETAIL:  Key (end_object_id)=(0) is not present in table "t_object".
Context:

What could be the issue ?

Updates:
- I upgraded the PCS to the latest build but it didn't resolve the issue
- I ran a project integrity check
- The workaround I found involved importing the XEA file to a blank EA project and re-exporting it with the Strip GUID enabled. I wonder if this is related with conflicts on external dependencies that are removed down by going through a blank EA project. The size of the new file is a bit smaller that the original one

[Geert Bellekens]

Hello,

I tried to import a large XEA file with a GUID reset to a new EA repository (shared on Postgres, available via the PCS 6.1.166) and I eventually get an Application Error.
Opening the DBError file, I have the following:

Enterprise Architect (Build: 1628 - 64 bit)
Sparx Systems Database API [0x00001086]
Native Update FAILED with error:
23503 ERROR:  insert or update on table "t_connector" violates foreign key constraint "fkam9fr64t66r6dgjgo3mfoji2a"
DETAIL:  Key (end_object_id)=(0) is not present in table "t_object".
Context:

What could be the issue ?

Updates:
- I upgraded the PCS to the latest build but it didn't resolve the issue
- I ran a project integrity check
- The workaround I found involved importing the XEA file to a blank EA project and re-exporting it with the Strip GUID enabled. I wonder if this is related with conflicts on external dependencies that are removed down by going through a blank EA project. The size of the new file is a bit smaller that the original one

Hmm, that's new. EA doesn't usually use any FK constraints.

Anyway, the reason is that you are trying to import a connector that connects to an object that is unknown.
I'm guessing your XEA file is not entirely self contained, and has references to elements outside of the XEA file.

Geert