Solved

List does not exist - cannot delete thus I cannot crawl/search.

Posted on 2010-09-08
15
1,411 Views
Last Modified: 2012-05-10
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-5E4481473211}

Is there a way to delete this list, perhaps through sql cmd, so that i can get crawling and search functioning again?
0
Comment
Question by:bustechllc
  • 7
  • 7
15 Comments
 
LVL 2

Expert Comment

by:exoduster
ID: 33627784
0
 

Author Comment

by:bustechllc
ID: 33628333
Nice idea, I like where you were going with it. Unfortunately: <OrphanedObjects Count="0" />

Soooo....
0
 
LVL 42

Expert Comment

by:zephyr_hex (Megan)
ID: 33629728
what's the error in Event Viewer?
0
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 

Author Comment

by:bustechllc
ID: 33630159
Nothing relative in event viewer.

I think we need to find a way to delete the list from the sql database?
0
 
LVL 42

Expert Comment

by:zephyr_hex (Megan)
ID: 33630345
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?
0
 

Author Comment

by:bustechllc
ID: 33630466
The Execute method of job definition Microsoft.SharePoint.Administration.SPIncomingEmailJobDefinition (ID 4423f619-2915-4013-aeaf-0783cf592d0c) 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-3c372c405244

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.)
0
 
LVL 42

Expert Comment

by:zephyr_hex (Megan)
ID: 33630576
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.
0
 

Author Comment

by:bustechllc
ID: 33630760
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?

0
 
LVL 42

Expert Comment

by:zephyr_hex (Megan)
ID: 33631701
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.
0
 
LVL 42

Expert Comment

by:zephyr_hex (Megan)
ID: 33631728
p.s.  also, i'd make a backup of the "real" list before trying to delete the broken one.
0
 

Author Comment

by:bustechllc
ID: 33633050
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-5E4481473211}
http://Site:Port/{CC3CB628-60CC-43C8-AD31-5E4481473211}

No luck. :(

0
 
LVL 42

Expert Comment

by:zephyr_hex (Megan)
ID: 33643045
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.
0
 

Accepted Solution

by:
bustechllc earned 0 total points
ID: 33684767
Thanks. I rebuilt the site.
0
 
LVL 42

Expert Comment

by:zephyr_hex (Megan)
ID: 33783197
if that fixed your problem, select your post as Accept as Solution
;)
0
 

Author Closing Comment

by:bustechllc
ID: 34040439
Done
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Summary In SharePoint 2010 it is easy to create custom color themes to jazz up a site. Theme colors can also be created in PowerPoint 2010 with a few clicks. But how do the chosen colors actually look in the SharePoint site? The attached PowerPoint…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now