Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> Commerce Server >> Commerce Server 2002 and Earlier

Error messages regarding Catalog DTS task

Hi,

when executing the DTS package to import data into the data warehouse database even though the process seems to be successful I get the following errors in the Event Log:

Event Type: Error
Event Source: Commerce Server 2002
Event Category: None
Event ID: 36911
Date: 22/1/2007
Time: 10:05:37
User: N/A
Computer: VMPERBI04
Description:
Catalog DTS task : Cannot change the variant type to BSTRs in WriteProductsIntoDW()

Event Type: Error
Event Source: Commerce Server 2002
Event Category: None
Event ID: 36880
Date: 22/1/2007
Time: 10:05:38
User: N/A
Computer: VMPERBI04
Description:
Catalog DTS task : Error writeing categories and products

Event Type: Error
Event Source: Commerce Server 2002
Event Category: None
Event ID: 36891
Date: 22/1/2007
Time: 10:05:38
User: N/A
Computer: VMPERBI04
Description:
Catalog DTS task : Error transfering the products table for the catalog %s

Event Type: Error
Event Source: Commerce Server 2002
Event Category: None
Event ID: 36875
Date: 22/1/2007
Time: 10:05:39
User: N/A
Computer: VMPERBI04
Description:
Catalog DTS task : Error Transfering the hierarchical data

Does anyone know what these errors mean and what could be wrong in the process?

Thanks!

[1388 byte] By [cchorfi] at [2008-3-6]
«« LINQ to SQL - remnant of MetadataToken bug in Jan Orcas CTP
»» Question about Ngen.exe and the assembly "Core question".
# 1
It looks like the task encountered a data mapping problem. Was there a change in the catalog runtime schema recently?
BrianBlum-MSFT at 2007-9-4 > top of Msdn Tech,Commerce Server,Commerce Server 2002 and Earlier...
# 2

What do you mean by catalog "runtime" schema? Is it the same as catalog schema? And what kind of change could cause such a problem? Not a change like adding a new property definition or associating a property to a product definition, right? We frequently do these kind of changes in our catalog and haven't noticed any problem so far.

cchorfi at 2007-9-4 > top of Msdn Tech,Commerce Server,Commerce Server 2002 and Earlier...
# 3

I was referring the the catalog schema used to the runtime to distinguish it from the catalog schema that is defined in the DW. The Catalog DTS task transforms the data from the runtime schema to the DW schema. The error is noting that a string is being incorrectly mapped.

Has a new catalog property been marked for export to the DW?

BrianBlum-MSFT at 2007-9-4 > top of Msdn Tech,Commerce Server,Commerce Server 2002 and Earlier...
# 4

No new catalog property has been marked for export, as far as I know. But I have restored the product catalog database from production environment in my development environment. Maybe this procedure has caused some "misunderstanding" regarding the fields defined in BizDesk that should be exported...

I'll check BizDesk definitions for the catalog properties to see if there's something different.

Thanks!

cchorfi at 2007-9-4 > top of Msdn Tech,Commerce Server,Commerce Server 2002 and Earlier...
Commerce Server
Commerce Server 2002 and Earlier

Commerce Server Hot Topic

Commerce Server New Topic

Commerce Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified