21
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,
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,
Recent Posts