View locked definitions for designing.
The user can view locked ETL definitions. When opened for editing by the ETL designer, ETL definitions are automatically locked for the user. The lock function 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 lock page is rendered as shown below. The ETL definitions and the lock status are listed in the table.
When an existing ETL Definition is opened for changes, 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 stay “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 message is displayed 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 and click the “Unlock Definitions” menu option to unlock it. The current user can only unlock their ETL definitions; administrative users can unlock any user’s definitions.
Note: The ETL definitions are automatically unlocked by the FlowWright application, and the time duration is determined by the system variable “$ItemAutoUnlockDays” configured in Engine Settings.
You must navigate to the Status > Settings > Settings Designer menu 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. You may change this value to any whole number and click the Save button to confirm the changes. The new changes take effect when the FlowWright application is restarted or the FlowWright Engine services are restarted using the Windows Services feature.
Select the ETL definition and click on the View - History menu option.
The ETL definition history includes the “Lock” and “Unlock” events, as shown in the image below.
