0 Replies Latest reply on Aug 8, 2018 9:32 PM by VHJLIMA

    ERROR: "PWX-02011 SQL fetch error. SQLCODE = -1" when running CDC Real Time session

    New Member

      We are having this error during the execution of a CDC session, it is the first time we are running something with CDC.
      Severity    Timestamp    Node    Thread    Message Code    Message

      ERROR    08-Aug-18 19:03:57    node_srjdeaprlx0012    READER_1_1_1    PWXPC_10035    [ERROR] Error message: [

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

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

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

      [Informatica][SCLI PWX Driver] PWX-04566 Capture Extract RC=4606 from CAPX_Interest_list

      [Informatica][SCLI PWX Driver] PWX-04606 Connection lookup failed for  and registration tag DB2DSD0isotbp061.

      [Informatica][SCLI PWX Driver] PWX-21602 Connection for DB2 not found in configuration.  Type used to find any connection.

      [Informatica][SCLI PWX Driver] PWX-21603 Connection of type DB2.DB2<?> not found in configuration.

      [Informatica][SCLI PWX Driver] PWX-04584 CAPXRT Application <wkf_CDC_ISOTBP06_DOC> CAPX type <CC> Extract map <d1dsd0.isotbp06.isotbp06_documento> source type <DB2> Before & After images No CDEP IO

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


      Thanks, Victor Lima