BUG: DTS Catalog Import Task Fails (279044)
The information in this article applies to:
- Microsoft Commerce Server 2000
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'
: You must be logged in to the Query Analyzer as either the existing database owner or sa.
STATUSMicrosoft has confirmed that this is a problem in Commerce Server 2000.
| Modification Type: | Major | Last Reviewed: | 10/18/2002 |
|---|
| Keywords: | kbbug kbdocerr KB279044 |
|---|
|