Database errors during duplication

[miksko]

I regularly set up a teaching environment where I want the participants to be able to experiment by manipulating their own set of use cases and requirements.

• I have produced a number of use cases and requirements, to keep as templates.
• I copy them by using the Sparx function Copy to Clipboard->Full Structure for Duplication.
• Then I move to the workspace of each participant and use the Paste Elements from Clipboard function.

During the following duplication process the database produces a number of errors, telling me I'm violating unique key constraints and such. I don't understand why, since a proper duplication should produce new keys which are unique.

[qwerty]

Run  consistency check. Should be done weekly...

Other than that: why not make EAP copies for your students?

q.

[Sunshine]

If you are using SQL Server then check the version of the schema is compatible with your Sparx EA Client.
https://sparxsystems.com/resources/repositories/index.html

Please Note: Throughout Enterprise Architect's history Sparx Systems have endeavored to avoid changing the underlining database structure to remain compatible with older versions. Since 2010 there have been the following schema releases:

Schema 1558 released in Feb-2021 with Enterprise Architect v15.2 (build 1558)
Schema 1220 released in Jun-2016 with Enterprise Architect v13 (build 1302)
Schema 851 released on 10-Feb-2010 with Enterprise Architect v8 (build 851)

[miksko]

Other than that: why not make EAP copies for your students?

I presume you mean one local model per user. Our setup is a repository stored in an MS SQL DB. And the environment we set up is not only for educational purposes but also to let the (in-house) participants use as a test environment later on.
If I was the administrator of the environment, I could of course export the template model and then import it to each participant's sandbox, but I'm not.

Mikael

[miksko]

If you are using SQL Server then check the version of the schema is compatible with your Sparx EA Client.

We are! Thanks for the input. I certainly expect our consultants to check out for such things but it certainly doesn't hurt to double-check.

[miksko]

If you are using SQL Server then check the version of the schema is compatible with your Sparx EA Client.
https://sparxsystems.com/resources/repositories/index.html

Please Note: Throughout Enterprise Architect's history Sparx Systems have endeavored to avoid changing the underlining database structure to remain compatible with older versions. Since 2010 there have been the following schema releases:

Schema 1558 released in Feb-2021 with Enterprise Architect v15.2 (build 1558)
Schema 1220 released in Jun-2016 with Enterprise Architect v13 (build 1302)
Schema 851 released on 10-Feb-2010 with Enterprise Architect v8 (build 851)

I just checked this myself (after noticing that you can now do it through the Help->About EA menu in the client). The schema version is 1558, which is the latest.