"Erro no Serviço da Web de Dados do Site" ao executar o rastreamento

1

Instalado o SharePoint Services v3 (SP2, atualizações cumulativas de outubro de 2009, Language Pack), anexado a um banco de dados de conteúdo que eu tinha anteriormente (todas as obras). O servidor de pesquisa instalado 2008 Express (com pacote de idiomas) sobre o WSS e o rastreamento não funcionam . No entanto, ele funciona para o aplicativo da Web + banco de dados recém-criado.

Estava brincando com contas, permissões para tentar fazê-lo funcionar. Atualmente eu tenho conta WSS_Crawler com tais permissões:

  • o Office Search Server é executado com a conta WSS_Crawler
  • O banco de dados de configuração tem permissões de leitura para o WSS_Crawler
  • O banco de dados de conteúdo tem permissões de leitura para o WSS_Crawler
  • WSS_Crawler é o proprietário do banco de dados de pesquisa.
  • Adicionado WSS_Crawler ao grupo de usuários e ao administrador do navegador do servidor SQL

Sim, recebi mais permissões do que o necessário, mas nem sequer funciona com isso e não sei se o problema de permissão ou o quê.

O log de rastreamento diz que há Erro no serviço da Web de dados do site. , nada mais. Havia problemas conhecidos com um erro similar : Error in the Site Data Web Service. (Value does not fall within the expected range.) , mas este não é o caso, já que é um problema antigo e espero que tenha sido incluído no SP2 ...

Os registros são de antigos para novos (ordem decrescente). Eles não parecem ser muito úteis.

Log de rastreamento

  • link Escritório local rastreado Sites do SharePoint Server 15/03/2010 9:39 AM
  • sts3: // serveris Escritório local rastreado Sites do SharePoint Server 15/03/2010 9:39 AM
  • sts3: // serveris / contentdbid = {55180cfa-9d2d-46e4 ... Escritório local rastreado do SharePoint Sites do servidor 15/03/2010 09:39
  • link Erro no Serviço Web de dados do site. Escritório local Sites do SharePoint Server 15/03/2010 9:39 AM
  • link Erro no site Serviço Web de dados. Escritório local Sites do SharePoint Server 15/03/2010 9:39 AM

EventLog

Nenhum erro no EventLog, apenas alguns eventos de Informações que o Office Server Search fornece

  • O serviço de pesquisa foi iniciado.
  • Armazenou com êxito o aplicativo
    instantâneo de registro de configuração no
    o banco de dados. Contexto: aplicativo
    'SharedServices
  • Componente: da1288b2-4109-4219-8c0c-3a22802eb842 Catálogo: Portal_Content. Uma mesclagem mestre foi iniciada devido a uma solicitação externa.
  • Componente: da1288b2-4109-4219-8c0c-3a22802eb842 Uma mesclagem mestre foi concluída para o catálogo Portal_Content.
  • Componente: da1288b2-4109-4219-8c0c-3a22802eb842 Catálogo: AnchorProject. Uma mesclagem mestre foi iniciada devido a uma solicitação externa.
  • Componente: da1288b2-4109-4219-8c0c-3a22802eb842 Uma mesclagem mestre foi concluída para o catálogo AnchorProject.

Log ULS

Apenas algumas informações, mas sem exceções, erros inesperados

03/15/2010 09:03:28.28  mssearch.exe (0x1B2C)                       0x0E8C  Search Server Common            GatherStatus                    0   Monitorable Insert crawl 771 to inprogress queue hr 0x00000000 - File:d:\office\source\search\search\gather\server\gatherobj.cxx Line:6591   
03/15/2010 09:03:28.28  mssearch.exe (0x1B2C)                       0x0E8C  Search Server Common            GatherStatus                    0   Monitorable Request Start Crawl 1, project Portal_Content, crawl 771 - File:d:\office\source\search\search\gather\server\gatherobj.cxx Line:2875     
03/15/2010 09:03:28.28  mssearch.exe (0x1B2C)                       0x0E8C  Search Server Common            GatherStatus                    0   Monitorable Advise status change 1, project Portal_Content, crawl 771 - File:d:\office\source\search\search\gather\server\gatherobj.cxx Line:4853    
03/15/2010 09:03:28.28  w3wp.exe (0x1D98)                           0x0958  Search Server Common            MS Search Administration        8wn6    Information A full crawl was started on 'Local Office SharePoint Server sites' by BALTICOVO\janis.veinbergs.     
03/15/2010 09:03:28.43  mssdmn.exe (0x1750)                         0x10F8  ULS Logging                     Unified Logging Service         8wsv    High        ULS Init Completed (mssdmn.exe, Microsoft.Office.Server.Native.dll)  
03/15/2010 09:03:30.48  mssdmn.exe (0x1750)                         0x09C0  Search Server Common            MS Search Indexing              8z0v    Medium      Create CCache    
03/15/2010 09:03:30.56  mssdmn.exe (0x1750)                         0x09C0  Search Server Common            MS Search Indexing              8z0z    Medium      Create CUserCatalogCache     
03/15/2010 09:03:32.06  w3wp.exe (0x1D98)                           0x0958  Search Server Common            MS Search Administration        90ge    Medium      SQL: dbo.proc_MSS_PropagationGetQueryServers     
03/15/2010 09:03:32.09  w3wp.exe (0x1D98)                           0x0958  Search Server Common            MS Search Administration        7phq    High        GetProtocolConfigHelper failed in GetNotesInterface().   
03/15/2010 09:03:34.26  mssearch.exe (0x1B2C)                       0x16A4  Search Server Common            GatherStatus                    0   Monitorable Advise status change 12, project Portal_Content, crawl -1 - File:d:\office\source\search\search\gather\server\gatherobj.cxx Line:4853    
03/15/2010 09:03:35.92  mssearch.exe (0x1B2C)                       0x16A4  Search Server Common            GatherStatus                    0   Monitorable Advise status change 12, project Portal_Content, crawl -1 - File:d:\office\source\search\search\gather\server\gatherobj.cxx Line:4853    
03/15/2010 09:03:37.32  mssearch.exe (0x1B2C)                       0x16A4  Search Server Common            GatherStatus                    0   Monitorable Advise status change 12, project Portal_Content, crawl -1 - File:d:\office\source\search\search\gather\server\gatherobj.cxx Line:4853    
03/15/2010 09:03:37.23  mssdmn.exe (0x1750)                         0x1850  Search Server Common            MS Search Indexing              8z14    Medium      Test TRACE (NULL):(null), (NULL)(null), (CrLf):  , end   
03/15/2010 09:03:39.04  mssearch.exe (0x1B2C)                       0x16A4  Search Server Common            GatherStatus                    0   Monitorable Advise status change 12, project Portal_Content, crawl -1 - File:d:\office\source\search\search\gather\server\gatherobj.cxx Line:4853    
03/15/2010 09:03:40.98  mssdmn.exe (0x1750)                         0x0B24  Search Server Common            MS Search Indexing              7how    Monitorable GetWebDefaultPage fail. error 2147755542, strWebUrl http://serveris  
03/15/2010 09:03:41.87  mssdmn.exe (0x1750)                         0x1260  Search Server Common            PHSts                           0   Monitorable CSTS3Accessor::GetSubWebListItemAccessURL GetAccessURL failed: Return error to caller, hr=80042616 - File:d:\office\source\search\search\gather\protocols\sts3\sts3acc.cxx Line:505  
03/15/2010 09:03:41.87  mssdmn.exe (0x1750)                         0x1260  Search Server Common            PHSts                           0   Monitorable CSTS3Accessor::Init: GetSubWebListItemAccessURL failed. Return error to caller, hr=80042616 - File:d:\office\source\search\search\gather\protocols\sts3\sts3acc.cxx Line:348     
03/15/2010 09:03:41.87  mssdmn.exe (0x1750)                         0x1260  Search Server Common            PHSts                           0   Monitorable CSTS3Accessor::Init fails, Url sts3://serveris/siteurl=test/siteid={390611b2-55f3-4a99-8600-778727177a28}/weburl=/webid={fb0e4bff-65d5-4ded-98d5-fd099456962b}, hr=80042616 - File:d:\office\source\search\search\gather\protocols\sts3\sts3handler.cxx Line:243     
03/15/2010 09:03:41.87  mssdmn.exe (0x1750)                         0x1260  Search Server Common            PHSts                           0   Monitorable CSTS3Handler::CreateAccessorExB: Return error to caller, hr=80042616 - File:d:\office\source\search\search\gather\protocols\sts3\sts3handler.cxx Line:261    
03/15/2010 09:03:40.98  mssdmn.exe (0x1750)                         0x1260  Search Server Common            MS Search Indexing              7how    Monitorable GetWebDefaultPage fail. error 2147755542, strWebUrl http://serveris/test     
03/15/2010 09:03:41.90  mssdmn.exe (0x1750)                         0x0B24  Search Server Common            PHSts                           0   Monitorable CSTS3Accessor::GetSubWebListItemAccessURL GetAccessURL failed: Return error to caller, hr=80042616 - File:d:\office\source\search\search\gather\protocols\sts3\sts3acc.cxx Line:505  
03/15/2010 09:03:41.90  mssdmn.exe (0x1750)                         0x0B24  Search Server Common            PHSts                           0   Monitorable CSTS3Accessor::Init: GetSubWebListItemAccessURL failed. Return error to caller, hr=80042616 - File:d:\office\source\search\search\gather\protocols\sts3\sts3acc.cxx Line:348     
03/15/2010 09:03:41.90  mssdmn.exe (0x1750)                         0x0B24  Search Server Common            PHSts                           0   Monitorable CSTS3Accessor::Init fails, Url sts3://serveris/siteurl=/siteid={505443fa-ef12-4f1e-a04b-d5450c939b78}/weburl=/webid={c5a4f8aa-9561-4527-9e1a-b3c23200f11c}, hr=80042616 - File:d:\office\source\search\search\gather\protocols\sts3\sts3handler.cxx Line:243     
03/15/2010 09:03:41.90  mssdmn.exe (0x1750)                         0x0B24  Search Server Common            PHSts                           0   Monitorable CSTS3Handler::CreateAccessorExB: Return error to caller, hr=80042616 - File:d:\office\source\search\search\gather\protocols\sts3\sts3handler.cxx Line:261    
03/15/2010 09:03:43.26  mssearch.exe (0x1B2C)                       0x0750  Search Server Common            GatherStatus                    0   Monitorable Advise status change 24, project Portal_Content, crawl 771 - File:d:\office\source\search\search\gather\server\gatherobj.cxx Line:4853   
03/15/2010 09:03:43.26  mssearch.exe (0x1B2C)                       0x1804  Search Server Common            GatherStatus                    0   Monitorable Remove crawl 771 from inprogress queue - File:d:\office\source\search\search\gather\server\gatherobj.cxx Line:6722   
03/15/2010 09:03:43.26  mssearch.exe (0x1B2C)                       0x0750  Search Server Common            GatherStatus                    0   Monitorable Advise status change 12, project Portal_Content, crawl -1 - File:d:\office\source\search\search\gather\server\gatherobj.cxx Line:4853    
03/15/2010 09:03:44.65  mssearch.exe (0x1B2C)                       0x1804  Search Server Common            GatherStatus                    0   Monitorable Insert crawl 772 to inprogress queue hr 0x00000000 - File:d:\office\source\search\search\gather\server\gatherobj.cxx Line:6591   
03/15/2010 09:03:44.65  mssearch.exe (0x1B2C)                       0x1804  Search Server Common            GatherStatus                    0   Monitorable Request Start Crawl 0, project AnchorProject, crawl 772 - File:d:\office\source\search\search\gather\server\gatherobj.cxx Line:2875  
03/15/2010 09:03:44.65  mssearch.exe (0x1B2C)                       0x1804  Search Server Common            GatherStatus                    0   Monitorable Advise status change 0, project AnchorProject, crawl 772 - File:d:\office\source\search\search\gather\server\gatherobj.cxx Line:4853     
03/15/2010 09:03:44.65  mssearch.exe (0x1B2C)                       0x1804  Search Server Common            GatherStatus                    0   Monitorable Unlock Queue, project Portal_Content - File:d:\office\source\search\search\gather\server\gatherobj.cxx Line:2922     
03/15/2010 09:03:44.82  mssearch.exe (0x1B2C)                       0x1DD0  Search Server Common            GathererSql                     0   Monitorable CGatherer::LoadTransactionsFromCrawlInternal Flush anchor, count 0 - File:d:\office\source\search\search\gather\server\gatherobj.cxx Line:4943   
03/15/2010 09:03:44.95  mssearch.exe (0x1B2C)                       0x0750  Search Server Common            GatherStatus                    0   Monitorable Advise status change 12, project AnchorProject, crawl -1 - File:d:\office\source\search\search\gather\server\gatherobj.cxx Line:4853     
03/15/2010 09:03:46.51  mssearch.exe (0x1B2C)                       0x0750  Search Server Common            GatherStatus                    0   Monitorable Advise status change 12, project AnchorProject, crawl -1 - File:d:\office\source\search\search\gather\server\gatherobj.cxx Line:4853     
03/15/2010 09:03:46.39  mssearch.exe (0x1B2C)                       0x1E4C  Search Server Common            GathererSql                     0   Monitorable CGatherer::LoadTransactionsFromCrawlInternal Flush anchor, count 0 - File:d:\office\source\search\search\gather\server\gatherobj.cxx Line:4943   
03/15/2010 09:03:49.01  mssearch.exe (0x1B2C)                       0x1C6C  Search Server Common            GathererSql                     0   Monitorable CGatherer::LoadTransactionsFromCrawlInternal Flush anchor, count 1 - File:d:\office\source\search\search\gather\server\gatherobj.cxx Line:4943   
03/15/2010 09:03:49.87  mssearch.exe (0x1B2C)                       0x155C  Search Server Common            GathererSql                     0   Monitorable CGatherer::LoadTransactionsFromCrawlInternal Flush anchor, count 1 - File:d:\office\source\search\search\gather\server\gatherobj.cxx Line:4943   
03/15/2010 09:03:49.29  mssearch.exe (0x1B2C)                       0x155C  Search Server Common            GathererSql                     0   Monitorable CGatherer::LoadTransactionsFromCrawlInternal Flush anchor, count 1 - File:d:\office\source\search\search\gather\server\gatherobj.cxx Line:4943   
03/15/2010 09:03:49.53  mssearch.exe (0x1B2C)                       0x155C  Search Server Common            GathererSql                     0   Monitorable CGatherer::LoadTransactionsFromCrawlInternal Flush anchor, count 1 - File:d:\office\source\search\search\gather\server\gatherobj.cxx Line:4943   
03/15/2010 09:03:49.67  mssearch.exe (0x1B2C)                       0x155C  Search Server Common            GathererSql                     0   Monitorable CGatherer::LoadTransactionsFromCrawlInternal Flush anchor, count 1 - File:d:\office\source\search\search\gather\server\gatherobj.cxx Line:4943   
03/15/2010 09:03:49.82  mssearch.exe (0x1B2C)                       0x155C  Search Server Common            GathererSql                     0   Monitorable CGatherer::LoadTransactionsFromCrawlInternal Flush anchor, count 1 - File:d:\office\source\search\search\gather\server\gatherobj.cxx Line:4943   
03/15/2010 09:03:49.84  mssearch.exe (0x1B2C)                       0x155C  Search Server Common            GathererSql                     0   Monitorable CGatherer::LoadTransactionsFromCrawlInternal Flush anchor, count 0 - File:d:\office\source\search\search\gather\server\gatherobj.cxx Line:4943   
03/15/2010 09:03:49.89  mssearch.exe (0x1B2C)                       0x155C  Search Server Common            GathererSql                     0   Monitorable CGatherer::LoadTransactionsFromCrawlInternal Flush anchor, count 0 - File:d:\office\source\search\search\gather\server\gatherobj.cxx Line:4943   
03/15/2010 09:03:49.90  mssearch.exe (0x1B2C)                       0x0750  Search Server Common            GatherStatus                    0   Monitorable Advise status change 12, project AnchorProject, crawl -1 - File:d:\office\source\search\search\gather\server\gatherobj.cxx Line:4853     
03/15/2010 09:03:51.42  mssearch.exe (0x1B2C)                       0x1E4C  Search Server Common            GatherStatus                    0   Monitorable Advise status change 4, project AnchorProject, crawl 772 - File:d:\office\source\search\search\gather\server\gatherobj.cxx Line:4853     
03/15/2010 09:03:51.00  mssearch.exe (0x1B2C)                       0x1E4C  Search Server Common            GathererSql                     0   Monitorable CGatherer::LoadTransactionsFromCrawlInternal Flush anchor, count 0 - File:d:\office\source\search\search\gather\server\gatherobj.cxx Line:4943   
03/15/2010 09:03:51.42  mssearch.exe (0x1B2C)                       0x1CCC  Search Server Common            GatherStatus                    0   Monitorable Remove crawl 772 from inprogress queue - File:d:\office\source\search\search\gather\server\gatherobj.cxx Line:6722   
03/15/2010 09:03:52.96  mssearch.exe (0x1B2C)                       0x1CCC  Search Server Common            GatherStatus                    0   Monitorable Insert crawl 773 to inprogress queue hr 0x00000000 - File:d:\office\source\search\search\gather\server\gatherobj.cxx Line:6591   
03/15/2010 09:03:52.96  mssearch.exe (0x1B2C)                       0x1CCC  Search Server Common            GatherStatus                    0   Monitorable Request Start Crawl 0, project AnchorProject, crawl 773 - File:d:\office\source\search\search\gather\server\gatherobj.cxx Line:2875  
03/15/2010 09:03:55.29  mssearch.exe (0x1B2C)                       0x1CCC  Search Server Common            GatherStatus                    0   Monitorable Unlock Queue, project AnchorProject - File:d:\office\source\search\search\gather\server\gatherobj.cxx Line:2922  
03/15/2010 09:03:55.29  mssearch.exe (0x1B2C)                       0x1CCC  Search Server Common            GatherStatus                    0   Monitorable Removed start crawl request from Queue 0, crawl 773  - File:d:\office\source\search\search\gather\server\gatherobj.cxx Line:2942     
03/15/2010 09:03:55.29  mssearch.exe (0x1B2C)                       0x1CCC  Search Server Common            GatherStatus                    0   Monitorable Request Start Crawl 0, project AnchorProject, crawl 773 - File:d:\office\source\search\search\gather\server\gatherobj.cxx Line:2875  
03/15/2010 09:03:55.29  mssearch.exe (0x1B2C)                       0x1CCC  Search Server Common            GatherStatus                    0   Monitorable Advise status change 0, project AnchorProject, crawl 773 - File:d:\office\source\search\search\gather\server\gatherobj.cxx Line:4853     
03/15/2010 09:03:55.37  mssearch.exe (0x1B2C)                       0x1CCC  Search Server Common            GathererSql                     0   Monitorable CGatherer::LoadTransactionsFromCrawlInternal Flush anchor, count 0 - File:d:\office\source\search\search\gather\server\gatherobj.cxx Line:4943   
03/15/2010 09:03:55.37  mssearch.exe (0x1B2C)                       0x0750  Search Server Common            GatherStatus                    0   Monitorable Advise status change 12, project AnchorProject, crawl -1 - File:d:\office\source\search\search\gather\server\gatherobj.cxx Line:4853     
03/15/2010 09:03:56.71  mssearch.exe (0x1B2C)                       0x1E4C  Search Server Common            GathererSql                     0   Monitorable CGatherer::LoadTransactionsFromCrawlInternal Flush anchor, count 0 - File:d:\office\source\search\search\gather\server\gatherobj.cxx Line:4943   
03/15/2010 09:03:56.78  mssearch.exe (0x1B2C)                       0x0750  Search Server Common            GatherStatus                    0   Monitorable Advise status change 12, project AnchorProject, crawl -1 - File:d:\office\source\search\search\gather\server\gatherobj.cxx Line:4853     
03/15/2010 09:03:58.40  mssearch.exe (0x1B2C)                       0x155C  Search Server Common            GathererSql                     0   Monitorable CGatherer::LoadTransactionsFromCrawlInternal Flush anchor, count 0 - File:d:\office\source\search\search\gather\server\gatherobj.cxx Line:4943   
03/15/2010 09:03:58.89  mssearch.exe (0x1B2C)                       0x155C  Search Server Common            GatherStatus                    0   Monitorable Advise status change 4, project AnchorProject, crawl 773 - File:d:\office\source\search\search\gather\server\gatherobj.cxx Line:4853     
03/15/2010 09:03:58.89  mssearch.exe (0x1B2C)                       0x1130  Search Server Common            GatherStatus                    0   Monitorable Remove crawl 773 from inprogress queue - File:d:\office\source\search\search\gather\server\gatherobj.cxx Line:6722   
03/15/2010 09:03:58.89  mssearch.exe (0x1B2C)                       0x1130  Search Server Common            GatherStatus                    0   Monitorable Unlock Queue, project AnchorProject - File:d:\office\source\search\search\gather\server\gatherobj.cxx Line:2922  

O que poderia estar errado aqui - alguma pista?

    
por Janis Veinbergs 15.03.2010 / 12:07

3 respostas

2

Isso pode ser um problema se sua tabela UserInfo no banco de dados tiver SIDs corrompidos nela. Eu definitivamente poderia ver isso acontecendo se você anexasse um banco de dados existente ao invés de fazer backup / restauração. A maneira de testar / corrigir é:

  1. Execute o seguinte comando no seu banco de dados de conteúdo no SQL Server:

    Selecione tp_login, tp_systemid, tp_deleted de userinfo onde len (ltrim (rtrim (tp_systemid))) < 25 e tp_deleted = 0

  2. Para qualquer usuário retornado pela consulta (exceto para usuários do sistema), conceda ao usuário permissão de leitura na raiz do conjunto de sites. (Os usuários do sistema incluem: NT AUTHORITY\authenticated users, NT AUTHORITY\local service, NT AUTHORITY\system, SHAREPOINT\system

  3. Execute novamente a consulta para garantir que ela não tenha resultados; quando não houver resultados, inicie um rastreamento completo.

Aqui é uma postagem no blog que fala sobre esta solução.

    
por 15.03.2010 / 15:13
1

Eu tive o mesmo problema hoje. Descobriu que os sites não estavam abrindo a partir do servidor de indexação. O web.config foi corrompido com entradas duplicadas. Limpar isso resolveu o problema.

    
por 06.09.2011 / 20:21
0

Depois de esperar, a pesquisa começou a funcionar ... não sei o que causou o problema. O importante é que isso funciona!

    
por 16.04.2011 / 12:19