SharePoint 2007: Table of Contents WebPart (max 50 sites)

We have a Table of Content webpart on our intranet site, which displays the sites below a given site. Apparently this web part will only show 50 subsites. To display more, Microsofts tell’s us to do the following:

Open web.config and search for the following:
<add name="GlobalNavSiteMapProvider" description="CMS provider for Global navigation" type="Microsoft.SharePoint.Publishing.Navigation.PortalSiteMapProvider, Microsoft.SharePoint.Publishing, Version=13.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" NavigationType="Global" EncodeOutput="true" />

<add name="CombinedNavSiteMapProvider" description="CMS provider for Combined navigation" type="Microsoft.SharePoint.Publishing.Navigation.PortalSiteMapProvider, Microsoft.SharePoint.Publishing, Version=13.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" NavigationType="Combined" EncodeOutput="true" />

<add name="CurrentNavSiteMapProvider" description="CMS provider for Current navigation" type="Microsoft.SharePoint.Publishing.Navigation.PortalSiteMapProvider, Microsoft.SharePoint.Publishing, Version=13.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" NavigationType="Current" EncodeOutput="true" />

<add name="CurrentNavSiteMapProviderNoEncode" description="CMS provider for Current navigation, no encoding of output" type="Microsoft.SharePoint.Publishing.Navigation.PortalSiteMapProvider, Microsoft.SharePoint.Publishing, Version=13.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" NavigationType="Current" EncodeOutput="false" />

Add the following the every line: DynamicChildLimit="<integer>" (a zero will apply a no limit).

for example:

<add name="GlobalNavSiteMapProvider" description="CMS provider for Global navigation" type="Microsoft.SharePoint.Publishing.Navigation.PortalSiteMapProvider, Microsoft.SharePoint.Publishing, Version=13.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" NavigationType="Global" EncodeOutput="true" DynamicChildLimit="100" />

thx to: http://suguk.org/forums/thread/3767.aspx

Video’s: PowerPivot for SharePoint Architecture

A cross post from my colleague Kasper de Jonge. He found some great video’s out on the PowerPivot Technet site. Video’s about the architecture you will work with when using PowerPivot for SharePoint. Pretty neat stuff.
The video’s are presented by Lee Graber, Senior Software Developer, Microsoft SQL Server Analysis Services.

Part 1: SharePoint User Identity Fundamentals for PowerPivot Server Administrators

Part 2: Security Context of PowerPivot Connections in a Farm

Part 3: PowerPivot Data Refresh in SharePoint

 

Part 4: Using PowerPivot Workbooks as a Data Source

SharePoint: The server block is not well formed

In SharePoint we have a document library for OneNote documents. This morning we had a problem that our OneNotes did not synchronize anymore with the SharePoint OneNote library.

As we browsed to the library, we received the following error:
”The Server block is not well formed”

image

It had something to do with the default view, which was corrupt. To resolve the problem, follow the steps below:

  • Go to your document library and change the AllItems.aspx part @ the end of your url to webfldr.aspx
  • Click on [Settings] and choose [Document Libary Settings]
  • Create a new view, name it temp or so (you can use allitems as a start of your view)
  • Again go back to your document library and change AllItems.aspx again to temp.asxp (or the name you choose).
  • Click Actions and choose [Open with Windows Explorer]
  • Change AllItems.asxp to AllItems_old.asxp
  • Rename temp.asxp to AllItems.asxp
  • If you browse to your document library, you will now see that the view is still named “temp’, open [Settings] again and choose [Document Libary Settings]Settings]
  • Change the Temp view, make it default and rename the view name to AllItems

SP2010: FAST Search not returning any results

I’ve been struggling with getting FAST search server to work. On a single box installation.
When I installed and configured FAST and created a search site, I did not get any results back.

The only error I got was “The Search request was unable to connect to the Search Service”.

This apparently had to do with certificates. If you open your Certificate store on your local server, you will see a store named SharePoint. In this store (under certificates) there will be a certificate named Sharepoint Security Token Service. I copied this certificate to the “Trusted People\Certificates” store, and voila the error above disappeared.

However I still did not get any results back.

After again some research time, I found that my  Fast Content SSA wasn’t configured correctly. I followed the Technet Guide,  and as it states here you have to open Install_info.txt from your FASTSearch installation directory and use the Content Distributer that is specified there (port 13391). However if you look at the file %FASTSearch Install Dir%\etc\contentdistributor.cfg it will display a different port: 13390.

Reconfiguring my FAST Content SSA with this new port, made my search site return result.

image

SharePoint: Web Databases

Note to self :-) :

Whenever you want to create a SharePoint Site bases on a Web Database template, you have to make sure you did the following:

  • Created a Access Service Application
    (Central Administration – Manage Service Applications – New – Access Services)
  • Started the Access Database Service
    (Central Administration – Manage Services on Server)

If you don’t you will receive an error like this:

Preparing Site …
Someone has recently made changes to this site and the site is being updated. If the site remains offline for an extended period of time, contact a site owner.

Wait a moment and refresh your browser

image

Don’t bother waiting…

After you did all of this, open up the SharePoint 2010 Management Shell, and give the following command:

enable-spSessionStateService –DataBaseName <SomeNewDatabaseName>

This will create a session state database and turns on the session state service.

SharePoint: Error Editing List in datasheet view

When I tried to edit a SharePoint List in a datasheet view a received the following error:

The list cannot be displaued in DataSheet view for one or more of the following reasons:

- A datasheet component compatible with Windows SharePoint Services is not installed.
- Your Web browser does not support ActiveX controles
- Support for ActiveX controles is disabled

image

I tried it with a SharePoint 2010 and a SharePoint 2007 List, both returned the same error.
As I had office 2010 on my machine. It seems that you have to install the 2007 Office System Driver: Data Connectivity Components for this to work.

SharePoint Search Error “Access is Denied”

If you are like me and did a single box farm installation of SharePoint 2010, you might get to an error whenever you have configured your search.

I configured the search to crawl my local SharePoint Sites and when it did a full crawl it gave me the following error:

Access is denied. Verify that either the Default Content Access Account has access to this repository, or add a crawl rule to crawl this repository. If the repository being crawled is a SharePoint repository, verify that the account you are using has “Full Read” permissions on the SharePoint Web Application being crawled.

image

This error is caused by the local loopback check.

You can disable the loopback check by setting the DisableLoopbackCheckregistry key. To set the DisableLoopbackCheck registry key, follow these steps

  1. Click Start, click Run, type regedit, and then click OK.
  2. In Registry Editor, locate and then click the following registry key:

    HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa

  3. Right-click Lsa, point to New, and then click DWORD Value.
  4. Type DisableLoopbackCheck, and then press ENTER.
  5. Right-click DisableLoopbackCheck, and then click Modify.
  6. In the Value data box, type 1, and then click OK.
  7. Quit Registry Editor, and then restart your computer.

You can now also browse your site on your local server

SP2010: User Profile Import

I had some problems getting the SharePoint User Profile import to work. I finally managed to get it to work, here is how I did it.

First let me explain the situation.

I have 2 domains which are part of the same forest, Domain A and Domain B.
Domain A was the first domain ever created, and Domain B is a new domain in the same forest. I’m setting up a new SharePoint Server which will be part of Domain B.

I did setup a Active Directory Synchronization Connection in the User Profile Service Application. This Profile will be importing the user profiles of Domain B, so this connection will be established with the farm account of SharePoint 2010.

Every time I tried to run a Full Profile Import it failed.

As this technet article states, your service account needs the Replicating Directory Change permission on your Active directory. I did give it that permission, but still it failed, it seems that this is because of my domain setup. Just read on, and it will all be clear to you.

Whenever you create a Sync connection, SP2010 will use the ForeFront Identity Manager 2010 to do the import of the AD accounts. The nice thing is you can manage this by opening the “Synchronization Service Manager” (SSM) on your SP2010 server. This tool is started by executing the command:

C:\Program Files\Microsoft Office Servers\14.0\Synchronization Service\UIShell\miisclient.exe

Synchronization Service Manager

With this tool you can also view what is going wrong with your Synchronization jobs.
Click on [Management Agents], you will then see your connection profile. You can right click it and execute the run command and select “[DS_FullImport]. In my case this resulted in the error: Replication access was denied – Error Code: 8453.

Connection Log Error

In the SSM opened the properties of my connection. Under the option “Configure Directory Partitions” I noticed 2 directory partitions named: “CN=Configuration, DC=<domain A>, DC=COM” and “DC=<Domain B>, DC=COM”.
As my sync kept failing on the first step, which obviously was the “CN=Configuration….” partition, I concluded that I had to give farm account, the “Replicate Directory Change” permission on my Configuration Partition.

For this I opened the ADSI editor on the domain controller of Domain A, and selected [Configuration] at the “Select a well known Naming Context:” drop down box. Next is to open the properties of this partition and select the Security Tab.
I then added the Farm Account and gave it the “Read and the Replicating Directory Changes” rights. This made sure that the Profile Import started working correctly.

Note: don’t forget to give the “Read and the Replicating Directory Changes” rights to your Farm Account on Domain B, as I stated earlier or else step 2 of the synchronization job will fail.

SP2010: ULS Log Viewer

ULSViewer allows users to open a ULS (Unified Logging Service) log file and display its contents in a user friendly format. Users can then perform advanced functions such as filtering, sorting, highlighting, loading logs, appending logs, etc in order to single out the data that is important to the user. This information can be used to diagnose problems with machines running ULS services, or to monitor machines and the events they create in realtime.

You can use this tool whenever you run into problems with i.e SharePoint. The log can be viewed in real-time.

ULS_Viewer

download the file here.