Create new engineering model - handeling of active domains is different with and without source model

[meritvdlee]

Prerequisites

• [x] I have written a descriptive issue title
• [x] I have verified that I am running the latest version of the COMET-IME
• [x] I have searched open and closed issues to ensure it has not already been reported

Description

When creating a new engineering model you have the option to select Active Domains. If you create a new engineering model from a source model and you select one or more Active Domains you get an error (see logs). If you create a new engineering model without a source model and you select one or more domains it does correctly create the model with all the domains.

Steps to Reproduce

Logs

The CDP4 Services replied with code InternalServerError: Internal Server Error: "exception:23505: duplicate key value violates unique constraint \u0022EngineeringModelSetup_ActiveDomain_PK\u0022\n\nDETAIL: Detail redacted as it may contain sensitive data. Specify \u0027Include Error Detail\u0027 in the connection string to include this information."

• [ ] There are no logs regarding the issue
• [x] I have attached a log file or included the relevant section in this issue

System Configuration

• COMET version:
  • [ ] COMET-IME: 9.6.0.1
  • [ ] Other:
• Web Services:
  • [ ] CDP4/COMET Web Services version: 8.0.0
  • [ ] OCDT WSP version:
• Environment (Operating system, version and so on):
  • [ ] Microsoft Excel (32/64 bit):
  • [ ] Windows OS (32/64 bit): Windows 11 Enterprise, 64 bit
  • [ ] Additional information: