DAO (3052) max locks exceeded

[John Brand]

On XMI import to overwrite a package I'm getting the above message. We are on 7.1.834 - can anyone offer advice?

[Geert Bellekens]

Do you have the same issue with 7.5.849?
In that case you better send an bug report to Sparx.

Geert

[mrf]

If you're using an EAP file, you can increase the maximum locks available to a Microsoft Jet database by modifying the MaxLocksPerFile option in the registry.

Please see http://support.microsoft.com/kb/815281 for more details.

[John Brand]

Thanks for the replies - I increased the MAXLOCKS and it went ok. We move to 7.5 in two weeks so I hope this doesn't re-occur.

[mrf]

Hi again John,

An EAP file is basically a renamed Microsoft Access file, so the issue here is with Microsoft's data access driver (named JET) and how it interacts with the filesystem - not with EA itself.

You could potentially try the EA option to use the Microsoft JET 4 driver to see if that solves the problem (see http://www.sparxsystems.com/uml_tool_guide/uml_modeling_tool_features/generalsettings.html). Additionally if your model is getting large, it might be time to consider moving it to a DBMS repository (see http://www.sparxsystems.com/uml_tool_guide/uml_model_management/createopenmodelfileoverview.html).