Issue with Oracle Load in 7.5.2

remo · Post by **remo** » Thu May 24, 2007 9:24 am

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 far as the settings are concerned inorder for these jobs to run in 7.5.2 without any changes bieng made

narasimha · Post by **narasimha** » Thu May 24, 2007 10:53 am

Do you get any warnings/errors in the logs for the aborted jobs, that could help find out the cause?

remo · Post by **remo** » Thu May 24, 2007 11:17 am

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]

DSguru2B · Post by **DSguru2B** » Thu May 24, 2007 11:58 am

What about any surrounding warning message?
Reset the job and see if you have any message "From Previous Run ...." pop up in the log. If it does, post its "entire" content here.

remo · Post by **remo** » Thu May 24, 2007 12:51 pm

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

DSguru2B · Post by **DSguru2B** » Thu May 24, 2007 12:56 pm

You still answered only half of my question. Did you reset the job? Also double click on the error message and post the entire content here.

ray.wurlod · Post by **ray.wurlod** » Thu May 24, 2007 3:05 pm

How do you calculate the array size that you use?

remo · Post by **remo** » Thu May 24, 2007 10:58 pm

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.

chulett · Post by **chulett** » Fri May 25, 2007 12:16 am

As noted, for any 'abnormal termination' situation, you need to Reset the aborted job from the Director to try and get more diagnostic information.

Have you tried that? Did the 'Reset' add a 'From previous run...' message to the log? If so, please post the contents of that message.

DSguru2B · Post by **DSguru2B** » Fri May 25, 2007 7:02 am

Tell them Craig, man.

remo · Post by **remo** » Fri May 25, 2007 8:58 am

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

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

chulett · Post by **chulett** » Fri May 25, 2007 9:02 am

Ok, what is the current Array Size in the job? Apparently, way 'more bigger' than it should have been.

remo · Post by **remo** » Fri May 25, 2007 9:17 am

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

DSXchange

Issue with Oracle Load in 7.5.2

Issue with Oracle Load in 7.5.2

hi

hey

hi