51
Automation Interface, Add-Ins and Tools / Re: Powershell Repository.Execute NullRef exception
« Last post by Guillaume on October 06, 2026, 06:21:34 pm »I'm not in favour of a direct database connection, especially as this is not possible in most cases since it's only accessible from the PCS.
My concern is that most users have custom addins, EA scripts or 3rd party scripts which often use the Repository.Execute method for the reasons I gave. Decomissioning this will generate a lot of issues and claims, with no workaround to provide due to the API limitations:
- Like you said, many direct updates in the DB won't probably addressed via API changes
- For technical reasons I can't explain, the API is very slow for specific actions that can be sorted via INSERT, DELETE or UPDATE queries in the DB. Unless a solution can be found, users won't accept to move backward with running times of a few minutes to an hour or more (I've seen scripts taking 3+hours via the API with a real life data set, dropping to 5 mins thanks to the use of queries + Execute method).
I'm not only saying this for my projects and the ones of EA consultants using this forum, but also for Sparx teams (support, marketing) as users start upgrading EA to 17.2 or greater.
I think it is an important topic to address and discuss.
My concern is that most users have custom addins, EA scripts or 3rd party scripts which often use the Repository.Execute method for the reasons I gave. Decomissioning this will generate a lot of issues and claims, with no workaround to provide due to the API limitations:
- Like you said, many direct updates in the DB won't probably addressed via API changes
- For technical reasons I can't explain, the API is very slow for specific actions that can be sorted via INSERT, DELETE or UPDATE queries in the DB. Unless a solution can be found, users won't accept to move backward with running times of a few minutes to an hour or more (I've seen scripts taking 3+hours via the API with a real life data set, dropping to 5 mins thanks to the use of queries + Execute method).
I'm not only saying this for my projects and the ones of EA consultants using this forum, but also for Sparx teams (support, marketing) as users start upgrading EA to 17.2 or greater.
I think it is an important topic to address and discuss.
Recent Posts
[], NullReferenceException