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

Transaction DTS task execution failed

Hi,

I'm having a problem when importing data from Commerce Server tables to the data warehouse. The Configuration synchronization task and the Web server log import task seem to work just fine but the Transaction data import task fails and I have the following error:

Transaction DTS task : No new data has been imported for the site <my site name>

The whole package is interrupted at this step.

Does anyone know what could be wrong? I have used CSDWDbgSrv to debug the process but haven't found any significant message.

Thanks!

[573 byte] By [cchorfi] at [2008-2-24]
«« Application settings lost upon new assembly
»» Two Dimensions Sharing same Parent Table
# 1
The message could be shown if you're running an incremental import and there is no new data. Has this package been in production for a while, or is this the first time it's being run?
BrianBlum-MSFT at 2007-9-3 > top of Msdn Tech,Commerce Server,Commerce Server 2002 and Earlier...
# 2

I'm running a full import and this is happening in my development environment. I've just figured that this message is shown when I extend the data warehouse to import custom fields from transaction tables: if I add just a few fields adding registers to the TransDimension table everything works fine; if I add about 30 fields I get the message saying there's no new data.

I guess that's the problem but can anyone confirm this? Is there any workaround to help me import more fields?

Thanks again.

cchorfi at 2007-9-3 > 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