Another user has changed the structure of this list .

ERROR :
Another user has changed the structure of this list . All your pending changes to this list will be discarded . To retrieve the latest copy of the list , click refresh

Suggested Resolution : Removing comma in hyperlinks
Reference URL : http://bmerri19.wordpress.com/

Implementing ASP.NET Impersonation

Impersonation can be implemented using one of four methods:

• Impersonate the IIS authenticated account or user
• Impersonate a specific user for all the requests of an ASP.NET application
• Impersonate the authenticating user in code
• Impersonate a specific user in code

More details give in following article :

http://support.microsoft.com/kb/306158#4

Feature '7a8b11f4-38b2-402b-ad94-1213e25150ca' for list template '1102' is not installed in this farm. The operation could not be completed.

I got this error while performing export of SharePoint site with stsadm and sharepoint designer.
It was happening because ShaerPoint Site was searching for the following feature "PWAProposals" which was present in my dev machine and not in my production . I was able to move it successsfully before as i used stsadm-backup but it started failing with stsadm -export.

Resolution :
Just copy the feature from your source server ---> destination server and install the feature. This will resolve the issue . Well this is not ideal solution . I am still in process of figuring out the reference to the feature in order to remove it from list template.

Sharepoint Config DB Size Grown too large

In my case the SharePoint Config DB log size became 35 GB which ate up all the disk space nearly crashing the system . This is a development machine so disk space was limited to 50 GB .

Did some search and the below steps solved the issue. The steps given below is not recommended to be implemeted in production , only in development / QA machine in order to save some resource .

1) Right click on you DB -> Properties
2)Select Options
3) Change the Recovery Model to SIMPLE and Click Ok

Once that is done ,
-Right click on DB -> Tasks - > Shrink -> Files
- In File type select log and click OK

My Config DB Log files were reduced from 35 GB - > 504 KB

Note : Simple recovery model is not suggested for Production Systems

Allow Access Request SharePoint 2007

In order to set individual email ID to receve email when the Access is requested for a SharePoint Site , follow these steps :
1) Go To Site Settings ->Modify All Site Settings
2) Click on Advanced Permissions under User and Permission
3)List Settings -> Access Requests
4) Set the email ID and activate the Allow Request for access

SharePoint 2010 Beta Product Key

Well i did my installation of SharePoint 2010 Beta and found the product key here :

SharePoint Server 2010 Beta (Enterprise CAL features): PKXTJ-DCM9D-6MM3V-G86P8-MJ8CY
SharePoint Server 2010 for Internet Sites Beta, Enterprise: BV7VC-RMR6B-26P6Y-BTQDG-DX2KQ

http://technet.microsoft.com/en-us/evalcenter/ee391660.aspx

SharePoint 2010 New Features

here is one of interesting article on SharePoint 2010

http://blogs.msdn.com/sharepoint/archive/2009/10/19/sharepoint-2010.aspx

Feature 1 SharePoint 2010 : Sandbox Solutions

This feature i am sure is one of the big enhancement in SharePoint 2010 . For all those developers out there who gave day and night to convince server admins that the developed code is safe and won't break the farm this is sign of relief.

Now the developers / Site administrator can get their custom code(restricted features) to the SharePoint site without concern .So in case there is bug in code then the only thing which will bomb is site owned by the team .

Farm administrator has total control over the deployed solution and can even define resource limit for the solution . It's win - win for the server admins as well as the site owners.

Less politics in organization now ;-) .

More details here

Atlast SharePoint 2010 Beta Installation complete

Today i completed my first SharePoint 2010 beta installation in my machine . AHHH what a relief, i have been planning to do this from past 2 weeks.

Well lets see how the new features turns up . I hope i can get some momentum now......

Free Tools from Metalogix

http://www.metalogix.net/Free-Tools/

Just tried SWAT tool till now, pretty impressive.

Exception from HRESULT: 0x80040E14 STSADM ERROR

In my case this error was purely due to lack of disk space in DB server.

ERROR:
Exception from HRESULT: 0x80040E14

Clearing hard disk space in DB server resolved the issue.

Unable to Delete SSP (unprovisioning)

If you are stuck with SSP and have no clue how to get rid of it then you are at right place.

Use the SharePoint Master Tool (STSADM), nobody says "no" to Master ;-)

stsadm -o deletessp -title [-deletedatabases] -[force]
http://technet.microsoft.com/en-us/library/cc263248.aspx

Caching in MOSS 2007

http://msdn.microsoft.com/en-us/library/aa661294.aspx

Cannot connect to the configuration database.

This might happen due to various reasons . Below are the most common reasons :
1) Check SQL DB exist and enabled
2) Application pool Identity has been added to SQL DB

SharePoint 2007 Best Practices

• Best Practices: Using Disposable Windows SharePoint Services Objects http://msdn.microsoft.com/en-us/library/aa973248.aspx
  
• Best Practices: Common Coding Issues When Using the SharePoint Object Model http://msdn.microsoft.com/en-us/library/bb687949.aspx
  
• Dispose Checker Tool http://code.msdn.microsoft.com/SPDisposeCheck
  
• Working with Large Lists in SharePoint Server 2007 http://technet.microsoft.com/en-us/library/cc262813.aspx
  
• SharePoint Products and Technologies Customization Best Practices http://msdn.microsoft.com/en-us/library/bb861954.aspx
  
• Developing Workflow Solutions with SharePoint Server 2007 and Windows Workflow Foundation http://msdn.microsoft.com/en-us/library/cc514224.aspx
  
• Developing SharePoint Applications:Patterns and Practices http://msdn.microsoft.com/en-us/library/dd203468.aspx
  
• Managed Path http://msdn.microsoft.com/en-us/library/bb802766.aspx
  
• Web Services Access http://msdn.microsoft.com/en-us/library/bb862916.aspx

SharePoint Pattern and Practices

http://msdn.microsoft.com/en-us/library/dd203468.aspx

Save as Site Template Missing

Are you trying to save a publishing site as site template and are still wondering where the "Save as Site Template " is?

Well It's hidden . Here is a nice article for you.

http://www.kwizcom.com/ContentPage.asp?PageId=1165

Cheers!!!

Improve SharePoint 2007 Website Performance

http://blogs.msdn.com/ecm/archive/2006/11/08/how-to-make-your-moss-2007-web-site-faster-with-caching.aspx

Get Client Machine Name ASP.NET

System.Net.Dns.GetHostByAddress(Request.UserHostAddress).HostName

Preliminary System Requirement SharePoint 2010

http://blogs.msdn.com/sharepoint/archive/2009/05/07/announcing-sharepoint-server-2010-preliminary-system-requirements.aspx

ASP.NET Progress control for FREE!!!

I tried this control and i must say it's too good to be free.
http://www.essentialobjects.com/Products/EOWeb/ProgressBar.aspx

Upgrade Checker in SP2 for SharePoint 2010

AJAX ERROR : Sys.WebForms.PageRequestManagerTimeoutException - The server request timed out

Well if you have this error then its due to long running process as the default time out set is 90 seconds.
If you want to increase the time out value , then make change to the Script Manager attribute .
For e.g to increase it to 5 min :




(Click on image to enlarge it)

SharePoint 2007 Scalability and Performance White Paper

http://blogs.technet.com/gurmeets/archive/2008/06/18/sharepoint-server-2007-scalability-and-performance-whitepaper-now-available.aspx

Enterprise Search Training Videos

http://blogs.technet.com/gurmeets/archive/2008/04/24/18-hours-of-free-enterprise-search-training.aspx

GetListItems SharePoint WebService

http://www.sharepoint-tips.com/2007/02/how-to-use-getlistitems-web-service.html

Unknown server tag 'asp:ScriptManager' PKS

I had configured PKS (Podcasting Kit for SharePoint ) June 2009 release. Everything went smooth and even the application was working well except the encoding which i haven't yet tested .

Anyways after couple of days when i tried accessing the site the main page went KAPUT , i started getting this error "Unknown server tag 'asp"ScriptManager" .Now the question was "What might have gone wrong?" . I didn't even touched the site for 2 days and everything was working fine before (Typical sentence used by most developers -;)) .

After some search i found one article which asked to check the web.config file for some entries and it's weird those entries were gone from my web.config file. (Murphy's law in total effect ) .

Anyways as suggested i made the following entries ,In case image is not clear click on it to get better view.

I am glad website is back . Up and running .

Here is the link where i got the web.config entries .

ENJOY!!!

The template you have chosen is invalid or cannot be found. SharePoint Template Error

It's pretty hard to find the actual reason of these kind of error . But one thing is sure that template is causing issue.
The most common reason for this error is missing of dependency . for e.g. missing feature.
Best solution is to run the STPInspector tool . It will help to diagnose whether all the dependency are present in server or missing something .
You can get tool from STPINSPECTOR

ENJOY!!!

Essential SharePoint Governance Tool

Tool which you should have to administer/Develop SharePoint 2007 :

• SP Forms Designer with content types(http://sptoolbasket.codeplex.com/Wiki/View.aspx?title=SharePoint%20-%20SPForms%20Designer)

• SPFeature Explorer(http://sptoolbasket.codeplex.com/Wiki/View.aspx?title=SharePoint%20-%20SPFeature%20Explorer)

• SharePoint - List Columns Manager(http://sptoolbasket.codeplex.com/Wiki/View.aspx?title=SharePoint%20-%20List%20Columns%20Manager)

• Security Management Tool m(http://www.codeplex.com/sushi)

• STP Inspector ( http://stpinspector.codeplex.com/)

Aspnet_merge.exe Exited with Code 1

I got this error while building the Web deployment project . After some search it came to my notice that class names in my webcontrols were same ,due to which build started bombing while merging the assembly .

I changed the class names and Voila ! it started working.

Creating single DLL for Web User Controls in ASP.NET website project

Are you trying to create single DLL for a web user control and end up getting multiple DLL's for each user control ?

Well you are in right place . The best option is to use web deployment project which is an Add in to Visual Studio .

Install the project template from here

http://msdn.microsoft.com/en-us/asp.net/aa336619.aspx

Once installed follow this article for creating a single DLL for your web project :

http://msdn.microsoft.com/en-us/library/aa479568.aspx

Microsoft New Search Engine

BING!!!!

I am impressed with the new search engine from Microsoft and i am glad it's fast.

http://www.bing.com/

Best Practices Webpart

It's a old story now, sharepoint has been around now for more than 6 years and numerous solution has been created using SharePoint Technology. But the basic remains and shoud be always kept in mind to have succesful implementation . I know many of developers might be aware of the best practices for developing the webparts but question is do we really follow them ?
Generally people go back to basics when something bombs , till then best practices are kept only in books. Anyways i have been thinking of writing about it from long time and here it goes today . just follow some of best practices and webparts maintenace becomes much easier and no more "Webpart maintenance page ".

• Error Handling : This is the most important part of webpart development . Always defined a try , catch , finally block in your webpart .E.g http://www.codeproject.com/KB/sharepoint/Errorhandling_in_Webparts.aspx
• Validate all user inputs
• Register the Client Side script to improve performance
• Always dispose the sharepoint Objects e.g. SPSite, SPWeb e.g. http://www.sharepoint-tips.com/2006/06/best-practices-writing-webparts-for.html
• Refrain using loops with list objects . use CAML query as much as possible to retrieve desired data

FIELD CONTROLS VS WEB PARTS

Lot of people had question surrounding this including me .Thanks toAndrew Connell for sharing the fundamental aspect of the differences put forward in the simplest way :

Article by Andrew Connell

Enjoy!!!!

SPUpdatedConcurrencyException: An update conflict has occurred, and you must re-try this action

I was moving site from One server farm to another , completed backup of source site successfully,everything was working fine till the Murhy's extended Law got into effect ......

"If there is a possibility of several things going wrong, the one that will cause the most damage will be the one to go wrong"

Anyways , i started restoring the site and bumped into this error. I had no clue why even this popped up . Tried multiple time but same result .Started search for error resolution and it was good to see that there are more victim of this issue.

So i tried one of the suggested approach and it worked ......

http://support.microsoft.com/kb/939308

Well i just completed the site restoration and hope i dont fall victim to another law which i read somewhere and i felt it's kind of funny :

"No matter how perfect things are made to appear, Murphy's law will take effect and screw it up"

ENJOY!!!!!

"HTTP Error 401.1 - Unauthorized: Access is denied

We had this error in our IIS and this solved the puzzle...

http://support.microsoft.com/kb/871179

Create new Content DB

Well it's a generic case where in we end up creating large number of site collections and then realize that DB size is too big to manage.

Well to take care of such situation, it's a good practice to create new content DB and move existing site collection new DB.

How to do it ?Here you go.

http://technet.microsoft.com/en-us/library/cc825327.aspx

MOSS SP2 is out

MOSS 2007 is out in April :

http://www.microsoft.com/downloads/details.aspx?FamilyId=B7816D90-5FC6-4347-89B0-A80DEB27A082&displaylang=en

Performance testing and Performance counters for Sharepoint 2007

Useful performance counters which cas be used while peformance testing of SharePoint 2007 Environment
http://blogs.msdn.com/ketaanhs/archive/2008/08/12/performance-testing-and-performance-counters-for-sharepoint-2007-moss.aspx

Business Intelligence Fundamentals Web Seminar Series

This link contains collection of web seminars on BI ..

http://www.msdev.com/Directory/SeriesDescription.aspx?CourseId=61

stsadm import failed with AllowAutomaticASPXPageIndexing error

Well i got stuck with this issue and the following hotfix helped to come over it :

http://support.microsoft.com/default.aspx?scid=kb;EN-US;957691

Server SQL Server evaluation period has expired.

In case you are trying to upgrade the Expired SQL server with retail SQL server follow these steps :

• Take Back up of the DB files (MDF and LDF)
• Unistall the expired SQL Server
• Install retail SQL Server
• Re-Attach old DB's

http://support.microsoft.com/kb/914158

SharePoint Designer for FREEE!!!!

Here it goes....


http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=baa3ad86-bfc1-4bd4-9812-d9e710d44f42

Calculated Column in SharePoint List

Am sure lot of you are searching for formulae which can we used in the Calculated column in SharePoint list. If yes, you are in right place .

Here are some useful links :
http://office.microsoft.com/en-us/sharepointtechnology/CH100650061033.aspx
http://office.microsoft.com/en-us/sharepointtechnology/CH101032701033.aspx
http://office.microsoft.com/en-us/sharepointtechnology/HA101054791033.aspx?pid=CH100650061033#4

STSADM: The farm is unavailable

This error pops up when the user running the command doesn't have access to SQl Server , make sure you are using admin account(preferable) in order to run stsadm tool.

Alert Not Working

Try this :

• stsadm.exe -o setproperty -propertyname job-immediate-alerts -propertyvalue "every 1 minutes between 0 and 59" -url "http://SiteName"
• stsadm.exe -o setproperty -propertyname alerts-enabled -propertyvalue "true" -url "http://SiteName"

CAML Query Builder

Life gets's so much easier when intellect people think of tool which developer community actually needs , here is the one tool which actually has the potential to give you that extra time which you spend writing long CAML query :-):

http://www.u2u.be/res/Tools/CamlQueryBuilder.aspx

Unable to add selected web part(s).

ERROR :

<WebpartName>: The file is not checked out. You must first check out this document before making changes.

Scenario with Solution

While trying to add webpart to the page , i received the above error. After some minutes i got the culprit .

1) Even on clicking "Edit Page" my file was not checking out , so i had to check out my webform using sharePoint designer. This solved my intial issue of adding web part .

2) Now question was , Why the "Edit Page" is not chekcing out my page , well it was no brainer . Publishing feature in my Site Feature was not active.

ENJOY!!

"Access Denied" MOSS 2007

I got this error while playing with the multiple authentication ie. authenticating sharepoint application with third party LDAP and Active Directory.
I was able to log in to home page but any system page e.g. _layouts/settings.aspx threw the "Access Denied " error.

This is how i got it working :

1) Go to "Application Management" tab in Central Administration
2) Click on the "Policy of Web application " link under "Application Security" section
3) Add the following users :

• - NT AUTHORITY\local service (Full Control)
• - "Site Collection Administrator" (Full Control)

Get all Custom Site Templates from Site collection

using (SPSite newSite = new SPSite(SiteURL))
{
using (SPWeb newWeb = newSite.OpenWeb())
{
SPWebTemplateCollection customTempCollection = newSite.GetCustomWebTemplates((uint)newWeb.Locale.LCID);
}
}

Unable to add selected web part(s).

ERROR:
Assemblies that implement ASP.NET Web Parts and are installed into a partially trusted location, such as the bin directory, must be compiled with the AllowPartiallyTrustedCallersAttribute set for import to succeed.

SOLUTION:
Add [assembly:AllowPartiallyTrustedCallers] to AssemblyInfo.cs

REFER :
http://msdn.microsoft.com/en-us/library/system.security.allowpartiallytrustedcallersattribute(VS.71).aspx

Hiding Menu Items on SharePoint 2007 List

If your requirement is to hide any menu item in SharePoint list for e.g. "Connect to Outlook" or "Open with Access" etc. then "ToolBar Manager " feature in codeplex is of great help .
http://www.codeplex.com/features

There are additional features which are useful too. You can download the same from :
http://www.codeplex.com/features/Release/ProjectReleases.aspx?ReleaseId=2502#ReleaseFiles

Configuring AJAX in ASP.NET

Here is the list of web.config entries requires for AJAX to work in ASP.NET App.

http://www.asp.net/AJAX/documentation/live/ConfiguringASPNETAJAX.aspx

Delete all Items in SharePoint List

You might end up with this requirement quite often and and try top down approach for delete :
for (int count=0;count < itemCount ; count++)
{ itemcoll[count].Delete(); }

and bump into exceptions , well the other way to do it is bottom up delete

for (int count =itemCount-1 ; count>0 ; count--)
{ itemcoll[count].Delete(); }

SharePoint Utility Pack

If you are looking for a tool for Site Mangement with following features :

• Recursively deleting sites
  
• Create a list in multiple sites at once
  
• Modifying field settings - some internal settings that you cannot modify in the regular interface, and the option to modify lists with the same name in multiple sites at once
  
• Push a web part to multiple sites (a specific page in each site) at once
  
• Manage list event hanlders (register and remove event handlers from lists)
  

Then you need to have this tool by Ishai Sagi

http://www.codeplex.com/spstipsUtilityPack

The event handler functionality has proven to be of great help to me.

Cannot use 'partitionResolver' unless the mode is 'StateServer' or 'SQLServer'

Have you ever got this error while trying to run an ASP.NET 2.0  web application in same port containing SharePoint 2007 Portal?

If yes here is the fix :

Add partitionResolverType="" in your ASP.NET web.config file

e.g.

sessionState mode="InProc" stateConnectionString="tcpip=127.0.0.1:42424" partitionResolverType="" sqlConnectionString="data 

source=127.0.0.1;Trusted_Connection=yes" cookieless="false" timeout="20"

SharePoint List Rating Engine

In my previous post of rating i had mentioned the lack of rating in discussion board .
http://metahat.blogspot.com/2008/12/sharepoint-listcontent-rating-system.html

Thanks to http://www.codeplex.com/site/users/view/StephaneEyskens for updating the rating engine and incorporating it in the discussion forum control too.

You can get the same from http://www.codeplex.com/sptoolbasket

Microsoft and SAP Business Process Integration Tool

http://www.duet.com/index.aspx