5 Replies Latest reply on Jul 13, 2021 2:48 PM by dan.smith@informatica.com

    CDCDispatcher cannot fetch changed data from the PowerExchange Listener. Error code: [271]

    Burgans Active Member

      Hi,

       

      I am running into the below error when trying to run a mapping to pull data from a condense logger file using a CAPX connection.  I am not sure if the issue is more wither the CDCDispatcher Error code 271 error or with the PWX-07411 error.

       

       

      READER_1_1_1> PWXPC_10091 [2021-07-13 15:38:18.660] [INFO] [PWX-04584 CAPXRT Application <S00M7B0Z0000000006AC> CAPX type <CC> Oracle overrides <SIT1_ORA//////> Extract map <d8sit1_ora.account.account> source type <ORA> After images No CDEP IO]

      READER_1_1_1> PWXPC_10091 [2021-07-13 15:38:18.660] [INFO] [PWX-21605 Connection selected CAPI_CDC found from covr< CAPI_CDC> tag< ORASIT1_ORAaccount1> type< > int< FALSE> method< CONN_OVR>.]

      READER_1_1_1> PWXPC_10091 [2021-07-13 15:38:18.660] [INFO] [PWX-21605 Connection selected CAPI_CDC found from covr< CAPI_CDC> tag< > type< > int< TRUE> method< CONN_OVR>.]

      READER_1_1_1> PWXPC_10091 [2021-07-13 15:38:18.660] [INFO] [PWX-04565 Regn tag ORASIT1_ORAaccount1 sequence 00 PowerExchange Logger 00]

      READER_1_1_1> PWXPC_10091 [2021-07-13 15:38:18.660] [INFO] [PWX-09970 CAPI i/f: Changed 1 sources to earliest sequence token]

      READER_1_1_1> PWXPC_10091 [2021-07-13 15:38:18.660] [INFO] [PWX-09959 CAPI i/f: Earliest UOW restart tokens: Sequence=00 PowerExchange Logger=0000000000000000]

      READER_1_1_1> PWXPC_10091 [2021-07-13 15:38:18.660] [INFO] [PWX-07411 Permanent error set because the open call failed for library "dtlamcpi"]

      READER_1_1_1> CMN_1761 [2021-07-13 15:38:18.660] Timestamp Event: [Tue Jul 13 15:38:18 2021]

      READER_1_1_1> PWXPC_10034 [2021-07-13 15:38:18.660] [ERROR] CDCDispatcher cannot fetch changed data from the PowerExchange Listener. Error code: [271]

      READER_1_1_1> CMN_1761 [2021-07-13 15:38:18.660] Timestamp Event: [Tue Jul 13 15:38:18 2021]

      READER_1_1_1> PWXPC_10035 [2021-07-13 15:38:18.660] [ERROR] Error message: [

      [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 260/2011/9974.

      [Informatica][SCLI PWX Driver] PWX-02011 SQL fetch error. SQLCODE = 9974.

      [Informatica][SCLI PWX Driver] PWX-04566 Capture Extract RC=9974 from CREAD_Open

      [Informatica][SCLI PWX Driver] PWX-10215 CAPI: Internal error: <CAPI_Open> call must succeed before <CAPI_Close> call can be attempted.

      [Informatica][SCLI PWX Driver] PWX-09974 CAPI i/f: RC=8 from CAPI_SendRestartInfo. Connection CAPI_CDC. Sources 1.

      [Informatica][SCLI PWX Driver] PWX-10214 CAPI: Cannot process <CAPI_SendRestartInfo> call due to a prior error in the API.

      [Informatica][SCLI PWX Driver] PWX-36946 No CDCT restart data available.

      [Informatica][SCLI PWX Driver] PWX-07411 Permanent error set because the open call failed for library "dtlamcpi"

      ]

      READER_1_1_1> PWXPC_12068 [2021-07-13 15:38:18.683] [INFO] [CDCRestart] Last restart tokens read at reader termination  : Restart 1 [] : Restart 2 []

      READER_1_1_1> CMN_1761 [2021-07-13 15:38:18.683] Timestamp Event: [Tue Jul 13 15:38:18 2021]

      READER_1_1_1> SDKS_38200 [2021-07-13 15:38:18.683] Partition-level [src_ACCOUNT]: Plug-in #304802 failed in run().

      WRITER_1_*_1> WRT_8333 [2021-07-13 15:38:18.683] Rolling back all the targets due to fatal session error.

      WRITER_1_*_1> WRT_8325 [2021-07-13 15:38:18.684] Final rollback executed for the target [STG_CACS_ACCOUNT] at end of load

      WRITER_1_*_1> WRT_8035 [2021-07-13 15:38:18.684] Load complete time: Tue Jul 13 15:38:18 2021

        • 1. Re: CDCDispatcher cannot fetch changed data from the PowerExchange Listener. Error code: [271]
          dan.smith@informatica.com Guru

          Hi Josh.

           

          The PWX-00271 is really just a termination notice.  It tells you nothing about the underlying problem, only that it was fatal and PWX is stopping.

           

          In this case the core problem is

          PWX-36946 No CDCT restart data available

           

          The CDCT is the structure that tracks what condensed data files (*CND* files) contains row images for which sources.  It is what PWX Listener reads to see where to start, based on the restart tokens passed from PC.

          If there is no CDCT, then no PC sessions can start, because PWX can't determine a start position.

           

          The CDCT is created and maintained - and destroyed - by PWXCCL.

          PWXCCL destroys it on a cold start, and updates it each time it closes a CND file.

          If PWXCCL closes a CND file and no CDCT exists, it creates one.

           

          So - if you have not run PWXCCL, or it has not run long enough to create at least one closed CND file, then there is no CDCT, and you can't start PC sessions with CDC sources.

           

          Also, please note that the CDCT is named like the DBID used in PWXCCL.

          That needs to match the INSTANCE name used in the TYPE=CAPX CAPI_CONNECTION, as that is what is used when a PC session tries to access data.

          So if the PC session is pointing to a CAPX CAPI_CONNECTION that has a different INSTANCE than the DBID that was used by PWXCCL to create the CDCT, then that will never find the CDCT, and you will also get this error.

          • 2. Re: CDCDispatcher cannot fetch changed data from the PowerExchange Listener. Error code: [271]
            Burgans Active Member

            Dan,

             

            Thank you so much for that detailed explanation.  I make updates to some source data and retest.

             

            As for your comment about the CDCT naming.  Is there a location in the pwxccl.cfg or dbmover.cfg where I set the CDCT name? In the pwxccl.cfg file I have the DBID = SIT1_ORA and in the

            dbmover.cfg file I have the CAPX CAPI_CONNECTION DFLTINST = SIT1_ORA.

             

             

            CAPI_CONNECTION=(NAME=CAPI_CDC,TYPE=(CAPX,DFLTINST=SIT1_ORA))

             

             

            For the PC connection, it is pointed to the CAPI_CDC connection.

            • 3. Re: CDCDispatcher cannot fetch changed data from the PowerExchange Listener. Error code: [271]
              Burgans Active Member

              Here are the files I see in the capture directory. Is there anything that appears to be missing, in terms of specific file types?

               

              -rwxrwxrwx. 1 pwxuser t2aadmins    1602 Jul 12 09:30 bkp-con

              -rwxrwxrwx. 1 pwxuser t2aadmins    4182 Jul 13 13:38 CCT.dat

              -rwxrwxrwx. 1 pwxuser t2aadmins 2949120 Jul 13 13:38 CCT.idx

              -rwxrwxrwx. 1 pwxuser t2aadmins    1602 Jul 13 13:40 CDCT_instance_SIT1_ORA_lockfile.lck

              -rwxrwxrwx. 1 pwxuser t2aadmins    2607 Jul 13 15:41 CDCT_SIT1_ORA.dat

              -rwxrwxrwx. 1 pwxuser t2aadmins   73728 Jul 13 15:41 CDCT_SIT1_ORA.idx

              -rwxrwxrwx. 1 pwxuser t2aadmins     543 Jul 13 13:40 CDCT_SIT1_ORA_INIT.bkp

              -rwxrwxrwx. 1 pwxuser t2aadmins    3991 Jul 12 14:27 CDCT_SIT1_ORA_TERM.bkp

              -rwxrwxrwx. 1 pwxuser t2aadmins     122 Jun 29 11:16 CDEP.dat

              -rwxrwxrwx. 1 pwxuser t2aadmins   40960 Jun 29 11:16 CDEP.idx

              -rwxrwxrwx. 1 pwxuser t2aadmins    1602 Jul 13 13:40 CondenseO_loggerfiles_lockfile.lck

              -rwxrwxrwx. 1 pwxuser t2aadmins      80 Jul 13 13:38 tstamp.txt

              • 4. Re: CDCDispatcher cannot fetch changed data from the PowerExchange Listener. Error code: [271]
                dan.smith@informatica.com Guru

                DBID in PWXCCL.CFG affects how PWXCCL creates and maintains the CDCT.

                 

                DFLTINST on the TYPE=CAPX CAPI_CONNECTION affects how PC sessions try to find the CDCT.

                 

                Those two values *must* be the same for PC CDC sessions to find the CDCT.

                • 5. Re: CDCDispatcher cannot fetch changed data from the PowerExchange Listener. Error code: [271]
                  dan.smith@informatica.com Guru

                  Those are all named like "CDCT_SIT1*.

                   

                  That means that the TYPE=CAPX CAPI_CONNECTION statement in PWX Listener's DBMOVER.CFG *must* have a DFLTINST=SIT1.