MOSS 2007 Error While Central Administration Navigation
MOSS 2007 SQL ServerHi There,
Repairing the table automatically deleted the uncommitted row and and we were able to select all items from that table. Magically the CA returned back and everything seems working now.
Happy SharePointing...!
We got an error while using SharePoint 2007 or MOSS 2007 in our production farm that whenever we navigate to few links in MOSS 2007, the pages seems crashing. SharePoint threw some unexpected errors with a correlation ID. Nothing special found in ULS logs regarding this crash. SharePoint was working fine with no issue. Each and every MOSS site was working as expected. The issue was only with SharePoint 2007 Central Administration. After some troubleshooting we were able to locate some error and noticed that its throwing from SQL server side not any SharePoint crash. Digging out more confirmed its a SQL server issue. Below are the error details.
Error:
|
Solution:
We found that there is a table in SharePoint_Config with name Objects. We selected all rows from that table and found the same error. The reason was an uncommitted SQL query. A row in this table was not successfully committed and SQL server was failing while selecting all items. Luckily we found that item (by selecting the top items etc) with some tricks. The item ID was '05c7c555-736e-45ac-ab0a-8a47012877e3'. We did a trick and quried all items except the problematic one and it worked.
select * from objects where id <> '05c7c555-736e-45ac-ab0a-8a47012877e3'
Now we found the problem and tried to fix using below technique which worked fine.
ALTER DATABASE SharePoint_Config SET SINGLE_USER WITH ROLLBACK IMMEDIATE
GO
ALTER DATABASE SharePoint_Config SET SINGLE_USER
GO
DBCC CHECKDB (SharePoint_Config, REPAIR_ALLOW_DATA_LOSS)
GO
Now repair the table.
USE SharePoint_Config;
GO
DBCC CHECKTABLE ('dbo.Objects',REPAIR_REBUILD)
GO
Happy SharePointing...!
