bustechllc
asked on
List does not exist - cannot delete thus I cannot crawl/search.
I cannot crawl my site because the url contains a list that does not exist. When I view all site content I see two lists with the same name - one opens correctly, the other does not. I get a:
List does not exist
The page you selected contains a list that does not exist. It may have been deleted by another user.
In the URL bar the name of the list isn't present but is: http://Site:Port/_layouts/ListEdit.aspx?List={CC3CB628-60CC-43C8-AD31-5 E448147321 1}
Is there a way to delete this list, perhaps through sql cmd, so that i can get crawling and search functioning again?
List does not exist
The page you selected contains a list that does not exist. It may have been deleted by another user.
In the URL bar the name of the list isn't present but is: http://Site:Port/_layouts/ListEdit.aspx?List={CC3CB628-60CC-43C8-AD31-5
Is there a way to delete this list, perhaps through sql cmd, so that i can get crawling and search functioning again?
ASKER
Nice idea, I like where you were going with it. Unfortunately: <OrphanedObjects Count="0" />
Soooo....
Soooo....
what's the error in Event Viewer?
ASKER
Nothing relative in event viewer.
I think we need to find a way to delete the list from the sql database?
I think we need to find a way to delete the list from the sql database?
you can do that with a SQL query, but it's unsupported.
that's why i'm trying to get you to give us the error you're seeing. if the search crawler cannot crawl, it should be producing an error in Event viewer.
what is the error you do see, and where do you see it?
that's why i'm trying to get you to give us the error you're seeing. if the search crawler cannot crawl, it should be producing an error in Event viewer.
what is the error you do see, and where do you see it?
ASKER
The Execute method of job definition Microsoft.SharePoint.Admin istration. SPIncoming EmailJobDe finition (ID 4423f619-2915-4013-aeaf-07 83cf592d0c ) threw an exception. More information is included below.
Value cannot be null.
Parameter name: path
A critical error occurred while processing the incoming e-mail drop folder . The error was: Value cannot be null.
Parameter name: path.
Are the only errors I see, they're recurring.
I see an information event for Office Server Search: A new query machine, '<ComputerName>', has been added to the query rotation based on changes to farm topology. Component: 719bf774-d57d-4957-b004-3c 372c405244
But no errors relatiing to Office Server Search.
In the crawl log:
http://Site:Port
The SharePoint list pointed to by this URL does not exist. Verify that it can be accessed using an internet browser. (List does not exist The page you selected contains a list that does not exist. It may have been deleted by another user.)
Value cannot be null.
Parameter name: path
A critical error occurred while processing the incoming e-mail drop folder . The error was: Value cannot be null.
Parameter name: path.
Are the only errors I see, they're recurring.
I see an information event for Office Server Search: A new query machine, '<ComputerName>', has been added to the query rotation based on changes to farm topology. Component: 719bf774-d57d-4957-b004-3c
But no errors relatiing to Office Server Search.
In the crawl log:
http://Site:Port
The SharePoint list pointed to by this URL does not exist. Verify that it can be accessed using an internet browser. (List does not exist The page you selected contains a list that does not exist. It may have been deleted by another user.)
do you have AAM configured?
see here:
http://support.microsoft.com/kb/970946
"When you try to do a search in a SharePoint site, the scope "This List: Name of list, doclib etc." for a particular listis missing. This issue occurs because you are using the Extended Web Applications and the Alternative Access Mapping (AAM) settings. "
if that's the case, i'd backup your site, and run updates.
see here:
http://support.microsoft.com/kb/970946
"When you try to do a search in a SharePoint site, the scope "This List: Name of list, doclib etc." for a particular listis missing. This issue occurs because you are using the Extended Web Applications and the Alternative Access Mapping (AAM) settings. "
if that's the case, i'd backup your site, and run updates.
ASKER
Yeah, that isn't exactly the error I'm getting. I'm not using Extended Web Applications, and I can do a search on the site, but it comes up with zero results because the site hasn't been crawled. I can't crawl the site because it contains a list that does not exist.
Any other suggestions?
Any other suggestions?
try the command here:
http://bloggingabout.net/blogs/harold/archive/2009/01/10/deleting-a-broken-sharepoint-list-using-stsadm.aspx
like i said, there is a way to do this via SQL... just trying to avoid that option because it's not a supported method, and MS says it's a big no-no to interact with sharepoint directly in SQL.
http://bloggingabout.net/blogs/harold/archive/2009/01/10/deleting-a-broken-sharepoint-list-using-stsadm.aspx
like i said, there is a way to do this via SQL... just trying to avoid that option because it's not a supported method, and MS says it's a big no-no to interact with sharepoint directly in SQL.
p.s. also, i'd make a backup of the "real" list before trying to delete the broken one.
ASKER
Ok, backed up the real list and deleted it (actually, it's a document library to be exact, but still). Then I ran that command and got the following error:
The system cannot find the file specified. (Exception from HRESULT: 0x80070002)
Tried using the stsadm command using the URL that list was at (http://site:port/DocLibraryname) and also using:
http://Site:Port/_layouts/ListEdit.aspx?List={CC3CB628-60CC-43C8-AD31-5 E448147321 1}
http://Site:Port/{CC3CB628-60CC-43C8-AD31-5 E448147321 1}
No luck. :(
The system cannot find the file specified. (Exception from HRESULT: 0x80070002)
Tried using the stsadm command using the URL that list was at (http://site:port/DocLibraryname) and also using:
http://Site:Port/_layouts/ListEdit.aspx?List={CC3CB628-60CC-43C8-AD31-5
http://Site:Port/{CC3CB628-60CC-43C8-AD31-5
No luck. :(
well...
maybe you might consider trying a direct delete from the db. make sure you do a complete farm backup first. it's completely against MS's recommendation, by the way.
if you proceed, i'd recommend that you start by becoming more familiar with how sharepoint stores data in sql. this will help:
http://weblogs.sqlteam.com/jhermiz/archive/2007/08/15/60288.aspx
you'll then need to apply that knowledge to constructing a TSQL DELETE statement.
maybe you might consider trying a direct delete from the db. make sure you do a complete farm backup first. it's completely against MS's recommendation, by the way.
if you proceed, i'd recommend that you start by becoming more familiar with how sharepoint stores data in sql. this will help:
http://weblogs.sqlteam.com/jhermiz/archive/2007/08/15/60288.aspx
you'll then need to apply that knowledge to constructing a TSQL DELETE statement.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
if that fixed your problem, select your post as Accept as Solution
;)
;)
ASKER
Done
Try this one: http://technet.microsoft.com/en-us/library/cc263282(office.12).aspx
Good luck.