How to break a SharePoint list in less than minutes
My client asked me today the limitation of Sharepoint 2010 in terms of number of words per column types, lines and attachments.
I found the answers in Microsoft website and also this blog http://sharepointgadget.blogspot.co.uk/2010/05/limits-in-sharepoint-2010.html that has a good summary.
But then I wanted to prove myself what “Multiple Lines of Text : 192 Maximum Value” really meant for my end user language, so now is the reference to my title “how to break Sharepoint”:
– In a Sharepoint list, I create a Multi-lines column
– Add the value “0123456789” to have 10 characters, then copy and paste this value a few times to have a few hundreds.
– Now be crazy and copy and paste is a lot, I used Word to count my characters and I arrive to 1Mo.
– From here Internet Explorer (I was pasting in a Datasheet mode) crashed, I could have let it think for 30 minutes but decided to crash it after 5.
– Now re-open IE and this list….
– It cannot open ! to be precise: the page opens but doesn’t load anything (blank page).
– And worse: if the list is also showing in a webpart on a page that page won’t open either. Quite an issue if that page is a homepage right ?
Now I had a problem: the list default view cannot be opened because it contains my very large value in a column, and you can only point to the list settings if you know the unique ID of the list (url http://sharepointsite/_layouts/listedit.aspx?List=%7B3C68CBBE%2D3F51%2D402A%2DA584%GD61A0F8C5AFA1%7D)
To fix it: open the site in SharePoint Designer, then open the list gives the option to
The column are now editable and I can change my “Multiple lines of text” to be “Single line of text”
By doing this the long text value in the column will be truncated (and rich text lost if any).
Don’t forget to close the Column edit tab in Sharepoint designer and save the changes.
Now any page containing the view and the list itself can be opened again.
-
May 3, 2012 at 13:09SharePoint Daily » Blog Archive » SharePoint Online Slide Libraries; Cloud Office Suite Shootout; The Dumbening of Technology
-
May 3, 2012 at 13:14SharePoint Online Slide Libraries; Cloud Office Suite Shootout; The Dumbening of Technology - SharePoint Daily - Bamboo Nation
-
May 4, 2012 at 13:09How to break a SharePoint list in minutes - The Microsoft SharePoint Blog
Tags
Top Posts
- #ProjectOnline #PowerBI Report – Include #HTML formatting #PPM #PMOT #PowerQuery #OData #REST Part 2
- Project Server - "An unknown error has occurred"
- Using PnP PowerShell to export and import Taxonomy
- Useful JavaScript Function: PreSaveAction #SP2010 #SharePoint #PS2010 #ProjectServer #in
- Calculated Column Formula: Probability and impact analysis for risks #SharePoint #SP2010 #ProjectServer #PS2010 #EPM #MSProject #in
- Take control of your log files
- Want to query cross #project site #SharePoint lists in #ProjectOnline / #ProjectServer ? #PowerBI #PowerQuery #BI #Office365 #Excel #PPM
- Unique alphanumeric list ID's via SPD Workflow and Calculated Columns #SharePoint #SP2010 #in
- So, you want to delete users with the Azure AD Graph API? Good luck with that!
- Customizing the Refinement Panel web part in SharePoint 2010
Archives
Blog Stats
- 603,956 hits