Tuesday, December 16, 2014

Remove the existing metadata during document upload



Refer script here : http://vinayak-projects.blogspot.com/2014/05/feature-id-not-assigned-when-saving.html

Sunday, November 16, 2014

Slipstream for sharepoint installation


Slipstream for sharepoint




Moss

http://blogs.technet.com/b/seanearp/archive/2009/05/20/slipstreaming-sp2-into-sharepoint-server-2007.aspx


Sharepoint 2010 


http://www.toddklindt.com/blog/Lists/Posts/Post.aspx?ID=295

Tuesday, September 30, 2014

Check all database Size SQL Server

SELECT d.name,
ROUND(SUM(mf.size) * 8 / 1024, 0) Size_MBs
FROM sys.master_files mf
INNER JOIN sys.databases d ON d.database_id = mf.database_id
WHERE d.database_id > 4
-- Ignore system databases
GROUP BY d.name
ORDER BY Size_MBs DESC

Wednesday, May 28, 2014

Feature id not assigned when saving a list as a template

It's pretty obvious that you will use List template to create similar list as you have created earlier within your share point environment .

During the course of action of saving a list template and uploading to List template Gallery and creating list from template , you notice template name is from missing from Libraries or custom list.

So if you check List template under galleries you will also find feature id is missing for this template.



This issue occurs due to ParserEnabled property is set to false for web application 

Use power shell script to resolve this issue

[System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SharePoint")
$siteurl="http://Your Site name/default.aspx"
$site=new-object Microsoft.SharePoint.SPSite($siteurl);
$web=$site.openWeb();
$web.ParserEnabled = $true
$web.update();
$web.Dispose();
$site.Dispose();


Remove list template and upload again and you should be able to see feature ID is associated with it .

Targeted share point version MOSS 2007

More reference here.

Thursday, May 22, 2014

How to get worker process PID and associated ID ( PID for W3WP.exe)

For troubleshooting specific application pool in server where multiple websites are running
Use following command for IIS 6.0 and Windows Server 2003

C:\WINDOWS\system32 >cscript iisapp.vbs


This command will give application pool names and respective process id.

 Using these PID’s each worker process (w3wp.exe) can be monitor under task manager . PID column is not enabled by default it can be added manually.























ProcDump tool can be used for further investigation .

Thursday, April 24, 2014

Immediate alerts and email notification not getting send Moss 2007

Many time during the business hours we receive this type of issue. following steps may help to resolve this issue.

Scenario : Email accounts are setup , alerts was working earlier , suddenly users stop receiving alerts.


This could be caused by Timer service locked the content database and alerts are getting stuck in queue.

Use query to check by which server timer service is locked  (Off course if you have multiple server farm environment)

#1
use [Your Content database]
select * from timerlock (nolock)

You can also check what event cache table is holding currently

#2
SELECT * FROM eventcache WITH (nolock) WHERE EventData is not null

If you see large no of items in queue you may go ahead and restart the timer service on the server. (First query will give you server name)

Actual alerts sending can take 20 min of time and can be verified  running second query again . If everything goes well you should see no record pending in second query output.

Thursday, April 10, 2014

Add Views to survey list

SharePoint handles Survey list little differently than the custom list or document library. So the new views cannot be crated on survey as on Custom list.

To achieve this follow these steps:

1. Get the GUID Url of the list on which you have created view.
   Easiest way to do so is 
Go to Site Action -> Site Settings 
Under Site Administration tab , Select Site library and lists
Select Customize “Your List name”
Notice in address bar you will get URL something like
http://WebapplicationName/sites/SitecollectionName/_layouts/SurvEdit.aspx?List={825760CD-090B-411F-805A-0C4796B50081}

a.       Yellow Highlighted part show GUID of your list
b.      Green Highlighted part shows type of list
2. Update URL
c.       Update “SurvEdit.aspx” with “ViewType.aspx
d.      Remove  {} from GUID
e.      Url should look like

3. Past this new url in address bar , this will give view creation interface as we usually get for custom list or document library.


Wednesday, March 26, 2014

One of the properties of the Web Part has an incorrect format

We ran into this issue after cleaning disk space on C Drive . One of web front end server ran out of disk space and after performing disk clean up some users start reporting this issue .

Recycling IIS on same server fixed  this issue.

Monday, March 17, 2014

Elements of type 'Receivers' are not supported at the 'Site' scope. This feature could not be installed.


from my old documentation for Sharepoint 2007


While working on installing event receiver as feature receive error
 "Elements of type 'Receivers' are not supported at the 'Site' scope.  This feature could not be installed. "

This is because receivers scope limited to web site.

See here more details from Microsoft documentation 

Thursday, March 6, 2014

An error occurred during the processing of . The event handler 'onclick' is not allowed in this page.


Pulling from my old notes:

Came accross this issue while  trying to run custom page deployed to share point  2007 site

"An error occurred during the processing of . The event handler 'onclick' is not allowed in this page."

When I check web.config file I notice   <PageParserPaths>.. </PageParserPaths> block was empty

<SharePoint>
    <SafeMode MaxControls="200" CallStack="false" DirectFileDependencies="10" TotalFileDependencies="50" AllowPageLevelTrace="false">
      <PageParserPaths>
<PageParserPath VirtualPath="/*" CompilationMode="Always" AllowServerSideScript="true" IncludeSubFolders="true" />
      </PageParserPaths>

Addition of highlighted line resolved the issue.

Original post I refereed is HERE 

Thursday, February 27, 2014

Resume SharePoint Crawls with PowerShell

Recently I worked on PowerShell script which is used to resume paused crawls.

We notice newly implemented backup solution is pausing the SharePoint ongoing crawls and over completion of the backup crawls not getting resume as expected.

This caused issue of delayed crawls and need manual intervention to resume paused crawls. Solution was to file post script over completion of the backup.

SharePoint Environment 2007

Script input : Site url and Content sources


########################### Load SharePoint assembles ############################

[System.Reflection.Assembly]::LoadWithPartialName("Microsoft.Office.Server.Search")
[System.Reflection.Assembly]::LoadWithPartialName("Microsoft.Sharepoint")
[System.Reflection.Assembly]::LoadWithPartialName("Microsoft.Office.Server")

#####################################################################

$sspURL= "Put your site name here"
$ContentSources = @("content1","content2")
$site = new-object Microsoft.SharePoint.SPSite($sspURL)
$CrawlStatus =""

# get spsite from $Url
$searchContext = [Microsoft.Office.Server.Search.Administration.SearchContext]::GetContext($site)

#Dispose site object
$Site.Dispose()

# get searchContext from spsite
$content = new-object Microsoft.Office.Server.Search.Administration.Content($searchContext)
$ContentSourceCollection = $content.ContentSources
foreach($item in $ContentSources)
{
    $oContentSource = $ContentSourceCollection[$item]
    if($oContentSource )
    {
       if($oContentSource.CrawlStatus -eq  "Paused" )
       {
          $oContentSource.ResumeCrawl()
          $CrawlStatus= $CrawlStatus+ $oContentSource.Name +" was paused Now "+ $oContentSource.CrawlStatus+" | "
       }
   }
}
Write-Host  $CrawlStatus

Monday, February 3, 2014

Cannot start the service SPAdmin on computer

Life saver article here :

http://blogs.msdn.com/b/sambetts/archive/2012/10/03/psconfig-system-invalidoperationexception-cannot-start-the-service-spadmin-on-computer.aspx