DSXchange

Are you on a 64bit or 32bit server? Also, set $APT_DISABLE_COMBINATION to True and rerun to see exactly where the error message is coming from.

Repeating something does not an explanation make.

nima511 wrote:I have not defined any column definition explicitly

What does this mean?

in before query i used update statement So... you update everything with a blanket update sql in the "before SQL" section? :? You need to post your actual (unedited) errors before anyone could really help, that and detail all of the settings you are using in the DRS stage. Without that, w...

Yes. What is key to this is the order you declare the variables as they are evaluated top to bottom. That is what allows you to still know the "previous" value when the "current" value shows up.

Also let us know what the "target" is.

Apparently, it's the Aggrigator. You need to understand that that stage converts everything to dfloat during its processing unless you override that default behaviour. Check the documentation for the details.

Apparently not... I would double-check.

Never mind the fact that no-one in their right mind would want a single nearly 1GB XML file. Google, for instance, imposes a 100MB limit on any XML you send them. Go over by a single byte and it is Rejecto-Time! Of course, there shouldn't be any kind of limit on the number of files they should accep...

Auto ensures nothing.

You normally attach and detach from explicit jobs that the routine will be running. DSJ.ME is just a 'shortcut' to the current controlling job that invoked the routine.

Being partitioned won't afffect your "normal" operation. You have the option to do things differently but that's certainly not required in any sense.

Please confirm the "sql database" you are using.

Reset the aborted job and let us know if a 'From previous run...' message gets added to the log. What function is the transformer serving?

You're right, I didn't look close enough at the data and the desired output when I made my statememt. D'oh.