EA16 error on a PG DB when duplicating a diagram with the Deep option

[Guillaume]

Hello,

I'm testing EA16.1 (1623) on an environment using the Pro Cloud Server 5.1.121 (64 bit) and a Postgres DB.

We found an error when running a Copy/paste a diagram and selecting the option Deep to create new elements.
The error occurs when it duplicates the links for a specific diagram i.e. it works with other class diagrams.

Sparx Systems Database API [0x0001086]
Native Update FAILED with error:
22001 ERROR: value too long for type character varying(50)

Looking at the DBError.txt file, the associated query is: GetLongVal( "Connector_ID" )

I suspected this to be a PCS bug but there's nothing in the PCS logs.
I found a similar issue on this forum thread: https://sparxsystems.com/forums/smf/index.php/topic,47238.msg275536.html#msg275536

I ran some tests on my PC with a local PCS and Postgres DB and I don't have any error. It also works fine if the same process if carried with EA 15.1.
I also carried the following test: I did a copy/paste of the diagram using the Shallow option first, and then duplicated it using the Deep option and it worked. It seems to have something to do with diagramlinks. I haven't tried yet to run an integrity check which could be a solution.

I noticed also in EA16 that one has to run Copy Diagram twice before the Paste diagram menu is available in the target package.

[Guillaume]

An update on this issue: even though nothing is visible in the PCS logs, it seems to be related with the PCS 5.1 (build 5.1.123) since it works ok with a PCS 4.1 configured with the same Postgres DB.

Update: I managed to find the following error in the PCS logs

Code: [Select]

2023-02-20 11:35:38 [WARNING]: Thread 2282  Error opening recordset during update: 22001 ERROR:  value too long for type character varying(50)
2023-02-20 11:35:38 [WARNING]: Thread=2282  Could not update recordset on <...>, while working on column notes.
2023-02-20 11:35:38 [WARNING]: Sparx Systems Database API [4230]
2023-02-20 11:35:38 [WARNING]: Native Update FAILED with error: 22001 ERROR:  value too long for type character varying(50)
2023-02-20 11:35:38 [SYSTEM]:  Thread 2282  Removed stale connection to: <...>
2023-02-20 11:35:38 [WARNING]: Thread 2282  REQUEST_UPDATE on <...> FAIL. Error (18): Database exception (Forwarded to Enterprise Architect)



[Guillaume]

I managed to identify the query (insert into t_connector  ...) that generates this error. All details have been sent to Sparx via a Bug Report.