BUG: You receive a time out error message when you try to delete a catalog by using BizDesk in Commerce Server 2002

View products that this article applies to.

Symptoms

In Microsoft Commerce Server 2002, when you try to delete a catalog by using the Commerce Server Business Desk Web application (BizDesk), you receive the following error message:

Error Type:
Active Server Pages, ASP 0113 (0x80004005) The maximum amount of time for a script to execute was exceeded. You can change this limit by specifying a new value for the property Server.ScriptTimeout or by changing the value in the IIS administration tools.
/your folder/your catalogs.asp

Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET CLR 1.1.4322; .NET CLR 1.0.3705)
Page: POST 54 bytes to /your folder/your catalogs.asp

POST Data:
type=delete&ct_name=catalogName&page_id=pageID&-bdtaskid=delete
Time:
Date and time

↑ Back to the top

Cause

This problem may occur because BizDesk queries a temporary table that does not exist.

↑ Back to the top

Resolution

To resolve this problem, follow these steps:

Run the following query from SQL Query Analyzer to delete a catalog.

DECLARE @FullTextCatalog sysname
DECLARE @CatalogTable sysname
 
Select @FullTextCatalog = Fulltextcatalog From catalogglobal where catalogname = 
'YourCatalog'
SET @CatalogTable = '[YourCatalog_CatalogProducts]'

EXEC dbo.ctlg_TableExistsInFullTextCatalog @FullTextCatalog, @CatalogTable, 1

Note In this query, replace YourCatalog with the name of the catalog that you want to delete.

2. If the query runs longer than five minutes, stop the query.

If you stopped the query in step 2, rebuild the full-text catalog that is associated with the catalog that you want to delete. To do this, follow these steps:

a.	Start SQL Server Enterprise Manager.
b.	Expand Microsoft SQL Server, expand SQL Server Group, and then expand your instance of SQL Server.
c.	Expand Databases, expand your Commerce Server database, and then click Full-Text Catalogs.
d.	Right-click the catalog that you want to rebuild, and then click Rebuild Catalog.

4. After the rebuild is completed, try to delete the catalog by using BizDesk.