Job warnings

pravin1581 · Post by **pravin1581** » Wed Jan 05, 2011 9:57 am

Hi All,

I am getting warnings like sort key no longer exists and it will be dropped from the inserted sort merge collector. This warnings are generated for all the sort keys. The design of the job is there is an input link, data is sorted and hash partitioned in the sort stage, then same partitioned is carried to the remove duplicate stage on the same keys to remove duplicates and then data is loaded into Teradata using Enterprise stage. When we replace the enterprise stage with dataset then these warnings are gone. The enterprise stage is a parallel stage. Please let me know how can I resolve these warnings.

Thanks in advance.

ray.wurlod · Post by **ray.wurlod** » Wed Jan 05, 2011 2:08 pm

By now (491 posts) you should realize that we need exact error messages. Without these we're wasting time guessing. Oh, and disable operator combination before capturing the error messages, so that you know from which actual operator they are being generated.

Kumar@1988 · Post by **Kumar@1988** » Thu Jan 06, 2011 1:05 am

Hi,

In ur job ur useing sort stage then after remove dupilicate stage is useing can u remove the dupilicates in sort stage itself so u can try on that option then u may get.......

ray.wurlod · Post by **ray.wurlod** » Thu Jan 06, 2011 4:14 am

Kumar@1988 wrote:
Hi,

In ur job ur useing sort stage then after remove dupilicate stage is useing can u remove the dupilicates in sort stage itself so u can try on that option then u may get.......

As previously admonished, please strive for a professional standard of written English on DSXchange. What you have written above does not fall into that category.

pravin1581 · Post by **pravin1581** » Tue Jan 11, 2011 9:55 am

ray.wurlod wrote:By now (491 posts) you should realize that we need exact error messages. Without these we're wasting time guessing. Oh, and disable operator combination before capturing the error messages, so that ...

The warning messages are :-

Code: Select all

  Sort key <key name> no longer exists in the dataset schema. It will be dropped from the inerted sort merge collector.

The above warning is repeated for all the sort keys defined in the sort stage and finally

Code: Select all

There are no sort keys in the dataset schema. No sortmerge collector will be inserted.

These warnings have started coming when the target dataset stage has been replaced with the TD enterprise stage.[/code]

pravin1581 · Post by **pravin1581** » Thu Jan 13, 2011 11:46 am

Any replies will be appreciated.

JRodriguez · Post by **JRodriguez** » Thu Jan 13, 2011 1:13 pm

Is runtime column propagation check?

Probably you have check runtime column propagation, the keys still exist in the stream ... just uncheck it and let us know

pravin1581 · Post by **pravin1581** » Thu Jan 13, 2011 3:40 pm

RCP is not on.

pravin1581 · Post by **pravin1581** » Mon Jan 17, 2011 5:05 pm

pravin1581 wrote:RCP is not on.

Any suggestions .

ray.wurlod · Post by **ray.wurlod** » Mon Jan 17, 2011 7:15 pm

pravin1581 wrote:Any suggestions .

Suggestion: Learn that DSXchange is an all-volunteer site whose members post as and when they can and, if they have nothing to contribute, will typically not post anything.

If you insist on demanding responses, do so of your official support provider, whom you are paying to provide responses.

DSXchange

Job warnings

Job warnings

Re: Job warnings

Re: Job warnings