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
Code 139,reading from oracle enterprise stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.