windows 10 restart breaks emclient database

Hi,
since updating to Windows 10 every time I restart the laptop emclient crashes when connecting to collect emails it says sqllite cannot access the database and the recovery does not resolve the issue.The only solution is to rerun the setup.msi and choose repair -what has happened ?
My setup does include the temp folder on a ramdisk and I do not use a pagefile. But this setup worked fine on 8.1. I will switch off the auto connect option, and look to find an export option for backup?

Hello if the application crashes, can you please copy the error report from the crash report window that’s thrown by the application? What mail service are you using with eM Client?

I’m not quite sure about your setup, eM Client database is by default setup in the AppData folder in your local user folder, have you moved the database location somewhere else?

Thank you,

Hi and Thankyou for your reply,

I use POP not IMAP

I have not moved any database or other settings files.

I have not had this issue since unchecking “synchronise on start-up” I did this several days ago.

The only perhaps less common setup I have is using Intel Rapid Storage and Rapid Start Technology with a 64gb mSata SSD - but this setup I have used on windows 8.1 for over two years.

I will try to reproduce the error again once I have exported my mail (just in case the repair from setup.msi) fails.

Many Thanks

Stuart

eM Client (6.0.22344.0)
Windows: Microsoft Windows NT 6.2.9200.0, Framework: 4.0.30319.42000
The following error has occurred:
System.Data.SQLite.SQLiteException (0x80004005): unable to open database file
unable to open database file
   at System.Data.SQLite.SQLite3.Reset(SQLiteStatement stmt)
   at System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt)
   at System.Data.SQLite.SQLiteDataReader.NextResult()
   at System.Data.SQLite.SQLiteDataReader…ctor(SQLiteCommand cmd, CommandBehavior behave)
   at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
   at MailClient.Pop3.Db.Pop3AccountConfiguration.CheckUids(IEnumerable`1 uidsList)
   at MailClient.Pop3.Pop3ReceiveCommand.Execute(WorkerStatus status)
   at MailClient.Commands.Command.Process(WorkerStatus status)
   at MailClient.Commands.SynchronizationQueue.ThreadWorker(Object threadData)
   at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart(Object obj)

" rel=“nofollow” target="_blank">http://emclient.com/ns/report">;

eM Client
6.0.22344.0

false

Microsoft Windows NT 6.2.9200.0
4.0.30319.42000


System.Data.SQLite.SQLiteException
unable to open database file
unable to open database file
System.Data.SQLite




System.Data.SQLite.dll
100663598
System.Data.SQLite
System.Data.SQLite.SQLite3
Reset


System.Data.SQLite
System.Data.SQLite.SQLiteStatement
stmt



83
2d35a




System.Data.SQLite.dll
100663597
System.Data.SQLite
System.Data.SQLite.SQLite3
Step


System.Data.SQLite
System.Data.SQLite.SQLiteStatement
stmt



3c
bb




System.Data.SQLite.dll
100663982
System.Data.SQLite
System.Data.SQLite.SQLiteDataReader
NextResult


12f
150




System.Data.SQLite.dll
100663943
System.Data.SQLite
System.Data.SQLite.SQLiteDataReader
.ctor


System.Data.SQLite
System.Data.SQLite.SQLiteCommand
cmd


System.Data
System.Data.CommandBehavior
behave



5d
72




System.Data.SQLite.dll
100663757
System.Data.SQLite
System.Data.SQLite.SQLiteCommand
ExecuteReader


System.Data
System.Data.CommandBehavior
behavior



c
26




System.Data.SQLite.dll
100663760
System.Data.SQLite
System.Data.SQLite.SQLiteCommand
ExecuteNonQuery


6
21




MailClient.exe
100682862
MailClient
MailClient.Pop3.Db.Pop3AccountConfiguration
CheckUids


mscorlib
System.Collections.Generic.IEnumerable`1[[System.String, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]
uidsList



24
97




MailClient.exe
100689954
MailClient
MailClient.Pop3.Pop3ReceiveCommand
Execute


MailClient
MailClient.Commands.WorkerStatus
status



61e
d4f




MailClient.exe
100664033
MailClient
MailClient.Commands.Command
Process


MailClient
MailClient.Commands.WorkerStatus
status



15
53




MailClient.exe
100664086
MailClient
MailClient.Commands.SynchronizationQueue
ThreadWorker


mscorlib
System.Object
threadData



8c
11a




mscorlib.dll
100678214
mscorlib
System.Threading.ThreadHelper
ThreadStart_Context


mscorlib
System.Object
state



25
9c




mscorlib.dll
100677968
mscorlib
System.Threading.ExecutionContext
RunInternal


mscorlib
System.Threading.ExecutionContext
executionContext


mscorlib
System.Threading.ContextCallback
callback


mscorlib
System.Object
state


mscorlib
System.Boolean
preserveSyncCtx



79
b3




mscorlib.dll
100677967
mscorlib
System.Threading.ExecutionContext
Run


mscorlib
System.Threading.ExecutionContext
executionContext


mscorlib
System.Threading.ContextCallback
callback


mscorlib
System.Object
state


mscorlib
System.Boolean
preserveSyncCtx



0
15




mscorlib.dll
100677966
mscorlib
System.Threading.ExecutionContext
Run


mscorlib
System.Threading.ExecutionContext
executionContext


mscorlib
System.Threading.ContextCallback
callback


mscorlib
System.Object
state



2b
40




mscorlib.dll
100678215
mscorlib
System.Threading.ThreadHelper
ThreadStart


mscorlib
System.Object
obj



f
4d



0




MailClient.exe
C:\Program Files (x86)\eM Client\MailClient.exe
MailClient.exe
MailClient.exe
6.0.22344.0
eM Client
eM Client
6.0.22344.0
False
False
False
False
False
Language Neutral


ntdll.dll
C:\WINDOWS\SYSTEM32\ntdll.dll
ntdll.dll
ntdll.dll.mui
10.0.10240.16384 (th1.150709-1700)
NT Layer DLL
Microsoft® Windows® Operating System
10.0.10240.16384
False
False
False
False
False
English (United States)


MSCOREE.DLL
C:\WINDOWS\SYSTEM32\MSCOREE.DLL
mscoree.dll
mscoree.dll
10.0.10240.16384 (th1.150709-1700)
Microsoft .NET Runtime Execution Engine
Microsoft® Windows® Operating System
10.0.10240.16384
False
False
False
False
False
English (United States)


KERNEL32.dll
C:\WINDOWS\SYSTEM32\KERNEL32.dll
kernel32
kernel32
10.0.10240.16384 (th1.150709-1700)
Windows NT BASE API Client DLL
Microsoft® Windows® Operating System
10.0.10240.16384
False
False
False
False
False
English (United States)


KERNELBASE.dll
C:\WINDOWS\SYSTEM32\KERNELBASE.dll
Kernelbase.dll
Kernelbase.dll.mui
10.0.10240.16384 (th1.150709-1700)
Windows NT BASE API Client DLL
Microsoft® Windows® Operating System
10.0.10240.16384
False
False
False
False
False
English (United States)


ADVAPI32.dll
C:\WINDOWS\SYSTEM32\ADVAPI32.dll
advapi32.dll
advapi32.dll.mui
10.0.10240.16384 (th1.150709-1700)
Advanced Windows 32 Base API
Microsoft® Windows® Operating System
10.0.10240.16384
False
False
False
False
False
English (United States)


msvcrt.dll
C:\WINDOWS\SYSTEM32\msvcrt.dll
msvcrt.dll
msvcrt.dll
7.0.10240.16384 (th1.150709-1700)
Windows NT CRT DLL
Microsoft® Windows® Operating System
7.0.10240.16384
False
False
False
False
False
English (United States)


sechost.dll
C:\WINDOWS\SYSTEM32\sechost.dll
sechost.dll
sechost.dll.mui
10.0.10240.16384 (th1.150709-1700)
Host for SCM/SDDL/LSA Lookup APIs
Microsoft® Windows® Operating System
10.0.10240.16384
False
False
False
False
False
English (United States)


RPCRT4.dll
C:\WINDOWS\SYSTEM32\RPCRT4.dll
rpcrt4.dll
rpcrt4.dll.mui
10.0.10240.16384 (th1.150709-1700)
Remote Procedure Call Runtime
Microsoft® Windows® Operating System
10.0.10240.16384
False
False
False
False
False
English (United States)


SspiCli.dll
C:\WINDOWS\SYSTEM32\SspiCli.dll
security.dll
security.dll
10.0.10240.16384 (th1.150709-1700)
Security Support Provider Interface
Microsoft® Windows® Operating System
10.0.10240.16384
False
False
False
False
False
English (United States)


CRYPTBASE.dll
C:\WINDOWS\SYSTEM32\CRYPTBASE.dll
cryptbase.dll
cryptbase.dll
10.0.10240.16384 (th1.150709-1700)
Base cryptographic API DLL
Microsoft® Windows® Operating System
10.0.10240.16384
False
False
False
False
False
English (United States)


bcryptPrimitives.dll
C:\WINDOWS\SYSTEM32\bcryptPrimitives.dll
bcryptprimitives.dll
bcryptprimitives.dll
10.0.10240.16384 (th1.150709-1700)
Windows Cryptographic Primitives Library
Microsoft® Windows® Operating System
10.0.10240.16384
False
False
False
False
False
English (United States)


mscoreei.dll
C:\Windows\Microsoft.NET\Framework\v4.0.30319\mscoreei.dll
mscoreei.dll
mscoreei.dll
4.6.79.0 built by: NETFXREL2
Microsoft .NET Runtime Execution Engine
Microsoft® .NET Framework
4.6.79.0
False
False
False
True
False
English (United States)


SHLWAPI.dll
C:\WINDOWS\SYSTEM32\SHLWAPI.dll
SHLWAPI
SHLWAPI.DLL.MUI
10.0.10240.16384 (th1.150709-1700)
Shell Light-weight Utility Library
Microsoft® Windows® Operating System
10.0.10240.16384
False
False
False
False
False
English (United Kingdom)


combase.dll
C:\WINDOWS\SYSTEM32\combase.dll
COMBASE.DLL
COMBASE.DLL.MUI
10.0.10240.16384 (th1.150709-1700)
Microsoft COM for Windows
Microsoft® Windows® Operating System
10.0.10240.16384
False
False
False
False
False
English (United States)


GDI32.dll
C:\WINDOWS\SYSTEM32\GDI32.dll
gdi32
gdi32
10.0.10240.16390 (th1_st1.150714-1601)
GDI Client DLL
Microsoft® Windows® Operating System
10.0.10240.16390
False
False
False
False
False
English (United States)


USER32.dll
C:\WINDOWS\SYSTEM32\USER32.dll
user32
user32
10.0.10240.16384 (th1.150709-1700)
Multi-User Windows USER API Client DLL
Microsoft® Windows® Operating System
10.0.10240.16384
False
False
False
False
False
English (United Kingdom)


IMM32.DLL
C:\WINDOWS\SYSTEM32\IMM32.DLL
imm32
imm32
10.0.10240.16384 (th1.150709-1700)
Multi-User Windows IMM32 API Client DLL
Microsoft® Windows® Operating System
10.0.10240.16384
False
False
False
False
False
English (United States)


MSCTF.dll
C:\WINDOWS\SYSTEM32\MSCTF.dll
MSCTF
MSCTF.DLL.MUI
10.0.10240.16384 (th1.150709-1700)
MSCTF Server DLL
Microsoft® Windows® Operating System
10.0.10240.16384
False
False
False
False
False
English (United Kingdom)


kernel.appcore.dll
C:\WINDOWS\SYSTEM32\kernel.appcore.dll
kernel.appcore.dll
kernel.appcore.dll
10.0.10240.16384 (th1.150709-1700)
AppModel API Host
Microsoft® Windows® Operating System
10.0.10240.16384
False
False
False
False
False
English (United States)


VERSION.dll
C:\WINDOWS\SYSTEM32\VERSION.dll
version
VERSION.DLL
10.0.10240.16384 (th1.150709-1700)
Version Checking and File Installation Libraries
Microsoft® Windows® Operating System
10.0.10240.16384
False
False
False
False
False
English (United States)


clr.dll
C:\Windows\Microsoft.NET\Framework\v4.0.30319\clr.dll
clr.dll
clr.dll
4.6.79.0 built by: NETFXREL2
Microsoft .NET Runtime Common Language Runtime - WorkStation
Microsoft® .NET Framework
4.6.79.0
False
False
False
True
False
English (United States)


MSVCR120_CLR0400.dll
C:\WINDOWS\SYSTEM32\MSVCR120_CLR0400.dll
msvcr120_clr0400.dll
msvcr120_clr0400.dll
12.00.52512.0 built by: VSWINSERVICING
Microsoft® C Runtime Library
Microsoft® Visual Studio® 2013
12.00.52512.0
False
False
False
False
False
English (United States)


mscorlib.ni.dll
C:\WINDOWS\assembly\NativeImages_v4.0.30319_32\mscorlib\b957e2761f39c847be8972eb3cccfc50\mscorlib.ni.dll
mscorlib.dll
mscorlib.dll
4.6.79.0 built by: NETFXREL2
Microsoft Common Language Runtime Class Library
Microsoft® .NET Framework
4.6.79.0
False
False
False
True
False
English (United States)


ole32.dll
C:\WINDOWS\SYSTEM32\ole32.dll
OLE32.DLL
OLE32.DLL.MUI
10.0.10240.16384 (th1.150709-1700)
Microsoft OLE for Windows
Microsoft® Windows® Operating System
10.0.10240.16384
False
False
False
False
False
E

now I run the setup.msi and choose “Repair” otherwise it never works again

Hello, unfortunately it seems like your database is corrupt, can you please try to run this database repair tool, http://www.emclient.com/tools/dbrepairrebuildall.exe and check if the issue persists or if the repair tool finishes unsuccessfully?

If the application is unable to repair the database, I’m afraid you won’t be able to restore this database data without setting up a new database, to setup a new database, please navigate to your local user/AppData/Roaming folder and remove or rename the current eM Client database folder.

Regards,

Hi Thanks for the advice and support,

What is in the database? all my mail? - as I said everything works fine after the setup.msi execution and click repair and the application works perfectly after a repair as long as I don’t automatically sync on application open.

I don’t want to break it and lose all my mail.

I am just now updating an identical (ish) laptop and will see if that has the same issue with emclient and let you know.

Many Thanks

Stuart

Yes your database contains all the downloaded data and account setup. Application setup repair will essentially allow to repair the installation/database as well, so if everything is working properly, I’m glad it works.

Regards,