.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

sharepoint Duplicate Site columns and updating content type failed when publishing to sharepoint

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :C#

1many duplicate columns in my library

we can see image here:

2run  sql :

select * from AllUserData 
where  tp_LeafName = 'xxxx.xml' and tpid='1123' 
and tp_DeleteTransactionid = 0x 

should find only one row,but then can find 7 rows:

row1                    0
row2                    1
row3                    3
row4                    4
row5                    6
row6               &

View Complete Post

More Related Resource Links

Error: Updating Site Content Type Failed - InfoPath 07/SharePoint 07


I have been working with InfoPath07 and SharePoint Moss 07 for two years.  I have recieved the Updating Content Type error in the past which I got around by creating new library's. This was over a year ago and happened only a couple times.

Recently, my dept did a database migration.  About 3 weeks prior to the migration I started having troubles with publishing InfoPath.

First issue, it would take about three hours for my form to go through to the form/document library.  Sometimes they would publish, other times I would get Updating Content Type Failed.

Now that our databases have been migrated, I don't have to wait three hours to get my error.  I get my error on (1)existing forms that just needed interface updated (no changes to forms content), (2) existing forms that have no content at all, (3) and brand new forms that have never existed, with no content.

I have tried:

  • Deleting some content (fields)
  • Deleting all content
  • Deleting the entire library and starting fresh (including any content types in Central Admin or workflows associated)
  • Creating a brand new form with no content type

I have been researching and trying to figure this issue out for at least three months. I am still getting this error with every form I publish to update the forms library; howe

Sharepoint 2007 publishing site home page displays unknown file type security message


I am using sharepoint 2007 sp2, it has been workig fine for the past 8 months but since one of the developers installed .net 4.0 framework, every time we create a new sharepoit publishng site or extend and existing application the home url displays an "Unknown File Type" security warning message and asks users to download the file.  If i manually tupe in the full url http://www.mysite.com/pages/default.aspx it is displayed correctly. I have uninstalled .net 4 from the server but i still have the same  error. I have tried to replicate this error on a development server but sharepoitn works fine on that even with .net 4.0 installed.

Has anyone had the same issue ? I would appreciate  any suggestios or help with troubleshootig this issue.


Easy way to migrate site columns and content types from moss 2007 to sharepoint 2010?

Easy way to migrate site columns and content types from moss 2007 to sharepoint 2010?

updating content type failed during publishing Infopath on MOSS 2007


Hi Folks,
I am new to MOSS & Infopath-2007. I want to publish form on MOSS onto Document Library not as Content Type. Last week, i published form successfully, but suddenly since last thursday, I am not able to publish - it gives me "updating content type failed" error. :(
I am publishing with Domain Trust, no certification is sign (actually, not required in my case).

Thereafter, I tried creating new template with single button/textbox, but it gives same error.
Today, i tried with blank form, it failed again with same error.

I tried creating Form library from Infopath form as well as from MOSS, but no help.
doing Googling, i only got 2 solution - timeout or too many columns added from infopath - but in my case there are only 3-4 columns i want to publish. 

I tried below links, but no help:

Inheriting from publishing page content type does not allow for overriding fields in SharePoint 2010


Hi there, we are creating custom content types that inherit from the "Page" content type.  We have found that we must have the "Inherits" property set to "TRUE" or else our custom content types do not show up in the content type gallery.  If we query the site collection using management shell the content type does appear to be there, but unfortunately it will not publish from the content type hub. If we set Interits=TRUE the content type deploys properly and appears in the content type gallery, but we cannot override (change the display name) or remove any of the inherited fields. Ultimately, we would like to have our content types inherit from "Page" and also override some of the "Page" fields, but this does not appear to be possible. We have spent quite a bit of time on this issue and are wondering if this is a bug or intential behavior of the "Page" content type. Any information you can provide would be appreciated? 

P.S. We have ran similar tests inheriting from "Document" and "Item" content types and do not encounter the same issue with overriding inherited fields.


SharePoint lookup site columns and Word Content Controls

I discovered that when you bind lookup columns in SharePoint to a Content Type that in turn pushed these properties to the document, the value actually stored is the ID and not the text that is displayed. What is the correct way to use such site columns to enable users to select the data they want to be associated with a document and then to have the display values be populated in the Content Controls?

SharePoint 2007 - Consolidating everything as feature into WSP [Content Type, Page Layout, Pages, Ma


Hello –


Overview – We are building a Mobile Web Site using SharePoint 2007. The big screen site has been already built and we need to integrate the mobile site into same site collection of big screen –


·         The Mobile site will use the existing content types of existing big screen site

·         We will build a new custom Master page

Creating SharePoint Server 2010 External Content Type Associations with SharePoint Designer 2010

Learn how to use Business Connectivity Services (BCS) to create associations between external content types in SharePoint Designer 2010 without using code.

Publishing SharePoint Site


I have published a sharepoint website that I created but I now have the following problem:

  • from the internal network, everything works fine..
  • from the external network (via web):

  1. the People Picker web part does not work (error in WebForm_DoCallBack)
  2. The "assigned to" field is empty, but when I see the source code, the users are there. They are just not displayed.
Can anyone help me. Thanks in advance..

SharePoint 2010 Publishing Site : Operation is not valid due to the current state of the object.

  I think as usual, the new version of SharePoint 2010 has a lot of problems. the below messege appear in a publushing site (FBA) enabled and when I try to access the pages list or even approve a page of accessing the SiteCollectionImages list and ......... etc every link produce the below error. I'm very frustrated with 2010.  Server Error in '/' Application. <nativehr>0x8107058a</nativehr><nativestack></nativestack>Operation is not valid due to the current state of the object. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Runtime.InteropServices.COMException: <nativehr>0x8107058a</nativehr><nativestack></nativestack>Operation is not valid due to the current state of the object. Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace: [COMException (0x8107058a): <nativehr>0x8107058a</nativehr><nativestack></nativestack>Operation is not valid due to the current state of the object.] Microsoft.SharePoint.Library.SPR

Unable to collaborate on document in SharePoint Workspace which has Content Type with more than look

1/ Add a new document into Shared Document library. 2/ In Shared Document of this workspace, add new content type having 12 lookup columns. 3/ Create a new workspace 4/ Add a user into the workspace with the editable permission (Contribute or Full Control). 5/ Open the document in Word 2007, in the Document Management Pane Using system account: the document is shown in the Document tab. Using normal account: the document is not shown in the Document tab. 6/ If we use Dws.GetDwsMetaData method to get information of the workspace site and lists it contains then:    + Using system account credential, this method returns the document's information in Shared Document library. The result contains the below xml data: <List Name="Documents"> <ID>{CFEDFC3C-2AD3-4A0E-88B6-821BF57CACDB}</ID> <z:row ows_FileRef="Shared Documents/Test Content Type.docx" ows_FSObjType="0" ows_Created="2010-09-01T02:38:31Z" ows_Author="1073741823;#System Account" ows_Modified="2010-09-01T02:38:31Z" ows_Editor="1073741823;#System Account" ows_ID="1" ows_ProgID="" xmlns:z="#RowsetSchema" /> </List>     + Using the normal user credential, this method does not return the document information in Shared Document library. I notice

Regarding Sharepoint Discussion Board- content type "Message"

Hi I am using following CAML query to display pending discussions in a discussion Board spQuery.Query = "<Where><And> <Eq><FieldRef Name='_ModerationStatus'  />  <Value Type='ModStat'>Pending</Value></Eq><Eq><FieldRef Name='ContentType'/>  <Value Type='Text'>Discussion</Value></Eq></And> </Where>"; now I want to display the replies inside a disussion with approval status- pending, So I just change the content type as Message  in above CAML Query. But its not working. Please provide C# code for above

Sharepoint export to spreadsheet gives two extra columns in excel 2007 named as type and path, is th

When i export a list in excel 2007, it creates two extra columns named as type and path. At the same time this behaviour is not exhibited in office 2000. Is there any way to remove these two columns without using code ? Is there any configuration settings required for this, to remove it on the fly ? Thanks Ravish Verma

How to migrate sharepoint site in 2007 with custom solution package and its content to sharepoint 20

Hi Experts, Recently, my organization is planning for SharePoint 2010 upgrade. We decide to go with Database content migration as it is less impact with down time due to hardware and software requirement (64 bit) in SharePoint 2010. We have a sub-site which contains a lot of customization such as master page, custom list, web parts and a lot of content. There is also a solution was built for that sub-site as well. However, as the time past by there quite a few update and manual creating from power users which concern to me that the solution package that we have does not up to date that can be use for SharePoint 2010 upgrade. I am planning to re-package the solution for the upgrade with all the changes users made for SharePoint 2010. But the question is how do I migrate the content of existing site when we upgrade to 2010? It is also possible that they want to change the sturction of the site when migrate eg: make this new upgrade site as top site collection instead of sub-site. Another concern is what happen after I finish making re-package the solution but during the re-package period users might make more change to the existing site? I would greatly appreciate for any ideas, suggestions as well as best methodology I should take.   Thanks praneth

Office Sharepoint Server Publishing Infrastructure is missing in site collection feature SharePoint

I was trying to activate the Office Sharepoint Server Publishing Infrastructure feature in the site collection features but the feature is simply not there. Is this option not available in SharePoint Foundation 2010?

InfoPath 2007 - Publishing Creates multiple columns on SharePoint Form Library (GUIDS apparently are

I have been working this issue for 2 days now.  This has happened to me in the past and I was able to work through it.  It doesn't appear that this time I am going to be so lucky. Issue Description: When publishing an InfoPath form a new column is created that has the same name as the correct one, but a new GUID is created. Troubleshooting steps: I have read this article: http://www.delphi-ts.com/blogs/lozzi/post/2009/06/03/Duplicate-site-columns-in-MOSS-from-InfoPath-Forms.aspx   This was the solution the last time I had this problem.  However, no matter what I do, it is not working now.  I have a column named User Name which is the username of the person that submitted the InfoPath form for use with my Visual Studio workflow.  When the workflow kicks off, it reads this column and attempts to get the value.  The value is blank because a new column with the name User Name now exists and that is where the value is stored.  I attempted to fix it by remapping the GUIDs as described in the article.  I also reverted the code to a previous version from TFS.  None of these worked.   I now have 3 columns called User Name and I can remap the GUID to the second column and third column.  But when I try to map it to the first column (the one I need) it doesn't work. The first column that is circled is the correct column. 

publish infopath form to sharepoint services 3.0 as content type



can an infopath form be published as content type to a sharepoint services 3.0 form library?

i have created 2 form libraries. one to store the tamplate an the other to store the form itself and where you can open a new form.

but whenever i click new to open a new form i get this error message:

the element "comment" is used but not declared in the DTD/schema.

does any one know what this error could be?

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend