Messages

1

General Board / Re: Locate Archimate profile in DB using SQL

« on: January 14, 2022, 07:27:34 pm »

My fear is that if I delete the folder and import the XMI the classifier links will be corrupted.

Don't delete anything. Just export, edit, import.

Yes, I did it on a test package, it alters the object and is not seen as ArchMate 2 Business Actor but as a Class object. As I see in the xml, just search and replace may not do the trick, some paths must be adapted for ArchiMate 2. I've corrected them by hand using the GUI last night, I will keep this in the back of my mind and if I find the fix I'll update here.

2

General Board / Re: Locate Archimate profile in DB using SQL

« on: January 14, 2022, 09:13:46 am »

I was trying to roll back the business actors from a package which was migrated from 2 to 3 and should not have been.

Perhaps the easiest way would be to export to XMI, open in a text editor, find and replace 'ArchiMate3', then re-import. It's not a universal solution - sometimes it's more than the stereotype that changes between technology versions - but for ArchiMate business actors it will be enough.

I have an XMI export done before the migration. I use the business actors  as classifiers and their instances are associated to some business processes. My fear is that if I delete the folder and import the XMI the classifier links will be corrupted. At this point I estimate that using the Cinderella method and changing each actor properties by hand in GUI is safer than importing and creating more errors. If this fails I can use the XMI back-up I've done for each package or maybe renounce all pride and go to DB admin and ask to roll back the DB to yesterday.

UPDATE, I've reimported a small number of elements, although I've preserved the GUID the links between classifier and instances  does not work properly, if I try to locate the actor in all diagrams it does not work but the instances retain the link, it works if i use Locate classifier in PB on the instance, I suspect is due to the object having a new object_id even if the GUID did not change. As I see it i can reload al actors, and using sql I can match them to the instances using the field classifier_guid and the update the fiel classifier with de new actors object ID. It may work.

3

General Board / Re: Locate Archimate profile in DB using SQL

« on: January 14, 2022, 08:37:28 am »

There is a script that will update your ArchiMate2 to ArchiMate3 for you. It's standard included in the MDG

Yes, the script works to migrate ArchiMate 2 to 3, I was trying to roll back the business actors from a package which was migrated from 2 to 3 and should not have been.

4

General Board / Re: Locate Archimate profile in DB using SQL

« on: January 14, 2022, 05:25:10 am »

The profile itself is not stored in t_xref, just the stereotype information from the profile (it's FQN).

The profile is either in the search path for the MDG, your %appdata% for EA, in EA's prorgram folder (internal and MDG) or imported in the model where it's in t_document.

q.

Hi, you got me confused, maybe I did not used the proper naming with profile. If I use the GUI and check an object properties I have a stereotype field with an option menu, for a Archimate business actor in the profile field I can se Archimate 2 or 3 based on the Archimate version under which it was created. Now in t_xref I found where the stereotype ie stored, but I suspect it is not the only place, since I chose to alter the version in the DB from 2 to 3 or 3 tot 2 the object profile is not change but EA is interpreting it as Class oject without profile. From what I found on the forum so far a "Profile Metatype" exist but I did not figure it out where is stored.

5

General Board / Re: Locate Archimate profile in DB using SQL

« on: January 14, 2022, 12:45:04 am »

Update, I've found the info in t_xref, should I look for it in more places?

6

General Board / Locate Archimate profile in DB using SQL

« on: January 14, 2022, 12:07:33 am »

Hi guys,

Can you tell me where in the DB is stored the archimate profile of a business actor ? I've searched t_object and t_objectproperties and did not found it. I have some Archimate 2 business actors and some Archimate 3 and I need to find them all without searching all the folders in the GUI. Also I did not found related posts on the forum.

Thank you.

7

General Board / Re: Login in issues using windows log in.

« on: January 11, 2022, 11:57:03 pm »

Hi guys,

We are still investigating but as a temporary solution adding the users in EA as [email protected] does the trick.

If we find more info I will post it here.

Thank you,

8

General Board / Re: Login in issues using windows log in.

« on: January 10, 2022, 07:09:12 pm »

Thank you guys,

The schema is not the last version but the users are standardized and should not exceed 32 characters.  We investigate the access problem and will provide an update here if we got any.

Thank you guys.

9

General Board / Re: Login in issues using windows log in.

« on: January 08, 2022, 01:41:00 am »

Hi,

Users connect through Pro Cloud (pro cloud is connected with technical user to the DB).

the error in system output is: "login: Windows user xxxx\john.doe is not a member of the model." followed by the login window

10

General Board / Re: Login in issues using windows log in.

« on: January 07, 2022, 10:41:07 pm »

Thank you Geert, can you take the time and guide me on where to check this permissions. I suspected this might be the case due to the error about user not having access to the model.

11

General Board / Re: Enable SysML 1.3 when only 1.5 is available

« on: January 07, 2022, 10:08:31 pm »

Hi, as Geert recommended you need to create a custom perspective to display older version in ea 15. See the userguid in this sections.

https://sparxsystems.com/enterprise_architect_user_guide/14.0/user_interface/techno_sets.html
https://sparxsystems.com/enterprise_architect_user_guide/14.0/user_interface/what_perspectives.html

12

General Board / Re: Login in issues using windows log in.

« on: January 07, 2022, 09:06:24 pm »

The same config with groups defined in EA and users imported from AD is on both repos all user can log in on one, and some cannot on the second.

13

General Board / Re: Login in issues using windows log in.

« on: January 07, 2022, 09:04:09 pm »

Groups are not link to AD (the check box is not checked in groups) only the users are imported and have Accept windows login enabled. In some cases some but not all user groups can log in, for some other groups all users can log in.

14

General Board / Re: Login in issues using windows log in.

« on: January 07, 2022, 08:49:26 pm »

I believe that I've performed this steps correctly. I've created groups in EA without AD link and then in users I've used import to get AD users for each group. The problem is that some users in the same group can log in and others can not.  The users were imported at the same time. I'm stuck.

15

General Board / Re: Login in issues using windows log in.

« on: January 07, 2022, 08:30:14 pm »

Hi,

Enable security is done as it is mandatory in order do define groups and add users.
Can you provide more details on the part with the AD permission?