Problem:

Access Denied for all SharePoint Search Pages suddenly.
You’re able to access with your service account but normal users just cant access it. You check all users with ‘READ’ permission.

Solution:

1. Access the Search top level site with Service Account, for instance.
2. Site Actions -> View All Site Content -> Document Libraries -> Pages (http://localhost/sites/search/Pages/Forms/AllItems.aspx)
3. Click on one of the page that users were not able to access. A context menu will appear and then click “Publish”
4. Users able to access the page without permission problem.

Seriously I had hard time to deal with this production issue.

Google around, found a lot of solutions such as, enable “SharePoint Server Enterprise Site Collection features”, Access Central Administration to make sure “Access Service is installed, and bind to the website”.

Unfortunately those wasn’t not able to solve the problem.

We came out a solution which is “save the Microsoft Access Web Database as template, and Create the site with the template”

To Save the Microsoft Access as “Local Database”

1. Access the Microsoft Access Web Database
2. Click” Options” -> “Open in Access”
3. Microsoft Access Launched -> Click “File” -> “Save & Publish” -> “Save Database As” -> “Save as Local Database”

To Save the “Local Database” as Template

1. Open the file you just saved
2. Click “File” -> “Save & Publish” -> “Save Database As” -> “Template (*.accdt)”
3. A window pop up -> Name it “testDB” (will be great without space between the filename), check “Application Part” & “Include Data in Template”
4. Click OK

Upload Template & Activate the solution

1. Launch IE, log on to “http://ServerName/sites/test/_catalogs/solutions/Forms/AllItems.aspx
2. Upload and Activate the solution

Create the Sub Site with uploaded template

1. Launch IE, log on to “http://ServerName/sites/test/
2. More Options -> Filter By -> Site -> “testDB”
3. Enter Site Name and URL and Save

Lastly, deactivate and delete the solution you just created.

Incoming search terms:

• failed to publish access db file to sharepoint (2)
• March 21 2012 AND sharepoint AND leave a reply (1)
• publish web database in sharepoint 2010 (1)
• sharepoint 2010 web database failed (1)
• sharepoint2010 database (1)

Access Denied when accessing properties in SPWeb with SPSecurity.Elevated Privileges as a visitor?
You may need to scan your code if you use “SPContext.Current.Site” or “SPContext.Current.Web” in your program.

To avoid access denied when you use RunWithElevatedPrivileges block, you need to create new instance of SPSite and SPWeb inside SPSecurity.RunWithElevatedPrivileges

SPSite siteColl = SPContext.Current.Site;
SPWeb site = SPContext.Current.Web;
SPSecurity.RunWithElevatedPrivileges(delegate() {
  using (SPSite ElevatedsiteColl = new SPSite(siteColl.ID)) {
    using (SPWeb ElevatedSite = ElevatedsiteColl.OpenWeb(site.ID)) {
      string SiteCollectionOwner = ElevatedsiteColl.Owner.Name;
      string Visits = ElevatedsiteColl.Usage.Visits.ToString();
      string RootAuditEntries =
          ElevatedSite.RootFolder.Audit.GetEntries().Count.ToString();
    }
  }
});

Incoming search terms:

• runwithelevatedprivileges sharepoint usage (1)
• spsecurity runwithelevatedprivileges avoid (1)
• spcontext runwithelevatedprivileges (1)
• sharepoint provision access denied spsecurity (1)
• sharepoint avoid ad usage (1)
• sharepoint 2010 runwithelevatedprivileges get spweb (1)
• sharepoint 2010 central admin spcontext (1)
• SharePoint 2010 access denied to SPWebCollection inside SPSecurity RunWithElevatedPrivileges (1)
• runwithelevatedprivileges spweb (1)
• runwithelevatedprivileges spcontext (1)

To save site as template

1. Site Actions
2. Site Settings
3. Site Actions -> Save Site as Template
4. It will save it at “http://yoursite/_catalogs/solutions/Forms/AllItems.aspx”

To create a site based on a template (create a subsite)

1. Download the template from “http://yoursite/_catalogs/solutions/Forms/AllItems.aspx”
2. Upload the site template to another site, “http://yoursite/subsite1/_catalogs/solutions/Forms/AllItems.aspx”
3. Browse “http://yoursite/subsite1/
4. Site Actions
5. More Options
6. Filter By Site, then select the template you just uploaded.

Incoming search terms:

• restore site template in sharepoint 2010 (4)
• sharepoint 2012 templates (3)
• sharepoint 2012 template (2)
• download site templates sharepoint 2010 (1)
• sharepoint 2010 save site as template download the template (1)
• sharepoint 2010 site template delete (1)
• sharepoint 2010 template download (1)
• sharepoint 2012 site templates (1)
• sharepoint 2012 upload site template (1)
• sharepoint2010 template download (1)

Problem: want to re-associate the SharePoint Designer Workflow to another document library.

Solution: using SharePoint Designer to edit “workflowfilename”.xoml.wfconfig.xml .

<association ListID="..." TaskListID="..." ...></association>

How to find out the ListID?

• Go to the List/Document Library
• List Setting/Document Library Setting
• You will to get the List ID from the Internet Browser URL
• URL looks like “http://URL/listedit.aspx?List=%7B532E2F14%2DF3B5%2D4BE9%2DA14A%2DE0DBD10E0935%7D”
• Go to “http://meyerweb.com/eric/tools/dencoder/”
• Paste the %7B532E2F14%2DF3B5%2D4BE9%2DA14A%2DE0DBD10E0935%7D
• the website will decode to “{532E2F14-F3B5-4BE9-A14A-E0DBD10E0935}”

Use that DECODED List ID to update the workflow XML file.

NOTE: if you having problem when you try to publish the workflow using SharePoint Designer,
you may delete the webcache at “C:\Users\loginnames\AppData\Local\Microsoft\WebsiteCache”

Incoming search terms:

• how to access email from in document library spd workflows 2010 (1)
• sharepoint 2010 xoml wfconfig xml cannot find association tag (1)
• sharepoint designer 2010 move document to another library (1)
• sharepoint designer 2010 workflow move document (1)
• sharepoint designer workflow 2010 (1)
• sharepoint designer workflow change list Association ListID= (1)
• sharepoint designer workflow listid (1)
• sharepoint move list workflow (1)
• sp 2010 workflow edit association listid (1)
• workflow to move document from library sharepoint 2010 (1)

Objective: to return XmlDocument from WCF REST WebService via URL.

Creating a WCF WebService is straight forward, but to create a WCF WebService to host under SharePoint 2010 you need extra steps to accomplish.
This is my first time to develop WCF RestFul WebService. Many of you may familiar with REST if you are the SharePoint Developer.

I will attach a zip file of a working solution at the end of this post.

To Create WCF Service

• New Project -> WCF -> WCF Service Library
• it will create 2 class files for you. (we need these 2 files)

To Create SharePoint WCF Service

• New Project -> SharePoint -> Empty SharePoint Project
• Map ISAPI SharePoint Folder
• Create a text file and rename it to “BuckOfficesService.svc”
• Create another text file and rename it to “web.config”
• Copy 2 cs files from WCF Service Project (Rename them as BuckOfficeService.cs and IBuckOfficesService.cs)
• Make sure those references added in the project as well

• Microsoft.SharePoint
• Microsoft.SharePoint.Client.Runtime
• Microsoft.SharePoint.Security
• System.ServiceModel
• System.ServiceModel.Web

Click it for clear view

So I wanted to return a XmlDocument from Rest WCF WebService.
You need to make sure you add [XmlSerializerFormat] in your Interface class (it will return error when you try to run the service) before or after [ServiceContract]

Deploy the solution to your SharePoint Server.
Launch IE with http://localhost/_vti_bin/buckofficesservice.svc/getbuckoffices

You may download the full working source code for HTTP only [here]

To cater for HTTPS, you need to add extra line in web.config (those red highlighted)
Click the image for better view

Incoming search terms:

• WCF XMLDocument (2)
• configuration for rest web service in sharepoint2010 (1)
• webservice return XmlDocument error (1)
• wcf return xml document (1)
• WCF REST service return xml document (1)
• WCF map sharepoint (1)
• sharepoint rest (1)
• SharePoint 2010 REST (1)
• returning xmldocument from wcf (1)
• return valid xml document rest wcf (1)

Recently received an assignment to retrieve all the terms belong to a specific group.
Here a snippet code to achieve the objective.

For Instance, I want to retrieve all terms under “SMR”

                SPSecurity.RunWithElevatedPrivileges(delegate()
                {
                    SPSite site = SPContext.Current.Web.Site;
                    TaxonomySession session = new TaxonomySession(site);

                    Group termGroup = session.TermStores[0].Groups["SMR"];
                    List<string> colSMRTerm = new List</string><string>();
                    if (termGroup != null)
                    {
                        foreach (TermSet ts in termGroup.TermSets)
                        {
                            foreach (Term t in ts.GetAllTerms())
                            {
                                colSMRTerm.Add(t.Name.ToLower());
                            }
                        }
                    }
                }); 

Incoming search terms:

• c# get all terms of taxonomy (1)
• sharepoint 2010 get terms c# contains (1)
• sharepoint 2010 taxonomysession runwithelevatedprivileges spcontext (1)
• SharePoint 2010 WCF TermSet serializable (1)
• sharepoint get all terms (1)
• sharepoint get all terms c# (1)
• sharepoint TermSet GetAllTerms (1)
• SharePoint2010 Is In Group (1)
• termstore getallterms sharepoint (1)
• runwith elevated privileges in sharepoint termset (1)