[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 255
  • Last Modified:

Microsoft OFiice Library Database

We created a Document Repository from Microsoft Office Library Template. It is working fine about 1 year now but lately some of the created document give us error telling

Field is too Large(32k) or View's Column & selection formula are too large.


please help.

amd


0
amd1979
Asked:
amd1979
  • 3
  • 3
  • 2
  • +1
1 Solution
 
marilyngCommented:
See this tech note: http://www-1.ibm.com/support/docview.wss?uid=swg21087474

If you're using a standard document library from the template, and haven't modified it to display differently, then you might have to separate the (affected) documents.

Basically you've reached a notes limit as to what can be displayed in the view
0
 
Sjef BosmanGroupware ConsultantCommented:
How many documents are in that library? What Notes/Domino releases are you using?

I must say that I don't see this error very often. Usually, it is caused by a field on a form that has a formula which retrieves a lot of data from a view (for some good reason).  It might be that you put all your documents into one single category. Or you have too many categories (>5000?). To really find out what the problem is, I'd have to touch the real database...

There might be an upgrade available for this template that no longer has this problem. An other "solution" might be to split the library into two or more different databases.
0
 
amd1979Author Commented:
i replaced the design design of old template and it works. thanks
0
Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

 
amd1979Author Commented:
thanks
0
 
mbonaciCommented:
I'm with Sjef on this, there's no limit as to what can be displayed in the view.

Here's very good list of LN known limits:
    http://www.geniisoft.com/showcase.nsf/DominoLimits

Similar on EE:
    http:Q_21702325.html
    http:Q_21099889.html


Hope this helps,
Marko
0
 
marilyngCommented:
Sorry, didn't mean to apply that the VIEW had too many documents in it,  the field referenced in the view COLUMN had too many characters to be displayed in the view.  As what the link says.  
0
 
Sjef BosmanGroupware ConsultantCommented:
apply -> imply ??
0
 
marilyngCommented:
sorry.. washed my fingers and now can't do a thing with them.. I meant imply, of course.
0
 
Sjef BosmanGroupware ConsultantCommented:
Good morning ;)
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 3
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now