41
Bugs and Issues / Re: XEA Import error
« Last post by Geert Bellekens on March 15, 2026, 07:00:57 pm »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
Recent Posts