1 Reply Latest reply on Feb 13, 2018 7:54 AM by dan.smith@informatica.com

    Power Exchange CDC workflow failure

    sandeep chikane Active Member

      Hello Guys,


      I have CDC workflows which keep failing with error description as below:-


      [Informatica][SCLI PWX Driver] PWX-07038 Group Fetch read connection failed: rc=271 rc1=271 rc2=1266.

      [Informatica][SCLI PWX Driver] PWX-00271 DBAPI Error. DB_READ failed for file <Capture Extract Realtime>.

      [Informatica][SCLI PWX Driver] PWX-01266 DBNTC Receive READ header for file <Capture Extract Realtime> failed, rcs 33302/33302/0.

      [Informatica][SCLI PWX Driver] PWX-33302 : connectivity lost - Heartbeat send failed. RC1=-1, RC2=13, RC3=32152.252:36268.

      [Informatica][SCLI PWX Driver] PWX-00652 : TCP/IP SEND Error, rc=32, reason <Broken pipe>



      Please note that since workflow were started late 4-5 days after intial load was done, the condense files which are being processes currently are old.


      Let me know

        • 1. Re: Power Exchange CDC workflow failure
          dan.smith@informatica.com Guru

          That can happen if either

          1) session hangs

          2) session takes too long to do something, and PWX thinks it has died, so it closes the connection.


          For PWX CDC sources, the most common causes of those are

          1) session has a UOW that won't fit in DTM buffer blocks, so PC hangs because it can't free any more blocks for use.  Current PC will print out a message when this happens.


          2) PC session connects to PWX, but then does a lot of other things before asking PWX for data (things like building cache)