Sparx Systems Forum

Enterprise Architect => General Board => Topic started by: ea0921 on November 01, 2023, 05:31:06 pm

Title: Enterprise Architect gives database lock pop-up when using API
Post by: ea0921 on November 01, 2023, 05:31:06 pm

I am using Enterprise architect API(using C#) to create an "Package" using API and then perform some updates on the same package created. The project I have created is an (.qea) file based project and using the same created project.

While updating the package using package.Update() method I get pop-up of database is locked from the enterprise architect application and the application is freezed and does not respond to any further API calls. Below is the error I get from the enterprise architect application:

Error : Sparx Systems Database API [0x00001086]

SQL API Update FAILED with error: database is locked
Context:
Update t_package set  PackageFlags  = :bv_packageflags,  Namespace  = :bv_namespace,  CodePath  = :bv_codepath,  UMLVersion  = :bv_umlversion,  PkgOwner  = :bv_pkgowner,  Version  = :bv_version,  LastSaveDate  = :bv_lastsavedate,  LastLoadDate  = :bv_lastloaddate,  XMLPath  = :bv_xmlpath,  ea_guid  = :bv_ea_guid,  Notes  = :bv_notes,  ModifiedDate  = :bv_modifieddate,  CreatedDate  = :bv_createddate,  Name  = :bv_name where Package_ID = 112
   at EA.IDualPackage.Update()

Environment: Here, I am using the same project to create elements, diagrams and packages on the same project and perform operations of multiple create and multiple updates concurrently.

I want to know the reason for why this pop-up comes from the enterprise-application for file based projects.

Thanks