Code 139,reading from oracle enterprise stage

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
verify
Premium Member
Premium Member
Posts: 99
Joined: Sun Mar 30, 2008 8:35 am

Code 139,reading from oracle enterprise stage

Post by verify »

HI all,

when i run the job from oracle entraprise stage to oracle enter prisse stage inbetween using with transformer stage.
when it was declared like in source stage
method: table read
autogeneration
11 colummns in table in oracle , but here it has declared in the stage just 5 columns.
its giving the primary key of the table in oracle(from 11 columns) not mentioned in this 5 columns.
but it was giving the error that primary key column "scale length has not been loaded".

RT_SC609/OshExecuter.sh: line 20: 11983 Segmentation fault (core dumped) $APT_ORCHHOME/bin/osh "$@" 2>&1
RK Raju
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Scale is the second piece of a Decimal number, which is specified as Decimal(precision,scale). You will find Scale in the Columns grid of the table definition. If this needs to be 0, put 0 in there explicitly, because the error message is complaining that there's no value there.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply