Since that incident, we've been encountering synchronization issues with a few of our Outlook email clients. Not all emails would sync. For a few, no emails are being synced for the entire 2017-2019 period. The period is random for other affected users. However, all emails are being displayed when using our webmail, Afterlogic Webmail Lite.
We've followed articles online re IMAP related issues with the Outlook email client.
Removed and re-added both the IMAP account and the mail profile. Added INBOX to root folder. None of which helped.
Used the reset mail settings option in Outlook Professional Plus 2016 which seemed to have helped. The emails were slowly being synced in the Inbox IMAP folder, but then after an hour, the Inbox was empty. Upon restarting the client, the issue resurfaced.
Upon checking the hMailServer error log, the following errors were observed:
Code: Select all
"ERROR" 2756 "2020-02-12 12:44:42.751" "Severity: 2 (High), Code: HM5033, Source: DALRecordset::Open, Description: Source: ADOConnection::Execute, Code: HM10046, Description: Unknown error when executing SQL statement.
select * from hm_messages where messageaccountid = ? and messagefolderid = ? order by messageuid asc
Microsoft OLE DB Provider for SQL Server
Query timeout expired"
"ERROR" 2640 "2020-02-12 12:45:50.841" "Severity: 3 (Medium), Code: HM5406, Source: ClamAVVirusScanner::Scan, Description: Unable to connect to ClamAV stream port at localhost:1669."
"ERROR" 2740 "2020-02-12 12:46:25.204" "Severity: 2 (High), Code: HM5033, Source: DALRecordset::Open, Description: Source: ADOConnection::Execute, Code: HM10046, Description: Unknown error when executing SQL statement.
select * from hm_messages where messageaccountid = ? and messagefolderid = ? order by messageuid asc
Microsoft OLE DB Provider for SQL Server
Query timeout expired"
"ERROR" 2760 "2020-02-12 12:46:37.582" "Severity: 2 (High), Code: HM5033, Source: DALRecordset::Open, Description: Source: ADOConnection::Execute, Code: HM10046, Description: Unknown error when executing SQL statement.
select * from hm_messages where messageaccountid = ? and messagefolderid = ? order by messageuid asc
Microsoft OLE DB Provider for SQL Server
Query timeout expired"
"ERROR" 2772 "2020-02-12 13:58:17.329" "Severity: 3 (Medium), Code: HM5042, Source: File::ReadTextFile, Description: An unknown error occurred while reading a text file from disk."
"ERROR" 2772 "2020-02-12 13:58:17.329" "Severity: 1 (Critical), Code: HM5062, Source: IMAPFetch::ReportCriticalError_, Description: ERROR HM10001 - IMAP FETCH: Error when loading MIME message. - E:\HMAIL\Data\domain\email\A6\{A6BEDCF9-4862-4EF7-A480-1C7E62919265}.eml"
"ERROR" 2772 "2020-02-12 13:58:17.345" "Severity: 2 (High), Code: HM4208, Source: File::ReadFile(), Description: An error occured when reading file., Message: bad allocation"
"ERROR" 2772 "2020-02-12 13:58:17.345" "Severity: 3 (Medium), Code: HM4227, Source: File::ReadFile, Description: An unknown error occurred while reading file from disk."
"ERROR" 2772 "2020-02-12 13:58:17.345" "Severity: 3 (Medium), Code: HM5042, Source: File::ReadTextFile, Description: An unknown error occurred while reading a text file from disk."
"ERROR" 2772 "2020-02-12 13:58:17.345" "Severity: 1 (Critical), Code: HM5062, Source: IMAPFetch::ReportCriticalError_, Description: ERROR HM10001 - IMAP FETCH: Error when loading MIME message. - E:\HMAIL\Data\domain\email\8F\{8F4B9B55-10F3-4C4A-A99A-FC1B23ABC226}.eml"
"ERROR" 2772 "2020-02-12 13:58:17.501" "Severity: 3 (Medium), Code: HM5042, Source: File::ReadTextFile, Description: An unknown error occurred while reading a text file from disk."
"ERROR" 2772 "2020-02-12 13:58:17.501" "Severity: 1 (Critical), Code: HM5062, Source: IMAPFetch::ReportCriticalError_, Description: ERROR HM10001 - IMAP FETCH: Error when loading MIME message. - E:\HMAIL\Data\domain\email\DD\{DD0A17B1-639D-4151-80A0-086BE0573C9A}.eml"