Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Topics - Geert Bellekens

Pages: [1] 2 3 ... 16
1
When trying to save (update()) an EA.ConnectorTag after setting the value to a string larger than 255 characters, EA crashes hard.
So hard you can't even catch the exception when debugging.
The exception code found in the eventviewer is 0xc0000409 which means STATUS_STACK_BUFFER_OVERRUN

I just spent a fun half a day tracking down this issue :-\

The API should catch this type of problem and return a regular COM exception instead of crashing and burning.

Geert

2
Bugs and Issues / FK association not created at import from ODBC
« on: November 15, 2018, 11:30:55 pm »
When a foreign key is not referencing the Primary key of the other table (it exists in the wild, don't ask :-\) the FK association is not created.
Only the FK operation is created.
The result is that there is no indication in the database that both tables are related to each other.

Example database (SQL Server 2012):
Code: [Select]
USE [test database]
GO
/****** Object:  Table [dbo].[MESSAGE_IN]    Script Date: 15/11/2018 13:28:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[MESSAGE_IN](
[MESSAGE_IN_ID] [bigint] IDENTITY(1,1) NOT NULL,
[MESSAGE_ID] [bigint] NOT NULL,
 CONSTRAINT [PK__MESSAGE_IN] PRIMARY KEY CLUSTERED
(
[MESSAGE_IN_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[MESSAGE_IN2]    Script Date: 15/11/2018 13:28:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[MESSAGE_IN2](
[MESSAGE_IN2_ID] [bigint] IDENTITY(1,1) NOT NULL,
[MESSAGE_ID] [bigint] NOT NULL,
 CONSTRAINT [PK__MESSAGE_IN2] PRIMARY KEY CLUSTERED
(
[MESSAGE_IN2_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[MESSAGE_OUT]    Script Date: 15/11/2018 13:28:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[MESSAGE_OUT](
[MESSAGE_OUT_ID] [bigint] IDENTITY(1,1) NOT NULL,
[REFERENCE_MESSAGE_ID] [bigint] NOT NULL,
 CONSTRAINT [PK__MESSAGE_OUT] PRIMARY KEY CLUSTERED
(
[MESSAGE_OUT_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[MESSAGE_OUT2]    Script Date: 15/11/2018 13:28:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[MESSAGE_OUT2](
[MESSAGE_OUT2_ID] [bigint] IDENTITY(1,1) NOT NULL,
[REFERENCE_MESSAGE_ID] [bigint] NOT NULL,
 CONSTRAINT [PK__MESSAGE_OUT2] PRIMARY KEY CLUSTERED
(
[MESSAGE_OUT2_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[MESSAGE_OUT]  WITH CHECK ADD  CONSTRAINT [FK_MESSAGE_OUT_MESSAGE_IN] FOREIGN KEY([REFERENCE_MESSAGE_ID])
REFERENCES [dbo].[MESSAGE_IN] ([MESSAGE_ID])
GO
ALTER TABLE [dbo].[MESSAGE_OUT] CHECK CONSTRAINT [FK_MESSAGE_OUT_MESSAGE_IN]
GO
ALTER TABLE [dbo].[MESSAGE_OUT2]  WITH CHECK ADD  CONSTRAINT [FK_MESSAGE_OUT2_MESSAGE_IN2] FOREIGN KEY([REFERENCE_MESSAGE_ID])
REFERENCES [dbo].[MESSAGE_IN2] ([MESSAGE_IN2_ID])
GO
ALTER TABLE [dbo].[MESSAGE_OUT2] CHECK CONSTRAINT [FK_MESSAGE_OUT2_MESSAGE_IN2]
GO
Result is that between MESSAGE_OUT and MESSAGE_IN there is no relation whereas between MESSAGE_OUT2 and MESSAGE_IN2 there is one.
The only difference is the fact that one uses a primary key and the other one doesn't.



Reported

Geert

3
Bugs and Issues / problems importing Foreign Keys from ODBC
« on: November 09, 2018, 10:02:07 pm »
I'm using EA v14.1.1427 and SQL Server 2016.

After renaming a foreign key things go wrong when trying to import the changes into EA

Steps to reproduce:
- Import a simple test database with two tables and a foreign key between them
- Change the name of the foreign key in the database
- Show differences in the database builder
- Set Import All
- Import from ODBC

Notice that the fK relation has lost it's properties and it now a simple association with stereotype «FK» with no name or assigned columns.

Then
- Import DB Schema from ODBC again with the option to synchronize everything.
- This brings back the foreign key (with the new name) but still leaves the broken FK association in the model.

The result of this all then looks like this:


Reported to Sparx

Geert

4
Bugs and Issues / Project transfer much slower when invoked from scripting
« on: November 08, 2018, 02:21:28 am »
I'm using EA 14.1 on an Oracle backend on a Citrix environment.

When doing a manual project transfer the whole thing take about 10 to 15 minutes to complete.
In the log file I can see that the first part, clearing the data in the target model, takes less then 3 seconds.

When doing the same thing from a script, the project transfer is an order of magnitude slower.

Clearing the data in the target model when doing it via a script takes minutes instead of 3 seconds.

I didn't even wait for the complete transfer to finish!

Does anyone know why this might be happening?

The script I'm using is the following:
Code: [Select]
'[path=\Projects\Project DL\DL Scripts]
'[group=De Lijn Scripts]
option explicit
 
'
' Script Name: Automated backup of EA project databases
' Author: Davy Glerum, Geert Bellekens, Tom Geerts, Alain Van Goethem
' Purpose: Automated Project Transfer from DBMS to EAP file as weekly backup. See end of script for different databases that are backed up.
' Date: 07/11/2018

'
sub DeLijnDEV

Dim CurrentDate
Currentdate = (Year(Date) & (Right(String(2,"0") & Month(Date), 2)) & (Right(String(2,"0") & Day(Date), 2)))  'yyyymmdd'

'dim repository
dim projectInterface
'set repository = CreateObject("EA.Repository")

Dim FileName
Filename = "EA_Export.eap"
 
dim LogFilePath
LogFilePath = "H:\backups\"&CurrentDate & " DeLijnDEV (back-up).log"

dim TargetFilePath
TargetFilePath = "H:\Backups\"&CurrentDate & " DeLijnDEV (back-up).eapx"

dim eapString
eapString = "DBType=3;Connect=Provider=OraOLEDB.Oracle.1;...;"

'get project interface
set projectInterface = Repository.GetProjectInterface()

projectInterface.ProjectTransfer eapString, TargetFilePath, LogFilePath

'repository.CloseFile
'repository.Exit

' Dim newFilename
' newFilename = "H:\Backups\"&CurrentDate & " DeLijnDEV (back-up).eap"
'
' Dim Fso
' Set Fso = WScript.CreateObject("Scripting.FileSystemObject")
' Fso.MoveFile TargetFilePath, newFileName
   
end sub



DeLijnDEV


MsgBox ("Back-up Finished.")

Anyone know a workaround to speed things up?

Geert

5
After importing all of the differences between the database in EA and the database on the server, I still get a list of differences.
All of the differences are related to the position of columns. They all seem to be shifted somewhat, but they have the same internal order.


This was tested with EA v 14.1.1427 and an SQL server 2016 database.

Geert

6
Bugs and Issues / Timeout on SQL search query
« on: October 18, 2018, 07:11:17 pm »
We are using an SQL Server backend and one of our export searches returning a timeout after a while.
Does anyone know if you can somehow increase the timeout?
When running the same query directly in SQL Server Management Studio we don't get a timeout.

I know I can probably improve the performance of the query by rewriting it, but that is not what I'm looking for.
Optimizing the query would take a non-trivial amount of time, and since it's something we run only once every couple of months, we don't care if it takes 10 minutes to execute.

The query is a bit too long to post here (34.000 characters, 508 lines, the forum only allows 20.000 characters per post)

Thanks

Geert

7
When I create a «trace» relation in v12.1.1230 I get a connector of type Abstraction with stereotype «trace»
When I create the exact same «trace» relation in v14.1.1427 I get a connector of type Dependency with stereotype «trace»

WTF! >:(

Who?/Why?/What?

So now we are getting a nice mix of abstractions and dependencies in our models.
Not to mention the countless queries that are now broken, and a number of add-ins that depend on this relation being an Abstraction.

Was this an intentional change (I didn't see anything about it in the release notes) or a mistake?
In case of the latter I hope it gets rectified real soon.

Geert

PS. I'm not arguing Abstraction is better somehow than Dependency.

8
General Board / Automatically maintain users from AD group
« on: September 11, 2018, 05:03:42 pm »
In the release notes for version 14.1 I see this:

Quote
- Added option to automatically maintain the list of available users based on Windows Active Directory or OpenID groups

But I can't seem to figure out how this automatic function works.
Surely they can't mean that you can now press a "sync" button can they? That wouldn't count as automatic for me.

What I'm expecting from this is that I now only once have to set the link between the AD groups and EA groups and that's it. No more adding/removing users of users anymore. (Just like all the other products that integrate with AD) Am I expecting too much?

Geert

9
V12.1: When saving a UML profile from a package you could select the checkbox "Color and Appearance" to save the default appearance of an element in the UML profile.

V14(.1): The option to save Color and appearance is only available when saving a UML profile from a diagram (although the menu option is still called "save package as UML profile"


I can somehow understand the reasoning behind the change, but it was working fine before when using the default appearance (which is an attribute of the element, not of a diagramObject). Why change? Now I save all my profiles from their packages, except for the UML profile, for which I have to select the diagram.

Geert

10
Context:

My users are doing modelling Archimate Business Processes and linking them to Archimate Business Objects. The use
- Business Process
- Business Object
- Flow
- Some of my own Stereotypes extending standard Archimate elements.

They don't need any of the other Archimate element/connector types, and I don't even want them to.

Question:
Is there a way to link the existing Archimate Business Diagram to a toolbox of my own?
I know how to do it with the standard UML and Extended toolboxes, but hat process doesn't seem to work with MDG diagram types such as Archimate.

Thanks

Geert

PS. If all else fails I'll make a new diagram type in my MDG and change the stereotype all of the standard Archimate Business Diagrams to my new diagram stereotype, but I would prefer it to work on standard Archimate diagrams.


11
Bugs and Issues / Toolbox with extended stereotypes
« on: September 10, 2018, 04:30:16 pm »
I'm having issues building a toolbox for extended stereotypes.

The help page says to create a generalization between the stereotype and the metaclass that represents an existing stereotype.

I did as instructed, and then I tried to create a toolbox for my stereotype using the profile helper. I use the button "Add" and select my stereotype, but then nothing happens.

In previous versions of EA you had to create two connectors. One generalization to the existing stereotype, and one extend relation to the base metatype.
As an experiment I tried this and it magically made it work.

Does anyone have similar experiences? Am I doing something wrong, or is there a bug in the profile helper for toolboxes.

Geert

12
Automation Interface, Add-Ins and Tools / UML profile example (v14 flavor)
« on: September 05, 2018, 11:25:58 pm »
Hi,

Does anyone know a good resource to serve as an example for a UML profile in the v14 flavor?
I'm specifically looking for examples for things like
- metaconstraint
- metarelation

These should now be used as an alternative to the dreaded quicklinker CSV definition.

The manual still leaves a lot to my imagination.

Thanks

Geert

13
General Board / Diagram alignment helper lines
« on: September 05, 2018, 06:36:42 pm »
At the very start of v14 I was excited to see new red helper lines when placing elements on a diagram.

Now for some reason I don't see them anymore :-[. Does anyone know how to turn them back on?

I'm on v14.0.1422

Thanks

Geert

14
Bugs and Issues / EA.Element.Runstate setter does not work
« on: August 29, 2018, 11:52:31 pm »
The setter for EA.Element.Runstate doesn't seem to work.
No Code below results in
"Runstate = " where I would expect "Runstate = 123"

Code: [Select]
option explicit

!INC Local Scripts.EAConstants-VBScript

sub main
dim selectedElement as EA.Element
set selectedElement = Repository.GetTreeSelectedObject()
selectedElement.Runstate = "123"
Session.Output "Runstate = " &selectedElement.Runstate
end sub

main

Anyone know why? The manual simply says it's a string and it is read/write, so I would expect this code to work.

Geert

15
Bugs and Issues / DAO.QueryDef [3131] Syntax error in FROM clause.
« on: August 14, 2018, 10:30:00 pm »
I'm trying to write a somewhat complicated query, and I don't seem to be able to get EA to execute my query if it does a join with a subquery
I boiled it down to this type of statement:
Code: [Select]
select * from
t_attribute ta
inner join (select a.ID, a.Name from t_attribute a) dataq on dataq.ID = ta.ID
when I execute this in EA I get

DAO.QueryDef [3131]
Syntax error in FROM clause.


The annoying thing is that this executed perfectly fine on the same model when I execute it using SQL Anywhere.

Geert

Does anyone know a workaround for this problem?

Pages: [1] 2 3 ... 16