SQL Server PDF全文搜索无法在FileStream PDF文件上工作 [英] SQL Server PDF Full-Text Search not working on FileStream PDF File

问题描述

我无法使用全文搜索来处理我通过FileStream加载到SQL Db中的PDF文件。

版本：SQL Server 2008 R2（开发版 - 做概念验证）
操作系统：Windows 7

• 安装Adobe iFilter


• 确保SQL Server已满文本守护程序服务正在运行


• 添加了Adobe PDF Filter bin目录的环境路径



• 运行以下脚本以设置新的iFilter并确保它是
  active
  
  

    EXEC sp_fulltext_service @ action ='load_os_resources'，@ value = 1; - 更新os资源
   EXEC sp_fulltext_service'verify_signature'，0  - 不验证签名
   EXEC sp_fulltext_service'update_languages'; - 更新语言列表
   EXEC sp_fulltext_service'restart_all_fdhosts'; - 重新启动守护进程
   EXEC sp_help_fulltext_system_components'filter'; - 查看活动过滤器
    




• 在我想要的FileStream表上创建全文索引索引
  
  

    CREATE FULLTEXT INDEX on local.FILE_REPOSITORY 
  （DOCUMENT TYPE COLUMN FILE_EXTENSION）
  键索引PK_File_Repository ON 
  （FileSearchCat，FILEGROUP [PRIMARY]）; 
   GO 
    




• 重建目录

    ALTER FULLTEXT CATALOG FileSearchCatREBUILD WITH ACCENT_SENSITIVITY = OFF; 
    




• 进行查询以查看索引是否正常工作
  
  

    select * 
   from local.FILE_REPOSITORYwhere freetext（DOCUMENT，'25678'）
    

不返回任何PDF结果，但对word（docx）正常工作？

我做错了什么？

解决方案

好吧，我明白了......我需要运行这些步骤：

  EXEC sp_fulltext_service @ action ='load_os_resources'，@ value = 1; - 更新os资源
 EXEC sp_fulltext_service'verify_signature'，0  - 不验证签名
 EXEC sp_fulltext_service'update_languages'; - 更新语言列表
 EXEC sp_fulltext_service'restart_all_fdhosts'; - 重新启动守护进程
 EXEC sp_help_fulltext_system_components'filter'; - 查看有效过滤器
  

但是也需要运行这个!!!!

 用重写重新配置
  

I cannot get the Full-Text search to work on PDF files I am loading into my SQL Db via FileStream.

Version: SQL Server 2008 R2 (Developer Edition - doing proof of concept) OS: Windows 7

Steps I have taken.

• Installed the Adobe iFilter
• Made sure SQL Server full Text Daemon service is running
• Added the environment path to the Adobe PDF Filter bin directory

• Ran the below scripts to setup the new iFilter and make sure it is active

  EXEC sp_fulltext_service @action='load_os_resources', @value=1; -- update os resources 
  EXEC sp_fulltext_service 'verify_signature', 0 -- don't verify signatures
  EXEC sp_fulltext_service 'update_languages'; -- update language list
  EXEC sp_fulltext_service 'restart_all_fdhosts'; -- restart daemon  
  EXEC sp_help_fulltext_system_components 'filter'; -- view active filters
  

• Created the full-text index on the FileStream table I wanted to index

  CREATE FULLTEXT INDEX on local.FILE_REPOSITORY
  (DOCUMENT TYPE COLUMN FILE_EXTENSION)
  Key Index PK_File_Repository ON 
  (FileSearchCat, FILEGROUP [PRIMARY]);
  GO
  

• Rebuilt Catalog

  ALTER FULLTEXT CATALOG FileSearchCatREBUILD WITH ACCENT_SENSITIVITY=OFF;
  

• Ran a query to see if the index is working

  select * 
  from local.FILE_REPOSITORYwhere freetext(DOCUMENT, '25678')
  

Doesn't return any results for PDF, but works fine for word (docx)?

What am I doing wrong?

解决方案

Ok so I figured it out....I needed to run these steps:

EXEC sp_fulltext_service @action='load_os_resources', @value=1; -- update os resources 
EXEC sp_fulltext_service 'verify_signature', 0 -- don't verify signatures 
EXEC sp_fulltext_service 'update_languages'; -- update language list 
EXEC sp_fulltext_service 'restart_all_fdhosts'; -- restart daemon 
EXEC sp_help_fulltext_system_components 'filter'; -- view active filters

But Also needed to run this!!!!

reconfigure with override

这篇关于SQL Server PDF全文搜索无法在FileStream PDF文件上工作的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！