Sharepoint Answers

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds
  Question Asked By: Jordan Cooper   on Aug 26 In Sharepoint Category.

Question Answered By: Nagesh Maulik   on Aug 26

I have a bit more information on this one as i now have something resembling
working  site.

The problem i was experiencing seemed to be relating to the Shared Services
Database that the migration process was trying to create. When investigated
further, it appeared the database had not been successfully created. The
shared service was also stuck with "provisioning" next to it in the "manage
this farm's shared services" page in Central Administration.

There were a couple of errors  in the Application event log that could be
related. The first was event id 0 from Windows Sharepoint Services 3 which
*"Could not determine if application pool Upgrade_App_Pool uses an
incompatible version of ASP. Ensure all sites associated with this
application pool are using the same version. Additional information is

*The method or operation is not implemented."*
Followed not long after by Event id 5586, also from Windows Sharepoint
Services 3 which said;
*Unknown SQL Exception 547 occured. Additional error information from SQL
Server is included below.*

*DELETE statement conflicted with COLUMN REFERENCE constraint
'FK_Dependencies1_Objects'. The conflict occurred in database
'SharePoint_Config', table 'Dependencies', column 'ObjectId'.
The statement has been terminated.*
I did try to created an SSP before upgrading the content, but there doesn't
seem to be an option (that i could see) to use an existing SSP for the
purpose of migration (admittedly i didn't explore the command line route).

The shared service database did actually exist in the database, but there
were no stored procedures and only some of the tables. While it was in that
state, i created a new SSP and then copied the stored procedures over. I
then associated the migrated sites with the newly created SSP and was then
able to delete the SSP that was created by the migration process.

Once that was ticking along nicely, i then started the process of upgrading
the sites, which has now successfully completed.

So i am almost there... the only problem i seem to have now is that the
migration process doesn't like my SSP configuration which has different web
applications for main site and my site. If anyone is still reading this,
any thoughts would be greatfully received!!



This Question has 2 more answer(s). View Complete Question Thread

Didn't find what you were looking for? Find more on Search not working after MOSS upgrade Or get search suggestion and latest updates.