SharePoint - Item - Edit Properties - Access Denied Error

10. února 2009 20:36jeff1024

0
Přihlásit se a hlasovat
I have a SharePoint 2007 EE Site (with patches up to version 12.0.0.6327) running on Windows Server 2008 & SQL Server 2008.
I ported an existing site from a different domain to this server by backing up/restoring the content database. The site is running fine.

I added a new sub-site and here is where I have the issue. If I create a document library, add a document, and then use the drop-down on the item to pick "edit properties" I bounce to the SP Error: Access Denied screen. My account is a site admin and has full access to the sub-site.
I can view the properties fine.

When I try to upload a document I get the access denied error message if some of the meta data properties are marked "required". The document is still uploaded. I also get the same error when I try to edit an item in a list.

I can view/edit the properties in Data sheet view fine. The libraries on the existing sites work fine. It only seems to be an issue on new sub-sites.

It almost seems like a permission problem generating the property edit forms. There is nothing in the SP log files.
- Reagovat
- Citovat

Odpovědi

9. dubna 2009 18:28

jeff1024

Přihlásit se a hlasovat

I worked through this issue with Micrososoft PSS. The Februray hotfix rollup kb961756 & kb961755 contain a fix to prevent this issue from occuring. This does not fix existing sites though. The support person sent me a small executable that when executed against the SP libraries with the issue fixed the problem. The source code for this app is as follows. Put this in a console app and pass the site URL and list name as parameters.

using System;
using System.Collections.Generic;
using System.Text;
using Microsoft.SharePoint;
using System.Xml;

namespace CA_TestingHotfix
{
    class Program
    {
        static void Main(string[] args)
        {
            FixField(args);
        }

        static void FixField(string[] args) 
        { 
            string RenderXMLPattenAttribute = "RenderXMLUsingPattern";

            //Console.WriteLine("Please enter the URL of the site: (Press enter after typing):");
            string weburl = args[0];

            //Console.WriteLine("Please enter the Document Library Name: (Press enter after typing):");
            string listName = args[1];
            SPSite site = new SPSite(weburl); 
            SPWeb web = site.OpenWeb(); 
            SPList list = web.Lists[listName]; 
            SPField f = list.Fields.GetFieldByInternalName("PermMask"); 
            string s = f.SchemaXml; 
            Console.WriteLine("schemaXml before: " + s); 
            XmlDocument xd = new XmlDocument(); 
            xd.LoadXml(s); 
            XmlElement xe = xd.DocumentElement; 
            if (xe.Attributes[RenderXMLPattenAttribute] == null) 
            { 
                XmlAttribute attr = xd.CreateAttribute(RenderXMLPattenAttribute);
                attr.Value = "TRUE"; 
                xe.Attributes.Append(attr); 
            } 
            string strXml = xe.OuterXml; 
            Console.WriteLine("schemaXml after: " + strXml); 
            f.SchemaXml = strXml; 
        }

    }
}

Navržen jako odpověďM_MS 22. dubna 2009 8:38
Označen jako odpověďjeff1024 22. dubna 2009 13:33

16. února 2009 3:05Xue-Mei Chang-MSFTMSFT, Moderator

0
Přihlásit se a hlasovat
Hi,
If you export a list template and then use the list template as a custom list template, after this you create a new list item and save, when you edit the list item, you will get an “Access Denied” error. This is by design behavior and is targeted for the next release.

Let me know if I misunderstand you.
Xue-Mei Chang
- Označen jako odpověďXue-Mei Chang-MSFTMSFT, Moderator20. února 2009 1:32
- Reagovat
- Citovat

Všechny reakce

11. února 2009 13:50Henrik Halmstrand

0
Přihlásit se a hlasovat
Do you have different SSP's? Check that your site is linked to right SSP.

Regards
/Henrik
- Reagovat
- Citovat
11. února 2009 14:08jeff1024

0
Přihlásit se a hlasovat
There is only one SSP setup for the farm. The site that is having the trouble is a sub-site. The top level site and the other sub-sites are fine. This sub-site and new sub-sites I create seem to have the issue.
- Reagovat
- Citovat
11. února 2009 14:56Henrik Halmstrand

0
Přihlásit se a hlasovat
Did you choose to have unique permissions or are the permissions inherited from top site?
- Reagovat
- Citovat
11. února 2009 15:02jeff1024

0
Přihlásit se a hlasovat
They are unique. I can create, delete, and edit the properties using the grid view. I cannot use the edit properties form - I get the access denied error. Thanks for your help.
- Reagovat
- Citovat
11. února 2009 15:26jeff1024

0
Přihlásit se a hlasovat
New items uploaded started working recently with no changes made to the system. Users cannot still edit properties of existing items.
- Reagovat
- Citovat
12. února 2009 8:46Xue-Mei Chang-MSFTMSFT, Moderator

0
Přihlásit se a hlasovat
Hi,

Could you please tell me was the document library created from a document template?

Thanks!
Xue-Mei Chang
- Reagovat
- Citovat
13. února 2009 16:08jeff1024

0
Přihlásit se a hlasovat
One was created using a template - Is there something specific to remplates that I should look at?
- Reagovat
- Citovat
16. února 2009 3:05Xue-Mei Chang-MSFTMSFT, Moderator

0
Přihlásit se a hlasovat
Hi,
If you export a list template and then use the list template as a custom list template, after this you create a new list item and save, when you edit the list item, you will get an “Access Denied” error. This is by design behavior and is targeted for the next release.

Let me know if I misunderstand you.
Xue-Mei Chang
- Označen jako odpověďXue-Mei Chang-MSFTMSFT, Moderator20. února 2009 1:32
- Reagovat
- Citovat
26. února 2009 16:47Brian.Jones

0
Přihlásit se a hlasovat
Does this affect read only permission with lists created from existing site content aswell ? I have a list which gives an access denied error when clicking on an item by a user who has read only permissions on the list. If I make them a contributor then they can view (and edit obviously). However, they are able to view other lists (with readonly permissions) that have been created from scratch with no probles.
- Reagovat
- Citovat
24. března 2009 14:04starepoint

0
Přihlásit se a hlasovat

I have a SharePoint 2007 running on Windows Server 2003 & SQL Server 2005 and I have a similar problem:

I added a new sub-site and here is where I have the issue. If I create a document library, add a document, and then use the drop-down on the item to pick "edit properties" I bounce to the SP Error: Access Denied screen. I can view the properties fine. The libraries on the existing sites work fine. It only seems to be an issue on new sub-sites.
If I try to set permissions for a specific document or folder it is not possible. In the Actions there is only "Manage Permissions of Parent"

I tried with Site collection admin account; System Account and user Account with full control on site and sub-site.

We did not import or export any template.

Does anybody found anything why this could happened?
- Reagovat
- Citovat
8. dubna 2009 9:36M_MS

0
Přihlásit se a hlasovat
I've found this answer in another forum... I've a similar problem and is a very big problem...

John Creevy said
March 13, 2009 at 6:13 pm
Anthony,

Through extensive testing in recreating VMs, we have seen this issue occur after the August Cumulative updates and not occur before. The access denied can be replicated by performing an export\import on any site or site collection on a farm that is at or greater than the August cumulative version. The February Cumulative updates does not repair the issue.

We found the following added to the tp_Field in the dbo.AllLists SQL table for newly created Announcements and Surveys after an export\import is done on a post August update farm:

Although we have seen this in Announcements and Survey Branching, we have not tested every list type. There may be other instances where the access denied occurs.

As your repair is for existing lists with the problem, would you have any insight into what one can do now to prevent any new lists from inheriting the problem?

Did Microsoft share root cause?

Did Microsoft indicate the ETA on the hotfix?
- Reagovat
- Citovat
8. dubna 2009 17:31K_Meyer79

0
Přihlásit se a hlasovat
Hi,
When you say 'this is by design behavior and is targeted for next release', do you mean 'targeted to be corrected in next release?' Do you know if there will indeed be a hotfix, as another reply has implied?
Thanks.
- Reagovat
- Citovat
9. dubna 2009 18:20SnowDiva

0
Přihlásit se a hlasovat
What is the work around? Do we have to move all the content OUT of the sub-site?
- Reagovat
- Citovat