Inbox Problem: No Mail Service; Formula Error - Reload

Greetings,

A couple of nights after upgrading a server to 8.5, we experienced an issue on some mailboxes where they wouldn’t open to the inbox.

You could bypass by opening straight to the calendar or todo views.

I was able to determine a temporarily resolution of the issue, but can’t find the underlying formula issue causing this. After going all the back to an R6 template to find one that worked, I started stripping out design elements in an R7 template one by one and testing. What I’ve found is a folder colum of the $Inbox, third from the right with the heading “^”, and value selection value of @Username.

On the properties, the 'Programmatic use Name:" value is $ToStuff. Removing this value ($ToStuff), and the mailbox will open fine.

Any ideas on what has happened here, what in the database has gotten corrupted, and what $ToStuff is and where it’s pulling from?

As a little background, I tried removing the $inbox folder and letting it rebuild. I purged the view via the Admin cleint. I did the same and replicated to another server and let it rebuild. None of these normal tricks worked, which leads me to believe it’s an issue that is within some of the documents themselves.

Any ideas appreciated,

thanks

Erik Welch

Subject: CalendarProfile corrupted

For whatever reason, the CalendarProfile became corrupted which caused this issue to occur. Delete the CalendarProfile profile and re-create and this problem will resolve itself.

How it got corrupted is still a question awaiting an answer from the Lotus engineers.

Subject: Removing profile docs allowed the db to be opened correctly

Domino console shows this when trying to open the db:

Database collection open error: /dominodata/mail/tuser.nsf: Formula Error

After trashing the profile docs it opens without problems

Subject: which profile docs

I only deleted the Calendar Profile doc, which others should I delete? Also, How do you do it, do you run an agent?

Subject: How do I find the Calendar Profile doc in mail DB?

Dear all,

Could you show me the way to find & delete it ? I dont know how to find Calendar Profile doc.

Thanks alot,

Tran Long

Subject: A tool for finding and deleting profiles

Hi,

We at Ytria make a tool called scanEZ that lets you quickly see and delete profile documents.

Here’s a link:

Best of luck resolving your issue.

Subject: To delete calendar profile

We’ve tried to delete the calendar profile but still not working.

Anyway this is the link how to delete the calendar profile.

http://www-01.ibm.com/support/docview.wss?fdoc=wplcnote&rs=475&uid=swg21088892

Also notice that in the 3rd last column, if you untick the User Define

Profile Document: Color Profile

It will work as well

But as soon as we tick back, the same error re-appear.

My colleage found something else that solve the problem… please see link below.

http://chris.brandlehner.at/Brandlehner/cab_blog.nsf/d6plinks/CBRR-7NRHWU

Cheers,

Subject: My Solution

What I did was I replaced the design of the faulty database with a customized template (NTF) downloaded from OpenNTF.org. After replacing the design, all views such as inbox, all documents, etc were fixed. Then, I replaced back the design of the template to Std85Mail and all views are still intact…

Subject: I ran into this problem on a NEW mail db

Created a new user using CA process, with mail db created in the background

Load convert -u mail/tuser.nsf * mail85.ntf did not fix it (nor mail8.ntf)

I’ll try the calendar profile next.

Subject: user definable - colorprofile

It has to do with the column property “user definable” “colorprofile” setting. Best to disable recipient indicators in Mail Policies

I found an interesting write up about this issue here http://chris.brandlehner.at/Brandlehner/cab_blog.nsf/d6plinks/CBRR-7NRHWU

Subject: Reset Color Profile to defaults

If you just reset the Colors to default that seems to correct the corrupted Color Profile document as well.