Page 1 of 1
Sort_455: |-100| Sort stage aborted
Posted: Tue Dec 15, 2009 6:21 am
by G SHIVARANJANI
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|
Re: Sort_455: |-100| Sort stage aborted
Posted: Tue Dec 15, 2009 6:22 am
by G SHIVARANJANI
G 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|
Can any one help me fix this issue please
Posted: Tue Dec 15, 2009 6:22 am
by chulett
Everything on the input link must exist on the output link.
Posted: Tue Dec 15, 2009 6:31 am
by G SHIVARANJANI
chulett wrote:Everything on the input link must exist on the output link. ...
Thankyou chulett
I see every thing in input is there in output with matching data types too
but still the error persists,
Posted: Tue Dec 15, 2009 6:41 am
by chulett
Including the mentioned "D_CAL" column? Worst case delete the stage and set it up again from scratch.
Posted: Tue Dec 15, 2009 6:49 am
by G SHIVARANJANI
chulett wrote:Including the mentioned "D_CAL" column? Worst case delete the stage and set it up again from scratch. ...
I tried to set up now but still the issue persist
Posted: Tue Dec 15, 2009 6:51 am
by G SHIVARANJANI
G SHIVARANJANI wrote:chulett wrote:Including the mentioned "D_CAL" column? Worst case delete the stage and set it up again from scratch. ...
I tried to set up now but still the issue persist
There are fields in the sorter stage which are numeric and date fields which are been passed as varchar fields,
can this be the issue ? craige
Posted: Tue Dec 15, 2009 6:53 am
by chulett
Possibly. Both the column names and data types must match for it to "map" properly. Do they?
Posted: Tue Dec 15, 2009 7:12 am
by G SHIVARANJANI
chulett wrote:Possibly. Both the column names and data types must match for it to "map" properly. Do they? ...
Sort Input stage 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
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
Posted: Tue Dec 15, 2009 8:48 am
by chulett
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?
Posted: Tue Dec 15, 2009 9:50 am
by G SHIVARANJANI
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