Skip to main content

RSUG Blog Zone

Go Search
Raleigh SharePoint Users Group
Events
RSUG Blog Zone
  

Other Blogs
There are no items in this list.
Raleigh SharePoint Users Group > RSUG Blog Zone
Search - Large File Index Issue
Files that have a lot of unique words in them will not index correctly.  For example a file that is 50MB, maybe only the first 10MB of words in the file will come back as hits.
 
First of all to even get a file that large indexed you have to add a registry to:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office Server\12.0\Search\Global\Gathering Manager

 

call it MaxDownloadSize, make it a DWORD value and the units are MB, so 100 = 100MB.

 

Now you can index the large files but will still have the issue I stated above.  I have been working with Microsoft on the issue for several months now, and they have given me the following registry values to increase and their suggestions:

 

CB_ChunkBufferSizeInMegaBytes – 35 (Decimal)

CB_MinBytesReservedForDoc – 30000000 (Decimal)

 

This does work for most of my tests, though I have still found a few problems, so will be doing some more experiments with these values.

 

The blog entry below describes the closest match on the web I have found to this symptom. His published suggestions do not go as far as mine.

http://bobklass.blogspot.com/2007/09/search-and-research.html

 

Save Site as a Template option missing from Site Setting Page

In my environment a owner of a team site with Full Control dose not see Save Site as a template on the site settings screen.  Full Control being the permission level bundled with SP.

 

If I make the user a Site Collection Admin the Save Site as a Template becomes available. 

 

This seems to be the case for all sites in the collection.

 

Regards,

Pat Donnelly

Misys Healthcare Systems

Mobile Views

Productivity on the go...

Of the many benefits of Windows SharePoint Services 3.0/Microsoft Office SharePoint Server 2007, often overlooked is the native support of mobile devices through embedded mobile site URLs and mobile views.

Mobile views permit both viewing and updating Lists and Document Libraries from a mobile device. 

When considering leveraging mobile views, you should carefully consider the restrictions on length and size of some parts of a list or library. 

Limitations

Rendering and performance are considered in mobile views, therefore it is important to understand the limitations imposed by these considerations when implementing Lists and/or Document Libraries, for instance many common fields should have a character limitation of no greater than 20 applied, these include List and Document Library titles and names, and List and column name titles.  When the 20 character limit is exceeded, mobile device users will be presented with an ellipses representing the additional characters.  In example, a List title ThisListHasOverCharacters will be rendered on the mobile device as ThisListHasOverChara... See below for a complete list of limitations to consider when designing Lists and Document Libraries settings for mobile views.

Item Limit
Characters in the Web title of a list or library 20
Characters in a list or library name 20
Number of mobile views 10
Number of items displayed in a view 100
Characters in a list item title 20
Characters in a column name 20
Single-line text field type 256
Multiple-line text field type 256
Each choice in a choice field type 10
Number of options in a choice field type 10
Characters in each item in a lookup field 20
Number of options in a lookup list 20
Characters in a hyperlink or picture field 20
Characters in an attachment file name 20
Number of attachments (to list items) displayed 3
Characters in a calculated field 20

NOTE Discussion Boards, the Currency, Yes/No, and Person or Group column types are not supported by mobile views.

Accessing Mobile Site URLs and Views

Mobile site URLs and views are native to Windows SharePoint Services 3.0/Microsoft Office SharePoint Server 2007, to access a mobile site URL or view simply append the URL with /m.  In example, http://<server>/<path>/<site>'s mobile URL can be accessed through http://<server>/<path>/<site>/m.

Standard Site URL View

Mobile Site URL View

Creating Mobile Views

In addition to the embedded mobile views you can also create mobile views for Lists and Document Libraries.

To create a mobile view, select the List or Document Library source and select Settings, and then select Document Library Settings or List Settings from the menu.

Select Create view and select Standard View under the Choose a view format section.

NOTE Calendar, Access, Datasheet, and Gannt views are not supported for mobile devices.

Using the table in the section labeled Limitations as a guide, complete the required fields on the Create View:  <List/Document Library> page.

Expand Mobile on the Create View:  <List/Document Library> page.

Select Make this a mobile view (Applies to pubic views only) and optionally Make this the default mobile view (Applies to public views only).

Click OK.

Now that you understand mobile site URLs and views in Windows SharePoint Services 3.0/Microsoft Office SharePoint Services 2007, go collaborate...on the go!/

User Profiles not showing up in other sites..

User Profiles - Why do my changes not show in other sites? - a detailed understanding of how the Sync works.

I was asked recently to advise on how to configure a MOSS 2007 installation to allow end users to update their display name as they had previously been able to do in 2003.  My initial thoughts on this were that its a simple update of the profile properties to allow them to edit the Name field,  however the results achieved in testing appeared inconsistent.

In this article I will show

  • How to setup the profile properties
  • What the user sees and can edit
  • What services/timer jobs are involved in the Sync and how to speed this up for testing
  • The conditions that need to be met to trigger the profile information to be replicated.

Setting Up Profile Properties

The first step is to setup the profile properties.   In this example I will be looking at enabling users to edit the display name ("PreferredName") field.  This example assumes that you have MOSS 2007 and a Shared Service Provider has been setup and configured.

From Central Admin choose the Shared Service Provider from the left hand menu.  This should display a screen similar to the one below.

Select the User profiles and properties option as highlighted.   This will allow you to add new properties or as in this example edit an existing property.

Scroll to the bottom of the page and click View profile properties.  On the list of properties select the Name field and choose Edit.

The profile properties page allows you to configure the profile property.  Ensure that the field selected is the PreferredName field, this has default Display Name of Name.

Check that the field is checked for replication.   You will note that the text suggests that properties that can be replicated cannot be edited by the user, however this does not appear to be the case.

Choose Allow users to edit values for this property,  this will allow the user to change the value via MySite.

Change the mapping to 'not mapped'.  If you do not change this any modification the user makes will be overwritten at the next profile import.

Note: When a user firsts accesses a site the User Info is extracted directly from AD (or your provider, not tested) and it still pulls the AD based display name into this field as it is not related to the profile mapping.

We will look at the different states for the User Info and profile imports below.

The properties page should show the PreferredName field is no longer mapped.

That is all of the changes required to make the display name editable by the user.

What The User Sees and Can Edit

When the user navigates to a SharePoint site the initial view will show the information contained in AD (I assume this is the same for other providers but you will need to test) including the display name.

AD user with defined Display Name, this will be used initially when the user accesses a SharePoint site as shown below.

To edit the display name navigate to your My Site, this will initially look like the image below,  notice that the Welcome message is not based on the display name from AD but the users account name. In this example I have blurred the domain name.

Click on the Details option under the My Profile Quick Launch and edit the Name field.

In order to test this I have used a time stamp so I could repeat the tests and identify what had changed.

Clicking on Save will take you back to the My Site home page and will show some of the fields have updated but others have not.  The fields that have not updated are based on the User Info table and is updated by the Quick Profile Synchronization timer job (see below).

 

The Quick Profile Synchronization timer job is scheduled too run regularly (minutes) but I have found in testing, and this will increase as your number of users and sites increase, it can take a while for the changes to take place.   You can force this timer job by running the STSADM operation SYNC.

stsadm -o sync

Note: this starts the job, the changes will not appear instantly.

After the sync has been performed the User Info table will be updated with the values from the My Profile details.

Why do some Team Sites not update with my details

The main reason for confusion around the updating (sync'ing) of My Profile details into team sites is that it is now based on if the user is Active.   As part of the upgrade to V3 Microsoft introduced the idea of users being active in a site rather than just having access.

When you first visit a site a record is recorded in the UserInfo table of the sites Content Database.   The field tp_IsActive is defaulted to false, which means you have visited but have not interacted with the site.

The Sync process uses this value to determine if the user info should be replicated from the My Profile details as edited above.

Following on from the example above you should be able to refresh your team site that you had only visited and see the user name is still the same, it was not updated when the My Site was updated.

If you now interact with the site, either add a document or edit a link,  in effect become an active user of the site, and then run the stsadm -o sync command as above the My Profile changes to the user name will be replicated to the site.

Sync Timer Jobs and STSADM

The synchronisation of the profile properties and information are based on two timer jobs,  and one stsadm command (as used above).  These jobs are per web application so you may see multiple of these configured in your environment.   Access to these is via Centra Admin -> Operations.

These timer jobs are part of the Microsoft.Office.Server.UserProfiles namespace and specifically
WSSProfileSynch
Handles the synchronization of user profile data in the Windows SharePoint Services user information list on each site, and the synchronization of Windows SharePoint Services members group membership in the user profile memberships. This class is not intended to be used directly from your code; use stsadm.exe instead.
WSSSweepSynch
Handles the incremental synchronization of user profile data in the Windows SharePoint Services user information list on each site. This class is not intended to be used directly from your code; use stsadm.exe instead. 

I have yet to determine exactly which of these processes are triggered using the stsadm -o sync command.

Additional Information

Profile Synchronisation on MSDN

Sahil Malik has a good post on the high level information flow within MOSS here.

I have also included below some sample code that I used to try and speed up the timer jobs.   You may want to use these to help understand what each timer job does.   Note, changing the Profile Synchronization schedule will not remain,  another time job appears to reset this to the installed defaults.

static void Main(string[] args)
{
List<System.Uri> urls =
new
List<System.Uri>();
urls.Add(
new System.Uri("http://mysite_webapplication"
));
urls.Add(
new System.Uri("http://portal_webapplication"
));

for (int
i = 0; i < urls.Count; i++)
{
SPWebApplication webApp = SPWebApplication.Lookup(urls[i]);

foreach (SPJobDefinition job in
webApp.JobDefinitions)
{
// "profsynch" = Profile Syncronisation

// "sweepsync" = Quick Profile Syncronisation

if (job.Name == "profsynch")
{
SPMinuteSchedule schedule =
new
SPMinuteSchedule();
schedule.BeginSecond = 0;
schedule.EndSecond = 59;
schedule.Interval = 1;
job.Schedule = schedule;
job.Update();

Console.WriteLine(
"Temporarily Updated Profile Sync for Web Application {0}"
, webApp.Name);
}
}
}
Console.ReadLine();
}

 

 

Error and Omissions

 

Warning:  Access to the database directly is not supported,  I performed this in my test environment to understand why things worked the way they did.

Using a famous Todd Bleeker line from TechEd Orlando - I reserve the right to be wrong!   This is what I have found so far,  but my knowledge and understanding of this may change over time.

Tags: moss, sharepoint

0 comments:

Post a Comment

Newer Post Older Post Home

Subscribe to: Post Comments (Atom)

MVP Award


MVP Microsoft Office SharePoint Server

About Me

Andrew Woodward

Shropshire, United Kingdom

SharePoint 2007 Design Limits

The following table lists the recommended guidelines for site objects.

Site object

Guidelines for acceptable performance

Notes

Scope of impact when performance degrades

Site collection

50,000 per Web application

Total farm throughput degrades as the number of site collections increases.

Farm

Web site

250,000 per site collection

You can create a very large total number of Web sites by nesting the subsites. For example, 100 sites, each with 1000 subsites, is 100,000 Web sites. The maximum recommended number of sites and subsites is 125 sites with 2,000 subsites each, for a total of 250,000 sites.

Site collection

Subsite

2,000 per Web site

The interface for enumerating subsites of a given Web site does not perform well as the number of subsites surpasses 2,000.

Site view

Document

5 million per library

You can create very large document libraries by nesting folders, using standard views and site hierarchy. This value may vary depending on how documents and folders are organized, and by the type and size of documents stored.

Library

Item

2,000 per view

Testing indicates a reduction in performance beyond two thousand items. Using indexing on a flat folder view can improve performance.

List view

Document file size

50MB (2GB max*)

File save performance is proportional to the size of the file. The default maximum is 50 MB. This maximum is enforced by the system, but you can change it to any value up to 2 GB.

Library, file save performance

List

2,000 per Web site

Testing indicates a reduction in list view performance beyond two thousand entries.

List view

Field type

256 per list

This is not a hard limit, but you might experience list view performance degradation as the number of field types in a list increases.

List view

Column

2,000 per document library4,096 per list

This is not a hard limit, but you might experience library and list view performance degradation as the number of columns in a document library or list increases.

Library and list view

Web Part

50 per page

This figure is an estimate based on simple Web Parts. The complexity of the Web Parts dictates how many Web Parts can be used on a page before performance is affected.

Page

The following table lists the recommended guidelines for people objects.

People object

Guidelines for acceptable performance

Notes

Users in groups

2 million per Web site

You can add millions of people to your Web site by using Microsoft Windows security groups to manage security instead of using individual users.

User profile

5 million per farm

This number represents the number of profiles which can be imported from a directory service, such as Active Directory, into the people profile store.

Security principal

2,000 per Web site

The size of the access control list is limited to a few thousand security principals (users and groups in the Web site).

The following table lists the recommended guidelines for search objects.

Search object

Guidelines for acceptable performance

Notes

Search indexes

One per SSPMaximum of 20 per farm

Office SharePoint Server 2007 supports one content index per SSP. Given that we recommend a maximum of 20 SSPs per farm, a maximum of 20 content indexes is supported. Note that an SSP can be associated with only one index server and one content index. However, an index server can be associated with multiple SSPs and have a content index for each SSP.

Indexed documents

50,000,000 per content index

Office SharePoint Server 2007 supports 50 million documents per index server. This could be divided up into multiple content indexes based on the number of SSPs associated with an index server.

Content sources

500 per SSP*

This is a hard limit enforced by the system.

Start Addresses

500 per content source*

This is a hard limit enforced by the system.

Alerts

1,000,000 per SSP

This is the tested limit.

Scopes

200 per site

This is a recommended limit per site. We recommend a maximum of 100 scope rules per scope.

Display groups

25 per site

These are used for a grouped display of scopes through the user interface.

Crawl rules

10,000 per SSP

We recommend a maximum 10,000 crawl rules irrespective of type.

Keywords

15,000 per site

We recommend a maximum of 10 Best Bets and five synonyms per keyword.

Crawled properties

500,000 per SSP

These are properties that are discovered during a crawl.

Managed properties

100,000 per SSP

These are properties used by the search system in queries. Crawled properties are mapped to managed properties. We recommend a maximum of 100 mappings per managed property.

Authoritative pages

200 per relevance level

This is the maximum number of sites in each of the four relevance levels.

Results removal

100

This is the maximum recommended number of URLs that should be removed from the system in one operation.

Crawl logs

50,000,000

Number of individual log entries in the crawl log.

The following table lists the recommended guidelines for logical architecture objects.

Logical architecture object

Guidelines for acceptable performance

Notes

Shared Services Provider (SSP)

3 per farm (20 per farm maximum)

  

Zone

5* per farm

The number of zones defined for a farm is hard coded to 5.

Web application

99 per SSP

This limit includes the number of Web applications on child farms consuming resources on this SSP.

Internet Information Services (IIS) application pool

8 per Web server

Maximum number is determined by hardware capabilities.

Site collection

50,000 per Web application

  

Content database

100 per Web application

  

Site collection

50,000 per database

  

The following table lists the recommended guidelines for physical objects.

Physical object

Guidelines for acceptable performance

Notes

Index servers

1 per SSP*

  

Application servers running Excel Calculation Services

No limit

  

Query servers

No limit

Because 100 content databases are supported for each query server, the number of query servers required per farm is based on the number of content databases in the farm. For example, if there are 500 content databases in your farm, you will need at least 5 query servers.

Web server/database server ratio

8 Web servers per database server

The scale out factor is dependent upon the mix of operations.

Web server/domain controller ratio

3 Web servers per domain controller

Depending on how much authentication traffic is generated, your environment may support a greater number of Web servers per domain controller.

You can find the full article on technet, with graphs and test environment settings that will help to complete the scenario.

SharePoint Training
Hi,
 
Aivea, Microsoft Gold Partner and a premier SharePoint Consulting Services provider for Microsoft is conducting an excellent SharePoint 2007 Architecture and Administration class in beautiful Portland, Oregon on 05/19 – 05/20, The training fees include Hotel and Meals. If you are interested, please call 1-800-779-7506 or e-mail consulting@aivea.com
 
 
Thanks
-Pradeep
New search filter pack available for .Zip, Visio, Onenote etc

The MS Filter Pack is finally available !!! The package can be downloaded from:

 http://www.microsoft.com/downloads/details.aspx?FamilyId=60C92A37-719C-4077-B5C6-CAC34F4227CC&displaylang=en

Contents:

The filter pack includes the following IFilters:

·         Metro (.docx, .docm, .pptx, .pptm, .xlsx, .xlsm, .xlsb)

·         Zip (.zip)

·         OneNote (.one)

·         Visio (.vdx, .vsd, .vss, .vst, .vdx, .vsx, .vtx)

Supported Products:

·         SPS2003, MOSS2007, Search Server 2008, Search Server 2008 Express

·         WSSv3

·         Exchange 2005

·         SQL 2005, SQL 2008

·         Windows Desktop Search 3.01, WDS 4

Overview:

·         The Filter Pack installs the above IFilters on the machine

·         Each IFilter is registered with Windows Indexing Service

·         Each product above has a corresponding KB to describe how to register the filters

Q&A:

“I noticed <product X> is not listed as a supported product, why is it not included?”

-       When we created the project plan we came up with the list of Microsoft Search products that we would be supporting.  During the project lifecycle we’ve tested to ensure that the Filter Pack works properly with each of these products.  We will work to determine if any new Search products can be supported in the future.

 

“Is the Filter Pack localized for <language y>?”

-       The Filter Pack will be localized in 36 different languages (see below).  It has been passed off for localization – details will be posted as they become available.  At the time of release (12/18), the Filter Pack will available in en-us only.

 

Fully Localized SKU Languages

Language Pack Languages