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

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

Error upgrading MOSS 2007 publishing site to 2010 - Exception: Column 'PublishingStartDate' does n

Posted By:      Posted Date: October 22, 2010    Points: 0   Category :SharePoint

We are in the process of testing a database attach upgrade from MOSS 2007 to SharePoint Server 2010. We are running into an issue when we attach the database with the main portal site collection which has the publishing features enabled. In the upgrade error log, we are receiving the following errors:

[powershell] [CmsImageLibrarySiteAction (] [INFO] [10/21/2010 3:40:37 PM]: SPSite Url=http://<WEBAPP>.<COMPANY>.com
[powershell] [CmsImageLibrarySiteAction (] [ERROR] [10/21/2010 3:40:37 PM]: Failed to upgrade site collection images library on site http://<WEBAPP>.<COMPANY>.com.
[powershell] [CmsImageLibrarySiteAction (] [INFO] [10/21/2010 3:40:37 PM]: SPSite Url=http://<WEBAPP>.<COMPANY>.com
[powershell] [CmsImageLibrarySiteAction (] [ERROR] [10/21/2010 3:40:37 PM]: Exception: Column 'PublishingStartDate' does not exist. It may have been deleted by another user.
[powershell] [CmsImageLibrarySiteAction (] [INFO] [10/21/2010 3:40:38 PM]: SPSite Url=http://<WEBAPP>.<COMPANY>.com
[powershell] [CmsImageLibrarySiteAction (] [ERROR] [10/21/2010 3:40:38 PM]:    at Microsoft.SharePoint.SPFieldCollection.GetField(String strName, Boolean bThrowException)
   at Microsoft.SharePoint.SPViewFieldCollection.Add(String

View Complete Post

More Related Resource Links

Error upgrading MOSS 2007 SSP database/user profiles to 2010


I am trying to use the new-spprofileserviceapplication powershell script to do a db attach/upgrade of my 2007 SSP to upgrade the user profiles.

New-SPProfileServiceApplication -applicationpool User_profile_service_app_pool -Name "User Profile Application" -Profiledbname prodsspconfig2 -Profiledbserver dbname\int

It gets a certain way and then errors out with the following error:

[powershell] [ProfileDatabaseSequence] [ERROR] [10/22/2010 12:13:56 PM]: Action of Microsoft.Office.Server.Upgrade.ProfileDatabaseSequence failed.
[powershell] [ProfileDatabaseSequence] [INFO] [10/22/2010 12:13:56 PM]: ProfileDatabase Name=prodsspconfig2
[powershell] [ProfileDatabaseSequence] [ERROR] [10/22/2010 12:13:56 PM]: Exception: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_ProfileTypePropertyAttributes_PropertyList". The conflict occurred in database "ProdSSPConfig2", table "dbo.PropertyList".
The statement has been terminated.
[powershell] [ProfileDatabaseSequence] [INFO] [10/22/2010 12:13:56 PM]: ProfileDatabase Name=prodsspconfig2
[powershell] [ProfileDatabaseSequence] [ERROR] [10/22/2010 12:13:56 PM]:    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowE

"User cannot be found" error when creating My Site after upgrading to SP2 for MOSS 2007



Hope this is the place for sharepoint gurus?

I upgraded MOSS2007/WSS3 to SP2 and since then I have been unable to get My Site to create new sites for existing domain users.

Some of the domain users created their My Site before the SP2 upgrade and they still work. We just cannot create new My Sites for existing domain users.

Now when we try to create a My Site we get this error:

"There has been an error creating the personal site. Contact your site administrator for more information."

I checked the event logs and usually no error is recorded when this happens so sharepoint does not even give me a breadcrumb (thanks!).

However, on one occassion I did get an event message after fiddling here and there and many attempts at trying to create a My Site, hooray! See below for all the glorious details of the event message, but the basic error is:

"User cannot be found".

I have checked the My Site settings of shared services (SSP1), veiwed user profiles, all the domain users are imported. So I have no idea why when creating a My Site it fails?

I have searched many forums and although they get the same error it seems to be for different reasons so the solutions don't help my situation.

Is there somewhere in Sharepoint that these domain users need to exist? Would I be able to c

Custom Site Column in MOSS 2007

Hello, We have a request to add List in a List, for example, one of the column in the list should contain a table...so, created a custom column "Column with HTML Table" from the list of publishing fields...but, somehow, I dont seem to find that site column any more... That column type is "Publishing HTML", and it allows to define HTML table. I am unable to add a screenshot here...so, any clues? Also, can we copy the custom site column as a template and move it to another Site Collection? Regards, Kishore.  Kishore

Site Migration from MOSS 2007 to MOSS 2010

Presently our client have the MOSS 2007 Portal and they want to migrate those sites in to MOSS 2010. So, We need to show case something to that client. Please anyone have idea on the same, please let us know. It's very urgent.Thanks in advance..Regards,Pradeep Seella  

Best Way to Convert MOSS 2007 Site Templates to SharePoint 2010 Templates

Ok, I just treid to do something that I didn't really think would work, but now that I've seen it fail, I get to ask the question. Is there a best practice on converting site templates built for MOSS 2007 to SharePoint 2010. We have several projects that used the Visual Studio Extensions (v1.3) and the SharePoint Solution Generator to build custom site templates and the .wsp packages. I can add and deploy the solution packages using the STSADM tool, but when I try to create a sub-site based on that template, I get an Object Not Set to an Oject Reference Error. In case anyone is wondering, it works fine in MOSS 2007. I have not tried Visual Studio 2010 yet (it's downloading in the background). I'm just wondering if anyone has run into this and what they did to fix it. TIA, John.

The URL is not valid error while publishing InfoPath form to MOSS 2007 server

Hi All,   When I try to publish the form onto a SharePoint Team site it throws the error: The following URL is not valid : http://tcs037288:6543/sites/projectmanagement   I have checked the comaptibility, trust and everything looks fine. Also, I tried to upload this template from Central Admin but there it is failing with browser-compatibility errors.       Regards,

Reg Upgrading List of MOSS 2007 to InfoPath 2010

Hi, Actually right now there is Newform.aspx of the list in MOSS 2007 through which we are collecting the data from the user.Now our customer is planning to migrate the application to SharePoint 2010 so i just want to know so that can we get a easy support to implement in InfoPath 2010 compared to the list of MOSS 2007 Thanks & Regards, Sudheer

Currency and number column error with office 2007 document formats in SharePoint 2010 library

Hi there,



The following error occurred within a SharePoint 2010 document library:

As I tried to test out the new SharePoint 2010 environment I changed the metadata from a few documents within a document library. I noticed that the data from the currency und number field was incorrect from a few documents. The numbers looked like that the decimal separator were ignored. For an example: 123.456,78 was saved as 12.345.678.

At first I thought it could be a language incompabilty but if that would be the case: Why would there be other documents which show the correct number?


I created another document library to recreate this error. And there I noticed the real reason: Every time I changed these fields from a document which was saved in the office 2007 format the error occurred. The metadata from the documents in the office 2003 format were correct.


Has anyone a similar problem or got an idea how to solve this problem?


System Specs:

Frontend: Windows Server 2008 SP2 ent

How to upgrade MOSS 2007 custom site definitions to SharePoint 2010?

I would like to know how to upgrade custom site definitions of MOSS 2007 to SharePoint 2010 in detail?

Visual Studio 2010 will not open my MOSS 2007 Site


I am using VS 2010 premium, Win Server 2008 R2, MOSS 2007 and are all installed on the same machine.

First, I when I try to connect with the server explorer...I get A SharePoint server is not installed on this computer which is not true.

Second, When I try to open a website through > open website > local IIS and click on my sharepoint portal site I get.....Unable to open website, Visual Web Dveloper does not support opening sharepoint sites. Why am I getting this? I am not using Visual web Devloper. I am using VS 2010 premium.

Why is it so hard to open adn/or connect to our sharepoint sites with VS 2010? I have no problem at all using Sharepoint designer to connect but I want to use visual stuidio.  I hate the designer. I think microsoft dropped the ball on this one.    Anybody know of a good article/tutorial on this?

Site migration for MOSS 2007 to SP 2010



Can any one give me the steps to migrate my MOSS 2007 Sites Collection to 

Sp 2010 Environment. because i can't use .stp in SP 2010 so i am stuck with it 

 Please help me out.


Thanks Inadvance.


MOSS 2007 to SharePoint 2010 Upgrade Fails - Exception: The user or group 'wsaarole:wsaa administra


Ok the top part of the error I have tracked down to some entries in the SharePoint_Config database (Classes, Objects, TimerRunningJobs) and since I have a VM I am going to study them and try deleting them probably, if it dies I will delete this VM and roll up another VM in my case its a timer job that I am guessing the farm can live without.

The other error further down is more of a concern to me which is the one I listed above. The Group exists and it is in the farm and appears to be healthy no errors in preugrade check or the like or in the Farm. When upgrading the show stopper for me is that the content databases will not upgrade (assuming they upgrade FBA I can configure) the chicken and egg issue for me is this is an FBA farm, so is it the case that b/c FBA is missing not configured yet on the other side of the upgrade in 2010 that these content dbs connected to FBA (by FBA users in the content dbs) will upgrade affter FBA is configured ( I haven't tried this yet sorting my error log one error at a time). The Particular content dbs with an issue are shared services and the main site collection db which includes my sites site collections also.

[psconfigui] [SPConfigurationDatabaseSequence2] [INFO] [9/30/2010 3:44:42 PM]: SPConfigurationDatabase Name=SharePoint_Config
[psconfigui] [SPConfigurationDatabaseSequence2] [WARNING] [9/

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?

How to upgrade MOSS 2007 custom site definitions to SharePoint 2010?

I would like to know how to upgrade custom site definitions of MOSS 2007 to SharePoint 2010 in detail?

MOSS 2007 configuration error


Hi Experts,

I installed sharepoint 2007 successfully but while configure the sharepoint it gives following error:

The following services may have to be started or reset during configuration:

1. internet Information services

2.Sharepoint Adminstration services

3.Sharepoint Timer service

But already run ISS in my server. how can i solve this problem

How to create a single entry page for site collections in MOSS 2007



I have  7 site collections containing a few hundred team collaboration sites. Some users are internal (intranet) but most are external (extranet). Extranet users are experiencing problems with losing links to their sites and forgetting which URLs to use. So I would like to create a single entry page that all users can enter after the logon process, which shows a list of sites they have permission to access, and other user-specific information. Perhaps relevant documents, tasks, recently modified documents etc.

I know this sounds like a 'My Site' but we want to use use a general welcome page instead. We use Windows authentication.
What is the best way of doing this and is it something that can be done in SharePoing Designer or does it need to be done in Visual Studio?

Many thanks in advance.

moss 2007 for intranet ,publishing portal with collaboration portal subsite or other way.

Hi All, We are planning to use moss 2007 for our intranet. Mainly we want to use it for collaboration purpose (i think collaboration portal is the appropriate template as root site). but in future if the company want publishing portal can i have it under collaboration portal or should i choose now itself the root site as publishing portal  and then create collaboration portal as sub site to meet our needs. can some one shed light on how to proceed and pros/ cons . Cheers, Friend. 
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