DSXchange

hi, There could be couple of ways to achieving it. 1. AfterJobsubroutine - go to your -->JOb properties--> under general tab you will find Afterjobsubroutine give your rename command in Input value. 2. if DS is installed in unix , and you are using unix script to call your jobs , after your job fini...

what is the datatype you were storing xml and passing through transformer --> folder stage through shared container?

what is transformer used for? you are reading XML from MQ and creating xml in transformer?

yes , you have 20 extra earlier

Error code
WHERE USTIMESTAMP > convert('#ps_AppraisalFormSection_DeltaDate.EXTRACT_TIMESTAMP#',datetime,20)

WHERE USTIMESTAMP > convert(datetime,'#ps_AppraisalFormSection_Delta_Date.EXTRACT_TIMESTAMP#')

Also the sequence of parameter

yeah i would agree with you, i was also not sure with the data type smallint when i saw the code, not at all my favourite for storing any calculation.

guys i found the spooky connection also.

the person is same org, he was trying to help the team until i came to know about the issue.

Out of curiousity i reached to you guys..

okay so we did resolve one mystery :D

please find below my response.... peek the partition number, row number and your "unique" key value for the duplicate rows i tried to simulate in other test enviornment , but to be honest can't replicate the same. this is production job which is showing duplicates intermittengly. yes, if i...

thanks for sharing the link, yes guys it does looks spooky to me ... well i would say a coincident, or IBM no more supporting 7.x from 2013 forcing everyone to migrate to 8.x enviornment replicating similar issues. well you guys sure have good memory and imagination :wink: jwiles , reply makes sense...

hi, i have a parallel job, (@PARTITIONNUM+1): @ INROWNUM function is used to gererate a unique key for further processing (inserting in database). the job is on 8.5, running on 8 node. records are failing while inserting into datase using (@PARTITIONNUM+1): @ INROWNUM as unique key. volume is 5000, ...

Well I used for apt block size the actual bytes it was looking for 4925006

APT_BUFFER_DISK_WRITE_INCREMENT=1048576
APT_IO_MAXIMUM_OUTSTANDING=2097152

the job fails while writing out to the file system or the dataset but not at transformer level where stage variable in unbounded.

Thanks Ray for guiding i tried to run an experiment to confirm the theory, the job is changed to row generator-->transformer-->dataset Sequential file stage failled with buffer size insufficent error. though i have given unbounded at stage variable the job is aborting with APT_CombinedOperatorContro...

hi, I am little confused here could someone help! I ran a small test where read 1816 char using seq file-->transformer-->seq file. In the transformer stage i kept a stage variable whole length is blank, i wanted to find out whether the ds will assign 255 as default legth if not specified or the job ...

my suggestion will be do not touch the code without business knowledge, you might get the sort working temporary but in long run something might have broken. Take a step back understand the business, nullability and decide on key columns confirm with someone/preferably functional analyst and from th...

please check that Microsoft Visual Studio 9.0 is installed properly on the system or not.

It should be the starting point for me!

managed in current situation with transformer as filter's and some bussiness logic.

Using xslt for the translation to avoid parsing of the xml and trying to keep the adapter thin layer.

Thanks,
Aruna