0 Replies Latest reply on Aug 31, 2020 9:31 PM by LUIZ CARLOS SANTOS

    Parameter query Salesforce with Bulk API options

    LUIZ CARLOS SANTOS New Member

      Hi guys,

       

      I'm sorry about my English. I have the following problem:
      I have a process that reads a salesforce table and generates a csv file.
      I'm using query to read the table and date parameter. In the options was to run using Bulk API, to use PK Chunking due to the high consumption of batches.

       

      When running with Bulk API, the process returns an error.

      READER_1_1_1> CMN_1761 [2020-08-27 14:24:26.391] Timestamp Event: [Thu Aug 27 14:24:26 2020]

      READER_1_1_1> GENERIC_READ_18 [2020-08-27 14:24:26.391] [ERROR] Error occurred while reading data from the target native system : [java.lang.ArrayIndexOutOfBoundsException: -1]

      READER_1_1_1> CMN_1761 [2020-08-27 14:24:26.391] Timestamp Event: [Thu Aug 27 14:24:26 2020]

      READER_1_1_1> JAVA PLUGIN_1762 [2020-08-27 14:24:26.391] [ERROR] com.informatica.powercenter.sdk.SDKException: com.informatica.cloud.api.adapter.runtime.exception.ReadException: java.lang.ArrayIndexOutOfBoundsException: -1

      at com.informatica.cloud.adapter.sfdc.runtime.SFDCRead.fetch(Unknown Source)

      at com.informatica.cloud.adapter.sfdc.runtime.SFDCRead.read(Unknown Source)

      at com.informatica.cloud.adapter.sfdc.lw.runtime.SFDCReadLW.read(Unknown Source)

      at com.informatica.cloud.api.adapter.reader.runtime.GenericRdrPartitionDriver.run(Unknown Source)

      READER_1_1_1> CMN_1761 [2020-08-27 14:24:26.391] Timestamp Event: [Thu Aug 27 14:24:26 2020]

      READER_1_1_1> JAVA PLUGIN_1762 [2020-08-27 14:24:26.391] [ERROR]

      READER_1_1_1> CMN_1761 [2020-08-27 14:24:26.392] Timestamp Event: [Thu Aug 27 14:24:26 2020]

      READER_1_1_1> JAVA PLUGIN_1762 [2020-08-27 14:24:26.392] [ERROR] at com.informatica.cloud.api.adapter.reader.runtime.GenericRdrPartitionDriver.run(Unknown Source)

      READER_1_1_1> CMN_1761 [2020-08-27 14:24:26.392] Timestamp Event: [Thu Aug 27 14:24:26 2020]

      READER_1_1_1> SDKS_38200 [2020-08-27 14:24:26.392] Partition-level [src_SF_Case]: Plug-in #500100 failed in run().

      WRITER_1_*_1> WRT_8333 [2020-08-27 14:24:26.392] Rolling back all the targets due to fatal session error.

      WRITER_1_*_1> WRT_8035 [2020-08-27 14:24:26.392] Load complete time: Thu Aug 27 14:24:26 2020

      .

      .

      .

      Thread [TRANSF_1_1_1] created for [the transformation stage] of partition point [src_SF_Case] has completed. The total run time was insufficient for any meaningful statistics.

      Thread [WRITER_1_*_1] created for [the write stage] of partition point [Case_csv] has completed. The total run time was insufficient for any meaningful statistics.


      However when I run with Standard API, the process works.

      READER_1_1_1> SalesforceReader_10143 [2020-08-27 14:33:59.902] [INFO] Total Expected Records from Salesforce is 269.  

      WRITER_1_*_1> WRT_8167 [2020-08-27 14:34:00.117] Start loading table [Case_csv] at: Thu Aug 27 14:33:59 2020

      TRANSF_1_1_1> DBG_21216 [2020-08-27 14:34:00.662] Finished transformations for Source Qualifier [src_SF_Case]. Total errors [0]

      WRITER_1_*_1> FTP_14069 [2020-08-27 14:34:00.727] The remote SFTP server supports these authentication methods: [publickey,password].

      WRITER_1_*_1> FTP_14070 [2020-08-27 14:34:00.752] Password authentication method succeeded.

      WRITER_1_*_1> WRT_8168 [2020-08-27 14:34:00.887] End loading table [Case_csv] at: Thu Aug 27 14:34:00 2020

      WRITER_1_*_1> WRT_8035 [2020-08-27 14:34:00.887] Load complete time: Thu Aug 27 14:34:00 2020


      Would anyone know how to use the Bulk API because the process does not work?