Skip navigation
Contact Us
959 Views 2 Replies Latest reply: Jan 12, 2013 11:55 AM by Venkat Byrapudi RSS
Babu Gurram Newbie 1 posts since
Jan 10, 2013
Currently Being Moderated

Jan 10, 2013 4:37 AM

Work flow session invalid

I got a error  "Joiner Transformation has invalid join condition: not all of the ports could be found". while validating the workflow task

 

i just changed the join types to Detail outer joins from master outer joins and error disappeared and again i changed the join types back to Mater outer join and error did not occur.

 

Can some help me to figure out the reason for this error?

  • Chris - Newbie 7 posts since
    Dec 19, 2012
    Currently Being Moderated
    Jan 10, 2013 12:30 PM (in response to Babu Gurram)
    Re: Work flow session invalid

    Hi Babu,

     

    this is the best I could find from an old v5 troubleshooting doc.

     

    CMN_1095     ERROR: Field name used in join not found in transform definition

     

    Cause:           The informatica Server could not locate a port specified in the Joiner transformation.  You may have repository inconsistencies.

     

    Action:           Contact Informatica Technical Support

     

    Sounds like chaning up the Join Type resolved your issue though.

  • Venkat Byrapudi Master 884 posts since
    Mar 25, 2010
    Currently Being Moderated
    Jan 12, 2013 11:55 AM (in response to Babu Gurram)
    Work flow session invalid

    Some times this may come changing port names in upstream and the propagation of ports to downstream, in mapping level we can change and save but in session level if we refresh it won't take modified port names on that time it will give above error. so, manually we have to modify join condition then session will valid.

     

     

    Regards,

    Venkat

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points