Sort_455: |-100| Sort stage aborted

G SHIVARANJANI · Post by **G SHIVARANJANI** » Tue Dec 15, 2009 6:21 am

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|

G SHIVARANJANI · Post by **G SHIVARANJANI** » Tue Dec 15, 2009 6:22 am

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

chulett · Post by **chulett** » Tue Dec 15, 2009 6:22 am

Everything on the input link must exist on the output link.

G SHIVARANJANI · Post by **G SHIVARANJANI** » Tue Dec 15, 2009 6:31 am

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,

chulett · Post by **chulett** » Tue Dec 15, 2009 6:41 am

Including the mentioned "D_CAL" column? Worst case delete the stage and set it up again from scratch.

G SHIVARANJANI · Post by **G SHIVARANJANI** » Tue Dec 15, 2009 6:49 am

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

G SHIVARANJANI · Post by **G SHIVARANJANI** » Tue Dec 15, 2009 6:51 am

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

chulett · Post by **chulett** » Tue Dec 15, 2009 6:53 am

Possibly. Both the column names and data types must match for it to "map" properly. Do they?

G SHIVARANJANI · Post by **G SHIVARANJANI** » Tue Dec 15, 2009 7:12 am

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

chulett · Post by **chulett** » Tue Dec 15, 2009 8:48 am

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?

G SHIVARANJANI · Post by **G SHIVARANJANI** » Tue Dec 15, 2009 9:50 am

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

DSXchange

Sort_455: |-100| Sort stage aborted

Sort_455: |-100| Sort stage aborted

Re: Sort_455: |-100| Sort stage aborted