Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 889578 - Last Review: May 16, 2005 - Revision: 1.2
BUG: You receive a time out error message when you try to delete a catalog by using BizDesk in Commerce Server 2002
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
This problem may occur because BizDesk queries a temporary table that
does not exist.
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
- 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.
Microsoft has confirmed that this is a bug in the Microsoft products that are
listed in the "Applies to" section.
APPLIES TO
- Microsoft Commerce Server 2002 Standard Edition
| kbnofix kbtshoot kbbug KB889578 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate