Tag Archives: Update

How to annoy your SharePoint admins – Circular Loop with Lookup Columns

The SharePoint June 2009 Cumulative Update fix list contains this entry (http://support.microsoft.com/kb/970946/):

When a SharePoint user creates a circular loop between lookup columns, if you click one of the lists that contain lookup columns, this action will cause 100% CPU usage on the SharePoint server. To work around this issue, you have to perform an application pool recycle.

(Also mentioned on my SharePoint updates page: http://blog.hemker.de/sharepoint-updates/)

I tested and this issue can be reproduced very easily.

1. Create two custom lists, for example list1 and list2


2. Create a column in list1, for example c-list1. It is of type “Single line of text”


3. Create a column in list2, for example c-list2. It looks up the column c-list1 in list1.


4. c-list1 cannot be changed to type Lookup, so we have to delete it.


5. Recreate c-list1 as type Lookup and let it lookup c-list2 in list2.


6. Open list1 or list2 and enjoy the CPU load. Only IISREST helps here. At least until the next access to list1 or list2.


If you apply the June 2009 CU, one of the existing columns will be changed to lookup the title column in the other list, not the lookup column.

If you try to create the circular loop columns when the June 2009 CU is applied, one of the columns will be changed to lookup the title column in the other list, not the lookup column.

Microsoft Office Sharepoint Server 2007 (MOSS) Cumulative Update for August 2008 released, Build 6327

As of August, 26th 2008, the new August post-SP1 Update was released by Microsoft. It fixes a lot of issues and should be obtained from Microsoft Support Services.

The build after installing this hotfix is 12.0000.6327.5000.

The KB article mentioned here http://support.microsoft.com/kb/953878/en-us is not public yet, but it should be very soon.

For more details, see this article: http://support.microsoft.com/kb/953878/en-us

MOSS Update fails: Cannot start service SPAdmin on computer (update)

There were some admins recently, that installed a WSS and MOSS Hotfix (for example 12.0.6314.5000, 12.0.6315.5000, 12.0.6316.5000) and got an error message when running the Configuration Wizard (PSCONFIG):

Windows Sharepoint Services Administration Service could not be started

In such a case you have to add two registry keys and restart the server:

1. HKLMSYSTEMCurrentControlSetControl -> add/modify DWORD value ServicesPipeTimeout to 60000 (60 seconds)

2. HKLMSYSTEMCurrentControlSetControl -> add/modify STRING value WaitToKillServiceTimeout to 120000 (120 seconds)

After the reboot, the service should start without problems, because it is set to automatic start.

Update: Eventually you have to start the service manually after the first boot.