Description
We have Kubernetes pod setup and using java code(salesforce soap api libraries like force-partner-api and force-wsc) running on api version 58.0 . On daily basis approximately 1400 calls are made and data is received successfully but once in 3-4 weeks we get this connection error while fetching the case records and we have tried multiple times to re-establish the connection but still we see the same error. Only thing that helps is killing the current Kubernetes pod and recreating the new one. So, every time the new pod is created it has a new ip address.
We have tried searching for this error and found this issue : #203
were updating the api helped but in our case we are using 58.0 already
This is the query we are using:
SELECT Id,CaseNumber,Subject,Description,Category__c,ContactEmail
FROM Case
WHERE CreatedDate > [some date time]
AND IsClosed = False
AND RecordTypeId = 'RecordId'
This is the competed description of the error:
2024-02-12T07:32:10.083Z WARN 1 --- [ scheduling-1] c.s.cxe.suggestion.sfdc.SfdcClient : Connection problem:com.sforce.soap.partner.fault.UnexpectedErrorFault: null at jdk.internal.reflect.GeneratedConstructorAccessor142.newInstance(Unknown Source) ~[na:na] at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:na] at java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:499) ~[na:na] at java.base/java.lang.reflect.ReflectAccess.newInstance(ReflectAccess.java:128) ~[na:na] at java.base/jdk.internal.reflect.ReflectionFactory.newInstance(ReflectionFactory.java:350) ~[na:na] at java.base/java.lang.Class.newInstance(Class.java:642) ~[na:na] at com.sforce.ws.bind.TypeMapper.readSingle(TypeMapper.java:721) ~[force-wsc-58.0.0.jar!/:na] at com.sforce.ws.bind.TypeMapper.readObject(TypeMapper.java:593) ~[force-wsc-58.0.0.jar!/:na] at com.sforce.ws.transport.SoapConnection.parseDetail(SoapConnection.java:250) ~[force-wsc-58.0.0.jar!/:na] at com.sforce.ws.transport.SoapConnection.createException(SoapConnection.java:224) ~[force-wsc-58.0.0.jar!/:na] at com.sforce.ws.transport.SoapConnection.receive(SoapConnection.java:163) ~[force-wsc-58.0.0.jar!/:na] at com.sforce.ws.transport.SoapConnection.send(SoapConnection.java:108) ~[force-wsc-58.0.0.jar!/:na] at com.sforce.soap.partner.PartnerConnection.queryAll(PartnerConnection.java:835) ~[force-partner-api-58.0.0.jar!/:na] at com.snowflake.cxe.suggestion.sfdc.SfdcConnection.lambda$queryAll$1(SfdcConnection.java:53) ~[libsfdc.jar!/:na] at com.snowflake.cxe.suggestion.sfdc.SfdcConnection.recreateConnectionOnUnexpectedErrorFault(SfdcConnection.java:73) ~[libsfdc.jar!/:na] at com.snowflake.cxe.suggestion.sfdc.SfdcConnection.queryAll(SfdcConnection.java:53) ~[libsfdc.jar!/:na] at com.snowflake.cxe.suggestion.sfdc.SfdcClientReal.getNewCases(SfdcClientReal.java:138) ~[libsfdc.jar!/:na] at com.snowflake.cxe.suggestion.service.CommentSuggestion.addNewCases(CommentSuggestion.java:83) ~[libservice.jar!/:na] at jdk.internal.reflect.GeneratedMethodAccessor232.invoke(Unknown Source) ~[na:na] at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:na] at java.base/java.lang.reflect.Method.invoke(Method.java:568) ~[na:na] at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:84) ~[spring-context-6.0.13.jar!/:6.0.13] at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54) ~[spring-context-6.0.13.jar!/:6.0.13] at org.springframework.scheduling.concurrent.ReschedulingRunnable.run(ReschedulingRunnable.java:96) ~[spring-context-6.0.13.jar!/:6.0.13] at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) ~[na:na] at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) ~[na:na] at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:304) ~[na:na] at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1135) ~[na:na] at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) ~[na:na] at java.base/java.lang.Thread.run(Thread.java:831) ~[na:na]