This section shows how PlantDataManager handles the locking of the PDMDataCache_[USERNAME].dcf.

The following is a list of use cases when using PlantDataManager.

1.Opening the project in PlantDataManager with no existing changes yet
 
If you open the project and you didn't make any changes yet, then there is no PDMDataCache_[USERNAME].dcf and therefore there will be no PDMDataCache_[USERNAME].dcf.lock file either.
 

2.Saving first changes in PlantDataManager with no prior changes
 
When saving your first changes the PDMDataCache_[USERNAME].dcf will be created and with that also the PDMDataCache_[USERNAME].dcf.lock file.
 

3.Closing project with existing changes
 
If you close the project in PlantDataManager and there is a PDMDataCache_[USERNAME].dcf and a PDMDataCache_[USERNAME].dcf.lock file, then the lock file will be removed when the project is closed.
 

4.Opening the project in PlantDataManager with existing changes
 
If you open a project with an existing PDMDataCache_[USERNAME].dcf, then the lock file will be created during the loading process.
 

5.Opening the project in PlantDataManager with existing changes while the changes are already loaded in PlantDataManager Plugin
 
If there is already a PDMDataCache_[USERNAME].dcf.lock file because the changes from your PDMDataCache_[USERNAME].dcf are loaded in PlantDataManager Plugin you will get this dialog:
 

 
You cannot continue making new changes if the PDMDataCache_[USERNAME].dcf is already in the process of being imported.
 

This section shows how PlantDataManager Plugin handles the locking of the PDMDataCache_[USERNAME].dcf.

The following is a list of use cases when using PlantDataManager Plugin.

1.Opening the project in PlantDataManager Plugin with existing changes
 
If you open a project with an existing PDMDataCache_[USERNAME].dcf, then the lock file will be created when the PlantDataManager Plugin gets opened.
 

2.Opening the project in PlantDataManager Plugin with existing changes while the changes are already loaded in PlantDataManager
 
If there is already a PDMDataCache_[USERNAME].dcf.lock file because the changes from your PDMDataCache_[USERNAME].dcf are loaded in PlantDataManager you will get this dialog:
 

 
Because you cannot import the changes, your changes will be shown as In Progress in PlantDataManager Plugin.
 

 

The uses cases when using SQL Server are essentially the same as when using SQLite. However, PlantDataManager will create the dcf file with xml content which points to a SQL Server database. And the SQL Server database will also be created by PlantDataManager.

The behavior of the lock file is the same as with SQLite projects.

A small difference compared to SQLite projects is, that the dcf file and the SQL Server databases will not be deleted if the DataCache table is empty (e.g., when all changes are imported).

Remark: Make sure the PlantDataManager users have sufficient user rights to be able to create databases on SQL Server.