Error retrieving documents for a tag

Apr 10, 2012 at 8:40 AM

Hi

I installed the Search application and pointed to an existing file table on a SQL2012 instancxe and get Error retrieving documents for a tag. I then installed a new database through the application, it created the db fine and allowed loading a new document, can query the table and see that the row exists but get the same error message  when trying to search the document or double click on the file. Tried various word document any pointers?

 

Error retrieving documents for a tag.

Database:FTDatabaseFileTable:

DemoFileTable

Developer
Apr 10, 2012 at 2:08 PM

Hi Martin,

You're probably missing a property list. Can you try the script below? I changed it according to your database and filetable, but it'd be best if you double-check everything before running it.

USE FTDatabaseFileTable
GO
EXEC sp_fulltext_service 'load_os_resources',1
EXEC sp_fulltext_service 'restart_all_fdhosts'
CREATE FULLTEXT CATALOG ft AS DEFAULT
GO
CREATE UNIQUE INDEX DocumentsFt ON FTDatabaseFileTable.. DemoFileTable(stream_id)
GO
CREATE SEARCH PROPERTY LIST DocumentProperties;
GO
ALTER SEARCH PROPERTY LIST DocumentProperties
   ADD 'Title'
   WITH ( PROPERTY_SET_GUID = 'F29F85E0-4FF9-1068-AB91-08002B27B3D9', PROPERTY_INT_ID = 2,
      PROPERTY_DESCRIPTION = 'System.Title - Title of the item.');
ALTER SEARCH PROPERTY LIST DocumentProperties
    ADD 'Author'
   WITH ( PROPERTY_SET_GUID = 'F29F85E0-4FF9-1068-AB91-08002B27B3D9', PROPERTY_INT_ID = 4,
      PROPERTY_DESCRIPTION = 'System.Author - Author or authors of the item.');
ALTER SEARCH PROPERTY LIST DocumentProperties
    ADD 'Tags'
   WITH ( PROPERTY_SET_GUID = 'F29F85E0-4FF9-1068-AB91-08002B27B3D9', PROPERTY_INT_ID = 5,
      PROPERTY_DESCRIPTION = 'System.Keywords - Keywords (Tags) of the item.');
GO
CREATE FULLTEXT INDEX ON FTDatabaseFileTable.. DemoFileTable
    (file_stream TYPE COLUMN file_type LANGUAGE 1033 statistical_semantics)
    KEY INDEX DocumentsFt ON ft
    WITH SEARCH PROPERTY LIST = DocumentProperties
GO

Please, let me know if that works for you.
---
Daniel Altamirano

Apr 10, 2012 at 3:30 PM

Thanks Daniel

That worked Great

Regards

Martin

From: danielaltamirano [email removed]
Sent: 10 April 2012 15:09
To: Martin Croft
Subject: Re: Error retrieving documents for a tag [mysemanticsearch:351755]

From: danielaltamirano

Hi Martin,

You're probably missing a property list. Can you try the script below? I changed it according to your database and filetable, but it'd be best if you double-check everything before running it.

USE FTDatabaseFileTable
GO
EXEC sp_fulltext_service 'load_os_resources',1
EXEC sp_fulltext_service 'restart_all_fdhosts'
CREATE FULLTEXT CATALOG ft AS DEFAULT
GO
CREATE UNIQUE INDEX DocumentsFt ON FTDatabaseFileTable.. DemoFileTable(stream_id)
GO
CREATE SEARCH PROPERTY LIST DocumentProperties;
GO
ALTER SEARCH PROPERTY LIST DocumentProperties
ADD 'Title'
WITH ( PROPERTY_SET_GUID = 'F29F85E0-4FF9-1068-AB91-08002B27B3D9', PROPERTY_INT_ID = 2,
PROPERTY_DESCRIPTION = 'System.Title - Title of the item.');
ALTER SEARCH PROPERTY LIST DocumentProperties
ADD 'Author'
WITH ( PROPERTY_SET_GUID = 'F29F85E0-4FF9-1068-AB91-08002B27B3D9', PROPERTY_INT_ID = 4,
PROPERTY_DESCRIPTION = 'System.Author - Author or authors of the item.');
ALTER SEARCH PROPERTY LIST DocumentProperties
ADD 'Tags'
WITH ( PROPERTY_SET_GUID = 'F29F85E0-4FF9-1068-AB91-08002B27B3D9', PROPERTY_INT_ID = 5,
PROPERTY_DESCRIPTION = 'System.Keywords - Keywords (Tags) of the item.');
GO
CREATE FULLTEXT INDEX ON FTDatabaseFileTable.. DemoFileTable
(file_stream TYPE COLUMN file_type LANGUAGE 1033 statistical_semantics)
KEY INDEX DocumentsFt ON ft
WITH SEARCH PROPERTY LIST = DocumentProperties
GO

Please, let me know if that works for you.
---
Daniel Altamirano

DISCLAIMER
Any opinions expressed in this email are those of the individual and not necessarily the Company.
This email and any file transmitted with it, including replies and forwarded copies (which may contain alterations) subsequently transmitted from the company, are confidential and solely for the use of the intended recipient. If you are not the intended recipient or the person responsible for delivering to the intended recipient, be advised that you have received this email in error and that any use is strictly prohibited.
If you have received this email in error please notify the Swinton Business Systems Service Desk via email to
ITServiceDesk@swinton.co.uk including a copy of this message. Please then delete this email and destroy any copies of it.
Swinton Group Limited may monitor the content of all emails sent via its network for the purposes of ensuring compliance with its policies and procedures.
As part of Swinton Group Limited security policy, this email has been virus scanned.
Swinton Group Limited, registered in England 756681, is connected for the purposes of the Insurance Companies Regulations 1994 to MMA Insurance plc and Gateway Insurance Company Limited.
Registered office: Swinton House, 6 Great Marlborough street, Manchester, M1 5SW.
Swinton Group Limited is authorised and regulated by the Financial Services Authority.