Recent Posts

61

General Board / Performance impact of reverse-engineering large databases

« Last post by andrea.barroso on August 06, 2026, 11:54:25 pm »

Hi everyone,

We are starting to import database schemas into Enterprise Architect using the Database Builder and its reverse-engineering functionality.

So far, we have only worked with relatively small databases, and we have not noticed any significant impact on repository performance. However, we are planning to import much larger schemas, including databases with approximately 5,000 tables and one with nearly 9,000 tables.

Has anyone worked with database models of this size in EA?

We would like to understand:

• How much impact could these imports have on repository performance?
• Is it advisable to keep several large database models in the same repository?
• Are there any recommended practices for organizing or separating these models?
• Are there any repository, database server, or EA configuration settings that could help maintain good performance?
• Would using separate repositories be a better approach for schemas of this size?

Any experiences, recommendations, or potential limitations we should consider would be greatly appreciated.

Thanks in advance.

62

General Board / Repository.Execute no longer works in JScript

« Last post by Mauricio Moya (Arquesoft) on August 06, 2026, 11:47:33 pm »

While testing the latest version of EA (17.2 build 1721), I noticed that JScripts that were working perfectly in previous versions are now failing on lines containing Repository.Execute("insert SQL here"). I am now getting an "Internal Error" when the script reaches that line.

Does anyone know if this command has been deprecated? Has it been replaced by something else?

63

PCS Bugs and Issues / Re: PCS url in the browser shows "invalid parameter"

« Last post by Guillaume on August 05, 2026, 04:30:04 pm »

Hi Emiliano & Henrik,

Thank you for your replies. I confirm that it's working with the /connectivitytest/ 

Guillaume

64

Automation Interface, Add-Ins and Tools / Re: Database Query Restrictions in Enterprise Architect 17.2

« Last post by GeordieKiwi on August 05, 2026, 04:04:52 pm »

These are likely to be in response to security issues that were brought to light a few months back

65

PCS Bugs and Issues / Re: PCS url in the browser shows "invalid parameter"

« Last post by wivel on August 05, 2026, 08:32:09 am »

Hi

This is also documented by Sparx here https://sparxsystems.com/forums/smf/index.php/topic,49282.0.html

Henrik

66

PCS Bugs and Issues / Re: PCS url in the browser shows "invalid parameter"

« Last post by emiliano.davila on August 05, 2026, 05:23:21 am »

Hi Guillaume,

In the new version, the connectivity test appears to have been moved. It can now be accessed at:

`{your Pro Cloud Server address}/connectivitytest/`

The previous connectivity test screen is displayed there.

Best regards,

67

General Board / Re: Accessing Sparx Registered Resources in Enterprise Environments

« Last post by Modesto Vega on August 04, 2026, 08:36:57 pm »

I did submit a support ticket, via e-mail because I cannot access the registered site from a managed device.

The reply is below:

Thanks for contacting Sparx support.

Based on the error message you are receiving, the Registered User section of the Sparx Systems website currently uses HTTP Basic Authentication. We have received similar reports from users whose managed systems or browser environments block the use of Basic Authentication. Unfortunately, if your environment has been configured to disallow HTTP Basic Authentication, there is currently no workaround that we can provide from our side.

However, some users working in restricted corporate environments have been able to access the Registered User section by using a personal network or by temporarily disabling their VPN, where permitted by their organization's security policies.

We are currently investigating alternative authentication methods, but at this stage we do not have a confirmed solution or an estimated timeline to share.

We hope this information is helpful. If you have any further questions or require additional assistance, please let us know

Needless to say that using a personal network or temporarily disabling security policies is not a very palatable option.

68

PCS Bugs and Issues / PCS url in the browser shows "invalid parameter"

« Last post by Guillaume on August 04, 2026, 07:28:26 pm »

Hi,

I installed the PCS 6.5.129 which works well with EA and Prolaborate, but when I open the url in the Browser , I get an "Invalid parameter" message on the screen instead of the PCS version and build details.
Is this a bug ?

69

Automation Interface, Add-Ins and Tools / Database Query Restrictions in Enterprise Architect 17.2

« Last post by emiliano.davila on August 04, 2026, 12:58:44 am »

Hello everyone,

We are currently testing the upgrade to Enterprise Architect 17.2 and have noticed some changes regarding database queries.

First, we observed that it is no longer possible to query the repository security tables, such as `t_secuser`, `t_secgroup`, and `t_secusergroup`, among others.

Additionally, the `Repository.SQLQuery()` method apparently only allows `SELECT` queries, meaning that it can no longer be used to execute `INSERT` or `UPDATE` statements.

We have also encountered issues when running recursive queries using expressions such as `WITH RECURSIVE`, even when they are read-only queries.

We reviewed the published change history for EA 17.2 but could not find any information related to these restrictions.

Has anyone experienced similar behavior?

Is this an expected and permanent change in the tool, or is there any configuration that would allow these operations to be enabled again?

Thank you in advance.

Best regards,

70

General Board / Accessing Sparx Registered Resources in Enterprise Environments

« Last post by Modesto Vega on July 30, 2026, 06:32:49 pm »

Access to the registered section appears to rely on HTTP Basic Authentication, which may present challenges in environments that have adopted modern authentication standards.

As a result, it may not be possible to:

• Download the latest versions of Enterprise Architect or Pro Cloud Server
• Access registered customer resources
• Submit support requests through the website

This raises a question for other organisations operating in managed enterprise environments:

Is anybody experiencing similar access issues, and is there a modern authentication option available or planned?

It would be particularly useful to understand whether support exists, or is planned, for authentication methods such as. For organisations with strict security requirements, reliable access to software updates and support services is essential for maintaining and supporting Sparx environments.

Any information from Sparx Systems or other customers regarding current options, workarounds, or future plans would be greatly appreciated.