Microsoft KB Archive/278985

= Cannot import product catalog information into the Commerce Server 2000 or Commerce Server 2002 Data Warehouse =

Article ID: 278985

Article Last Modified on 11/17/2004

-

APPLIES TO


 * Microsoft Commerce Server 2002 Standard Edition
 * Microsoft Commerce Server 2000 Standard Edition

-



This article was previously published under Q278985



SYMPTOMS
Failure to import product catalog information into the Commerce Server 2000 or Commerce Server 2002 Data Warehouse can be caused by improper SQL Server user permissions. To import catalog data into a Commerce Server 2000 or Commerce Server 2002 data warehouse by using the Product Catalog Import (Commerce Server) DTS package, a user must have the Database Owner (db_owner) role. If the user does not have this role assigned, they will receive the &quot;1 Task(s) failed during execution&quot; message. In the Application event log, the following error occurs:

Event Type: Error

Event Source: Commerce Server 2000

Event Category: None

Event ID: 32794

Date: 

Time: 

User: N/A

Computer: 

Description: Error state: 1, Severity: 14, Server: , Line#: 1, msg: CREATE TABLE permission denied in database '_dw'.



RESOLUTION
The user should seek the assistance of the SQL Database Administrator to obtain the appropriate db_owner role for the Data Warehouse.

-OR-

If you are a Commerce Server administrator, you can supply the Global Resource for the site's Date Warehouse with another SQL ID that has the db_owner role. To do this, follow these steps:
 * 1) Open the Commerce Server Manager.
 * 2) Click to expand the Global Resources.
 * 3) Right-click the Data Warehouse for your site, and then select Properties.
 * 4) On the Connection tab, modify the User ID and Password fields with a SQL ID and password that has db_owner rights to the Data Warehouse database.
 * 5) Click OK to save these settings,

After the db_owner role has been supplied, the user will be able to successfully import product catalog information into the Data Warehouse by using the Product Catalog Import (Commerce Server) DTS task.

Additional query words: plutonium

Keywords: kbprb kbpending KB278985

-

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

© Microsoft Corporation. All rights reserved.