Author Topic: Enterprise Architect gives database lock pop-up when using API  (Read 2385 times)

ea0921

  • EA User
  • **
  • Posts: 99
  • Karma: +0/-1
    • View Profile
Enterprise Architect gives database lock pop-up when using API
« 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