BUG: You receive a time out error message when you try to delete a catalog by using BizDesk in Commerce Server 2002 (889578)
The information in this article applies to:
- Microsoft Commerce Server 2002
SYMPTOMSIn 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 CAUSEThis problem may occur because BizDesk queries a temporary table that
does not exist.RESOLUTIONTo 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. - 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:
- Start SQL Server Enterprise Manager.
- Expand Microsoft SQL Server, expand
SQL Server Group, and then expand your instance of SQL
Server.
- Expand Databases, expand your Commerce
Server database, and then click Full-Text Catalogs.
- Right-click the catalog that you want to rebuild, and
then click Rebuild Catalog.
- 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.
| Modification Type: | Major | Last Reviewed: | 5/16/2005 |
|---|
| Keywords: | kbnofix kbtshoot kbbug KB889578 kbAudDeveloper kbAudITPRO |
|---|
|