Sparx Systems Forum
Enterprise Architect => Bugs and Issues => Topic started by: Guillaume on March 14, 2026, 02:15:49 am
-
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
-
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