System Resource Exceeded on Large Deletes

[Rich Anderson]

Hi There, I'm having problems deleting packages with lots of elements and attributes, frequently getting the dreaded "System Resource Exceeded" message.  The only workaround I have found was to restart EA and delete the package in smaller parts. (I could write a script, but I'd rather not).  I've scoured the messages to see if anyone has had this problem and did not find anything.  I've also filed a but with Sparx because I've seen this recommended also, but I thought I would ask.   I do this a lot because I'm writing code that generates lots of elements, so in my testing I frequently need to delete packages that are quite large.   I'm using the standard EAP file on my desktop.

[Nizam]

I've seen this mostly when we try some large operation in an EAP file (MS Access).

Whilst i would suggest a Project Integrity Check / Repair EAP to start with (if you are using EAP), I'm not sure if this will fix the issue.

AFAIK there was some registry fix for a similar error (https://support.microsoft.com/en-us/help/198633/you-receive-an-file-sharing-lock-count-exceeded-error-message-when-you), Not sure if there is one for the System Resource Exceeded error (check this https://social.msdn.microsoft.com/Forums/en-US/53597e95-5ca0-44d7-a381-1888f70c301a/ms-access-system-resource-exceeded-error-message?forum=accessdev)

If you are connecting to the server,  check the below link too
https://serverfault.com/questions/881262/system-resource-exceeded-what-resource-could-that-be

[VKN]

That error is from the DB engine, not EA itself.
There is no workaround for it, you'll need to delete in smaller chunks.

[Paolo F Cantoni]

Hi Rich,

if it's only on .EAP files, you might try changing the Access Locks count in the registry.

HTH,
Paolo

[Nizam]

Hi Rich,

if it's only on .EAP files, you might try changing the Access Locks count in the registry.

HTH,
Paolo

Reference for this.
https://support.microsoft.com/en-us/help/198633/you-receive-an-file-sharing-lock-count-exceeded-error-message-when-you

[Rich Anderson]

Hi Guys, I couldn't actually find the registry entries mentioned in these articles. Even searching the registry would not find them.  I think I'll just write a script that recursively goes through all the packages, sub-package and elements and deletes them one at a time.  It seems to me that this should be an option in EA itself. It would be something like "Execute deletes as separate transactions (helpful for large deletes)" with a checkbox.   

[Nizam]

Agreed, such an option will be helpful.

Refer to http://www.sparxsystems.com/forums/smf/index.php/topic,17906.msg242877.html#msg242877
for the registry key related discussion

[Paolo F Cantoni]

Yes, the option would be useful.

We're also finding some queries (internal to EA) which generate overly large sets which tax the system on our production repository.  Fortunately, we've learnt that when they fail, nothing bad (appears to) happens.  So we just ignore them, but it would be better if they didn't occur.

Paolo

[Nizam]

Another instance where we've seen this is when trying to import a fairly large DB Schema, 900+ tables precisely.

[Paolo F Cantoni]

Another instance where we've seen this is when trying to import a fairly large DB Schema, 900+ tables precisely.

Just got one a few minutes ago, doing just that!

It seems like we got the Oracle Reverse Engineering going (see another topic) only to get this...  The Reverse Engineer is still running (at time of writing) so I can't tell how big the source DB was.

BTW Nizam, was there any impact of the error?

Paolo

[Nizam]

We couldn't succeed with import even after changing the Registry setting (EA just froze), so we ended up importing in parts.
(obviously compromising the inter-relationships between entities).

[Paolo F Cantoni]

We couldn't succeed with import even after changing the Registry setting (EA just froze), so we ended up importing in parts.
(obviously compromising the inter-relationships between entities).

We upgraded the user to b1421 and although we got the error, the RE seemed to complete.  2355 Tables (with, apparently, NO FK Constraints defined).

Paolo

[Nizam]

Thats good to know, will suggest this to the client and suggest to try again (if they are still onto it