When trying to im****t a catalog in Commerce Server 2007 (using the
Catalog Manager) I am encountering the following error in the event
log:
An exception occurred in the 'CatalogWebService' Web service.
Exception details follow:
Microsoft.CommerceServer.Catalog.CatalogDatabaseException: Failed to
regenerate the full text indexes. --->
System.Data.SqlClient.SqlException: File
'sysft_Catalog1_FullTextCatalog' cannot be reused until after the next
BACKUP LOG operation.
Full-Text catalog 'Catalog1_FullTextCatalog' does not exist in database
'OnlineShop_productcatalog' or user does not have permission to perform
this action.
Clicking on the "Refresh Catlaog Full Text Index" task in Catalog
Manager also results in the same error.
Looking at the database, I note that it doesn't have any full text
indexes.
Is there a script, stored proecedure, etc. that I can run to create the
full text index?
Any help would be greatly appreciated.
Thanks in advance
Chris