SharePoint (2003 thru Online): July 2015

Monday, July 20, 2015

SharePoint Search functionality

Sometimes, SharePoint Search functionality doesn't work due to issues like error in Propagation Status in Search Administration such as query Server not responding.

Click  on the below link for solution.
http://venugopalareddy.blogspot.com/2014/10/query-server-is-not-responding-and.html


Also we need to clear the config cache on all servers.

This is a summary of the actions:

  • Stop the “SharePoint 2010 Timer” service.

  • There are loads of XML files that can be found in the folder "C:\ProgramData\Microsoft\SharePoint\Config\". Note there seems to  be folder(s) under Config which has a GUID. 

  • Do not delete the folder(s) with GUID
  • Delete all the XML files in the GUID folder. 
  • Do not delete 'cache.ini' file.



  • Edit the "cache.ini" file, setting the content to "1" (without the double-quotes). This indicates that all cache settings need to be refreshed. Eventually this value gets automatically updated to another number when the cache is repopulated.
  • Start the “SharePoint 2010 Timer” service.
We need to perform the above steps on Index, Search, WFE(s) and App(s) servers in order.

Based on your SharePoint Usage, it is better to do this activity every 6 months.

For SP 2010 and 2013 >> https://spcachecleaner.codeplex.com/

List of All DBs in MOSS 2007

Tried to find list of DB’s used by SharePoint. We used to go searching the Central Admin - Application Management - Content Databases option and note all the databases against the URLs.

1. Found an awesome option, navigating to Central Admin >> Operations >> Perform a Backup




2. You can also run the following script on "SharePoint_Config" and get the list. Change the DatabaseInstance and DatabaseServer in the below script with your details.

SELECT o.[Name] AS 'SharePoint_Config',
    Instance.[Name] AS 'DatabaseInstance',
    [Server].[Name] AS 'DatabaseServer'
FROM Objects AS o
    INNER JOIN classes c on c.id = o.classid     
    LEFT JOIN Objects AS Instance ON o.ParentId = Instance.Id
    LEFT JOIN [Objects] AS [Server] ON Instance.ParentId = [Server].Id
    WHERE c.Fullname LIKE '%Administration.SPConfigurationDatabase%'
    OR c.Fullname LIKE '%Administration.SPContentDatabase%'
    OR c.Fullname LIKE '%Administration.SharedDatabase%'
    OR c.Fullname LIKE '%Administration.SearchSharedDatabase%'
    OR c.Fullname LIKE '%Administration.SPSearchDatabase%'


Wednesday, July 8, 2015

No Web Part Zones in SP 2010

We actually don't see Web part Zones in SharePoint 2010. 
We can add the web parts and changing the Layout of the Page.

Edit the Home Page, change the Layout with "Text Layout".


Keep the cursor in the Layout you need and click on 'Insert' tab.



Click on "Web Part" to see and add the Web Parts.