kwizcom banner advertisement

HTTP 400 Bad Request (Request Header Too Long) - Error in SharePoint

1:23 PM    , ,
One of the End-User started seeing this error in SharePoint 2007 - InfoPath form submission. Bad Request (Request Header Too Long) Resolution: 1. Try deleting the browser cookies at the Client browser first. See whether it helps. 2. If not, implement the fix as per KB: http://support.microsoft.com/kb/920862/en-us Save the below registry entries to .Reg file and merge it simply! Windows Registry Editor Version 5.00 [HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\HTTP\Parameters] "MaxRequestBytes"=dword:00500000 "MaxFieldLength"=dword:00065534 Restart the server for the changes to take effect, and as always take backup before making any registry change.
HTTP 400 Bad Request (Request Header Too Long) - Error in SharePoint HTTP 400 Bad Request (Request Header Too Long) - Error in SharePoint Reviewed by Salaudeen Rajack on 1:23 PM Rating: 5

SharePoint Site Users & Hits Count Report for the past 30 days

10:12 PM    , , ,
Another SharePoint Report Requirement: Need count of users & hits on each site (not for site collection - site collection has OOTB report! but at site level) for a particular web application for past 30 days! No worries! My code goes here: Find Hits Count for the Past 30 Days: using System; using System.Collections.Generic; using System.Linq; using System.Text; using Microsoft.SharePoint; using Microsoft.SharePoint.Administration; using System.Data; using System.IO; namespace AdminReports { class GetSiteUsageReport { //Method to Get Usage Data public static int GetUserCount(SPWeb oSPWeb) { try { //Get the Usage Details object userCount = null; //DataTable for users set - Because GetUsageData returns DataTable! DataTable dtUsers = new DataTable(); dtUsers = oSPWeb.GetUsageData(SPUsageReportType.user, SPUsagePeriodType.lastMonth);
SharePoint Site Users & Hits Count Report for the past 30 days SharePoint Site Users & Hits Count Report for the past 30 days Reviewed by Salaudeen Rajack on 10:12 PM Rating: 5

Remove Faulty Webpart with Web Part Page Maintenance Mode

5:35 PM    , , , ,
There was a custom web part deployed in our environment. For some reasons, web part encountered some issue and made the pages crashed!. Ideally, The developer should have handled the error in web part to avoid page crash! but it didn't happen! how to remove faulty web part in SharePoint 2007 or in SharePoint 2010? Alright, to fix the issue, I get into Maintenance mode (by just appending " ?contents=1 " to the end of URL)  E.g. http://sharepoint.company.com/sites/sales/reports.aspx ?contents=1 Deleted the particular faulty web part, and we are back to business! In a another case, When we migrated from MOSS 2007 to SharePoint 2010 with 1000+ sites. After the upgrade for some reasons, we wanted to delete a particular web part (Tip of the day web part) from the home page of All migrated sites' default.aspx page of the many sites. So I wrote the PowerShell code to delete error Web parts programmatically .
Remove Faulty Webpart with Web Part Page Maintenance Mode Remove Faulty Webpart with Web Part Page Maintenance Mode Reviewed by Salaudeen Rajack on 5:35 PM Rating: 5

Find Large SharePoint Lists & Generate Report with PowerShell

1:38 AM    , , , , , , ,
Requirement: Find large lists in SharePoint using PowerShell! Large lists are potential threats to SharePoint performance. So, wanted to audit SharePoint environment to find all large lists which are having items more than 2000 and generate a report. PowerShell to Find Large Lists and Generate Report in SharePoint: Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue #For Output file generation $OutputFN = "LargeListsData.csv" #delete the file, If already exist! if (Test-Path $OutputFN) { Remove-Item $OutputFN } #Write the CSV Headers Add-Content $OutputFN "List Name , site Collection , Site URL , Item count" #Get the Web Application URL $WebAppURL = Read-Host "Enter the Web Application URL:" $SPwebApp = Get-SPWebApplication $WebAppURL #Loop through All Site collections, Sites, Lists foreach($SPsite in $SPwebApp.Sites) { foreach($SPweb in $SPSite.AllWebs) { foreach($SPlist in $S
Find Large SharePoint Lists & Generate Report with PowerShell Find Large SharePoint Lists & Generate Report with PowerShell Reviewed by Salaudeen Rajack on 1:38 AM Rating: 5

How to Disable Default Out of the Box Workflows in SharePoint?

9:29 PM    , , ,
For some weird reasons, site owner wanted to disable out of the box workflow: Collect Signature from a particular site collection. In SharePoint 2010, These workflows can be simple activated/deactivated from Site collection features. Refer my post Unable to find OOTB Workflows - Approval, Collect Signatures, Feedback for more info. But in MOSS, Its little tricky. This workflows(Almost all others too) are deployed as a Feature and lives in 12 Hive. So we can manually deactivate these features to remove default workflows in SharePoint . Here is how: stsadm -o deactivatefeature -filename SignaturesWorkflow\Feature.xml -url http://Site-collection-URL And if you want to enable it back: stsadm -o activatefeature -filename SignaturesWorkflow\Feature.xml -url http://Site-collection-URL Here is the screen once deactivated:
How to Disable Default Out of the Box Workflows in SharePoint? How to Disable Default Out of the Box Workflows in SharePoint? Reviewed by Salaudeen Rajack on 9:29 PM Rating: 5

Solution Successfully Deployed but deployment status shows: Not deployed!

4:51 PM    , ,
Recently, while deploying a Solution, It happened to me! Solution was successfully deployed with out any issues. But couldn't see the features in Site!! See the workarounds here: http://blogs.technet.com/b/manjesh/archive/2009/10/13/solution-package-gets-deployed-successfully-but-status-shows-not-deployed.aspx
Solution Successfully Deployed but deployment status shows: Not deployed! Solution Successfully Deployed but deployment status shows: Not deployed! Reviewed by Salaudeen Rajack on 4:51 PM Rating: 5

Site Collection Locks in SharePoint 2010

9:16 PM    , , ,
Some time back, I ran into a issue where a particular site collection was in read-only mode to every one including site collection admin, certain options such as site action menus were in disabled state!. Then I realized site collection backup process was interrupted due to disk-space issue and it left the site collection in "Read-only" mode! which was documented in my post SharePoint site is read-only to everyone Screenshot from Read-only locked Site collection: Note that ribbon items are disabled! Screenshot from Unlocked site: SharePoint 2010 Locks can be Set/Reset in 4 ways: Using Web User Interface - Through Central Administration Using STSADM  Using PowerShell Using Object Model By .Net code By PowerShell Lets Look at the examples: Using Web User Interface: Where to Look? Go to Central Administration > Application Management > Configure Quotas and Locks  Under Site Collection Quotas and locks, set the site collection to "Not lock
Site Collection Locks in SharePoint 2010 Site Collection Locks in SharePoint 2010 Reviewed by Salaudeen Rajack on 9:16 PM Rating: 5

Error When trying to access listdata.svc: Could not load type 'System.Data.Services.Providers.IDataServiceUpdateProvider' from assembly 'System.Data.Services, Version=3.5.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.

3:35 PM    , ,
When trying to access: http://sharepoint.com/_vti_bin/listdata.svc , Received this Error message: Error:  Could not load type 'System.Data.Services.Providers.IDataServiceUpdateProvider' from assembly 'System.Data.Services, Version=3.5.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'. Fix: Install the ADO.NET Data Services Update for .NET Framework 3.5 SP1 - KB976127 http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=2343
Error When trying to access listdata.svc: Could not load type 'System.Data.Services.Providers.IDataServiceUpdateProvider' from assembly 'System.Data.Services, Version=3.5.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'. Error When trying to access listdata.svc: Could not load type 'System.Data.Services.Providers.IDataServiceUpdateProvider' from assembly 'System.Data.Services, Version=3.5.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'. Reviewed by Salaudeen Rajack on 3:35 PM Rating: 5

Fix SharePoint 2010 Datasheet View is Disabled Issue

2:31 PM    ,
Problem: SharePoint datasheet view is a quick nifty way to update metadata on multiple items at once. Unfortunately, some of the list and libraries such as picture libraries in SharePoint 2010 doesn't provide datasheet view! Solution: So, How to get datasheet view on SharePoint picture libraries? Well, here in the work around! How to Get Datasheet view for any List view in SharePoint: To get datasheet on any list view, Just append "&ShowInGrid=True" parameter to the URL. E.g. http://sharepoint.crescent.com/credit/Lists/pipeline/RptAll.aspx?View={74EA6C44-C956-4B7F-8EB5-48C92EB6D7AB} &ShowInGrid=True This activates datasheet view for any list in SharePoint 2010!
Fix SharePoint 2010 Datasheet View is Disabled Issue Fix SharePoint 2010 Datasheet View is Disabled Issue Reviewed by Salaudeen Rajack on 2:31 PM Rating: 5

How to Create a Feature in SharePoint 2010 - Step by Step

5:54 PM    , , , , ,
In this article, I'm demonstrating how to create a feature in SharePoint 2010 using Visual Studio 2010 in 10 easy steps: Step 1: Create a new project in Visual Studio 2010, Choose SharePoint 2010 - Empty SharePoint Project Template , Name the project. Here I've named it as: Crescent.TitleChanger.Feature  Step 2: Enter the existing SharePoint 2010 site's URL for debugging, Choose the solution type as "Deploy as a farm solution" On clicking Finish button, Visual Studio will create a project structure as below.  Step 3: Right click the Features node, Choose "Add Feature" Step 4: This will add a feature with name "Feature1" to the project. Rename "Feature1", it give it some meaning . I've named it as "Crescent.TitleChanger"  Step 5: Change the Title, Descriptions of the feature accordingly. Set the Scope of the project to "Web" Step 6: Add a Event Receiver to the project by right clicking &
How to Create a Feature in SharePoint 2010 - Step by Step How to Create a Feature in SharePoint 2010 - Step by Step Reviewed by Salaudeen Rajack on 5:54 PM Rating: 5

Synchronize Between SharePoint Lists and Microsoft Excel

6:36 PM    , , ,
Requirement: End-User has a Excel file, wants to Create a SharePoint list with data from Excel file and Synchronize between SharePoint Lists and Microsoft Excel. Fairly Simple,The very first option comes to our mind is: Import Spreadsheet,  isn't it? nope, That can be used to Create List and import data but not when it comes to sync. Here the requirement is to synchronize SharePoint list excel 2007. Solution: Use the "Excel 2007 Add-in: Synchronizing Tables with SharePoint Lists " to synchronize SharePoint list with excel. 1. Download and install the Add-on from http://www.microsoft.com/en-us/download/details.aspx?id=9345 . This will create SynchronizeWSSandExcel.xlam under: C:\2007 Office System Developer Resources\Code Samples\XL2007SynchronizeWSSandExcel 2. Open Excel, Go to File >> Options >> Add-Ins and click on Go button next to "Manage: Excel Add-ins Drop down. 3. Click on Browse Button and locate the SynchronizeWSSandExcel.xlam
Synchronize Between SharePoint Lists and Microsoft Excel Synchronize Between SharePoint Lists and Microsoft Excel Reviewed by Salaudeen Rajack on 6:36 PM Rating: 5

Creating Custom Timer Job for Automations in SharePoint 2010

2:52 PM    , , , , , , ,
Business Scenario: We have a Project collaboration environment with 5000+ site collections. This environment has been primarily used for managing project artifacts by various teams. Every day, We - Admin Team, get lot of requests to create site collections, Change Owners of the site collections, Increase the Site quota for the existing site collection and requests for deleting site collections once the project is closed. Earlier, as part of process automation, what I've done is: Created a dedicated site collection (Named it as "Self Service site") where users will come and fill the above requests in separate lists. Then I wrote  .Net console applications, placed them under task scheduler. The task scheduler will run these executable once a day. Refer my old posts for the process flow and complete code. Site Owner Change Automation Site Delete Process Automation When the End-user fills the request forms (Say, Request for creating a new site collection)
Creating Custom Timer Job for Automations in SharePoint 2010 Creating Custom Timer Job for Automations in SharePoint 2010 Reviewed by Salaudeen Rajack on 2:52 PM Rating: 5
Powered by Blogger.