• Lucas Lu 10
  • NEWBIE
  • 0 Points
  • Member since 2017

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 0
    Questions
  • 2
    Replies
Hello,
   We routinely collect objects' data from our salesforce org via running SOQL querries using the API, authenticating via token and refresh token.  Starting 4/29/17 we started to see our connection being reset after a few batches of data (Log below).  We are able to collect this data from our staging server (even thought we still saw some of these errors), but for some reason our connection is always being reset on our production server.  The call that we usually see this error on is the authentication call to refresh our token.

IOException encountered with Task Id 41106a96-fa94-40e3-ba0c-4518002516d1 java.net.SocketException: Connection reset     at java.net.SocketInputStream.read(SocketInputStream.java:210)     at java.net.SocketInputStream.read(SocketInputStream.java:141)     at sun.security.ssl.InputRecord.readFully(InputRecord.java:465)     at sun.security.ssl.InputRecord.read(InputRecord.java:503)     at sun.security.ssl.SSLSocketImpl.readRecord(SSLSocketImpl.java:973)     at sun.security.ssl.SSLSocketImpl.readDataRecord(SSLSocketImpl.java:930)     at sun.security.ssl.AppInputStream.read(AppInputStream.java:105)     at org.apache.http.impl.io.SessionInputBufferImpl.streamRead(SessionInputBufferImpl.java:136)     at org.apache.http.impl.io.SessionInputBufferImpl.fillBuffer(SessionInputBufferImpl.java:152)     at org.apache.http.impl.io.SessionInputBufferImpl.readLine(SessionInputBufferImpl.java:270)     at org.apache.http.impl.conn.DefaultHttpResponseParser.parseHead(DefaultHttpResponseParser.java:140)     at org.apache.http.impl.conn.DefaultHttpResponseParser.parseHead(DefaultHttpResponseParser.java:57)     at org.apache.http.impl.io.AbstractMessageParser.parse(AbstractMessageParser.java:260)     at org.apache.http.impl.DefaultBHttpClientConnection.receiveResponseHeader(DefaultBHttpClientConnection.java:161)     at org.apache.http.impl.conn.CPoolProxy.receiveResponseHeader(CPoolProxy.java:153)     at org.apache.http.protocol.HttpRequestExecutor.doReceiveResponse(HttpRequestExecutor.java:271)     at org.apache.http.protocol.HttpRequestExecutor.execute(HttpRequestExecutor.java:123)     at org.apache.http.impl.execchain.MainClientExec.execute(MainClientExec.java:254)     at org.apache.http.impl.execchain.ProtocolExec.execute(ProtocolExec.java:195)     at org.apache.http.impl.execchain.RetryExec.execute(RetryExec.java:86)     at org.apache.http.impl.execchain.RedirectExec.execute(RedirectExec.java:108)     at org.apache.http.impl.client.InternalHttpClient.doExecute(InternalHttpClient.java:184)     at org.apache.http.impl.client.CloseableHttpClient.execute(CloseableHttpClient.java:82)     at org.apache.http.impl.client.CloseableHttpClient.execute(CloseableHttpClient.java:106)     at org.apache.http.impl.client.CloseableHttpClient.execute(CloseableHttpClient.java:57)     at org.apache.http.client.fluent.Request.execute(Request.java:143)     at com.unified.utils.http.HttpUtils.request(HttpUtils.java:236)     at com.unified.utils.http.HttpUtils.request(HttpUtils.java:185)     at com.unified.utils.http.HttpUtils.post(HttpUtils.java:118)     at com.unified.utils.http.HttpUtils.postJson(HttpUtils.java:102)     at com.unified.platform.socialapi.SocialAPI.postWithBasicAuthorization(SocialAPI.java:248)     at com.unified.platform.socialapi.SocialAPI.postWithBasicAuthorization(SocialAPI.java:275)     at com.unified.platform.collectors.salesforce.SalesforceBaseCollector.requestAuthToken(SalesforceBaseCollector.java:101)     at com.unified.platform.collectors.salesforce.SalesforceBaseCollector.run(SalesforceBaseCollector.java:114)     at com.unified.platform.collectors.BaseCollector.collect(BaseCollector.java:944)     at com.unified.platform.collectionengine.processor.CollectionTaskProcessor.doWork(CollectionTaskProcessor.java:159)     at com.google.common.collect.ImmutableList.forEach(ImmutableList.java:408)     at com.unified.platform.collectionengine.processor.CollectionTaskProcessor.processMessages(CollectionTaskProcessor.java:124)     at com.unified.platform.messagebus.processor.AbstractProcessor.processMessages(AbstractProcessor.java:153)     at com.unified.platform.messagebus.processor.AbstractProcessor.lambda$processMessageTask$0(AbstractProcessor.java:276)     at java.util.concurrent.FutureTask.run(FutureTask.java:266)     at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)     at java.util.concurrent.FutureTask.run(FutureTask.java:266)     at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)     at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)     at java.lang.Thread.run(Thread.java:745)

Any ideas why we would be experiencing this error?

Thanks for the help!

Over the past week, I've been getting intermittent "Connection reset by peer" errors while querying contacts.

2004-04-13 15:42:46,002 INFO  CaIntegration.CaIntegration doIntegration (CaIntegration.java:777) - Found a total of 12017 records in contact
2004-04-13 15:42:55,241 INFO  CaIntegration.CaIntegration manageInsertOrUpdate (CaIntegration.java:621) - About to query sforce for more info about records#0 to 199(200)
2004-04-13 15:43:32,639 INFO  CaIntegration.CaIntegration manageInsertOrUpdate (CaIntegration.java:633) - Adding data to the DB
...

2004-04-13 15:44:13,486 INFO  CaIntegration.CaIntegration manageInsertOrUpdate (CaIntegration.java:621) - About to query sforce for more info about records#600 to 799(200)
2004-04-13 15:44:13,862 ERROR CaIntegration.CaIntegration doIntegration (CaIntegration.java:820) - Failed to transfer data for entity contact because of error:
com.salesforce.common.exceptions.IntegrationException: Failed to query sforce records: com.salesforce.common.exceptions.SforceException: Cannot retrieve data from contact because java.net.SocketException: Connection reset by peer: Connection reset by peer
Attempting to recover...
2004-04-13 15:44:13,968 INFO  CaIntegration.CaIntegration cleanup (CaIntegration.java:137) - Connection to sforce closed

 

The line which throws this exception is:

                sobjects = binding.retrieve(fieldList, entityName, idList);

Similiar queries to account doesn't result in any issues. I'm using Java 1.3 (for deployment compliance reasons) with SOAP API 2.5.

 

Has anyone else seen this?