DSXchange

Hi mfecdsx, sorry, I thought I had seen a difference in the job-score you posted on the sort-order of the hash-partitioner, but doublechecking I can't see it now. :? Concerning the environment-variable: Vincent advised to set APT_NO_SORT_INSERTION, not APT_DISABLE_COMBINATION. If You do not use the ...

If I don't use as ASInteger, Iam getting the values as below from 1st job target table. 1.12267e+007 1.54196e+007 Here is why the the values are different in source and target. The precision of the floating-point values is too small to give you the correct values (hence 0 at the final position in d...

Hi ravipuli, it is almost impossible to give an answer to your question. You say that both jobs and both environments are (at least as far as you can see) identical in terms of hardware. Hopefully you've also got approximately the same workload on both servers while running the job in question (ther...

Hi Vincent, but the thing is, that the job already contains Sort-Stages - according to the job description and also according to the job score (op2 and op3). @mfexdsx: What I find suspicious is the difference between the APT_HashPartitioner-definitions on ds0 and ds1. In case of ds1 the subArgument ...

Or you may be able to accomplish that in a Parallel job by using a Server Shared Container for that USERSTATUS portion but I'd have to leave that to others to confirm / deny... No. This won't work. It is currently impossible to manipulate the Userstatus-variable from within parallel-jobs. The behav...

The question is: does the child-sequence abort, or is it the parent-sequence? If for example one of the child-sequences does not receive a mandatory parameter, the parent-sequence will abort without actually calling the job. As a result there is no job log for the child-sequence. You should see a co...

Of course, but this is only for passing a parameter to a job. Does not look like that to me in the example...

In Enterprise Edition (PX)?

Sorry, Madhusan. Would you like to have your string converted to a timestamp (which is represented internally by some integer-format in most databases) or do you need a different string-output-format for your data? To save your data as a timestamp have a look at the transformer function StringToTime...

Hi deesh, just to clarify: you did not reduce the size of the decimal, but enlarged it. Decimal(18,17) is a numeric value with a single digit integer part and 1 decimal places and can never become as high as 10. Decimal(18,4) is a numeric value with a 14 digit (big-)integer part and 4 decimal places...

Check data-type compatibility of the values listed in the second warning with the metadata defined on the XML-Input-Stage.

DSHOME should be a variable set in the dsenv file.

It should be listed in the Job Log in an entry starting with "Environment variable settings:".

Not likely.

The message must be introduced by the name of the stage instead of APTCombinedOperatorController,0:

Do You use a Basic-Transformer in Your job?

If this is the case, please post the complete Error-message.

When ever some one clicks a button on GUI a file is uploaded on the server ... This looks like a typical web-service scenario and this is what Information Services Director is made for. There you'd have your "always on"-job that would be watching for new instances of an xml-input-file in ...