|
The only time we have seen "database is locked" error is with concurrent usage by multiple users or when cancelling a search or navigation using the Item Text or Item Notes virtual attributes... Are you using either of these virtual attributes in the Child Items Pane? There is currently an issue when cancelling an operation (search or Related Items Pane population) that uses these virtual attributes.
It is recommended to only use these attributes when necessary to achieve true "phrase searching" as they are inefficient attributes (computed values at run-time), are not indexed, and can cause the reported error if the operation is cancelled shortly after it is started.
This "cancellation" can occur when
1) Cancelling search using one or both of these attributes (as a criteria or displayed in the Search Results Pane)
2) or nearly immediately halting population of the Related Items Pane when one or both of these attributes is displayed there (this population is cancelled when quickly navigating before this pane is completely populated).
Note: this error does not indicate any data or application corruption, it is a limitation with how these virtual attributes are implemented by the data engine of Ultra Recall. When this error is encountered, currently the only solution is to restart Ultra Recall. When a workaround is found to fully prevent the error (while preserving the provided functionality) it will be provided.
|