Wednesday, September 4, 2013

Error Deleting Site Collection The system cannot find the path specified

Here is the interesting issue i came across while doing some migrations.

Post migration when i try to delete site collections from SP 2007 envionment, I deleted a site collection which is huge in size the operation went for such a long time and finally resulted failure to delete the site collection.

After that when i see the site collection from CA i see the site collection listed in CA but none of the properties for the site collection were listed there like Title, URL, Description, Database name.
All the above properties were empty.

An error like this prevents you from upgrading SharePoint aswell, because you won't be able to access the site collection either

Root cause :  The site collection deleted from content database but some references still there in database.

Solution :

1. Execute database repair command : 

Execute the following two commands one after one.

STSADM.EXE -o databaserepair -url "url of the application" -databasename "Name of the DB" >"C:\Result.txt"

STSADM.EXE -o databaserepair -url "url of the application" -databasename "Name of the DB" -deletecorruption

First command should result as <OrphanedObjects Count="0" />

2. Delete and add Content DB : 

To resolve the error, detach and attach the content database of the afflicted site collection.

stsadm -o deletecontentdb -databasename "DB name" -url "site collection url"

stsadm -o addcontentdb -databasename "DB name" -url "site collection url" 

NOTE : Executing above script will not delete anything in the content database except the issue causing things or partially deleted site collections.

After this you can go and check in CA and found the site collections deleted completely. 

Thank you !!!


 



12 comments:


  1. SharePoint utilizes a windows Service sharepoint development
    for logging. some of the time, such as amid sending, you will discover the log document is growing couple of hundreds megabytes in brief time. So following administration may play a bit part in execution. On the off chance that you needn't bother with the log petition for a timeframe, you can handicap the windows benefit. Amid advancement I typically impair the administration and when I have to see the log document, I empower the administration.Visit Here-http://aufait.in/sharepoint or call us-+91 80 46557800

    ReplyDelete
  2. It’s great to come across a blog every once in a while that isn’t the same out of date rehashed material. Fantastic read.
    Data science Course Training in Chennai |Best Data Science Training Institute in Chennai
    RPA Course Training in Chennai |Best RPA Training Institute in Chennai
    AWS Course Training in Chennai |Best AWS Training Institute in Chennai
    Devops Course Training in Chennai |Best Devops Training Institute in Chennai
    Selenium Course Training in Chennai |Best Selenium Training Institute in Chennai
    Java Course Training in Chennai | Best Java Training Institute in Chennai

    ReplyDelete
  3. I am obliged to you for sharing this piece of information here and updating us with your resourceful guidance. Hope this might benefit many learners. Keep sharing this gainful articles and continue updating us.
    Blue Prism Training in Chennai
    Blue Prism Course in Chennai
    Angularjs Training in Chennai
    AWS Training in Chennai
    Big Data Analytics Courses in Chennai
    CCNA Course in Chennai
    SEO Training in Chennai
    Blue Prism Training in Tambaram

    ReplyDelete
  4. Its very nice post and useful to understand. Thanks for sharing your knowledge
    Sharepoint Training in Electronic City

    ReplyDelete
  5. Very useful post. I found so many interesting stuff in your blog especially its discussion. Really it's great article. oracle training in chennai

    ReplyDelete



  6. This post is so interactive and informative.keep update more information...
    Tally Course in Chennai
    Tally Classes in Chennai
    Online Tally Course

    ReplyDelete