.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

Error upgrading MOSS 2007 SSP database/user profiles to 2010

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

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

View Complete Post

More Related Resource Links

SharePoint 2010 Server: Cannot manage all user profiles from upgraded MOSS SSP database

I have upgraded an SSP database to SharePoint 2010 and successfully performed User Profile Synchronization with Active Directory, however I cannot manage ALL of the user profiles in the database. I go to "Manage User Profiles" in Central Administration and perform a filtered search (i.e. I want all DOMAIN accounts beginning with "j" so I search for "DOMAIN\j" in Manage User Profiles), but I don't receive ALL the user profiles back. I receive about 8 in return when I know there are about 20 starting with "j". If I create a new AD account beginning with "j" it is successfully synched with SharePoint 2010 and I see it in the Manage User Profiles. I ran an stsadm -o sync to clear any old synchronization information, and the Forefront Synchronization Service appeared to pull in many changes to existing accounts (including ones I can't currently manage), but I still cannot manage them using "Manage User Profiles". I really need to be able to manage all the profiles so I can manually edit some fields. Can anyone please help? Thanks in advance.

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


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

"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

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

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/

Configuring User Profiles in SharePoint Server 2010

Note: I've added the necessary links relating to SharePoint Server 2010 prerequisites, along with instructions for configuring the user profile synchronization service, at the end of this

Visual Web Dev 2010 error or new user error?


In a new web app, using the fresh new build, I added some fields that I wanted processed during login, i.e. common Profile stuff... added them to web.config.... sadly it appears that Studio 2010 will not automatically create a ProfileCommon class from ProfileBase, as previous studio web IDE's would do - that was frustrating for a bit, then I just created my own class... but that led to this interesting problem.

When populating the new profile attributes, the code behind class could not resolve any of the textbox referenced, all showed as not defined... figuring it was something simple, I kept going... added a customValidation control I needed, but though I double clicked the event in studio, and it dutifully created the stub code for me... the event never fired.

Determined to locate the problem I poored through forum entries and every reference I could (found lots of folks complaining about the profileCommon class stuff which is what led me to create my own class finally) -- but nothing specific to the problem I had of not seeing defined controls that were clearly there and working nor my customValidator control.

But... all of the code samples I saw - none had the ContentTemplate section... curious I removed that section, other items started to fail that were logical (header tags, etc.) but, my code behind section snapped back into order, intelisense n

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

Unable to search Custom User Property Created in User Profiles in SharePoint 2010


Hi ,

I have created a custom user property,and created metadata property and added mapping to it, still i m not able to Search in People,Please advise

How to fill out a form as another user , while using profiles database


I have created an InfoPath 2007 form. It works great.. I have 5 data connections to sharepoint lists and profile's database. The form displays public data (profile database) about the user, such as name, manager.. etc.

What I would like to do is have an option on the form that says " If you are not this person , click here" , manually type the persons last name , and bring up their information.

Basically , there are some people who will have someone else fill the form out for them. But I don't want them to be giving out their username and password to the system.

I want the ability to fill out a form as another user without logging off sharepoint. 

Cannot crawl sharepoint site and mysite after database attach upgrade form sharepoint 2007 to 2010.

After database attach upgrade site and mysite from sharepoint 2007 to 2010 , I have full crawl and get "The crawler could not communicate with the server. Check that the server is available and that the firewall access is configured correctly. If the repository was temporarily unavailable, an incremental crawl will fix this error. ( Error from SharePoint site: HttpStatusCode ServiceUnavailable The request failed with HTTP status 503: Service Unavailable. )" for mysite and get "Access is denied. Verify that either the Default Content Access Account has access to this repository, or add a crawl rule to crawl this repository. If the repository being crawled is a SharePoint repository, verify that the account you are using has "Full Read" permissions on the SharePoint Web Application being crawled." for sharepoint site. The content access account for search is "db_owner" of both of site and mysite. How do I solved this problem ?

User Profiles Service Application and Import of SharePoint 2007 SSP data

I have setup a test SharePoint 2010 Farm. I will be using this as a test upgrade of a current live SharePoint 2007 Farm. The database attach method will be used. I have replicated the web application and AAM settings of the SharePoint 2007 Farm to the SharePoint 2010 Farm and have made the 2010 Farm a DC in a new Forest. I don't want to join this to the current domain at the moment. It also has SQL server 2005 with SP3 and cumulative update 3 installed. I have just setup the User Profiles Serice Application and when I go to Manage it, I get this. Error An unexpected error has occurred.   Troubleshoot issues with Microsoft SharePoint Foundation. Correlation ID: a1760e87-372f-4711-afac-3ceba34bc599 Date and Time: 8/31/2010 4:22:56 PM I have verified and configured the following. Created the Managed Metadata Service. The status is started via Service Applications and Services on Server. Created the User Profiles Service Application and ensured status is started via Service Applications. I started the User Profile Service and User Profile Synchronisation Service via Manage Services on Server.      

New SP 2010 Installation - Can't Get User Profiles / Outlook / My Site stuff working.

Hello,   I have a new SP 2010 Installation. I did NOT set it up in Standalone mode. My users can log in and create their own My Sites. They can edit them, add content, etc. When using Outlook 2010, they add one another in the People Pane. It shows up under My Site > My colleagues that they are connected. However, in Outlook, the MySite icon in the People Pane has a red X on it. I thought that User Profile Sync Service might be the culprit after reading through various blogs. However, if I go to Central Administration > Manage Profile Service : User Profile Service Application... if I click Configure Synchronization Connections, the page comes up - "The query returns nothing." I try to click "Create New Connection"... I get an error message - Cannot navigate to the requested page while User Profile Synchronization is running. Please wait for the current Synchronization to finish.   OK - I thought that the query returned no results. I don't see the service running... can someone point me in the right direction?

MOSS 2007 Metadata using FAST 2010

Is it possible to include custom metatdata from MOSS 2007 sharepoint sites in the crawled index using Sharepoint 2010 with FAST?  If so can you include the steps to configure this correctly.  I am able to crawl and search MOSS 2007 sites but the custom metadata is not available in the results.

User Profiles Error - Failure trying to synch web application... No User Profile Application availab

Hello, everyone, I've got an issue I can't seem to figure out. every since I set up my farn and configured the User Profile Service Application, I've been getting the following error every morning at 6:11 AM: Log Name:      Application Source:        Microsoft-SharePoint Products-SharePoint Portal Server Date:          9/3/2010 6:11:23 AM Event ID:      5555 Task Category: User Profiles Level:         Critical Keywords:      User:          NS\spfarm Computer:      jxnpvsp01.NetworkStreaming.local Description: Failure trying to synch web application 3f3f96cc-8bbd-439c-ae80-1ed633c6ec1d, ContentDB 6ef952b5-3312-46a2-b3e1-1b5218b5d209  Exception message was Microsoft.Office.Server.UserProfiles.UserProfileApplicationNotAvailableException: No User Profile Application available to service the request. Contact your farm administrator.    at Microsoft.Office.Server.Administration.UserProfileApplicationProxy.get_ApplicationProperties()    at Microsoft.Office.Server.Administration.UserProfileApplicationProxy.get_PerfmonInstanceHandle()    at Microsoft.Office.Server.UserProfiles.ContentDBS

how to Upgrade MOSS 2007 to MOSS 2010 ?

how to Upgrade MOSS 2007 to MOSS 2010

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  
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