Author Topic: EA hangs in some projects  (Read 2620 times)

SevEd

  • EA Novice
  • *
  • Posts: 7
  • Karma: +0/-0
    • View Profile
EA hangs in some projects
« on: May 14, 2024, 12:57:14 am »
Hello everyone,

I'm facing a annoying  issue in certain models.
There are certain models where EA hangs (up to ~30 seconds) when:
  • Navigating in project browser
  • Selecting Elements in project browser
  • Open diagrams (also those with less than 10 elements)
  • Open properties of an element
  • other simple operations

Add-ins and plugins were disabled, but the issue still persist.
This issue was mitigated by setting affinity to only one core (Windows Task Manager). This makes EA hangs only for few seconds (< 7 seconds)

Now, I just noticed that this issue disappears when an external tool (excel-based) modifies the EA DB while keeping EA project open. This "fix" just works until I close the project.

Environment details:
Windows 11
RAM: 32 GB
EA version: 15.2
EA project size: ~300 MB
EA model: eapx file
Note: This issue happen to in different computers, different users. Same behavior.

Any idea of what could be causing this? Is there any optimization value/option in EA that could be activating when accessing DB outside EA? So I can check and compare after running this external tool?
Thanks


Best Regards
Edgar Sevilla

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +396/-301
  • I'm no guru at all
    • View Profile
Re: EA hangs in some projects
« Reply #1 on: May 14, 2024, 02:53:27 am »
Sounds like you use M$Access over the network. Not a good idea - google for that. Try using a decent database.

q.

wivel

  • EA User
  • **
  • Posts: 242
  • Karma: +12/-1
  • Driven by Models
    • View Profile
Re: EA hangs in some projects
« Reply #2 on: May 14, 2024, 03:06:38 am »
What other views do you have open? Traceability and Relationships can take time to load.

Just a thought.

Henrik

SevEd

  • EA Novice
  • *
  • Posts: 7
  • Karma: +0/-0
    • View Profile
Re: EA hangs in some projects
« Reply #3 on: May 15, 2024, 12:44:26 am »
Hi wivel, Hi qwerty

I have only Traceability, Features and Properties open. I disabled all of them, but I do not see difference.

The model uses M$Access (I know bad decision). Anyways the projects are local, not within network. Unfortunately, company does not want to switch to another DB  :'(

Thanks for your feedback.


Best Regards,
Edgar Sevilla

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +396/-301
  • I'm no guru at all
    • View Profile
Re: EA hangs in some projects
« Reply #4 on: May 15, 2024, 02:44:55 am »
For local use they are ok (though with distributed workers still less than optimal). Another idea is shape scripts taking time to render. Or simply many elements in a diagram. Also look for add-ins and turn them off.

q.

ea0522

  • EA User
  • **
  • Posts: 134
  • Karma: +5/-0
    • View Profile
Re: EA hangs in some projects
« Reply #5 on: May 15, 2024, 03:57:31 pm »
Would it be an option to upgrade to V16.1 and then use a QEAX instead?
Did you try to repair the repository?
Just some suggestions.

SevEd

  • EA Novice
  • *
  • Posts: 7
  • Karma: +0/-0
    • View Profile
Re: EA hangs in some projects
« Reply #6 on: May 30, 2024, 06:57:30 am »
Unfortunately, the company is not willing to migrate to a good DB nor upgrade EA version. Repairing and compaction the repository didn't work.

Anyways, after digging into the web, I tried some "solutions" to the MS Access issues. One in particular suggested to set affinity to a particular core (https://www.access-programmers.co.uk/forums/threads/system-resource-exceeded.313820/).
If EA was assigned to all cores, the best case was that EA hangs for at least 30 seconds. After setting affinity to only one core, the improvement was good to worst case of 10 seconds. But if the affinity is set to Two cores (any of them), then the issue disappear.

So, this workaround will be living in these particular projects until final solution (change of DB) happens.
Thanks all of you for your help and proposals.

BR
Edgar Sevilla