Thursday, December 31, 2009

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/

Wednesday, December 30, 2009

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

Tuesday, December 22, 2009

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.

Tuesday, December 08, 2009

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

Wednesday, December 02, 2009

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

Sunday, November 29, 2009

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......

Friday, November 20, 2009

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.

Tuesday, November 17, 2009

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

Friday, September 25, 2009

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

SharePoint Pattern and Practices

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

Tuesday, September 22, 2009

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.


Cheers!!!

Tuesday, September 08, 2009

Get Client Machine Name ASP.NET

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

Wednesday, August 05, 2009

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)

Thursday, July 23, 2009

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!!!




Monday, July 13, 2009

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 :

Thursday, July 09, 2009

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

Friday, July 03, 2009

Microsoft New Search Engine

BING!!!!

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

Sunday, June 28, 2009

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 ".

Friday, June 26, 2009

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!!!!

Tuesday, June 23, 2009

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 ......


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!!!!!

Friday, June 05, 2009

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.

Wednesday, April 22, 2009

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

Wednesday, April 15, 2009

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.

Tuesday, April 14, 2009

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"

Monday, April 13, 2009

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

Friday, April 03, 2009

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!!

Thursday, March 26, 2009

"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)

Monday, March 09, 2009

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);
}
}

Thursday, March 05, 2009

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

Tuesday, February 10, 2009

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

Thursday, February 05, 2009

Configuring AJAX in ASP.NET

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

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

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

Friday, January 30, 2009

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"



Thursday, January 22, 2009

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