Microsoft KB Archive/279044

= BUG: DTS Catalog Import Task Fails =

Article ID: 279044

Article Last Modified on 10/18/2002

-

APPLIES TO


 * Microsoft Commerce Server 2000 Standard Edition

-



This article was previously published under Q279044



SYMPTOMS
The DTS catalog import task may fail and cause the following error messages to be logged in the Event Viewer's Application event log:

Commerce Server 2000 Event ID 32778 DataSource::GetActiveCatalog(DS-2-DWSchema) failed on catalog load (0) - Catalog not present and CATALOG_CREATE not enabled

Commerce Server 2000 Event ID 32773 DataSource::Init(DS-2-DWSchema) failed on catalog load (-2147467259)

Commerce Server 2000 Event ID 32769 In BindArgs::OpenDataSrc, failed initializing data source (-2147467259)

Commerce Server 2000 Event ID 33184 The description for Event ID ( 33184 ) in Source ( Commerce Server 2000 ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. The following information is part of the event: Cannot initialize the provider wrapper

Commerce Server 2000 Event ID 36867 Catalog DTS task: cant write the status into the taskhistory table DSDataWareHouse Event ID 36864 Catalog DTS task: Import failed



CAUSE
These errors occur because the catalog import task creates a table to store intermittent results. The name of the temporary table is CatTmp. Before creating the table, the catalog import task checks for the table's existence and removes it if found. It is unable to do this if the user logged into the database is not the database owner.



RESOLUTION
Change the owner of the database to the user who owns the CatTmp table by executing the following command in the SQL Query Analyzer:

EXEC sp_changedbowner 'New Owner'

NOTE: You must be logged in to the Query Analyzer as either the existing database owner or sa.



STATUS
Microsoft has confirmed that this is a problem in Commerce Server 2000.

Additional query words: plutonium

Keywords: kbbug kbdocerr kbpending KB279044

-

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

© Microsoft Corporation. All rights reserved.