Microsoft KB Archive/889578

= 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.

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

POST Data:

type=delete&ct_name= &page_id= &-bdtaskid=delete

Time:



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



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  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.</li> Right-click the catalog that you want to rebuild, and then click Rebuild Catalog.</li></ol> </li> After the rebuild is completed, try to delete the catalog by using BizDesk.</li></ol>

<div class="status_section">

STATUS
Microsoft has confirmed that this is a bug in the Microsoft products that are listed in the &quot;Applies to&quot; section.

Additional query words: CMS2002

Keywords: kbtshoot kbbug kbnofix KB889578

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.