Shame on me when I renamed a database I made a site lock on my site collection and forgot to unlock it after restoring.
This is difficult to troubleshoot because you think that you made everthing correct. Everything looks fine but you have no access to your site collection. If you have no access to your site collection first check the sitelock on the command line!
stsadm -o getsitelock -url http://<yourSiteCollection>
Your output should be
<SiteLock Lock=“none“ />
If not you can review your eventlog and will see below errors (this two error are repeating each hour)
Event Source: Office SharePoint Server
Event Category: User Profiles
Event ID: 5555
Date: 7/14/2008
Time: 8:00:01 PM
User: N/A
Computer: <yourServerName>
Description:
Failure trying to synch web application ac716e97-0297-4ddf-a6c4-a751034147c6, ContentDB 465225b1-5ced-4a34-8a0c-381cd54d5199 Exception message was A duplicate site ID 86fe2e72-5347-46b2-b7c5-73b92fc8c6db(http://<yourSiteCollection) was found. This might be caused by restoring a content database from one server farm into a different server farm without first removing the original database and then running stsadm -o preparetomove. If this is the cause, the stsadm -o preparetomove command can be used with the -OldContentDB command line option to resolve this issue.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Event Source: Office SharePoint Server
Event Category: Office Server General
Event ID: 7888
Date: 7/14/2008
Time: 8:00:01 PM
User: N/A
Computer: <yourServerName>
Description:
A runtime exception was detected. Details follow.
Message: A duplicate site ID 86fe2e72-5347-46b2-b7c5-73b92fc8c6db(http://<yourSiteCollection>) was found. This might be caused by restoring a content database from one server farm into a different server farm without first removing the original database and then running stsadm -o preparetomove. If this is the cause, the stsadm -o preparetomove command can be used with the -OldContentDB command line option to resolve this issue.
Techinal Details:
Microsoft.Office.Server.UserProfiles.ProfileSynchronizationDuplicateSiteIDException: A duplicate site ID 86fe2e72-5347-46b2-b7c5-73b92fc8c6db(http://<yourSiteCollection>) was found. This might be caused by restoring a content database from one server farm into a different server farm without first removing the original database and then running stsadm -o preparetomove. If this is the cause, the stsadm -o preparetomove command can be used with the -OldContentDB command line option to resolve this issue.
at Microsoft.Office.Server.UserProfiles.ContentDBSynchronizer.RegisterSitesForSynch(Guid[] rgGuid, Int32 nGuids, Object dummy)
at Microsoft.Office.Server.UserProfiles.SynchCollection`2.FlushAdds()
at Microsoft.Office.Server.UserProfiles.ContentDBSynchronizer.AddRemoveSites(String strFirstChangeToken, SPChangeToken lastChangeToken)
at Microsoft.Office.Server.UserProfiles.ContentDBSynchronizer.SynchContentDB()
at Microsoft.Office.Server.Diagnostics.FirstChanceHandler.ExceptionFilter(Boolean fRethrowException, TryBlock tryBlock, FilterBlock filter, CatchBlock catchBlock, FinallyBlock finallyBlock)
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
If you try to access the site collection you will get following error (only if you try to access!)
Event Source: ASP.NET 2.0.50727.0
Event Category: Web Event
Event ID: 1314
Date: 7/14/2008
Time: 9:08:16 PM
User: N/A
Computer: <yourServerName>
Description:
Event code: 4011
Event message: An unhandled access exception has occurred.
Event time: 7/14/2008 9:08:16 PM
Event time (UTC): 7/14/2008 7:08:16 PM
Event ID: 8de7884ebe164cdc9110021e83992184
Event sequence: 77
Event occurrence: 9
Event detail code: 0
Application information:
Application domain: /LM/W3SVC/5294604/Root-1-128605293299491491
Trust level: WSS_Custom
Application Virtual Path: /
Application Path: C:\Inetpub\wwwroot\wss\VirtualDirectories\<dirName>\
Machine name: <yourServerName>
Process information:
Process ID: 3684
Process name: w3wp.exe
Account name: <yourFarmAccount>
Request information:
Request URL: <yourSiteCollection>
Request path: /Pages/default.aspx
User host address: <yourHostName>
User: <yourUserName>
Is authenticated: True
Authentication Type: NTLM
Thread account name: <yourFarmAccount>
Custom event details:
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
I was really confused bacause all the infos what I found wasn’t helpful.
As it always is the resolution is just simple.
Check the sitelock on your site collection
stsadm -o getsitelock -url http://<yourSiteCollection>
Your output should be „<SiteLock Lock=“readonly“ />“
type following command
stsadm -o setsitelock -lock none -url „http://<yourSiteCollection>“
check again the sitelock status
stsadm -o getsitelock -url http://<yourSiteCollection>
Your output should be „<SiteLock Lock=“none“ />“
Because your database is now out of synchronisation you should make following steps:
1) Make a full index of your site collection
2) Check your sync after you crawled the site collection (You should see that the sync of one site collection is different to the others)
stsadm -o sync -ListOldDatabases 0
3) Wait one day (you see the time above)
If you type
stsadm -o sync -ListOldDatabases 0
your see that one database is out of sync
Delete the database which is out of sync
stsadm -o sync -DeleteOldDatabases 1
Now everything should be fine.
Refer my article Rename content database correctly
Timo