eM Client Application Error - Unable to Open My Email

JackQ_JackQ · February 11, 2015, 12:28am

eM Client Application Error - Unable to Open My Email. Several times I have entered a description to “What were you doing” but I’m don’t thing think anyone is looking at the responses. I have pasted the error message below.

eM Client (6.0.21372.0)
Windows: Microsoft Windows NT 6.2.9200.0, Framework: 4.0.30319.34014
The following error has occurred:
System.Data.SQLite.SQLiteException (0x80004005): SQL logic error or missing database
SQL logic error or missing database
   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.Storage.Data.SQLite.DbMailRepository.RemoveOids[ST](Object senderContext, String oidList, IEnumerable1 items)    at MailClient.Storage.Data.SQLite.DbRepository1.RemoveByItems[ST](Object senderContext, IEnumerable1 items)    at MailClient.Storage.Data.SQLite.DbRepository1.Remove[ST](Object senderContext, IEnumerable1 items)    at MailClient.RepositoryExtensions.Remove[T,ST](IRepository1 repository, IEnumerable`1 items)
   at MailClient.Imap.Synchronizer.SynchronizeMessagesCommand.RemoveDeletedMessages(ConnectionContext context)
   at MailClient.Imap.Synchronizer.SynchronizeMessagesCommand.ExecuteInternal(WorkerStatus status)
   at MailClient.Imap.Synchronizer.ImapCommand.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”>http://emclient.com/ns/report">;

eM Client
6.0.21372.0

false

Microsoft Windows NT 6.2.9200.0
4.0.30319.34014

System.Data.SQLite.SQLiteException
SQL logic error or missing database
SQL logic error or missing database
System.Data.SQLite

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

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

83
2c162

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

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

3c
bb

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

12f
150

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

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

System.Data
System.Data.CommandBehavior
behave

5d
71

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

System.Data
System.Data.CommandBehavior
behavior

c
26

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

6
21

100685726
MailClient
MailClient.Storage.Data.SQLite.DbMailRepository
RemoveOids

MailClient

mscorlib
System.Object
senderContext

mscorlib
System.String
oidList

mscorlib

items

22e
506

100670340
MailClient
MailClient.Storage.Data.SQLite.DbRepository1</type> <name>RemoveByItems</name> <genericarguments> <argument> <assembly>MailClient</assembly> <type></type> </argument> </genericarguments> <parameters> <parameter> <assembly>mscorlib</assembly> <type>System.Object</type> <name>senderContext</name> </parameter> <parameter> <assembly>mscorlib</assembly> <type></type> <name>items</name> </parameter> </parameters> </method> <offset>151</offset> <nativeoffset>37a</nativeoffset> <frame> <method> <modulename>MailClient.exe</modulename> <metadatatoken>100670341</metadatatoken> <assembly>MailClient</assembly> <type>MailClient.Storage.Data.SQLite.DbRepository1
Remove

MailClient

mscorlib
System.Object
senderContext

mscorlib

items

1c
9e

100670420
MailClient
MailClient.RepositoryExtensions
Remove

MailClient

MailClient

MailClient

repository

mscorlib

items

0
5f

100668681
MailClient
MailClient.Imap.Synchronizer+SynchronizeMessagesCommand
RemoveDeletedMessages

MailClient
MailClient.Imap.ConnectionContext
context

129
361

100668677
MailClient
MailClient.Imap.Synchronizer+SynchronizeMessagesCommand
ExecuteInternal

MailClient
MailClient.Commands.WorkerStatus
status

378
77b

100668513
MailClient
MailClient.Imap.Synchronizer+ImapCommand
Execute

MailClient
MailClient.Commands.WorkerStatus
status

0
1d

100664007
MailClient
MailClient.Commands.Command
Process

MailClient
MailClient.Commands.WorkerStatus
status

15
53

100664060
MailClient
MailClient.Commands.SynchronizationQueue
ThreadWorker

mscorlib
System.Object
threadData

8c
11a

100669370
mscorlib
System.Threading.ThreadHelper
ThreadStart_Context

mscorlib
System.Object
state

25
9b

100668987
mscorlib
System.Threading.ExecutionContext
RunInternal

mscorlib
System.Threading.ExecutionContext
executionContext

mscorlib
System.Threading.ContextCallback
callback

mscorlib
System.Object
state

mscorlib
System.Boolean
preserveSyncCtx

70
a6

100668986
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

100668985
mscorlib
System.Threading.ExecutionContext
Run

mscorlib
System.Threading.ExecutionContext
executionContext

mscorlib
System.Threading.ContextCallback
callback

mscorlib
System.Object
state

2b
40

100669367
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.21372.0
eM Client
eM Client
6.0.21372.0
False
False
False
False
False
Language Neutral

ntdll.dll
C:\WINDOWS\SYSTEM32\ntdll.dll
ntdll.dll
ntdll.dll.mui
6.3.9600.17031 (winblue_gdr.140221-1952)
NT Layer DLL
Microsoft® Windows® Operating System
6.3.9600.17031
False
False
False
False
False
English (United States)

MSCOREE.DLL
C:\WINDOWS\SYSTEM32\MSCOREE.DLL
mscoree.dll
mscoree.dll
6.3.9600.16384 (winblue_rtm.130821-1623)
Microsoft .NET Runtime Execution Engine
Microsoft® Windows® Operating System
6.3.9600.16384
False
False
False
False
False
English (United States)

KERNEL32.dll
C:\WINDOWS\SYSTEM32\KERNEL32.dll
kernel32
kernel32
6.3.9600.17031 (winblue_gdr.140221-1952)
Windows NT BASE API Client DLL
Microsoft® Windows® Operating System
6.3.9600.17031
False
False
False
False
False
English (United States)

KERNELBASE.dll
C:\WINDOWS\SYSTEM32\KERNELBASE.dll
Kernelbase.dll
Kernelbase.dll.mui
6.3.9600.17031 (winblue_gdr.140221-1952)
Windows NT BASE API Client DLL
Microsoft® Windows® Operating System
6.3.9600.17031
False
False
False
False
False
English (United States)

ADVAPI32.dll
C:\WINDOWS\SYSTEM32\ADVAPI32.dll
advapi32.dll
advapi32.dll.mui
6.3.9600.16384 (winblue_rtm.130821-1623)
Advanced Windows 32 Base API
Microsoft® Windows® Operating System
6.3.9600.16384
False
False
False
False
False
English (United States)

msvcrt.dll
C:\WINDOWS\SYSTEM32\msvcrt.dll
msvcrt.dll
msvcrt.dll
7.0.9600.16384 (winblue_rtm.130821-1623)
Windows NT CRT DLL
Microsoft® Windows® Operating System
7.0.9600.16384
False
False
False
False
False
English (United States)

sechost.dll
C:\WINDOWS\SYSTEM32\sechost.dll
sechost.dll
sechost.dll.mui
6.3.9600.16384 (winblue_rtm.130821-1623)
Host for SCM/SDDL/LSA Lookup APIs
Microsoft® Windows® Operating System
6.3.9600.16384
False
False
False
False
False
English (United States)

RPCRT4.dll
C:\WINDOWS\SYSTEM32\RPCRT4.dll
rpcrt4.dll
rpcrt4.dll.mui
6.3.9600.16384 (winblue_rtm.130821-1623)
Remote Procedure Call Runtime
Microsoft® Windows® Operating System
6.3.9600.16384
False
False
False
False
False
English (United States)

SspiCli.dll
C:\WINDOWS\SYSTEM32\SspiCli.dll
security.dll
security.dll
6.3.9600.16408 (winblue_gdr.130920-1803)
Security Support Provider Interface
Microsoft® Windows® Operating System
6.3.9600.16408
False
False
False
False
False
English (United States)

CRYPTBASE.dll
C:\WINDOWS\SYSTEM32\CRYPTBASE.dll
cryptbase.dll
cryptbase.dll
6.3.9600.16384 (winblue_rtm.130821-1623)
Base cryptographic API DLL
Microsoft® Windows® Operating System
6.3.9600.16384
False
False
False
False
False
English (United States)

bcryptPrimitives.dll
C:\WINDOWS\SYSTEM32\bcryptPrimitives.dll
bcryptprimitives.dll
bcryptprimitives.dll
6.3.9600.17120 (winblue_gdr.140509-1516)
Windows Cryptographic Primitives Library
Microsoft® Windows® Operating System
6.3.9600.17120
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.0.30319.34014 built by: FX45W81RTMGDR
Microsoft .NET Runtime Execution Engine
Microsoft® .NET Framework
4.0.30319.34014
False
False
False
True
False
English (United States)

SHLWAPI.dll
C:\WINDOWS\SYSTEM32\SHLWAPI.dll
SHLWAPI
SHLWAPI.DLL.MUI
6.3.9600.16384 (winblue_rtm.130821-1623)
Shell Light-weight Utility Library
Microsoft® Windows® Operating System
6.3.9600.16384
False
False
False
False
False
English (United States)

combase.dll
C:\WINDOWS\SYSTEM32\combase.dll
&n

Paul_Technical_Suppo · February 11, 2015, 1:46pm

Hi Jack, this unfortunately seems to be a database issue, some of your database files might have got corrupted and are no longer accessible for eM Client. Are you using an IMAP account or are you using any local data in your eM Client setup?

If you’re using an IMAP account, navigate to your local folder > App Data > Roaming and rename or remove the current eM Client database folder, launch eM Client and the application should automatically create a new database allowing you to setup your account(s) from scratch.

In case you’re using any local data, I’m afraid that without an existing database backup you won’t be able to restore your data.

Using IMAP all your items should be automatically resynchronized after you setup the account.

Thank you,
Paul

JackQ_JackQ · February 11, 2015, 9:05pm

Hi Paul,

Thanks for the quick response. I did as suggested above and had to use a backup from Feb 1 even though the problem only started on Feb 9. I have IMAP and POP email accountsusing eM Client desktop. In any case things are working ok.

The problem appeared to start when I tried to email a video attachment of 255mb on one of my IMAP accounts not realizing it was that big. I was unable to delete it from the Outbox. Then I restored from a backup prior to me creating the email with the big attachment. That’s when things went down hill. Everything okay now though.

Thank, Jack

Hans_Nieuwenhuis · February 12, 2015, 4:37am

If attaching very, very big files to an e-mail can corrupt the database, then that might be a very good reason for eM Client to ask the end user if he really wants to add such a big attachment to an e-mail.

(And offer the option to add a link to that file on a file sharing website, like SendSpace or Dropbox.)

Paul_Technical_Suppo · February 12, 2015, 11:50am

Hi Jack, glad it works, please make sure to let us know if you come across any other issues or questions about the application, we’ll be happy to help.

Regards,
Paul

Gamal_Shohaiep · March 6, 2015, 4:47pm

I had the same the problem, I accidentally attached a large file to an email and the problem started and I can not get it to work. This is definitely a bug that need to be fixed and the proposed solution is not acceptable, to add the email accounts again.