SharePoint Resource

The latest insights from the SharePoint Experts

Archive for September, 2011

Business Development Manager Vacancy

Posted by Steve Jones on September 26, 2011

Novotronix are looking for a new Business Development Manager for our SharePoint team-do you fit the bill? Find out more at http://ow.ly/6BVjo

Posted in Uncategorised | Leave a Comment »

Change local site language format (locale) in Sharepoint C#

Posted by niknovotronix on September 22, 2011

Had to change the regional settings on a SharePoint site programmatically to get correct date/time format in lists and calendars. Since the whole site is dynamically created with a site definition, this had had to be done with a feature which was activated upon site creation.
  1. Create a feature
  2. Create an event receiver class to the feature
  3. Code:
   

4. Set the local country code of your country instead of “en-GB”

Posted in Uncategorised | Leave a Comment »

Best practices for capacity management for SharePoint Server 2010

Posted by Steve Jones on September 16, 2011

For those involved in designing SharePoint 2010 infrastructure I would recommend reading the newly published article on capacity management best practices.  See http://technet.microsoft.com/en-us/library/hh403882.aspx

Posted in SharePoint 2010 | Leave a Comment »

SharePoint Error after moving databases

Posted by Gary Powell-Jones on September 12, 2011

A lot of people have experienced issues after moving databases (especially the configuration database)

The typical message when trying to run an stsadm command, or some Central Administration pages is…

“System.ArgumentNullException: Value cannot be null.Parameter name: str at System.Security.Permissions.FileIOPermission.HasIllegalCharacters(String[] str)”

 

One cause for this could be that the timer service has not reconnected to the Configuration Database.

The timer service has a local cache of all jobs stored in %systemdrive%\documents and settings\all users\application data\microsoft\sharepoint\config, in a folder with a GUID name. (on SharePoint 2010 it is $systemdrive%\users\all users\application data\microsoft\sharepoint\config. Note that this is a hidden folder

This folder will contain a file called cache.ini and many XML files.

First possible issue..

As noted in http://technet.microsoft.com/en-us/library/cc561004(office.12).aspx the SharePoint application groups may have ‘lost’ permissions (although the article has the wrong path). TheWSS_ADMIN_WPG and WSS_RESTRICTED_WPG require write permissions to this folder. Stop the SharePoint Timer service and Administration service, grant the permissions and re-start the services.

Second possible issue..

We have seen this once. The server registry lost the record of the configuration database ID. This is stored in HKEY_LOCAL_MACHINE\Software\Microsoft\Shared Tools\Web Service Extensions\12.0\Secure\ConfigDB (or 14.0 for 2010). There should be a REG_SZ key called Id. The value of this key should match the name of the folder in the %systemdrive%\documents and settings\all users\application data\microsoft\sharepoint\config folder.

In the case we saw, the value of this key was 00000000-0000-0000-0000-00000000000000

As above, we changed stopped the services, changed the key, and restarted the services.

Important note – Editing the registry can be a dangerous task & is done at your own risk

 

Posted in SharePoint, SharePoint Deployment | Leave a Comment »

The workbook you requested cannot be opened in the browser

Posted by niknovotronix on September 1, 2011

This error is not unusual when configuring excel services and trying to display an excel document inside the browser. OK, so what to do then?

  1. First step would be to check the SharePoint log and the event log for errors
  2. Check that the account running the excel service application has “db_owner” rights to the SharePoint content database. (http://blogs.msdn.com/b/jjameson/archive/2010/05/04/the-workbook-cannot-be-opened-error-with-sharepoint-server-2010-and-tfs-2010.aspx)
  3. If you get this error in the event log “The data culture ‘X’ was requested, and it is not fully supported because its language pack is not installed. Some features will not be available.”, install the language pack for that specific country and run the configuration wizard. (http://www.kowalski.ms/2008/07/04/excel-services-was-unable-to-load-the-workbook-that-you-requested/)
  4. See an “System.InvalidOperationException: Could not retrieve a valid Windows identity.” error in the ULS log? Make sure “Claims to Windows Token Service is started in Windows Services
  5. Also, check if Claims to Windows Token Service is started in central administration (Services on server)
If you have more steps to add to this post, leave a comment.

Posted in Uncategorised | 1 Comment »

 
Follow

Get every new post delivered to your Inbox.

Join 45 other followers