Microsoft KB Archive/277486

= PRB: &quot;Catalog Import in Progress&quot; Message Appears After SQL Server Connection Ends During a Catalog Import =

Article ID: 277486

Article Last Modified on 10/17/2002

-

APPLIES TO


 * Microsoft Commerce Server 2000 Standard Edition

-



This article was previously published under Q277486



SYMPTOMS
If the Microsoft SQL Server connection ends or you stop the SQL Server service during a catalog import, a message box that states &quot;Import process has been started successfully!&quot; appears in the Business Desk Catalog editor. In addition, the message &quot;catalog import in progress&quot; appears below the content pane. This message is not cleared even after you restore the connection to SQL Server.



CAUSE
For every import that you attempt, a row is added to the catalog status table in the database, which the catalog resource uses. When an import fails, the Enddate field contains a NULL value.



RESOLUTION
To resolve this problem, use Enterprise Manager or Query Analyzer to manually delete the record from the catalog status table.



Steps to Reproduce Behavior

 * 1) In the BizDesk Catalog editor, import a catalog.
 * 2) While you import the catalog, stop the SQL Server service or end the SQL Server connection.
 * 3) Restart or reconnect to SQL Server. The message &quot;catalog import in progress&quot; still appears below the content pane and will not go away.

Keywords: kbprb kbpending KB277486

-

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

© Microsoft Corporation. All rights reserved.