Messages

1

Bugs and Issues / How do I visualize a root node in a package diagram?

« on: May 03, 2024, 06:48:04 pm »

I have created a package diagram and can drag-and-drop package (and "view") elements from the Project Browser into the diagram to visualise them but this does not work for Root Nodes. Is this a bug?

2

Automation Interface, Add-Ins and Tools / Floating license server and windows authentication/single sign-on

« on: August 04, 2023, 08:13:40 pm »

Good morning all!

I am confused about whether it is possible to use Windows (Active Directory) authentication with the floating license server; please can anyone share how to accomplish this?

I am still confused after reading...
https://sparxsystems.com/enterprise_architect_user_guide/16.1/the_model_repository/cloud_server_iis.html
“In version 3 of the Pro Cloud Server, native support for Windows Active Directory and OpenID single sign-on was added, providing a more integrated, robust and secure single sign-on methodology.”

However, it is not clear whether this independently applies to the floating license manager…
https://sparxsystems.com/enterprise_architect_user_guide/15.2/team_support/single_sign_on.html

3

Automation Interface, Add-Ins and Tools / Is MDG Link for DOORS only compatible with the 32 bit build of Sparx EA 16.1?

« on: June 15, 2023, 07:30:30 pm »

Is the MDG Link for DOORS Version 3.0 Build 301 only compatible with a 32 bit build of Sparx EA 16.1?

The 64 bit version of Sparx EA version 16.1.125 does not recognise it in the Specialize ribbon.

I could not find any additional information at:
https://sparxsystems.com/products/mdg/link/doors/index.htmli

4

Bugs and Issues / Re: Aggrieved about aggregation using SQL queries

« on: April 25, 2023, 06:41:59 pm »

Thanks for your comprehensive (if slightly unsettling) replies, Gentlemen!

5

Bugs and Issues / Re: Aggrieved about aggregation using SQL queries

« on: April 20, 2023, 08:35:05 pm »

Whilst I have no doubt your reasons are impeccable, I don't really get why testing the Subtype is such a bad thing (apart from the "is null" issue, of course)?

6

Bugs and Issues / Re: Aggrieved about aggregation using SQL queries

« on: April 20, 2023, 08:08:17 pm »

Sorry, query should be:

Code: [Select]

select * from t_connector
where Connector_Type = 'Aggregation'
and (SubType = 'Strong'
or SubType = 'Weak'
or SubType is null);

7

Bugs and Issues / Aggrieved about aggregation using SQL queries

« on: April 20, 2023, 07:38:06 pm »

I am very surprised about needing to query for SubType is null in Aggregation relationships; surely it should either be 'Strong' or 'Weak'? Could this be a bug?

Code: [Select]

select Start_Object_ID from t_connector
where Connector_Type = 'Aggregation'
and SubType = 'Strong'
or SubType = 'Weak'
or SubType is null;

8

General Board / Re: Can't focus on finding conveyed items on connectors in SysML IBD diagrams?

« on: January 04, 2023, 02:49:14 am »

Thanks for your suggestion BobM; I translated it into the following query:

Code: [Select]

select
c.ea_guid  as CLASSGUID,
c.Connector_Type as CLASSTYPE,
't_connector' as CLASSTABLE,
ISNULL(c.Name,'NO_NAME') as ConnectorName,
os.Name as Source,
ot.Name as Target
from t_connector as c
left join t_Object as os
on c.Start_Object_ID = os.OBJECT_ID
left join t_Object ot
on c.End_Object_ID = ot.OBJECT_ID
where
c.Connector_Type = 'InformationFlow'
and c.ea_guid in (
select x.Client
from t_xref x
left join t_object o
on x.Description LIKE CONCAT('%',o.ea_guid,'%'));
Unfortunately, it still results in the same issue.

The thing is that this query does the right thing in a custom SQL query but does not work as a Focus window custom query. I have logged it as a bug, although maybe some people will choose to regard it as an enhancement... :-D

9

General Board / Can't focus on finding conveyed items on connectors in SysML IBD diagrams?

« on: January 04, 2023, 12:13:41 am »

Happy New Year!

I have the following SQL query (for Microsoft SQL Server) that will find conveyed signal items on connectors in SysML IBD diagrams:

Code: [Select]

select ea_guid as CLASSGUID, Connector_Type as CLASSTYPE, 't_connector' as CLASSTABLE, *
from t_connector
where ea_guid in (
select x.Client from t_xref as x
join t_object as o
on x.Description like concat('%', o.ea_guid,'%')
where x.type = 'connector property'
and x.Behavior = 'conveyed'
and o.Object_Type = 'Signal');
This is quite handy, so I want to make a query that works within a search folder inside the Focus window... I modified the query as follows:

Code: [Select]

select ea_guid as CLASSGUID, Connector_Type as CLASSTYPE, 't_connector' as CLASSTABLE, isnull(Name,'NO_NAME') as Name   
from t_connector
where ea_guid in (
select x.Client from t_xref as x
join t_object as o
on x.Description like concat('%', o.ea_guid,'%')
where x.type = 'connector property'
and x.Behavior = 'conveyed'
and o.Object_Type = 'Signal');
I added

Code: [Select]

isnull(Name,'NO_NAME') as Name to the query so that there is always something to click in the returned result set, even if the connector is nameless.

Unfortunately, "Find in diagrams" is greyed out for the rows returned in the Focus search result set. Can anyone suggest what I have done wrong (or might this be a bug)?

10

General Board / Re: Sparx EA revision control with server repositories

« on: September 07, 2022, 08:30:03 pm »

Support for multiple users and version control are sort of orthogonal issues (at least in Sparx EA).

Assuming you can get administrator access to the server machine, you could install Pro Cloud Server and use the basic included functionality to share access to a FEAP repository. Sparx provide some helpful documentation about how to do it https://sparxsystems.com/resources/user-guides/16.0/repository/cloud-based-repositories.pdf

You would then need to configure external version control separately. I prefer to use Subversion for this. Again, Sparx provide some helpful documentation about this https://sparxsystems.com/resources/user-guides/16.0/repository/change-management.pdf

11

General Board / Re: Can SQL be used to find the custom sort order of elements inside a package?

« on: September 07, 2022, 08:04:31 pm »

Excellent! Thank you very much for your assistance gentlemen!

12

General Board / Can SQL be used to find the custom sort order of elements inside a package?

« on: September 06, 2022, 10:54:37 pm »

Sparx EA usually sorts the elements inside a package alphabetically when displayed in the browser. However, this can be overridden by manually setting a sort order. Can SQL be used to find the custom sort order of elements inside a package in the browser?

Not sure which tables in the repository (if any) might hold this information... I have been looking at t_object, t_xref and others but no luck so far...

13

Bugs and Issues / Re: Error - Missing (0x800401f3) from MDG Link for DOORS 3.0.301.4

« on: January 27, 2021, 12:22:27 am »

The good news is that after our IT guys "massaged" the repackaged installer, we have successfully installed the DOORS/EA MDG from the Software Centre and
it appears as an icon on the Sparx EA ribbon. No error messages are displayed in the "Manage Plug-Ins" window. :-)

The bad news is that connecting to DOORS fails...
We (briefly) see a dialog box indicating that connection is in progress but then it disappears and no connection is made.

After getting DOORS working again on my machine, I see the same issue. The Sparx website lists the requirements (System Requirements for DOORS MDG Link | Sparx Systems) including "DOORS® 9.6.1 or later".

We are running with DOORS version 9.7.0.1, so should work according to the requirements. Can anyone else report success with using this configuration?

14

Bugs and Issues / Re: Error - Missing (0x800401f3) from MDG Link for DOORS 3.0.301.4

« on: January 26, 2021, 11:57:11 pm »

Thanks Geert,

I tried logging a bug report with Sparx but did not even get an automated reply saying my problem had been received; not sure why that did not work.

Whilst I agree there are upsides to EA installed using some kind of "remote desktop" solution, there are potential problems around this deployment option harming the use of external scripting options for power users. :-(

15

Bugs and Issues / Re: Error - Missing (0x800401f3) from MDG Link for DOORS 3.0.301.4

« on: January 20, 2021, 08:20:01 pm »

After some investigation of the issue by IT support, they reported the following:

So it is installed with System rights on SCCM Software Center. When you installed from the share (using elevated privileges) it effectively installs as a limited user installation giving you the correct rights to use the application.

So the question to Sparx is can they provide a user-based installer that installs to Program Data rather than Program Files so that it will register and install correctly (or something like that). Ideally we want to deliver it via Software Center – so we can ask why when installed with the system privs (standard process) will it not work correctly.