EA16.1 bug: duplicate db tables on a diagram

[Guillaume]

Hi,

A user reported a weird bug on EA16.1 build 1628 with a data modelling diagram: the user opened the diagram wit a number of table and added existing ones from the browser. Then EA froze and after it restarted, the diagram now displays all the tables twice which is something that is not supposed to happen with EA. The repository is hosted on a PostgresDB, accessed via the PCS 5.1.128 (configured with System ODBC).
I ran the following query on the EA database and I get 2 diagram objects linked to the same element e.g. Instance ID = 1, Object ID = 1 + Instance ID = 2, Object ID = 1 + Instance ID = 3, Object ID = 2 + Instance ID = 4, Object ID = 2
select t_diagramobjects.Instance_ID, t_diagramobjects.Object_ID from t_diagramobjects where t_diagramobjects.Diagram_ID = 1000 order by t_diagramobjects.Object_ID

Has anyone come across this issue before ?
I haven't found any error in the PCS logs and I couldn't get the DBError.txt content related with the issue.

I'm trying to reproduce the issue and will update this thread if I have additional details. I plan to report it as a bug.

[Geert Bellekens]

Does a project integrity check solve the issue?

I've never heard of a bug like that

Geert

[Guillaume]

Thanks for the advice but the integrity check has not solved the issue.
I'm surprised that EA client is able to render twice an element in the same diagram. It looks like a script or addin could exploit this.

The user has a remote VPN connexion and works on a large diagram. I suspect connexion issues led this to inconsistent situation in the DB which is not ideal.

[Geert Bellekens]

It looks like a script or addin could exploit this.

Yes, it can. I've known that for ages, but I'm afraid to use it because of sideeffects I might not be aware of.

Geert