Knowledgebase: iPad/iPhone/iPod touch
After applying NLES Update 8, ActiveSync device stops getting new mail
Posted by - NA - on 03 August 2009 10:41 AM
iPhone/iPod touch:

After applying NLES v4.6.0 Update 8 (NLES v4.6.1), ActiveSync devices may stop gleaning if a database trigger was not updated correctly. The user would stop receiving new email on their device and the GleanerController.log file will show an error in red text that states the "FolderName" column could not be found. To correct the problem, follow the steps below.


1) Stop all NotifyLink services and the web server
2) Run the following query:

USE [NLES_IMAP4_POP3]
GO

DROP TRIGGER [dbo].[AS_MAIL_UpdateNeedsSync]
GO

CREATE TRIGGER [dbo].[AS_MAIL_UpdateNeedsSync] ON [dbo].[SyncMLCheckpoint]
FOR UPDATE, INSERT AS

UPDATE PingFolders SET NeedsSynced = 1 FROM inserted WHERE FolderID = CASE WHEN ISNUMERIC(PingFolders.ServerID) = 1 THEN PingFolders.ServerID ELSE 0 END AND inserted.Filtered = 0 AND inserted.ClientDeviceSAKey = PingFolders.ClientDeviceSAKey AND (inserted.Modified <> 0 OR inserted.Deleted = 1) AND PingFolders.Type = 'Email'

GO

3) Start the web server and all NotifyLink services