Messages

1

Bugs and Issues / Re: EA16.1 (1628) DB RetroEngineering gives an error

« on: May 28, 2025, 11:55:08 pm »

By now, I would have confirmed that the problem exists in v17.0 or v17.1.

Just a thought,
Paolo

(Experience has shown that to get any traction on a defect, it must be present in the latest version)

Thanks,
I'm still progessing on that.
Problem still exists on 17.1

Screenshots i sent were with DB2 Odbc Driver v10.5
When I try with Driver v 11.5 I have this error message. Is there any way to have a more verbose message ? Obviously this is ok while testing the connection in ODBC panel



Many thanks

2

Bugs and Issues / Re: EA16.1 (1628) DB RetroEngineering gives an error

« on: May 14, 2025, 10:21:23 pm »

Have you tried importing everything except for foreign keys? You might even be able to exclude just the offending FK.

I have seen that error before and I am trying to find out if I have any notes on what cause it and how it got fixed.

As long as I'm trying to import either FK / PK / Constraints it blocks.

Seems like EA itself doesn't allow duplicate in its own structure.
Weird thing is that I managed to do the exact same retro 3 years ago and don't remember having suffered a lot like this.

I tried the retro within qea, eap and SQL based repo.
I have different formulations for the error message but still point the same thing regarding an which can't be duplicated in operationparams

3

Bugs and Issues / Re: EA16.1 (1628) DB RetroEngineering gives an error

« on: May 14, 2025, 06:16:55 pm »

Thanks a lot.

Also, are you reverse engineering from scratch or refreshing a model? If refreshing a model, there are is an option on the reverse engineering screen to update the existing model. 

I meant deleting the constraint in your model (assuming you are reverse engineering over an existing model)
If not then I would check the constraint in the database as Modesta Vega suggested.
There might be something weird going on why you get the error on this particular constraint.

Geert

This is a import from scratch.
I also tried an import with only tables list (no FK, no PK, no Index) and it's ok.
Once I add PK, FK or Index it fails.
As said before, i'm just supporting the retro and can't mess with the data structure as it is.
I'm gonna submit a ticket to support.
Many thanks.

4

Bugs and Issues / Re: EA16.1 (1628) DB RetroEngineering gives an error

« on: May 14, 2025, 01:41:39 am »

Thanks a lot for your replies

You probably want to delete the constraint operation that it is trying to create, and then try again.

You can send a bug report to Sparx support: https://sparxsystems.com/support/forms/bug_report.html

Geert

Hi Geert
Maybe I didn't get your point but I'd rather not touch to the data structure I try to retromodel.
Regarding the bugs I come across there's a lot (mainly on interface)

What type of database are you trying to reverse engineer (SQL Server, PostgreSQL)?

Does Sparx EA reverse engineer anything before getting to that point?

Is it giving you any indications of whether it is failing to read the constraint of failing to write its representation to the model?

Hi Modesto

It's failing to write in the model. Everything is ok until it tries to add the tables to the model. Seems like there's a unique constraint in the model (we use qea), I tried on EAP which gives me the same kind of error but in French.
I'm not a DB Admin but seems like the EA DB structure can't handle the way our database is designed.
EA points to a solution which is to redesign the index of t_operationparams to allow duplicate values but don't know if it's impacting.

here are the screens

5

Bugs and Issues / EA16.1 (1628) DB RetroEngineering gives an error

« on: May 08, 2025, 12:38:49 am »

Hi guys,
when I try to make a retro engineering for an ODBC based connection, when comes the moment to import tables into the packages I have this error



Moreover, there a few bugs in this interface, for example when I tick a schema it brings me all the tables from all schemas.
is there a support team reachable for those kind of issues ?

Many thanks

6

General Board / Simple way to migrate from 32 to 64 Version

« on: March 20, 2025, 02:56:09 am »

Hi guys,
we have a setup with more than 200 PC installed on EA 16.1 32 bit version.
We plan to upgrade to 17 and by the same time user the 64 Bit version.
During our tests we found that 32 and 64 bits version are installed side by side and 64 doesn't inherit from 32 bits config.
Is there an easy way to migrate and keep settings from 32 to 64 ?

Many thanks,

7

PCS General Board / Re: Difference PCS OSLC API from EA or 3rd party

« on: February 19, 2025, 02:37:12 am »

Besides that, they are not limited to using the PCS interface, there is also the (native) database connection which might be used directly in case the PCS interface will not suffice.

I think one of the major points of the PCS server is to hide the database and allow only connections through PCS.

Direct client/database connections are frowned upon by security architects.

Geert

Hi Geert,
we're considering Prolaborate.
At the moment we have an installation with EA Heavy client and direct connection to DB.
We have more than 50 dbs, a db per project/app repository and each one has its own AD group.
How do you manage groups and access with PCS ?
Does it means PCS has full access to all databases (eg with a Service account ?)
We need to enable security in every project we have to handle authorizations or is there a way to centrally manage it ?

Many thanks

8

Bugs and Issues / Re: Error processing XML document message when trying to create a new baseline

« on: May 02, 2023, 11:31:17 pm »

None of those works,
actually xmi doesn't stop on the same item, and when I try to export packages from items which seem to block everything is ok.
Seems more like blocking after a certain amount of items (9900 and so)

Any idea ?

Hi Geert thanks a lot (again) for your reply,
I tried an xmi export, I got the same message and I see it stops on an element but don't know if the element displayed is the last processed or if it's the one failing.

Using integrity check tool I see a few problems (invalid connectors and tagged value) but it doesn't tell to which object it refers ?

Thanks again

You can further narrow it down by temporarily moving the element to another package, and try the xmi export again.

With regards to the project integrity. Simply fix all errors and see if the problem with the XMI persists.

Geert

9

Bugs and Issues / Re: Error processing XML document message when trying to create a new baseline

« on: May 02, 2023, 10:15:49 pm »

Hi Geert thanks a lot (again) for your reply,
I tried an xmi export, I got the same message and I see it stops on an element but don't know if the element displayed is the last processed or if it's the one failing.

Using integrity check tool I see a few problems (invalid connectors and tagged value) but it doesn't tell to which object it refers ?

Thanks again

A baseline is basically an XMI export stored in the database.

XMI is an XML format, so that's probably where it goes wrong. For some reason he can't create a valid XMI export.

What you could try is to create an XMI export manually. If that fails, try to narrow it down to the exact element, package, or diagram that causes the problem.
There might be an invalid (or empty) name somewhere or something like that. (e.g. a name containing "<" or ">",...)

A project integrity is also worth trying.

Geert

10

Bugs and Issues / Error processing XML document message when trying to create a new baseline

« on: May 02, 2023, 06:12:25 pm »

Hi,
When I try to make a new baseline on my project I have an error message "Error Processing XML Document:"

Any ideas about this ? I'm on EA 16.1

Many thanks

11

General Board / Re: AD based native SQL server connection on EA16

« on: November 18, 2022, 03:04:04 am »

You can still connect the to the server like you did before.
The new "native" connections are an extra way to connect, not the only way.

Geert

Hi Geert,
I know but I was interested connecting "the native way" with AD because I have some problems with "Data Link Properties" way, especially a problem already documented here : https://sparxsystems.com/forums/smf/index.php/topic,41896.0.html

Many thanks

12

General Board / AD based native SQL server connection on EA16

« on: November 17, 2022, 09:26:59 pm »

Hi guys,
I saw that on EA16 we had a new native connection feature.
We currently have a sql server based repository with one DB per project. Users are authentified direct within SQL server with AD groups.
User XX is in AD group PROJECTA which has access to DB PROJECTA.
Previously with Data Link Properties we had an option to use integrated security but I don't find it for native connections.
Has it disappeared ?

Many thanks

13

General Board / Re: Use Encryption for Data

« on: October 25, 2022, 11:43:56 pm »

Hi Wivel,
thanks for your answer.
Not exactly,
OP has the same problem I have, using the data link connection provided with EA, we have a SSL error.
OP says that with other clients he ticks "trust server certificate" and wanted to know if there was a way to have this option in the connection string.

Hi guys

Not sure if this is what you ask, but you can enter your own connection string in EA:

• Select 'Open Custom' from the Start Page. Here you can type in a connection string.
• If you have already added the repository, select 'Manage Projects' from the Start Page. Right click on the repository on the list and select 'Edit Connection string'

Its on EA 15.2 BTW.

Henrik

14

General Board / Re: Use Encryption for Data

« on: October 25, 2022, 03:07:14 am »

same problem here, did you manage to resolve it ?

15

Bugs and Issues / V15.2 - Import table from ODBC postgre crashes if synchronize elements

« on: May 11, 2022, 12:35:55 am »

Hi guys,
We're on EA 15.2, with a Postgre DB.
When trying to synchronize existing tables in the model EA crashes (windows disappear). Was thinking about a db timeout issue (crashed at about 30 seconds) but dit the same with a new model and import went through (lasted roughly 40 secs)
Did any of you already had the issue ?
Is there any crash log I can check ?

Many thanks