Microsoft KB Archive/889578

Knowledge Base

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

Article ID: 889578

Article Last Modified on 5/16/2005

---

APPLIES TO

• Microsoft Commerce Server 2002 Standard Edition

---

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

CAUSE

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

RESOLUTION

To resolve this problem, follow these steps:

1. 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.
3. 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:
   1. Start SQL Server Enterprise Manager.
   2. Expand Microsoft SQL Server, expand SQL Server Group, and then expand your instance of SQL Server.
   3. Expand Databases, expand your Commerce Server database, and then click Full-Text Catalogs.
   4. 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.

STATUS

Microsoft has confirmed that this is a bug in the Microsoft products that are listed in the "Applies to" section.

Additional query words: CMS2002

Keywords: kbtshoot kbbug kbnofix KB889578

---

Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.