Sort_455: |-100| Sort stage aborted
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 137
- Joined: Sun Jan 07, 2007 11:17 pm
- Location: VISAKHAPATNAM
Sort_455: |-100| Sort stage aborted
Hi,
My sort stage is aborting with the following error
->xivpd515PostSmoothingRndgDP_1_CHANGE..Sort_442: At row 0, link "DSLink449", while processing column "D_CAL"
Input column does not promote to output column
->Sort_455: |-100|
My sort stage is aborting with the following error
->xivpd515PostSmoothingRndgDP_1_CHANGE..Sort_442: At row 0, link "DSLink449", while processing column "D_CAL"
Input column does not promote to output column
->Sort_455: |-100|
-
- Participant
- Posts: 137
- Joined: Sun Jan 07, 2007 11:17 pm
- Location: VISAKHAPATNAM
Re: Sort_455: |-100| Sort stage aborted
Can any one help me fix this issue pleaseG SHIVARANJANI wrote:Hi,
My sort stage is aborting with the following error
->xivpd515PostSmoothingRndgDP_1_CHANGE..Sort_442: At row 0, link "DSLink449", while processing column "D_CAL"
Input column does not promote to output column
->Sort_455: |-100|
-
- Participant
- Posts: 137
- Joined: Sun Jan 07, 2007 11:17 pm
- Location: VISAKHAPATNAM
-
- Participant
- Posts: 137
- Joined: Sun Jan 07, 2007 11:17 pm
- Location: VISAKHAPATNAM
-
- Participant
- Posts: 137
- Joined: Sun Jan 07, 2007 11:17 pm
- Location: VISAKHAPATNAM
There are fields in the sorter stage which are numeric and date fields which are been passed as varchar fields,G SHIVARANJANI wrote:I tried to set up now but still the issue persistchulett wrote:Including the mentioned "D_CAL" column? Worst case delete the stage and set it up again from scratch. ...
can this be the issue ? craige
-
- Participant
- Posts: 137
- Joined: Sun Jan 07, 2007 11:17 pm
- Location: VISAKHAPATNAM
Sort Input stage haschulett wrote:Possibly. Both the column names and data types must match for it to "map" properly. Do they? ...
Varchar,varchar,varchar,decimal,varchar,varchar
D_PERD_STRT,D_PERD_END,D_CAL,SUM,ID,I_PLT
2010-12-13,2010-12-13,2010-12-13,12,1,08475
Output has
Varchar,varchar,varchar,decimal,varchar,varchar
D_PERD_STRT,D_PERD_END,D_CAL,SUM,ID,I_PLT
2010-12-13,2010-12-13,2010-12-13,12,1,08475
You need another set of eyes on site to check your work, everything you've posted looks fine so far. Not sure what else to tell you. What other settings are you using in the stage? Is "D_CAL" mentioned elsewhere, in your Sort Specification perhaps? ![Confused :?](./images/smilies/icon_confused.gif)
![Confused :?](./images/smilies/icon_confused.gif)
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 137
- Joined: Sun Jan 07, 2007 11:17 pm
- Location: VISAKHAPATNAM
chulett wrote:You need another set of eyes on site to check your work, everything you've posted looks fine so far. Not sure what else to tell you. What other settings are you using in the stage? Is "D_CAL" mentioned elsewhere, in your Sort Specification perhaps?
I have put a transformer ,hash file then a sort stage then a transforemr.
Now when i remove the hash file and put transformer, sort stage, and tansformer... the job works fine