Sunday, December 11, 2011

The list cannot be displayed in Datasheet view

You cannot view a list in Datasheet view on a SharePoint website after you install the 64-bit version of Microsoft Office 2010. 

When you click Actions and then click Edit in Datasheet on a SharePoint 2003 or 2007 site, or you click the List tab and then click Datasheet view on a SharePoint 2010 site, you receive the following error message:

The list cannot be displayed in Datasheet view for one or more of the following reasons:
  • A datasheet component compatible with Microsoft SharePoint Foundation is not installed.
  • Your Web browser does not support ActiveX controls.
  • A component is not properly configured for 32-bit or 64-bit support.

This happens because  64-bit version of the Datasheet component is not available for Office 2010.
To resolve this issue download the office 2007 driver components by clicking here.

refer http://support.microsoft.com/kb/2266203 for more info on this issue.



Wednesday, December 7, 2011

STSADM with complete reference

MOSS CU / service pack versions

To check SharePoint version open central administration site--> Operations--> Servers in Farm

if your version is more than 12.0.0.6421 then it is SP2

12.0.0.6548 WSS 3.0 or MOSS 2007<sup>1</sup> SP2 + Oct 10 cumulative Update (KB2412268 + KB2412267)
12.0.0.6545 WSS 3.0 or MOSS 2007<sup>1</sup> SP2 + Aug 10 cumulative Update (KB2276474 + KB2276472)
12.0.0.6539 WSS 3.0 or MOSS 2007<sup>1</sup> SP2 + June 10 cumulative Update (KB983311 + KB983310)
12.0.0.6535 WSS 3.0 or MOSS 2007<sup>1</sup> SP2 + April 10 cumulative Update (KB981043 + KB981042)
12.0.0.6529 WSS 3.0 or MOSS 2007<sup>1</sup> SP2 + February 10 cumulative Update (KB978396 + KB978395)
12.0.0.6524 WSS 3.0 or MOSS 2007<sup>1</sup> SP2 + December 09 cumulative Update (KB977027 + KB977026)
12.0.0.6520 WSS 3.0 or MOSS 2007<sup>1</sup> SP2 + October 09 cumulative Update (KB974989 + KB974988)
12.0.0.6514 WSS 3.0 or MOSS 2007<sup>1</sup> SP2 + August 09 cumulative Update (KB973400 + KB973399)
12.0.0.6510 WSS 3.0 or MOSS 2007<sup>1</sup> SP2 + June 09 cumulative Update (KB971538 + KB971537)
12.0.0.6504 WSS 3.0 or MOSS 2007<sup>1</sup> SP2 + April 09 cumulative Update (KB968850 + KB968851)
12.0.0.6421 WSS 3.0 or MOSS 2007<sup>1</sup> SP2 (KB953338 + KB953334)
[Updated 1st Aug 09: SP2 download now includes the hotfix (KB971620) that corrects the activation issue more information on the Microsoft SharePoint team blog]

 If you are running SP1 after 13/Jul/2010 then you are running an un-supported environment,

12.0.0.6341 WSS 3.0 or MOSS 2007<sup>1</sup> February 09 cumulative Update (KB961755 + KB961756)
12.0.0.6335 WSS 3.0 or MOSS 2007<sup>1</sup> December 08 cumulative Update (KB960010 + KB960011)
12.0.0.6331 WSS 3.0 or MOSS 2007<sup>1</sup> October 08 cumulative Update (KB957691 + KB957693,KB958567 and KB958569)
12.0.0.6327 WSS 3.0 or MOSS 2007<sup>1</sup> August 08 cumulative update (KB956056 & KB956057)
12.0.0.6318 WSS 3.0 or MOSS 2007<sup>1</sup> Infrastructure Update (KB951695 & KB951297)
12.0.0.6303 WSS 3.0 or MOSS 2007<sup>1</sup> post-SP1 hotfix (KB948945)
12.0.0.6301 WSS 3.0 or MOSS 2007<sup>1</sup> post-SP1 hotfix (KB941274)
12.0.0.6300 WSS 3.0 or MOSS 2007<sup>1</sup> post-SP1 hotfix (KB941422)

12.0.0.6219 WSS 3.0 or MOSS 2007<sup>1</sup> SP1
12.0.0.6039 WSS 3.0 or MOSS 2007<sup>1</sup> October public update
12.0.0.6036 WSS 3.0 or MOSS 2007<sup>1</sup> August 24, 07 hotfix package
12.0.0.4518 WSS 3.0 or MOSS 2007<sup>1</sup> RTM
  

Error deploying solution, timer job stuck

Solution deployment timer job stuck and results in an error in WSP deployments.


Investigation steps..
·         Checked SharePoint services (including timer service) on all  boxes which I found to be running.
·         Opened central administration-->operations-->Servers in farm
·         Checked the version column and found that one of the WFE was having SharePoint version (12.0.0.6421) lower than other WFEs which were having version 12.0.0.6529.
·         Ran SharePoint Product technology wizard on the WFE having version 12.0.0.6421 and as expected, wizard failed to connect to SQL server due to schema version differences.
Problem resolution steps…
·         Disconnected the affected WFE from the farm.
·         Requested hotfix (http://support.microsoft.com/kb/978395  and http://support.microsoft.com/kb/978396 ) downloads from Microsoft website as installation of both these hotfix updates the SharePoint to the version which other WFEs were having.
·         Installed Office-kb978395-fullfile-x64-glb.exe and restarted the affected WFE.
·         Installed Wss-kb978396-fullfile-x64-glb.exe post the restart.
·         Ran the SharePoint product and technology wizard.
·         Post the successful completion of wizard checked the version (central administration-->operations-->Servers in farm)
·         Version of all WFE were same.