Messages

1

General Board / Re: user defined scripts gone

« on: September 29, 2025, 10:45:39 pm »

investigation status:
Our DevOps did a select on the script table to find out witch script was not returning a result: select * from table script id xxx  or > xxx < xxx
We found out that 2 scripts were not returning result in the query (reason still under investigation)
In the database directly we did a: delete from table where scriptid = xxx and xxx
This helped restore the hundreds user-defined scripts in the Scripting view

The investigation will probably not result to anything.
This might be caused by a something like a crash in the middle of saving a script or debugging.

Geert

Root cause is a 'smiley' found in a script that the tool could not handle and crashed miserably...

2

General Board / Re: Dumping a production database into a staging environment - recommendations

« on: September 25, 2025, 10:52:53 pm »

I would go with database backup/restore any day.

That's indeed much faster and resistant to Sparx glitches but preservation of specific STG security settings is a requirement and with that method we loose them...
Is there a way to restore them after a full DB restore!?

3

General Board / Dumping a production database into a staging environment - recommendations

« on: September 25, 2025, 07:25:19 pm »

Hi guys,
We have several Sparx environments PRD, STG and DEV all attached to Azure RDS (MSSQL)
STG is practically a copy from production but with different security settings.
Today we use Sparx Export/Import functionality but the size of PRD has increased significantly over the years and today it would take >6 hours to refresh STG, must be done outside business hours, involve many manual steps and is very sensitive to glitches.
We could go with Sparx agnostic alternatives such database replication, snapshot, cloning techniques or the classy database backup/restore.
However those alternatives have limitations, complexity involved, cost impacts and may not be supported by Sparx actually.

Questions are:
- First, are there Sparx built-in alternatives i.e. other than classy Export/Import function? Could be external tools but provided and supported by Sparx.
- If not, what are Sparx supported/validated/recommended alternatives available out there?

Thanks for your feedbacks!

4

General Board / Re: user defined scripts gone

« on: September 17, 2025, 09:48:04 pm »

investigation status:
Our DevOps did a select on the script table to find out which script was not returning a result: select * from table script id xxx  or > xxx < xxx
We found out that 2 scripts were not returning result in the query (reason still under investigation)
In the database directly we did a: delete from table where scriptid = xxx and xxx
This helped restore the hundreds user-defined scripts in the Scripting view

5

General Board / Re: user defined scripts gone

« on: September 17, 2025, 01:00:31 am »

Thx Geert.
Investigation ongoing...
But I guess we will have to go thru a restore process!

6

General Board / user defined scripts gone

« on: September 16, 2025, 09:54:52 pm »

Hi guys,
We have a lot of user-defined scripts but today they are all gone for whatever reason.
Built-in scripts still there thought...

Any tips what's the issue here and how to fix??

Thx a million

P.S. We found a table called t_script, query returns null but we see +600 scripts (lines) on this table...
 

7

PCS General Board / Sparx EA + PCS + OpenID + callback URI + Citrix Virtual IP

« on: April 14, 2025, 09:58:38 pm »

Hi guys,
When setting up OpenID I have to identify on the ID Provider the callback or redirect URI i.e. http://localhost:8888/openid/callback
As we run Sparx EA v17 on a Citrix platform w/o Virtual IP I was wondering how does it impact OpenID callback flows when several Sparx EXEs run on the same server!?
Unless localhost:8888 is actually hosted elsewhere on the PCS server for instance, is it!?
Documentation is not clear about this...
What does listen to localhost:8888?

Thx a million,

8

PCS General Board / Re: Custom attributes in ProLaborate

« on: April 10, 2025, 11:52:30 pm »

Go to Modeling Languages -> Custom Properties (top right) -> Import
Then back to Modeling Languages -> on your ML go to More -> Manage Profiles -> again More -> Manage Stereotypes
Then finally select your Stereotype and under Action click on Form Designer -> Custom Properties
There you may want to add a new Group for segregation

Now you can add your custom tags one by one (no bulk update AFAIK)


This YT video explains it all: https://youtu.be/00wNsD-s-VA?feature=shared

9

PCS General Board / Prolaborate - Tagged Values not showing up

« on: February 10, 2025, 11:13:28 pm »

Hi guys,

Running Prolaborate v5.4
Added ArchiMate Modeling Language for which we defined a group in the form designer.
We also set the 'Show for all stereotypes'.

We were then expecting to find our Tagged Values (created in the 'UML Types' dialog) in any of the four groups for stereotypes but no luck...

Can Prolaborate actually show 'custom' Tagged Values coming from the 'UML Types' dialog?

Thx,

10

Bugs and Issues / Sparx EA to crash - v17 streamed from Citrix

« on: January 10, 2025, 02:10:47 am »

Hi guys,

Sparx EA v17.0.1703
Citrix environment
MSSQL Database
PCS enabled

So every time I select two objects and still have ctrl key pressed in while going to the align menu, Sparx hangs and crashes shortly with a popup saying the instruction at 0x.... referenced memory at 0x..... The memory could not be read issue.

This behavior can be reproduced on and on.

Is this a bug in this version/build?
Are other having the same behavior?

Thx for you help,

11

General Board / Re: Tagged Value Types - maximums?

« on: December 18, 2024, 12:56:31 am »

You should really only create tagged values as part of UML profiles in an MDG technology.

Loose tagged values are a nightmare to maintain.

Geert

Thx Geert for the heads up, we indeed hit that wall of manageability...
Lack of expertise in UML/MDG is the main culprit here.

12

General Board / Tagged Value Types - maximums?

« on: December 17, 2024, 10:25:05 pm »

Hi guys,
We are heavy consumers of Tagged Value Types and so far have created >100 Tag Types and more to come in the context of Prolaborate.
Question is where is the limit, the maximum number of Tag Types allowed in Sparx v16/17?
And eventually Sparx roadmap to make them more bulk 'manageable'?

Thx,

13

Automation Interface, Add-Ins and Tools / Re: Relationship, reporting and automation

« on: October 16, 2024, 10:49:16 pm »

Thanks for the confirmation.
I can safely assign a Dev to this user story knowing it can be done.

14

Automation Interface, Add-Ins and Tools / Relationship, reporting and automation

« on: October 16, 2024, 09:28:21 pm »

Hi guys,
The Relationship property is great as it gives you a complete overview of the relations being controlflow, association or notelink of your diagram's elements.
I can even manually copy/paste into an Excel sheet.
Ultimately I would like to automate this.
For all these diagrams, export all relationships into a csv named after the diagram..
Is that even possible?

Thx for your help!

 

15

General Board / Root Node and GUID

« on: August 20, 2024, 07:59:46 pm »

Hi,
Sparx EA 16.x here.
I have noticed that Root Nodes do not have a GUID.
Is it expected and what's the rational?

Thx,