ODBC escape convert error

[Guillaume]

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 ?

[Geert Bellekens]

"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

[Guillaume]

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