8.0/8.5 Mail Database "Overflow"

For one particular user’s database, when I open it in any client, equal to or newer than the design template version of course, it takes a few seconds longer than normal to open, and I get the error message “Overflow.” After this happens, the database will open and work just fine.

This started in release 8.0. I upgraded the user to 8.5 FP1 and replaced the database design to no avail.

I have tried making a new replica of the database. The replica behaves the same way. I have run dozens of different compact, fixup, and updall commands. Since this started happening, the database has been upgraded to transactional logging with DAOS. So a lot has been done to the database, but this error message persists.

Anybody know what this means, and how I can fix it? Thanks.

Subject: Fix

I came across this error too. I think it is related to the color profile in the mail file as a result of Attention Indicators being enabled.

Its possibly related to the issue described here - http://chris.brandlehner.at/Brandlehner/cab_blog.nsf/d6plinks/CBRR-7NRHWU

You can remove profiles by creating an agent…

Dim session As New NotesSession

Dim db As NotesDatabase

Dim doc As NotesDocument

Set db=session.CurrentDatabase

Set doc=db.GetProfileDocument("<Profile Name>")

Call doc.Remove(True)

Msgbox "Profile Document is Successfully Removed"

Subject: Fix Part 2

I tried just deleting the colorprofile document with no luck.

I had to delete the calendar profile document to fix this issue. I ran the debugger and noticed it was choking on the “SoftDeliveryExpiryTime” setting in the calendar profile document, which the user had set to “99999”. Once I deleted the calendar profile document and let notes recreate it, the overflow message stopped.

Subject: Solution For Me

Overflow - Message while Opening Maildatabase:

A user has entered ‘99999999’ in the Mail Preferences Option ‘Empty Trash after XXXX Hours’.

Seems max value is 32768, it works with 32000 Hours.

I recommended better using folders for eventaul later necessary mails.

best regards Heiner

Subject: empty trash was the problem

Overflow appearing whenever user mailbox was opened with different versoin and patches (8.5.1, 8.5.3 FP1)Yes, also for me the solution was to reduce the value in the field “Empty Trash after XXXX Hours.”