Sparx Systems Forum

Enterprise Architect => General Board => Topic started by: John Brand on October 26, 2009, 11:37:45 pm

Title: DAO (3052) max locks exceeded
Post by: John Brand on October 26, 2009, 11:37:45 pm

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

Title: Re: DAO (3052) max locks exceeded
Post by: Geert Bellekens on October 26, 2009, 11:56:02 pm

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

Geert

Title: Re: DAO (3052) max locks exceeded
Post by: mrf on October 27, 2009, 08:52:52 am

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.

Title: Re: DAO (3052) max locks exceeded
Post by: John Brand on October 30, 2009, 09:20:00 pm

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. :)

Title: Re: DAO (3052) max locks exceeded
Post by: mrf on November 02, 2009, 08:51:49 am

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).