Kinook Software Forum

Go Back   Kinook Software Forum > Ultra Recall > [UR] General Discussion
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Rate Thread Display Modes
  #1  
Old 09-16-2020, 10:12 AM
cnewtonne cnewtonne is online now
Registered User
 
Join Date: 07-27-2006
Posts: 519
Database is locked when editing external documents

To get advanced editing features e.g. tables, I started using MSWord to open stored .docx files externally writable.

I noticed on at least 5 occasions at some point in time after keeping the doc open externally, I get a dialogue box 'Database is locked'. Hitting OK returns another message 'Error saving item: Access violation. Exception ...'. Hitting OK does not crash UR. I'm able to continue working with it.

I was not able to reproduce the AV error, but it seems to happen after a set number of minutes having the external doc open.

The urd file is stored on Dropbox and I can guarantee there are no other UR instance having this file open. Furthermore, I always run one instance of UR.

1. Why is DB locked in the above scenario?
2. If 'database is locked' not an error, simply informational, why is UR crashing with an AV error afterwards?

Thanks
Reply With Quote
  #2  
Old 09-16-2020, 10:14 AM
cnewtonne cnewtonne is online now
Registered User
 
Join Date: 07-27-2006
Posts: 519
Error messages
Attached Images
 
Reply With Quote
  #3  
Old 09-16-2020, 10:17 AM
cnewtonne cnewtonne is online now
Registered User
 
Join Date: 07-27-2006
Posts: 519
The av error message
Attached Images
 
Reply With Quote
  #4  
Old 09-16-2020, 10:19 AM
cnewtonne cnewtonne is online now
Registered User
 
Join Date: 07-27-2006
Posts: 519
Ultra Recall Professional 6.1 (x64)
Copyright © 2004-2020 Kinook Software, Inc.
Registered to: xxxxx(1-user license)
Windows version: Windows 10 Home
Install path: C:\Program Files\UltraRecall
HRW15.DLL version 15.0.0.1
HTW21.DLL version 21,0,0,0
MSPTLS.DLL version 16.0.11929.20048
msvcr100.dll version 10.00.40219.325
PolarSpellChecker.dll version 4.0.5.6
RICHED20.DLL version 16.0.11929.20048
SftPrintPreview_x64_U_20.dll version 2.07
TEW26.DLL version 26.0.0.7
UltraRecall.exe version 6.1.0.1
unins000.exe version 51.52.0.0
Database filename: C:\Users\xxxxx.urd
Database version: 4.0.1 [FTS]
Reply With Quote
  #5  
Old 09-16-2020, 05:02 PM
kinook kinook is online now
Administrator
 
Join Date: 03-06-2001
Location: Colorado
Posts: 6,034
Does the problem persist after restarting your PC?
Reply With Quote
  #6  
Old 09-17-2020, 07:54 AM
cnewtonne cnewtonne is online now
Registered User
 
Join Date: 07-27-2006
Posts: 519
Thanks for taking the time to reply.

As per my above description, I'm able to continue working with UR even after receiving the AV exception. However, I do restart UR to be cautious.

As such, there is no need to restart Windows and, logically, the problem wouldn't persist.

And if I may, did you get the chance to address my two questions, above.

Thanks, again.
Reply With Quote
  #7  
Old 09-17-2020, 09:47 AM
kinook kinook is online now
Administrator
 
Join Date: 03-06-2001
Location: Colorado
Posts: 6,034
1. I don't know.
2. It is a real error. It appears that another error occurs after that due to the first error.

I haven't been able to reproduce the problem.
Reply With Quote
  #8  
Old 09-17-2020, 11:32 AM
cnewtonne cnewtonne is online now
Registered User
 
Join Date: 07-27-2006
Posts: 519
I may have not been clear in my first question. I meant under which conditions UR return 'db is locked error'.

In a 2005 post, I have seen a user state ...

Quote:
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
Is there a scenario where opening a stored document externally writable creates two users or processes trying to update same table/record?

https://www.kinook.com/Forum/showthr...%2Ais%2Alocked
Reply With Quote
  #9  
Old 09-17-2020, 12:42 PM
kinook kinook is online now
Administrator
 
Join Date: 03-06-2001
Location: Colorado
Posts: 6,034
There is not.
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



All times are GMT -5. The time now is 06:04 PM.


Copyright © 1999-2023 Kinook Software, Inc.