DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
niranjanpanda030
Participant



Joined: 09 Dec 2014
Posts: 1
Location: Bangalore
Points: 19

Post Posted: Thu Aug 10, 2017 5:35 am Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Hi ,

I am getting below warning:.

FN_Rej_Sku_Diffs: When checking operator: Dropping "diff_3_sku" in transfer from "inRec" to "outRec".

Googled a lot but could not find any resolution. Job has more than 50 warnings, because of which the Job aborts when triggered through Control-M. However when I run it manually it is working fine.

There is no RCP enable in the job . All the metadata passed to funnel stage verified . Everything is in sync.

_________________
Niranjan
thompsonp



Group memberships:
Premium Members

Joined: 01 Mar 2005
Posts: 186

Points: 1701

Post Posted: Thu Aug 10, 2017 6:42 am Reply with quote    Back to top    

Firstly - no need to post the same thing in two places.
Hopefully one of the admins can remove the duplicate in the General section.

Have you checked that diff_3_sku exists on all the input streams and that it is of the same type?
Rate this response:  
Not yet rated
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 42215
Location: Denver, CO
Points: 216749

Post Posted: Thu Aug 10, 2017 7:22 am Reply with quote    Back to top    

Two other places, actually. But now the cheese stands alone. Wink

_________________
-craig

Watch out where the huskies go and don't you eat that yellow snow
Rate this response:  
Not yet rated
PaulVL



Group memberships:
Premium Members

Joined: 17 Dec 2010
Posts: 1153

Points: 7639

Post Posted: Thu Aug 10, 2017 10:57 am Reply with quote    Back to top    

I think the important thing you need to research is why does the job abort if run via Control-M scheduler and work fine if run manually.

I think you will find that control-M submits a script to execute, the script is probably reading the return code of the job and saying that "ran with warnings" is not the same as "ran ok" so it throws back a return code to your scheduler saying "blah it messed up".
Rate this response:  
Not yet rated
priyadarshikunal



Group memberships:
Premium Members

Joined: 01 Mar 2007
Posts: 1730
Location: Troy, MI
Points: 9288

Post Posted: Mon Aug 21, 2017 4:41 am Reply with quote    Back to top    

Do you get the same warnings when executed from director, but still it completes?

_________________
Priyadarshi Kunal

Genius may have its limitations, but stupidity is not thus handicapped. Wink
Rate this response:  
Not yet rated
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 54034
Location: Sydney, Australia
Points: 293130

Post Posted: Sun Aug 27, 2017 9:36 pm Reply with quote    Back to top    

The warning suggests that (in the compiled version at least) diff_3_sku is not being transferred to the output link. It is possible that this is because diff_3_sku exists on some, BUT NOT ALL, input ...

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
currently hiring: Canberra, Sydney and Melbourne
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours