Commerce Server 2007 Staging Error: CatalogImport failed; _FullTextCatalog' cannot be reused until after the next BACKUP LOG operation

  • Article

In one of the production commerce server instances of my client, I suddenly found this error getting logged since a couple of days. Now, the text of the error has nothing to do with Commerce Server 2007 but everything to do with the Sql Server 2005 that forms of the datastore of the commerce server. The full error would look like this:

Event Type: Error Event Source: Commerce Server Staging Event Category: None Event ID: 61993 Date: 10/10/2008 Time: 7:42:13 PM User: N/A Computer: PRODUCT-WEB1 Description: Failed to import business data for 'Catalog' resource for project 'ProductionStaging' : Microsoft.CommerceServer.Staging.StagingSubsystemException:CatalogImport failed. See log for details.369801:File 'sysft_ProductBaseCatalog1_FullTextCatalog' cannot be reused until after the next BACKUP LOG operation.

Full-Text catalog 'ProductBaseCatalog1_FullTextCatalog' does not exist in database 'ECommOnline_productcatalog' or user does not have permission to perform this action.

at Microsoft.CommerceServer.Staging.CatalogHandler.Import(String project, BusinessData businessData, String projectLocation, String destinationSite)

at Microsoft.CommerceServer.Staging.BusinessDataStagingEngine.ImportBusinessData(String projectName, String projectLocation)

For more information, see Help and Support Center at https://go.microsoft.com/fwlink/events.asp.

There are a couple of solution to get rid of this depending on the data and the purpose of the Catalog database.

Solution 1: Change the Recovery Model to Simple

This would make sure that the transaction logs aren't included for backup, thereby eliminating the error.

Solution 2: Backup the log before running staging service

Execute the SQL command BACKUP LOG ECommOnline_productcatalog TO DISK='c:\temp.log' and get the log backed up. Restart the Staging service. Also, you can include this as a scheduled maintenance so that the backup is performed just before staging is invoked.