Page 1 of 3

Database has reached maximum size

Posted: Tue Jan 20, 2009 7:23 pm
by SidebandSamurai
Hello, I have a client that gets the following error when starting outlook. He is using Outlook XP (the one before 2003). After he clicks OK on both these error messages outlook will close.

I also found out after asking him a series of questions, that the first error (SXLSVR32) has been comming up for some time. but outlook would continue to work.

Smartcache is important as he frequently will work remotely and this speeds up access to his inbox while on the VPN. I would like to allow him to continue to use smartcahce for this reason. Turning off smartcache would not be a desireable solution.

Code: Select all

SXLSVR32
Data base has reached maximum size
<OK>


Code: Select all

Scalix Connect
Smart Cache has reached maximum file size fo 2GB
<OK>

I was not aware that Smartcache had a 2GB limit, is that true?

If so Do I have to reduce the size of his inbox below 2GB? He currently has a mail store size of over 5GB.

Will the removal of other folders (stuff he has archived) solve this problem also?

Or do I have to just simply reset his cache file to correct this issue?

Mind you this is a law firm and they want to keep EVERY piece of mail that they use to communicate between thier clients.

He is currently using the web client right now but I would like to get him back to Outlook if I can.

Currently he is using the 11.4.2 client and that is what the server is also on.

Thanks alot for your help.

Sincerley,

SidebandSamurai

Posted: Wed Jan 21, 2009 3:06 am
by Valerion
There is a 2GB limit, yes. Some attachments are stored outside the cache, though, and you can set the size at which this happens, to ensure more emails gets stored in this way. You'll have to search here for the correct syntax, though.

Posted: Thu Jan 22, 2009 9:03 pm
by SidebandSamurai
Thank you for your reply,

Is there a way of compressing the .mdb file found in the scalix profile?

When I try to open it for compacting (in access), it asks for a password. I don't want to delete and recreate the cache file because it tells me there are uncommitted changes to the Scalix server and deleting the profile will loose these changes.

Thanks for your time.

Sincerely,

SidebandSamurai

Posted: Fri Jan 23, 2009 12:35 am
by Valerion
Nope, only Scalix knows how to access that. I think the maintenance gets done automatically anyway, You'll have to externalize some items, then recreate the cache.

Or make sure that the guy REALLY needs a 5GB mailbox. is everything in there REALLY that important? It may be, or it may not be. In my experience such mailboxes are often filled with jokes and similar. Or contain 10 years worth of email.

Posted: Tue Jan 27, 2009 7:31 pm
by SidebandSamurai
I see,

When I destroyed his cache and re-created it with out changing anything in his email store, the size of the mdb was only 500mb. That is a far cry from 2GB.

Also, does this 2GB limit exist for Outlook 2007 also?

Sincerley,

Sideband Samurai

Posted: Wed Jan 28, 2009 1:19 am
by Valerion
It's a limitation in the Microsoft JET implementation. If it's been lifted in Access 2007 then it may work, otherwise Scalix is at the mercy of what JET provides. As for the size, this is likely something to be taken up by Scalix Support. May be correct, or may be a bug.

Posted: Thu Feb 12, 2009 12:49 pm
by SidebandSamurai
I did test with a workstation that was installed with Office 2007, and it did not work, after it hit 2 GIG the cache stopped working. After doing further research, Office 2007 (which includes Access 2007) still has the 2GB limitation. To actually exceed the 2GB limit I would actually have to install SQL server which is not practical, and would not solve my problem as Scalix uses Microsoft's Jet Data base not the SQL data base to create its cache file.

As the Cache file exceeds 2GB this makes smart Cache unusable for my largest customers.

Are there any suggestions on how I can get this with in the 2GB limit? For example maybe I can only cache the Inbox for example, but not any sub folders below that.

It was suggested in some articles that I was reading that the data be split between different files. A suggestion would be to create a .mdb file for each folder that needs to be cached. Also allowing the user to set which folders should be cached would optimize the time it takes to actually cache large mail boxes. Of course that would limit each folder for 2GB but that's better than having the whole mail store limited to 2GB.

I wonder how Outlook and the Exchange MAPI client does its caching.

Sincerely,

Sideband Samurai

Posted: Thu Feb 12, 2009 3:23 pm
by billb3
What is the majority of the contents of the mailbox? I have a bunch of users that have 2-2.5GB mailboxes and use full smartcache sync. Since mailboxes this big often contain a lot of attachments, their mdb file is still a reasonable size...as most big items are in the MailExt directory.

Also, someone earlier mentioned that you can adjust the settings for what gets filed in the MailExt folder? Seems like that would be the best fix....

Posted: Fri Feb 13, 2009 10:05 am
by florian
the limit exists, independent of the outlook version.

if is however possible to set the threshold at which objects are externalized as opposed to be kept inside the mailbox. this may get you a long way towards supporting larger mailboxes. the default value is 64k, i've had to tune this down to 2k to be able to have smartcache support my 7 GB mailbox.

The setting is a registry key and should be documented in the client deployment guide.

Florian.

Posted: Fri Feb 13, 2009 5:49 pm
by SidebandSamurai
Billb3,

Thanks for your reply, the reply that Florian provided (after you replied) is that the same fix?

Posted: Fri Feb 13, 2009 5:52 pm
by SidebandSamurai
Florian

Thanks for the suggestion, I will definately pursue this.

I will look in the client deployment guide to see what the registery entry is for this.

A question though, should'nt this be set in the Scalix Client instead of mucking around in the registery? Or is this an infrequent problem that the time is not worth investing in making such a change to the client.

Thanks for your time.

Sincelrey,

Sideband Samurai

Posted: Fri Feb 13, 2009 6:11 pm
by SidebandSamurai
Florian,

I reviewed the Client deployment Guide, and I did not find the registery entry you mentioned. It has only basic troubleshooting steps for smartcache and THAT only tells you what the status icons are for smartcache. There is no mention of this setting in the table of contents either.

Can you tell me what the registery entry is?

Thanks for your time.

Sincerley,

Sideband Samurai

Posted: Fri Feb 13, 2009 7:57 pm
by florian
I note that this is missing from the documentation.

Please see

https://bugzilla.scalix.com/show_bug.cgi?id=19222

Florian

Posted: Tue Feb 17, 2009 12:05 am
by billb3
More details about that registry key are in this thread:

http://scalix.org/forums/viewtopic.php? ... b97e#44351

Re: Database has reached maximum size

Posted: Fri Aug 21, 2009 3:29 pm
by SidebandSamurai
Hi Everyone,

This problem has become more of an issue and now I am forced to address this. I attempted to click on the link that billb3 was nice enough to give me, now when i click on it I only get the Scalix home page. This is probably due to the new forum software.

Can someone tell me what the registry entry is so that I can finally get this off my plate?

Also once I change this setting in the registry will I need to reset the SmartCache?

I will research this on the forums to see if I can find it myself and if I do I will post the updated link.

Thanks for all your help

Sincerely,

SidebandSamurai