1 Reply Latest reply on May 16, 2018 12:37 AM by Nico Heinze

    Power exchange workflow is failied with error

    Janardhan Gullapalli Active Member

      Hi All,

       

      We installed Informatica power cenetr and power exchage on smae server and configured environmental variables like INFA_HOME,PWX_HOME,ODBC_HOME,PWX_CONFIG variables.

      Power exchage we are using to get the change date from Sql server (CDC).Since our Informatica and SQl server are running on Windows O.S we install  power exchage also in Informatica power cenetr meachine.

       

      We configured dbmover and pexccl files and we created extraction groups .

       

      When we created worklfow and run the flow it is failed with below error.Kindly help us

      [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>.

      [Informatica][SCLI PWX Driver] PWX-01266 DBNTC Receive READ header for file <Capture Extract> 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 CAPXSYNC. 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-00268 DBAPI Error. DB_OPEN failed for file D:\App\Informatica\PowerExchange\capture\CDCT_RHEA000.

      [Informatica][SCLI PWX Driver] PWX-00150 DBAPI SEQ Filename "D:\App\Informatica\PowerExchange\capture\CDCT_RHEA000" Open error reason 0002 <non-CISAM error No such file or directory>.

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

        • 1. Re: Power exchange workflow is failied with error
          Nico Heinze Guru

          Two things.

           

          First you should always post such questions on the PowerExchange (for mainframe-related questions) or PowerExchange Adapters (all other PowerExchange products) forum, not here. There you will find the real experts.

           

          Second a question: is drive D: a mapped network drive?

          If this is the case, then you should replace this drive letter by a UNC path; mapped network drives do NOT work for Windows service users (thanks to the security context which is set up long before mapped network drives are available to a Windows service).

           

          Regards,

          Nico