Sparx Systems Forum

Enterprise Architect => Bugs and Issues => Topic started by: Guillaume on January 12, 2024, 08:57:43 pm

Title: ODBC escape convert error
Post by: Guillaume on January 12, 2024, 08:57:43 pm

Hi,

I have 2 postgres EA DB available via the PCS. Once authenticated, accessing one of them leads to a popup with the following error: ODBC escape convert error
Looking at the DBError.txt, I identified the associated query:

SELECT DISTINCT t_diagram.Diagram_ID, t_diagram.ea_guid, t_diagram.Name as DgmName, t_package.Name as PkgName FROM t_diagram LEFT JOIN t_package ON t_diagram.Package_ID = t_package.package_ID WHERE t_diagram.Diagram_ID IN (1,2,3,TMPXMI:{A45F0E83-485D-48c0-A238-F03BE45A4BD5},4,5)

The other Postgres EA project works fine. I wonder if this could be due to the EA project content or a config issue on the PG DB.

Has anyone come across this ?

Title: Re: ODBC escape convert error
Post by: Geert Bellekens on January 12, 2024, 09:05:10 pm

"TMPXMI:{A45F0E83-485D-48c0-A238-F03BE45A4BD5}" seems like the culprit here, since diagramID's are supposed to be integers.

Looks like this is some kind of temporary xmi import artifact that has not been properly cleaned up.

I would first run a project integrity check, and if that doesn't help, look for the thing with that GUID, and delete it.

Geert

Title: Re: ODBC escape convert error
Post by: Guillaume on January 12, 2024, 09:30:25 pm

Hi Geert,

I indeed thought about it and ran the integrity check which fixed a number of issues but not this one.
Looking at the query, I found the diagram from the GUID in TMPXMI which had been generated using an XMI import. A minor update + saving the diagram fixed the issue.

Thanks,
Guillaume