Confusing unread marks on BlackBerry
Tags: BlackBerry
Normaly snycronisation between Domino and the BlackBerry device works very well. But sometimes strange things happen. For example with unread marks. I had such a strange problem today. I saw the sign for one unread message on my device but no unread message was available, nor it was in my mailfile.
To solve this, you need to know that the BlackBerry Enterprise Server syncronizes data with the Domino server over the SQL database. In this special case you should look into the table SyncNotesDocumentState and search for entries where the column CMD has the value Update and the column NotesSequenceTime has the value 0000000000000000:
After you've deleted the found entries the unread marks should sync again (a restart of the device is also a good idea) and voila, the "ghost" unread marks dissapear.
Normaly snycronisation between Domino and the BlackBerry device works very well. But sometimes strange things happen. For example with unread marks. I had such a strange problem today. I saw the sign for one unread message on my device but no unread message was available, nor it was in my mailfile.
To solve this, you need to know that the BlackBerry Enterprise Server syncronizes data with the Domino server over the SQL database. In this special case you should look into the table SyncNotesDocumentState and search for entries where the column CMD has the value Update and the column NotesSequenceTime has the value 0000000000000000:
SELECT *, Cmd AS Expr1, NotesSequence AS Expr2 FROM SyncNotesDocumentState WHERE (Cmd = 'Update') AND (NotesSequence = 0000000000000000)
After you've deleted the found entries the unread marks should sync again (a restart of the device is also a good idea) and voila, the "ghost" unread marks dissapear.
