Messages

1

General Board / Re: Table of object-specific properties

« on: April 28, 2023, 09:01:17 pm »

I guess I found it in t_xref

2

General Board / Table of object-specific properties

« on: April 28, 2023, 08:16:02 pm »

Hello,

does anyone know in which table and column I can find the object-specific properties like the "Redefined Property" of a Port?

Thank you.

3

General Board / Re: How to Enable a MDG Technology

« on: April 28, 2023, 12:43:57 am »

Thank you. You are right, it was disabled from the options!

And thanks for the perspective advise!

4

General Board / How to Enable a MDG Technology

« on: April 27, 2023, 10:06:18 pm »

Hello

I would like to enable an internal MDG Technology (CodeEngineering) for our Model in EA 15.1.
Unfortunately this is not possible, since it says "This technology has been disabled by model administrators and can't currently be changed".
What rights do I need to enable Technologies? I can disable technologies but not enable them again?

Thank you!

5

Bugs and Issues / Re: Irregular crashes of EA 15.1

« on: April 21, 2023, 05:18:37 pm »

We dont use scripting/add-in in our MDG.
We do use some workflow skripts in our main model to control version and status handling, but actually this is independent from the element type.

We observed a higher number of crashes when dragging the CallAction from our Toolbox to diagrams. Is this giving any hints to the problem?

Thank you.

6

Bugs and Issues / Re: Irregular crashes of EA 15.1

« on: April 18, 2023, 09:44:51 pm »

Thanks for your replies.

In fact the most direct correlation of the crashes occure with an element defined in our MDG Technology.
Its an extension of the metaclass "Action" of Kind "CallOperation".
The definition of the stereotype is quite easy:

Code: [Select]

<Stereotype name="ExampleName" notes="">
<AppliesTo>
<Apply type="Action">
<Property name="context" value=""/>
<Property name="effect" value=""/>
<Property name="kind" value="CallOperation"/>
</Apply>
</AppliesTo>
</Stereotype>

Is there anything wrong with that?

Have you checked the schema version of sql server is right for v15.1

I'm not the one who is setting up the SQL-Server. So, to be honest, I've no idea
Can you help me concretize the question for our IT? What is the right schema?
We are working on this setup for several years already without any major problems. Is it possible that the wrong schema only affects in some situations (maybe with a quite new stereotype in our MDG Tech)?
Thank you!

7

Bugs and Issues / Irregular crashes of EA 15.1

« on: April 14, 2023, 07:30:49 pm »

Hello,

we are working with EA 15.1.1526 on a MS SQL Server DB.
About 30 People are working in different parts of the same model. Security is enabled to avoid concurrent work on the same elements.

We experience erratic crashes of EA in a form that EA simply shutdown without any information. After restart the model opens normally but the last touched diagrams may show up in an undesired condition.
It seems like some actions leads to an accumulation of this crashes but its hard to find a common cause.

Is there any way to look into the origin of this behavior or find out how to avoid it?

Thank you!

Best regards

8

General Board / Restrict use of Status Attribute for Stereotypes in MDG Tech

« on: May 19, 2022, 05:26:52 am »

Hello,

I would like to restrict the available options for the Status attribute of Elements wich are defined as Stereotypes in our MDG Technology.
What is a good way to do that? Maybe stereotype constraints (I couldnt find documentation or examples how to define them)?

Most of our stereotypes have the same status life cycle but some are different.
So first of all I would like to reduce the selectable status values of a stereotype.
In the next step I would like to define constraints for status changes.
Any suggestions to do that?

Thank you!

9

General Board / Re: How to get CreatedDate for connector

« on: April 02, 2022, 11:09:03 pm »

Actually I need to analyse this information for existing connectors. So adding additional information might be a solution for future preparation but its not for my current problem.

Since I only need to know the order of creation for a subset of connectors I'm thinking of comparing the connector ID as an alternative way.
Probably I can't trust the ever-expanding characteristic of the ID, but is there a good chance to be close to it at least?

It won't be the end of the world if I'm wrong in some cases with this approach but it would be useless if the result is more like a fortunate coincidence.

What do you think?

10

General Board / How to get CreatedDate for connector

« on: April 02, 2022, 09:53:56 pm »

Hello,

I'm looking for a way to get the date of creation for connectors via script.
Unfortunately there is noch CreatedDate in t_connector as in t_object.

Maybe there is a chance with t_snapshot?
But the Information here seams to be quite difficult to decode.

Any ideas?

Thank you!

wzr

11

General Board / Re: Deleting wrong record in t_seclocks

« on: February 21, 2022, 08:43:22 pm »

What consistency check do you mean and how to run it?

Configure -> Model -> Integrity -> Project Integrity doesn't report this point.

Thank you!

12

General Board / Deleting wrong record in t_seclocks

« on: February 19, 2022, 10:28:42 pm »

Hello,

when I'm transfering our DB from MSSQL-Server to a local eapx file i'm always getting an error message, saying that there is an entry in t_seclocks with an empty entity id. The transfer is still completing successfully, but the message annoying.

The result for the following query is exactly one row

Code: [Select]

SELECT *
from t_seclocks
where t_seclocks.EntityID = ''
Since this entry doesnt make any sense to me at all, I'm thinking of deleting this row by using the API:

Code: [Select]

Repository.Execute("DELETE from t_seclocks where t_seclocks.EntityID = '' ")
Do you see a chance that this will harm our model in any way?

13

General Board / Re: Repository method SQLQuery() with aggregate function in select statement

« on: February 13, 2022, 08:53:03 pm »

Thank you Geert, it's working now!

I was just checking the XML result without column name in the local DB which looks like that

Code: [Select]

<Expr1000>44134,134468</Expr1000>
Is it possible that the SQL Server is trying to process this somehow because the node is called Expr...?

14

General Board / Repository method SQLQuery() with aggregate function in select statement

« on: February 13, 2022, 08:38:34 pm »

Hello,

I'm currently trying to use COUNT or AVG functions in my query for the the Repository.SQLQuery() call.
Even though the very simple query works fine using the SQL Scratch Pad by GUI, it leads to a kind of scaring Error Popup when using it with the API method.

The simple (and useless) example

Code: [Select]

SELECT AVG(t_object.Object_ID) FROM t_object
leads to the messange "Error processing XML document:" and additional in german (system language) something like "to create nodes of type 'ELEMENT' you need to declare a valid name".

I wasnt aware of processing a XML document at all and even more I dont want to create an Element-Node 

Does anyone know whats happening here?
The DB is running on a MS SQL Server. After transfering the same DB to a local project (MS JET?) the same call creates a proper result without the error message.

Thank you!

15

General Board / Re: Element needs to be locked to activate Info View!?

« on: January 25, 2022, 11:15:37 pm »

Thank you for the very fast replies!

Until now I could get around the UPDATE SQL stuff since I'm a bit scared of that one

Paolo, what exactly do you mean with

I've used it in Group and User Lock diagram.  Worked OK forme.

?
You can activate the InfoView with just user lock on the diagram and without locking the element you are activating the InfoView for?