Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: Can not read data from Salesforce!

  1. #1
    Join Date
    Feb 2017
    Posts
    6

    Default Can not read data from Salesforce!

    Experts ! am getting the below error while running the pentaho salesforce input. Note that it reads data to some extent and then fails with the below error.
    Am using Pentaho 6.


    Salesforce Input.0 - Error while reading data from Salesforce :
    Salesforce Input.0 - Can not read data from Salesforce!
    Salesforce Input.0 - Error while calling queryMore!
    Salesforce Input.0 - java.net.SocketException: Connection reset

  2. #2
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    The server felt neglected for too long, so it cut the connection.
    You should know where you spent all the time.

  3. #3
    Join Date
    Feb 2017
    Posts
    6

    Default

    Thanks for the reply. But is there a way to address this issue ? Can we set the batch size in the salesforce input ? Have you tired doing anything like that ?

  4. #4
    Join Date
    Aug 2011
    Posts
    236

    Default

    Hi mashraf,

    Sounds like the query you are trying to run is taking too long to get results from the API. You can try looping through dates based on created_date for records in the table.

    Not sure on your data volume, but you could try 6,3 or 1 month chunks. You can also experiment within the Salesforce input component to see what works for you.

    Good luck.
    PDI 8.0.0
    MySQL - 5.6.27
    Redshift - 1.0.1485
    PostgreSQL 8.0.2
    OS - Ubuntu 10.04.2

  5. #5
    Join Date
    Feb 2017
    Posts
    6

    Default

    Thank you, will certainly give a try. In the meantime, if you find any other solutions, please keep me posted.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.