Approval Workflow goes to Infinite Loop while Editing

In SharePoint Out of the Box Approval workflow for content approval has issue while triggering workflow when the item is changed, the status will remain on “InProgress” or “Pending” even though the item is approved.

Microsoft has released the hotfix for this issue. It can be downloaded from here

Site Content Type in Use – Error while Deleting Content Type

If you get “Site Content Type in Use” error while deleting the content type.

Change the default content type for the list/library, which uses this content type.

Then try to delete the content type.

“The file has been modified by SHAREPOINT\system” Error while Updating InfoPath xml file in SharePoint Library

If you try to update the InfoPath xml file through object model in events/WebParts or through any medium.

While execting the Item.Update() will cause the below error. While updating the InfoPath xml file in ListItem
the file and ListItem object getting disconnected.

Item.File.Update() will solve your issue.

StackTrace of Error:

[COMException (0x81020037): The file SampleFile/SampleFile_2009-06-11T18_57_00.xml has been modified by SHAREPOINT\system on 13 Jun 2009 00:25:30 +0530.]

Microsoft.SharePoint.Library.SPRequestInternalClass.AddOrUpdateItem(String bstrUrl, String bstrListName, Boolean bAdd, Boolean bSystemUpdate, Boolean bPreserveItemVersion, Boolean bUpdateNoVersion, Int32& plID, String& pbstrGuid, Guid pbstrNewDocId, Boolean bHasNewDocId, String bstrVersion, Object& pvarAttachmentNames, Object& pvarAttachmentContents, Object& pvarProperties, Boolean bCheckOut, Boolean bCheckin, Boolean bMigration, Boolean bPublish) +0

Microsoft.SharePoint.Library.SPRequest.AddOrUpdateItem(String bstrUrl, String bstrListName, Boolean bAdd, Boolean bSystemUpdate, Boolean bPreserveItemVersion, Boolean bUpdateNoVersion, Int32& plID, String& pbstrGuid, Guid pbstrNewDocId, Boolean bHasNewDocId, String bstrVersion, Object& pvarAttachmentNames, Object& pvarAttachmentContents, Object& pvarProperties, Boolean bCheckOut, Boolean bCheckin, Boolean bMigration, Boolean bPublish) +203

[SPException: The file SampleFile/SampleFile_2009-06-11T18_57_00.xml has been modified by SHAREPOINT\system on 13 Jun 2009 00:25:30 +0530.]

Microsoft.SharePoint.Library.SPRequest.AddOrUpdateItem(String bstrUrl, String bstrListName, Boolean bAdd, Boolean bSystemUpdate, Boolean bPreserveItemVersion, Boolean bUpdateNoVersion, Int32& plID, String& pbstrGuid, Guid pbstrNewDocId, Boolean bHasNewDocId, String bstrVersion, Object& pvarAttachmentNames, Object& pvarAttachmentContents, Object& pvarProperties, Boolean bCheckOut, Boolean bCheckin, Boolean bMigration, Boolean bPublish) +251

Microsoft.SharePoint.SPListItem.AddOrUpdateItem(Boolean bAdd, Boolean bSystem, Boolean bPreserveItemVersion, Boolean bNoVersion, Boolean bMigration, Boolean bPublish, Boolean bCheckOut, Boolean bCheckin, Guid newGuidOnAdd, Int32& ulID, Object& objAttachmentNames, Object& objAttachmentContents, Boolean suppressAfterEvents) +1026

Microsoft.SharePoint.SPListItem.UpdateInternal(Boolean bSystem, Boolean bPreserveItemVersion, Guid newGuidOnAdd, Boolean bMigration, Boolean bPublish, Boolean bNoVersion, Boolean bCheckOut, Boolean bCheckin, Boolean suppressAfterEvents) +182

Microsoft.SharePoint.SPListItem.SystemUpdate() +97

Peoples.WebControls.<>c__DisplayClass1.<ExportData>b__0() +993

Microsoft.SharePoint.SPSecurity.CodeToRunElevatedWrapper(Object state) +70

Microsoft.SharePoint.<>c__DisplayClass4.<RunWithElevatedPrivileges>b__2() +392

Microsoft.SharePoint.Utilities.SecurityContext.RunAsProcess(CodeToRunElevated secureCode) +152

Microsoft.SharePoint.SPSecurity.RunWithElevatedPrivileges(WaitCallback secureCode, Object param) +345

Microsoft.SharePoint.SPSecurity.RunWithElevatedPrivileges(CodeToRunElevated secureCode) +86

Peoples.WebControls.CalendarExport.ExportData() +320

Peoples.WebControls.CalendarExport.ExportCalendar_Click(Object sender, EventArgs e) +40

System.Web.UI.WebControls.Button.OnClick(EventArgs e) +111

System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +110

System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10

System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13

System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36

System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1565

SQL Server 2008 Developer Training Kit Available


SQL Server 2008 offers an impressive array of capabilities for developers that build upon key innovations introduced in SQL Server 2005. The SQL Server 2008 Developer Training Kit will help you understand how to build web applications which deeply exploit the rich data types, programming models and new development paradigms in SQL Server 2008. The training kit is brought to you by Microsoft Developer and Platform Evangelism.


Overview and Benefits

The training kit offers the following benefits:

  • Learn how to build web applications that exploit the unique features and capabilities of SQL Server 2008.
  • Provides a comprehensive set of presentations, demos and hands-on labs
  • Designed for web developers who are already familiar with SQL Server application development.
  • Easy to download and install and works on free editions of SQL Server 2008 and Visual Studio 2008.
  • Produced by Southworks SRL, a well-known provider of evangelism content, using both existing and new content custom developed for this training kit.

Software Requirements

The following software is not included with the training kit and must be downloaded and installed separately.

  • SQL Server 2008 Express with Advanced Services (or higher-level SKU)
  • Microsoft Visual Web Developer 2008 Express (or higher-level SKU)
  • AdventureWorks 2008 Sample Databases

Intended Audience

The training kit is designed for the following technical roles:

  • Web developers who build applications for the Microsoft platform.
  • Microsoft technical specialists and consultants.

Contents

The training kit includes the following content:

  • Presentations (6)
    • Filestream
    • Spatial
    • T-SQL
    • Date and Time Types
    • SQLCLR
    • Reporting Services
  • Demos (13)
    • AdventureWorks Racing All-Up SQL Server 2008 Demo
    • SQL Server 2008 All-Up Spatial Demo
    • Spatial Types Demo
    • Intro to Filestream Demo
    • SQL CLR Nullable Types Demo
    • Programming with Filestream Demo
    • Reporting Services Web Application Integration Demo
    • Date and Time Support in SQL Server 2008 Demo
    • T-SQL Table-Valued Parameters Demo
    • T-SQL Row Constructors Demo
    • T-SQL Grouping Sets Demo
    • T-SQL Merge Demo
    • Trasact-SQL
  • Hands-on Labs (3)
    • Using Spatial Data in TSQL
    • Using Spatial Data in Managed Code
    • Using SQL CLR in SQL Server 2008


The training kit is available at the following URL: http://go.microsoft.com/?linkid=9665942

TechEd 2009 India – Actions in Twitter

For those attending and for those who couldn’t make it in person, the biggest
technology event is HERE! The excitement of TechEd India is in the air. To add
some heat, we are putting things live as it happens from TechEd India 2009. You
can watch all the action from the twitterverse. Here’s how:

Official
TechEd India 2009 Twitter:
http://twitter.com/techedindia
2009

The twitter chatter from
community:
http://twitter.com/#search?q=techedin
[Hint: If you want your tweet
featured, include the hastag #techedin inyour tweet]

Pictures from TechEd
India 2009:
http://www.flickr.com/photos/tags/techedin/

Join Steve Ballmer Live on
Stage:
http://virtualtechdays.com
/joinsession.aspx

Some community mashups
created by attendees:

MVP Blogs from TechEd India:
http://teched.indiamvp.net

TechEd MashUp:
http://baxiabhishek.info/teched/

And that’s not all – You can pose your
questions for Steve Ballmer over twitter as well by directing your questions to
@techedindia2009. We’ll try to get the boss to answer them for you (if the Live
audience let’s us ;))!

Exception occurred while activating publishing feature

Activate the publishing infrastructure in site collection through stsadm in command line.

stsadm -o activatefeature -name publishing -url http://uday -force

stsadm -o activatefeature -name publishingresources -url http://uday -force

stsadm -o activatefeature -name publishingsite -url http://uday -force

stsadm -o activatefeature –name publishingweb -url http://uday -force

stsadm -o activatefeature –name publsihinglayouts -url http://uday –force

Now verify the site collection feature’s status. You could see the publishing feature enabled. J

SharePoint Diagnostics (SPDiag) Tool for SharePoint Products and Technologies

The real power of Office SharePoint Server 2007 and Windows SharePoint Services 3.0 is that they can be endlessly customized to meet a wide variety of business needs. The Protean nature of SharePoint is at once its most powerful feature and its most formidable; the complexity of your SharePoint environment can increase by orders of magnitude when you begin to shape it to suit your needs. This complexity can make troubleshooting SharePoint issues a daunting task, as many different data points from different sources must be correlated and analyzed.

The SharePoint Diagnostics (SPDiag) tool greatly simplifies the process of gathering and analyzing troubleshooting data, and can significantly reduce the time needed to diagnose issues. SPDiag provides administrators with a unified interface for troubleshooting SharePoint performance issues, and saves collected data and reports to a SQL Server database.

With SPDiag, you can:

Collect IIS and ULS log files, performance counter data, event logs, and WMI instrumentation data from a SharePoint farm.

Filter data to show granular information related to specific servers, Web applications, HTTP requests, event IDs, URI queries, and almost any other data points captured through supported channels.

Create custom reports that can help reveal performance trends over time.

Create snapshots of your SharePoint farm that include detailed information about your farm’s hardware, installed software and logical topology.

Export collected data and reports that can be sent to Microsoft support personnel.

SPDiag is included in the Microsoft SharePoint Administration Toolkit v3.0, available for download at the following locations:

Microsoft SharePoint Administration Toolkit v3.0 x86: http://go.microsoft.com/fwlink/?LinkId=141504

Microsoft SharePoint Administration Toolkit v3.0 x64: http://go.microsoft.com/fwlink/?LinkId=142035

Documentation for SPDiag is available from those download pages as well.

Source : SharePoint IT Pro Documentation Team

How to Change Default Content Database

To Change Default Content in DB.

Open Central Administration.

Click Operations.

Under Data Configuration Click “Default database server” option

Provide the Database Server Name and credentials to access.

The new database server is configured to host content db.

SPDisposeCheck Released!

SPDisposeCheck v1.3.1 has been released on MSDN Code Gallery, http://code.msdn.microsoft.com/SPDisposeCheck. This tool will help improve the quality of your SharePoint assemblies. It will inspect your SharePoint assemblies and check that you are correctly disposing of certain SharePoint objects (IDisposable objects which includes SPSite and SPWeb). The tool is based upon the guidance published in this MSDN article, Best Practices: Using Disposable Windows SharePoint Services Objects

SharePoint Conferences

Upcoming SharePoint Conferences

SharePoint Technology Conference
January 27–29, 2009: Burlingame, CA
For three exciting days in January, you’ll be eating, drinking, sleeping, talking and living Microsoft Office SharePoint Server and Windows SharePoint Services. The first day at SPTechCon is filled with intense full and half-day workshops, half in the morning, half in the afternoon. The next two days are filled with more than 50 break-out classes to choose from. Build your own custom program! This conference is hosted by BZ Media LLC.

SharePoint Best Practices Conference
February 2–4, 2009: San Diego, CA
The SharePoint Best Practices Conference eliminates design, deploy, organization and administration confusion, replacing disorder with Clarity, Direction and Confidence. This conference is hosted by Mindsharp.

Microsoft FASTforward ’09
February 9–11, 2009: Las Vegas, NV
3 days of compelling discussion on the evolving business environment and how search is enabling companies to succeed. This conference is hosted by Microsoft.

Microsoft MIX09
March 18-20, 2009: Las Vegas, NV
Now in its fourth year, MIX is a unique technology conference that connects web professionals with industry thought leaders to explore the future of the Web together. This conference is hosted by Microsoft.

Microsoft Tech Ed North America 2009
May 11-15, 2009: Los Angeles, CA
This will be the 17th year for Microsoft’s premier technical education and networking conference. Sessions and events are presented by Microsoft product team members and industry experts. This conference is hosted by Microsoft.