3 Replies Latest reply on Aug 15, 2019 11:08 PM by mini mishra

    Unable to open the remote file over SFTP Error

    mini mishra Seasoned Veteran

      Hi All,

       

      We are facing below issue in one of our Informatica workflows:

       

      FTP_14072 Using Public Key file: [/home/a_informatica/.ssh/id_act_rsa.pub].

      FTP_14073 Using Private Key file: [/home/a_informatica/.ssh/id_act_rsa].

      FTP_14075 Public Key authentication method succeeded.

      CMN_1761 Timestamp Event: [Fri May 10 13:58:13 2019]

      FTP_14068 Unable to open the remote file [/apps/landing_pad/a_actxfr/ch_sur/in/abc.dat] over SFTP: [].

      READER_1_1_1> CMN_1761 Timestamp Event: [Fri May 10 13:58:14 2019]

      READER_1_1_1> FR_3111 Error in transferring remote files over SFTP.

      READER_1_1_1> CMN_1761 Timestamp Event: [Fri May 10 13:58:14 2019]

      READER_1_1_1> BLKR_16002 ERROR: Initialization failed.

      MANAGER> PETL_24031

       

       

      We manually checked whether file is getting copied properly over SFTP or not? Yes, It was but we are facing above error through Informatica. We also verified whether Informatica user has required READ privileges or not.? Yes, it has.

       

       

      bash-4.1$ ls -l /apps/landing_pad/a_actxfr/ch_sur/in/abc.dat

      rw-rr- 1 a_actxfr a_actxfr 269 May 10 13:39 /apps/landing_pad/a_actxfr/ch_sur/in/abc.dat

      bash-4.1$ cat /apps/landing_pad/a_actxfr/ch_sur/in/abc.dat

      1000194,0,12-APR-19,101.93,106.48,101.93,105.31,1126555,777019.2,766699.173913044,823506.580645161,15.9014630320117,6.6646409399372,6.6646409399372,6.83778025768489,5.86047446722959,6.7727871, 442665,4.46384773864417,3.20957174057544,17634081,SYSYTEM,16-APR-19,LOW,XYZ

      bash-4.1$

       

       

      Now, what else can be the cause of this error?

       

      Regards,

      Komal.