No DB read/write access depending on special chars

Gabriel · Post by **Gabriel** » Sat Jul 04, 2020 9:06 pm

Hi

Concerns EssentialPIM Pro 9.1.1
Windows 10 Version 1903 Build 18362.900

Since the Update from 8.* to 9.1.1 I get this Error message (full message quoted below)

Code: Select all

no permission for read-write access to database C:\USERS\GABRIEL\## DATA ##\LISTEN_UND_DATEN\ESSENTIALPIM\DB\DATENBANK.EPIM.

I did a little bit of testing with alternate paths and came to the conclusion that the problem exists when the path contains the hash ("#") character. Can you fix this? Putting the DB file into another path really messes up my backup solution.

Code: Select all

------------------------------------------------------------------------------
Exception log with detailed tech info. Generated on 04.07.2020 22:01.
You may send it to the application vendor, helping him to understand what had happened.
 Application title: EssentialPIM Pro
 Application file: C:\Program Files (x86)\EssentialPIM Pro\EssentialPIM.exe
 Application: EssentialPIM Pro 9.1.1  30.06.2020
------------------------------------------------------------------------------
Exception class: EIBInterBaseRoleError
Exception message: no permission for read-write access to database C:\USERS\GABRIEL\## DATA ##\LISTEN_UND_DATEN\ESSENTIALPIM\DB\DATENBANK.EPIM.
Exception address: 00777AFD
------------------------------------------------------------------------------
Main thread ID = 8668
Exception thread ID = 8668
------------------------------------------------------------------------------
Object Logs:
1271028671  DBClose OK
1271028500  DBSave OK
1271028484  DBSave
1271027968  DBClose
1271027968  DBOpen
1270871265  SetViewMode OK
1270871078  SetViewMode 6
1270861078  DBOpen OK
1270860968  SetViewMode OK
1270860796  SetViewMode 0
1270860687  DBOpen
1270826437  DBOpen
1270721734  DBClose OK
1270721656  DBSave OK
1270721640  DBSave
1270721078  DBClose
1270721078  DBOpen
1270702968  DBOpen OK
1270702875  SetViewMode OK
1270702578  SetViewMode 0
------------------------------------------------------------------------------
Active Controls:
1271028796  MainForm
1270988031  MainForm FormPan FormPan2 PasswordsForm PreviewPnl PassEntryEditPC PersonalTS Panel1 PersonalSG
1270975531  AboutForm OKBtn
1270879531  MainForm FormPan FormPan2 PasswordsForm PreviewPnl PassEntryEditPC PersonalTS Panel1 PersonalSG
1270877531  MainForm FormPan FormPan2 PasswordsForm ListsPan PassEntriesVT
1270874031  MainForm FormPan TBXToolbar2 TopPan Top2TB FindCB
1270873031  MainForm FormPan FormPan2 PasswordsForm ListsPan GroupsVT
1270871531  MainForm
1270870531  MainForm FormPan FormPan2 TodayForm Panel2 TasksPan TasksSubForm TasksVT
1270852531  MainForm
------------------------------------------------------------------------------
System   : Windows 8 Workstation, Version: 6.2, Build: 23F0, ""
Memory: 16361; free 9031
Display  : 1920x1080 pixels, 32 bpp, 96 PPI
------------------------------------------------------------------------------
PrevExceptions:
1270724156  no permission for read-write access to database C:\USERS\GABRIEL\## DATA ##\LISTEN_UND_DATEN\ESSENTIALPIM\DB\DATENBANK.EPIM
1270852484  no permission for read-write access to database C:\USERS\GABRIEL\## DATA ##\LISTEN_UND_DATEN\ESSENTIALPIM\DB\DATENBANK.EPIM
------------------------------------------------------------------------------
Updates: 1
Last update: 04.07.2020

Max · Post by **Max** » Sun Jul 05, 2020 11:40 pm

Hello,

does the error appear immediately when you try to start EPIM? I can not reproduce the problem, trying with path C:\Users\Maksim\Desktop\## DATA ##\emails.epim

Gabriel · Post by **Gabriel** » Mon Jul 06, 2020 11:52 am

Hi Max.

Thank you for paying attention to this problem.

I have now found a workaround and will let you know everything I found out. The problem seems to be only triggered by the 8->9 DB conversion. When (1) I open the V8 DB file in another path (as described in the above post), (2) close EssentialPIM after, (3) copy the converted V9 file back the original path and (4) open it from there it works fine. So this solved it for me. I am not certain what the problem with the path is. My guess is the special char because it is somewhat unusual. Maybe you can test if the conversion happens okay in your test path? Besides that, the offending path is watched by Google Drive and the other is not. I checked all the file and path properties (Attributes, Owner, Rights etc) and couldn't find any difference between the paths.

Again, for me this is solved now, but if you want to pursue this for the sake of others or the next update and have any questions I'm happy to assist you. I can remember btw that I had problems with DB conversion and access rights before, but can't atm remember what the problem was back then.

Gabriel · Post by **Gabriel** » Mon Jul 06, 2020 11:58 am

Oh and forgot to answer your actual question^^: Yes, it happens immediately when the file is attempted to be opened. It happens both when you manually select "Open" from the menu and when it auto-opens the last open file on startup.

Gabriel · Post by **Gabriel** » Mon Jul 06, 2020 12:05 pm

[more testing] No, it's not the hashes in the path. It's something else. Tried a number of additions variations and the only thing it is still consistent with is the path being watched by Google Drive. I give up now.

Gabriel · Post by **Gabriel** » Mon Jul 06, 2020 12:44 pm

Okay, one more entry and I'm done. It is not only Google Drive watching, but also NetBackReplicator 4.5.12.1108. I'm not sure which one because I've somehow lost the ability to reproduce it anymore. I don't quite understand why and I'm not sure if I've got the time to investigate atm.

EPIM