The user can view locked ETL definitions. When an ETL designer opens an ETL definition for editing, it is automatically locked for that user. The lock prevents other users from editing or updating an ETL definition while another user is designing it. 

On the ETL Definitions page, select the Security > Definition Locks menu option. 

The ETL Definition Locks page is shown below. The table lists the ETL definitions and their lock status in this example. 

When an existing ETL Definition is opened for editing, the definition remains locked to the user. An alert message “the user locks definition” is displayed in the top-right corner. Creating a new ETL Definition also remains locked to the user. The definitions are “unlocked” when the user closes the ETL designer tab. The definitions remain “locked” to the user when the session has expired and the application pages are closed by the user. 

Suppose another FlowWright user attempts to open the ETL definition that is currently in use. An alert appears in the top-right corner, indicating that the definition is locked for design by another user and can only be viewed. 

Select the ETL definition, then click the “Unlock Definitions” menu option to unlock it. The current user can unlock only their ETL definitions; administrative users can unlock any user’s definitions.

Note: The ETL definitions are automatically unlocked by the FlowWright application, and the duration is determined by the system variable “$ItemAutoUnlockDays” configured in Engine Settings.  

Navigate to the Status > Settings > Settings Designer page. 

The Settings Designer page is rendered as shown below. Navigate to the Engine Settings category and click to expand the branch. Search and double-click the “$ItemAutoUnlockDays” setting to view. 

A pop-up window displays the Configuration Item value. By default, all “locked” ETL definitions are “unlocked” after 3 days, or as specified in this configuration. Change this value to any whole number, then click the Save button to confirm. The changes take effect when the FlowWright application is restarted or the FlowWright Engine services are restarted via the Windows Services feature.  

Select the ETL definition, then click the View > History menu option. 

The ETL definition history includes the “Lock” and “Unlock” events, as shown in the image below.