Chris’s SharePoint Reflections

Just another weblog

  • Chris Zhong

    IT consultant Australia

  • Advertisements

Archive for the ‘General’ Category

Error: “The sandboxed code execution request was refused because the Sandboxed Code Host Service was too busy to handle the request”

Posted by chrissyz on March 25, 2012

Have you experienced “Error: “The sandboxed code execution request was refused because the Sandboxed Code Host Service was too busy to handle the request”  when you try to activate your sandbox solution and  Microsoft SharePoint Foundation Sandboxed Code Service is running OK on your server? Well.. this is what happened to me today. Check below post  This is actually caused by incorrect registry key and  below is the workaround that works for me:

1.    On the server, click Start | Administrative Tools | Services.

2.    On the Services dialog, scroll to SharePoint 2010 User Code Host.

3.    Note the full user name in the Log On As column. You will need this information later.

4.  Open SharePoint Management Shell.

5.  Enter the following at the command prompt, including all punctuation.

(Get-SPManagedAccount –Identity “username”).Sid.Value

Replace username with the name you obtained in step 3. E.g., CorpDomain\FarmAdmin

This will return the user’s SID (Security ID), which you will use in a later step.

6.    Open the registry editor and navigate to:

HKEY_USERS\SID you obtained earlier\SOFTWARE\Microsoft\Windows\CurrentVersion\WinTrust\Trust Providers\SoftwarePublishing

7.     Be sure the State key value is set to 0x00023e00.

8.    Restart the sandboxed host service on all servers on which it is to run. It cannot hurt to do an iisreset as well.


Posted in General, Trouble Shooting | Tagged: | Leave a Comment »

SharePoint 2010 Document Management features

Posted by chrissyz on February 17, 2011

Today I would like to talk about a couple of lovely new features in SharePoint 2010 Document Management. Before my ranting starts, I think probably clarify some terminologies first as they can be confusing sometimes (but necessarily have to :)). SharePoint Document management is a subsite Enterprise content management (ECM) workload (remember the classic six wheel?) ECM refers to technologies, methods and tools used to capture, manage, store, preserve and deliver content and documents related to an organization and its processes.

A similar but often confused term is web content management. This technology addresses the content creation, review, approval and publishing processes of web-based content. Key features include creation and authoring of tools or integrations, input and presentation template design and a subset of ECM.

And what about document management?  DM helps organization better manage the creation, revision, approval and consumption of electronic documents. It provides key features such sass document profiling, checking/check out, version control, security etc.

DM is similar to ECM, but the same. Both of them facilitate information life cycle management, encourage collaboration and help manage information. But the key differences are: ECM can manage more than just documents. It brings a large science of record management and manage rich media and even hard copies. DM is purely the management of the documents, with or without any records management

This brings us another term: Record management. Record management is the practice of maintaining the records of an organization from the time they are created up to their eventual disposal. Duties may include classifying, storing, securing and destroying the records.

OK. Now we are all clear. In this post I will cover some DM features that I personally think is very useful. A bit of history, SharePoint 2007 was the first release where SharePoint really broke out of its collaboration role and enabled customers to apply structure and management to their document libraries. A lot of the key DM infrastructure was established in that release: Check in/Check Out, Major/Minor Versioning, Per-Item Permissions, Content Types, Workflows, and the Recycle Bin are just a few examples. In  the SharePoint 2010 version, the team keep up the good work and bring to us some freshness into this space.

  • Document ID

In a heavily used and adopted collaboration environment, one challenge people face is when content is reorganised or moved in the typical course of business. Hyperlinks emailed between team members that point to a document are no longer relevant which causes frustration and loss of efficiency. SharePoint 2010 offers a new capability to assign documents a unique identification number. This unique ID, embedded within a special URL, can then be used to retrieve the document regardless of where it is moved to within the site collection. No more broken links!

  • Document Set    

People often create multiple documents that support a single project or task. SharePoint 2010 includes a feature that enables people to group all of these documents together into a single entity. All documents in a Document Set share the same metadata and the entire Document Set can be versioned as a whole and downloaded as a compressed ZIP file with all contents included. People can also initiate a workflow on the entire Document Set instead of individual workflows for each document.

  • SharePoint Workspace 

Two highlights regarding SharePoint Workspace. The first one is offline capability. Whether you are travelling on an airplane or just have spotty network access, SharePoint workspace allows you to take your content offline. The other one is its rich experience. From drag-and-drop functionality to better performance, SharePoint workspace provides all the benefits to a rich client. And since it is a rich client, it also provides quick and easy navigation among list and libraries. You can simply click from one to another without waiting for webpages to load. The caveat when you are using SharePoint workspaces is you cannot download all content types with it. For example, you cannot download from a calendar, wiki and survey

Posted in General, SharePoint 2010 | Tagged: , | Leave a Comment »

Farewell to Patrick Tisseghem

Posted by chrissyz on September 6, 2008

It is extremely sad for the passing of my dearest friend and mentor Patrick Tisseghem. I am still in shock and couldn’t believe this is real.

Patrick and I met in the sharepoint training course in Canberra and became good friends immediately since then. We talked about everything: dreams, beers, cars, lifes.. and of course SharePoint. He is charming, inspiring and down to earth. A man with integrity and true characters. He leads me not only in the adventurer of SharePoint but also in the journey of life.

He encouraged me to start this blog and also named it. (We had a couple of “disputes” about the name 🙂 ) And today, when I am writing his farewell here, I looked back fondly on those time. Patrick, thank YOU for making my journey in Sharepoint such a memorable experience and always be there for me during my highs and lows in life. No word can describe how deeply I will miss you, my dearest friend, may God be with you and may you rest in peace.

Posted in General | Tagged: | Leave a Comment »

SharePoint development tools

Posted by chrissyz on August 18, 2008

Just a show-off of my SharePoint development tool set 🙂

Must have:

·         Visual Studio 2008 + Visual Studio 2008 Extensions version 1.2

Before we use Visual Studio 2005 + Extension for WSS3.0 is because the development of Custom Web Parts, Site and list definitions etc for SharePoint is not readily available in Visual Studio 2008. Since the new WSS extension for 2008 released in June 2008 and fully support various SharePoint custom development templates, I think we can call it a day for VS2005

·         SharePoint Designer 2007

Visual Studio is great to develop custom features in SharePoint. But have you ever tried to modify a SharePoint pages in Visual Studio? SPD is great when comes to the issue of branding. It gives you great preview and all the controls SharePoint controls in a menu ready to drag & drop and use. The DataView Web Part is another great feature of SPD. It takes a short time to get a DataView Web Part on your page and linked up to a data source. Creating custom views and filtering information from/around the site simple using this feature.

·         IE Developer Toolbar

Inspect HTML source, style usage, IFRAME content, image location etc. Definitely play an important role when you have to start changing the CSS in SharePoint or need to address accessibility in your website

·         Lutz Roeder’s Reflector for .NET

No need to explain. Most developers in .NET world know this tool.

·         U2U CAML Query Builder

From U2U. A great tool for writing and firing CAML queries.  It helps you decipher CAML and do queries against your lists to see if your CAML will work. You can also save your queries in XML format and launch from your application or web parts.


·         WSPBuilder

A SharePoint Solution Package creation tool for WSS and MOSS.  The manual process of packaging our solution is: we create your own manifest.xml and DDF file and use makecab.exe for nice granular control. With this tool, WSPBuilder will automatically traverse a “12” folder structure and creates a SharePoint solution manifest.xml and the wsp file based on the files it finds. It makes SP deploying and packaging very easily.

·          Fiddler HTTP Debugger

Inspected and manipulate HTTP traffic between your browser and the server, handy for debugging web services

·         Power Shell

Write scripts to automate administration and configuration tasks. A small tip here, the next version of SharePoint STSADM will be based on Power Shell.

·         BDC Metaman

Generate BDC XML from SQL data source. The commercial version also builds definitions for web services. An alternative is baked into the MOSS SDK, but BDC Metaman will continue to be the gold standard

·         SmartPart

Another great community tool by U2U. A SmartPart is a SharePoint web part that can host any ASP.NET control. You can create your own web parts using VS.NET designer instead of coding everything by hand.

Posted in General | 7 Comments »

Say no to SharePoint Customization

Posted by chrissyz on June 2, 2008

I am going to start this controversial article to my blog. The purpose of this article is to provide some reflections on the adoption and utilization of SharePoint in the organzation. Patrick Tisseghem mentioned “SharePoint is about build or buy” in his famous blog “SharePoint is not a holy grail“. Well, I quite agree with that as SharePoint is not a solution for everything. It is how you apply it in order to aid you in the solution. However, from my own experience, SharePoint development experience isn’t as friction-free as it could be. Therefore, my formula is simple:  Effective sharepoint solution = OOTB SharePoint + third party tools + minimal customization. Yes, if you still think you need heavy customization after leveraging OOTB SharePoint and evaluate the existing off the shelf sharepoint application, then forget about Sharepoint

1. Customizing SharePoint costs money and takes time. I am sure any .NET developers can skill up and be productive and happy working with SharePoint, but it takes time. There is a steep learning curve and new development conceptes to adjust. The current situation is people pay $XXX for SharePoint Developers and they still can’t get decent ones. Oh, don’t forget these PM/business owners who have been nurtured in SharePoint OOTB syndrome, they won’t be happy to see developers spending too much time on learning and training.

2. Poor supportability.To say SharePoint is a development platform, well, it is partially true. It is a development platform for Microsoft and its partners. It should be a product for the ordinary companies who wish to use SharePoint to solve their daily problems. Why? First of all, customized SP is hard to support. You get some funky contractors write some funky custom code and after a couple of months something goes wrong and their successors have to dig into these code to investigate what is going on. Secondly, Microsoft has three year dev cycle for SharePoint. You will expecting your application to upgrade with Microsoft’s new release. But remember, Microsoft doesn’t support custom code. You messed up, bad luck.
3. There are a lot of community supports for SharePoint, but looks like most people is still learning the concepts and exploraing the best practises. Again, a good place to go maybe Codeplex. It has a lot of community tools. It is free and it has version controls as well. At least it will give you some code block to start with for customization. But, like I say, they are community tools, so don’t be too fuzzy.

Looking forward, we are expecting Microsoft and its partners to develop more useful web parts and features just like what they do in MOSS 2007. And organizations only need to subscribe to what they need and configure it according to business requirements.

Posted in General | 4 Comments »

A tragic week

Posted by chrissyz on May 17, 2008

This week, I took 70-541 WSS3.0 – Application Development exam and luckily passed it. To say it is lucky is because I am in control of it. There are things in the world that we don’t have controls at all and sometimes..they bring us to our knees.

I am totally hit by 5.12 Earthquake in Sichuan, China. Until today, 22069 people dead in the earthquake, most of them are primary school and middle school students. It crashed me, it broke my heart. My heart was full of sorrow for the people who lost their lives, their homes, their beloved ones during the earthquake.

 Besides donating money, I don’t really know what else I can do for the people in Sichuan.  I pray for the determination to change the things we need to change, and also, the courage to accept the things we cannot change..It is an absolutely down week with a lot of tears.  

Posted in General | 1 Comment »

Blog away with SharePoint

Posted by chrissyz on April 27, 2008

 “What’s it going to be then, eh?”

The most quoted sentence in my favorite movie “The Orange Clock”.  I guess lots of people will pop up the same question for SharePoint just like me

First introduced in 2001 as SharePoint Team Services, then as SharePoint Server in 2003, now the much more mature and pro-enterprise Microsoft Office SharePoint Server 2007 is making major inroads within large corporations as the base for collaborative applications. Microsoft has stuffed BI, search, form services, workflow automations and content management capabilities all into MOSS this large playground. What you can do with it? You can work it into almost anything.

Yes, people want choices. It is one of the things Sharepoint fascinates me. Playing with all sorts of possibilities, try to get the best bid out of it. But this is a double-sword: either it can be a competitive advantage and innovation catalyst for the business or it can be another layer of chaos sitting on your already complex enough enterprise system. It is not an easy game, but I am sure you don’t want to (and can’t afford) to miss it.

Being an IT consultant, I inevitably need to work with SharePoint from time to time.  I start this blog to share some of my thoughts on SP during my daily work. Special thanks for my good teacher and friend Patrick Tisseghem’s inspiration and encouragement. Enjoy the reading.


Posted in General | Tagged: | 1 Comment »