Funnel warning - Dropping "APT_0_comm_type"

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
suryadev
Premium Member
Premium Member
Posts: 211
Joined: Sun Jul 11, 2010 7:39 pm

Funnel warning - Dropping "APT_0_comm_type"

Post by suryadev »

Funnel_786: When checking operator: Dropping "APT_0_comm_type" in transfer from "inRec" to "outRec"


In the job log I can view a lot of these warnings from a funnel stage.

can anyone help me with that warning?
Thanks,
Surya
suryapkakani
Participant
Posts: 47
Joined: Wed Aug 20, 2008 7:31 am
Location: New jersey

Post by suryapkakani »

You have to make sure to match the input and output metadata when using a Funnel Stage.
sunny
HariK
Participant
Posts: 68
Joined: Thu May 17, 2007 1:50 am

Re: Funnel warning

Post by HariK »

suryadev wrote:"APT_0_comm_type" in transfer from "inRec" to "outRec"
Try running the job after deactivating the RCP option.
vijaykumarpj
Participant
Posts: 30
Joined: Sat Dec 19, 2009 5:19 am
Location: Manchester, UK

Post by vijaykumarpj »

Hi,

Make sure that, all the level numbers of the columns are same.

Regards,
Thanks,
VJ.
suryadev
Premium Member
Premium Member
Posts: 211
Joined: Sun Jul 11, 2010 7:39 pm

Post by suryadev »

@suryap

Yes the input and output metadata is the same in that stage.

@harik
Did that but did not help.

@vijay

what is level numbers of columns?
do you mean the size of the column?
Thanks,
Surya
vijaykumarpj
Participant
Posts: 30
Joined: Sat Dec 19, 2009 5:19 am
Location: Manchester, UK

Post by vijaykumarpj »

Nup... Level numbers are used to specify the data hierarchy, but not the size.
Thanks,
VJ.
suryadev
Premium Member
Premium Member
Posts: 211
Joined: Sun Jul 11, 2010 7:39 pm

Post by suryadev »

where can I find the level numbers of the columns to make sure they are same
Thanks,
Surya
kandyshandy
Participant
Posts: 597
Joined: Fri Apr 29, 2005 6:19 am
Location: Singapore

Post by kandyshandy »

Funnel can have many input links. Check whether you have the same number of columns in all the input links. I understand that you already compared input metadata with output metadata, but need to check whether all input links have the same metadata.. May be, one input link has an extra column than the other.
Kandy
_________________
Try and Try again…You will succeed atlast!!
Post Reply