Skip to main content

Posts

Showing posts from 2009

SharePoint User Profiles and Properties error

I recently encountered an issue with the Shared Services Administration page for User Profile and Properties (the page where you schedule an Active Directory profile import).

The page in question is in the Shared Services Provider site, e.g. http://server:port/ssp/admin/_layouts/ProfMain.aspx

The error that gets displayed is:
An error has occurred while accessing the SQL Server database or the Office SharePoint Server Search service. If this is the first time you have seen this message, try again later. If this problem persists, contact your administrator.

The error was odd, because I knew SharePoint Search was functioning (search crawls were running as normal, and search queries were being filled in the web front end). After a bit of investigation, I found the following table to be missing some records that were required.

So in actual fact, the error being referred to when accessing the SQL Server database was that some expected records weren't in the table being looked up, not that …

Highlights from SharePoint 2010 - from SPC2009

I'm here at Microsoft's SharePoint Conference 2009 with lots of cool info about SharePoint 2010. I will start by saying the new release is cool. Lots of annoying things about 2007 have been fixed, and there's lots of useful information.

I thought I'd quickly list out some of the highlights that I hold dear...

You've probably seen this already - the Ribbon interface is EVERYWHERE. This includes all web part pages, publishing pages, list forms, and admin pages. Like it or loathe it, you probably should embrace it or get out of the Microsoft Office ecosystem.
A new Dialog Framework has been introduced, so editing item properties does not take you away from where you were. Interestingly (perhaps lazily?) this has been implemented via an absolutely positioned div tag with an iframe inside - the UI benefits for users on this is tremendous (IMO)
SharePoint and SQL need to run on 64 bit operating systems
The requirements for SQL is 2005 SP2 or 2008 SP1 Cumulative Updates 2…

New SharePoint Config DB on pre-existing server

Today I had the pleasure of having to deal with a SharePoint test environment whose Config DB had a corruption. Being a test environment, and knowing that it was quite old and crufty as far as Test environments go, I decided the best way to deal with it was to kill the Config DB and create a new one, re-attach the content dbs and go from there.

A couple of points about this situation:
- the SharePoint environment is a single server environment (with SQL 2000 Standard running)
- I didn't want to set up an entirely new SharePoint server, simply use the current one keeping all the other stuff already running on it
- When re-creating the Config DB, I renamed it to a new naming standard

So I went about disconnecting the server from the farm by using the SharePoint Products and Technologies Configuration Wizard. This is a relatively straight-forward, wizard based task.

I re-ran the SharePoint Products and Technologies Configuration Wizard, this time creating a new farm with the desired C…

A problem has occured: SharePoint / TRIM integration

I came across this problem when configuring the TRIM TCSI Components for SharePoint 2007. Specifically, the project was installing the "TCSI SharePoint 2007 Components 2.1 SP3.exe" components.

Installation of the components went OK. We were specifying the TRIM Context server during the MSI install, but with no ICE server (left blank). Once the MSI install was complete, and the Site Collection features were activated, the usual TcsiSettings.aspx link appears under the site collections Settings.aspx page.

However, once clicking on the page, the following two errors were displayed (on /_layouts/TcsiSettings.aspx).

A problem has occured: An unexpected and unknown problem has occurred in the Unique World Software framework exception handling class. No details are available for this problem. Problem ID: 1001003001

and

A problem has occured: An unexpected and unknown problem has occurred in the TCSI CommonServices. No details are available for this problem Problem ID: 1100004001

L…

Microsoft SQL 2005 Build Numbers

Looking for a list of SQL Server 2005 Service packs and their corresponding build numbers?
SQL Server 2005 Release To Manufacturing (RTM, original version) - 9.0.1399 RTM
SQL Server 2005 Service Pack 1 - 9.00.2047SQL Server 2005 Service Pack 2 - 9.00.3042SQL Server 2005 Service Pack 3 - 9.00.4035

Modifying SharePoint's ItemStyle.xsl causes problem with Summary Link Web Part

Today I discovered an issue with some customisations I did for a client. The customisations involved changing the ItemStyle.xsl file, to add new templates for a Content Query Web Part.

More specifically, the client wanted to show a view of news items, the latest news item to be displayed in full, and the remaining x number of items to display in summary form.

This can be done with a test for preceding sibling nodes, e.g.
<xsl:test="count(preceding-sibling::*)=0">

This particular client had one more specific requirement, to also show images associated to the latest News Item. To do this, I created a new XSL variable, pulling in the URL of the image with the following code:
<xsl:variable name="NewsItemImage">
<xsl:call-template name="OuterTemplate.FormatValueIntoUrl">
<xsl:with-param name="Value" select="@ImageUrl">
</xsl:with-param>
</xsl:call-template>
</xsl:va…