DSXchange

it was put at 10000 in this run. when i tried 3000 it works fine
what actually limits the array size.... because i want to see why the same job worked on a different server. is there anyhting i got to change in the settings.. am i missing somethin

this is message I see when I reset the job....

Dynamic_RDBMS_54: Array size out of bounds, set to default of 1

i never did any sort of calculation. actually these jobs were build by somebody else in 6.0 and i am trying to moe them into 7.5.2 and run them there.

Looks like u have nulls padded....nulltoempty function should help you out

there are no other warning messages I can see here..The message I mentioned earlier is the only one I could see.

Hi... This is the message I see in the director

Abnormal termination of stage CC900Stg3TrackCodeDetail..Transformer_0 detected.

My job reads from oracle, uses a transformer to do a lookup and then loads into oracle.

[/img]

Hi , we have server jobs moved from 6.0 to 7.5.1. Thse jobs load into oracle using plug-in. We had array sizes set to 10000. thse ran fine in 6.0 but we have jobs being aborted in 7.5.2. The job runs fine in 7.5.2 when the array size is reduced to around 3000. Is there anything i need to chnage as f...