cancel
Showing results for 
Search instead for 
Did you mean: 

Salesforce adapter Metadata Error

Former Member
0 Kudos

Greetings,

I've been trying to connect the datastore to using the salesforce adapter, so far from the configurations there has been no problem, but now the Datastore is created and whenever i try to get to see the metada data the same error has been appearing:

"Cannot browse external metadata for adapter instance <Salesforce_adapter) at <serverxxx>.

<Can't browse adapter metadata.

Error message: Error browsing root nodes. Xml generated so far: []; com.acta.adapter.salesforce.exceptions.CommunicationFailureException: There was a communication error when talking to Salesforce.com: Connection has been shutdown: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target. (BODI-1112008>.

Possible reasons:

1. Cannot start adapter instance.

2. Job Server is not Started;

3 Adapter datastore is not adjusted after import.

4. Adapter was shut down but not restarted yet. (BODI-1112326)"

For better Visualization the TXT for the logs are attached.

This is the error generated in from the error file of the adapter:

8/24/15 3:28:21 PMThere was a communication error when talking to Salesforce.com: Connection has been shutdown: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
8/24/15 3:28:21 PMFault-tolerance-login-failed : There was a communication error when talking to Salesforce.com: Connection has been shutdown: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
8/24/15 3:28:21 PMRetry : 3. Waiting 45 mins before trying to login to Salesforce.com again.
8/24/15 3:29:51 PMThere was a communication error when talking to Salesforce.com: Connection has been shutdown: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
8/24/15 3:29:51 PMFault-tolerance-login-failed : There was a communication error when talking to Salesforce.com: Connection has been shutdown: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
8/24/15 3:29:51 PMRetry : 3. Waiting 45 mins before trying to login to Salesforce.com again.
8/24/15 3:31:23 PMThere was a communication error when talking to Salesforce.com: Connection has been shutdown: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
8/24/15 3:31:23 PMFault-tolerance-login-failed : There was a communication error when talking to Salesforce.com: Connection has been shutdown: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
8/24/15 3:31:23 PMRetry : 3. Waiting 45 mins before trying to login to Salesforce.com again.
8/24/15 3:32:53 PMThere was a communication error when talking to Salesforce.com: Connection has been shutdown: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
8/24/15 3:32:53 PMFault-tolerance-login-failed : There was a communication error when talking to Salesforce.com: Connection has been shutdown: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
8/24/15 3:32:53 PMRetry : 3. Waiting 45 mins before trying to login to Salesforce.com again.
8/24/15 3:34:48 PMThere was a communication error when talking to Salesforce.com: Connection has been shutdown: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
8/24/15 3:34:48 PMFault-tolerance-login-failed : There was a communication error when talking to Salesforce.com: Connection has been shutdown: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
8/24/15 3:34:48 PMRetry : 3. Waiting 45 mins before trying to login to Salesforce.com again.
8/24/15 3:36:19 PMThere was a communication error when talking to Salesforce.com: Connection has been shutdown: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
8/24/15 3:36:19 PMFault-tolerance-login-failed : There was a communication error when talking to Salesforce.com: Connection has been shutdown: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
8/24/15 3:36:19 PMRetry : 3. Waiting 45 mins before trying to login to Salesforce.com again.
8/24/15 3:37:50 PMThere was a communication error when talking to Salesforce.com: Connection has been shutdown: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
8/24/15 3:37:50 PMFault-tolerance-login-failed : There was a communication error when talking to Salesforce.com: Connection has been shutdown: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
8/24/15 3:37:50 PMRetry : 3. Waiting 45 mins before trying to login to Salesforce.com again.
8/24/15 3:39:21 PMThere was a communication error when talking to Salesforce.com: Connection has been shutdown: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
8/24/15 3:39:21 PMFault-tolerance-login-failed : There was a communication error when talking to Salesforce.com: Connection has been shutdown: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
8/24/15 3:39:21 PMRetry : 3. Waiting 45 mins before trying to login to Salesforce.com again.
8/24/15 3:44:34 PMThere was a communication error when talking to Salesforce.com: Connection has been shutdown: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
8/24/15 3:44:34 PMError browsing root nodes. Xml generated so far: []. com.acta.adapter.salesforce.exceptions.CommunicationFailureException: There was a communication error when talking to Salesforce.com: Connection has been shutdown: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
at com.acta.adapter.salesforce.SForceMetadata.describeGlobal(SForceMetadata.java:46)
at com.acta.adapter.salesforce.metadata.SForceBrowsing.getRootNodes(SForceBrowsing.java:72)
at com.acta.adapter.sdk.AdapterRunnerImpl.processBrowseRoot(AdapterRunnerImpl.java:2532)
at com.acta.adapter.sdk.AdapterServiceDataListener.handleBrokerMessage(AdapterServiceDataListener.java:106)
at com.acta.brokerclient.BrokerClient.handleMessage(BrokerClient.java:406)
at com.acta.brokerclient.BrokerClient.access$100(BrokerClient.java:53)
at com.acta.brokerclient.BrokerClient$MessageHandler.run(BrokerClient.java:1559)

at com.acta.brokerclient.ThreadPool$PoolThread.run(ThreadPool.java:100)

And this is the full Tracelog:


ilding failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target

8/24/15 3:22:48 PM Thread[Thread-18,5,main] Fault-tolerance-login-failed : There was a communication error when talking to Salesforce.com: Connection has been shutdown: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target

8/24/15 3:22:48 PM Thread[Thread-18,5,main] Retry : 2. Waiting 15 mins before trying to login to Salesforce.com again.

8/24/15 3:24:18 PM Thread[Thread-19,5,main] Login to Salesforce, attempt : 2

8/24/15 3:24:19 PM Thread[Thread-19,5,main] There was a communication error when talking to Salesforce.com: Connection has been shutdown: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target

8/24/15 3:24:19 PM Thread[Thread-19,5,main] Fault-tolerance-login-failed : There was a communication error when talking to Salesforce.com: Connection has been shutdown: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target

8/24/15 3:24:19 PM Thread[Thread-19,5,main] Retry : 2. Waiting 15 mins before trying to login to Salesforce.com again.

8/24/15 3:26:31 PM Thread[Thread-20,5,main] Receive message:  BrokerMessage(

_e.ErrorsTo=com.acta.adapter..client.dataAndMetadata_166

_e.Timestamp=Mon Aug 24 15:26:31 2015

_e.SourceTimeoutLength=90000

_e.MessageID=368

_e.Destination=com.acta.adapter.salesforce.SalesForceAdapter.data_116

_e.MessageType=MSG_ADAPTER_BROWSE_STOP

_e.ReplyTo=com.acta.adapter..client.dataAndMetadata_166

_e.CorrelationID=367_com.acta.adapter..client.dataAndMetadata_166

_a.MSGFIELD_ADAPTER_SESSION_ID=18

_e.Source=com.acta.adapter..client.dataAndMetadata_166)

8/24/15 3:26:31 PM Thread[Thread-20,5,main] Process Browse request. Message: BrokerMessage(

_e.ErrorsTo=com.acta.adapter..client.dataAndMetadata_166

_e.Timestamp=Mon Aug 24 15:26:31 2015

_e.SourceTimeoutLength=90000

_e.MessageID=368

_e.Destination=com.acta.adapter.salesforce.SalesForceAdapter.data_116

_e.MessageType=MSG_ADAPTER_BROWSE_STOP

_e.ReplyTo=com.acta.adapter..client.dataAndMetadata_166

_e.CorrelationID=367_com.acta.adapter..client.dataAndMetadata_166

_a.MSGFIELD_ADAPTER_SESSION_ID=18

_e.Source=com.acta.adapter..client.dataAndMetadata_166)

8/24/15 3:26:31 PM Thread[Thread-20,5,main] Receive message:  BrokerMessage(

_e.ErrorsTo=com.acta.adapter..client.dataAndMetadata_166

_e.Timestamp=Mon Aug 24 15:26:31 2015

_e.SourceTimeoutLength=90000

_e.MessageID=370

_e.Destination=com.acta.adapter.salesforce.SalesForceAdapter.data_116

_e.MessageType=MSG_ADAPTER_BROWSE_START

_e.ReplyTo=com.acta.adapter..client.dataAndMetadata_166

_e.CorrelationID=369_com.acta.adapter..client.dataAndMetadata_166

_a.MSGFIELD_ADAPTER_SESSION_ID=18

_e.Source=com.acta.adapter..client.dataAndMetadata_166)

8/24/15 3:26:31 PM Thread[Thread-20,5,main] Process Browse request. Message: BrokerMessage(

_e.ErrorsTo=com.acta.adapter..client.dataAndMetadata_166

_e.Timestamp=Mon Aug 24 15:26:31 2015

_e.SourceTimeoutLength=90000

_e.MessageID=370

_e.Destination=com.acta.adapter.salesforce.SalesForceAdapter.data_116

_e.MessageType=MSG_ADAPTER_BROWSE_START

_e.ReplyTo=com.acta.adapter..client.dataAndMetadata_166

_e.CorrelationID=369_com.acta.adapter..client.dataAndMetadata_166

_a.MSGFIELD_ADAPTER_SESSION_ID=18

_e.Source=com.acta.adapter..client.dataAndMetadata_166)

8/24/15 3:26:31 PM Thread[Thread-20,5,main] Starting SForceMetadata Session

8/24/15 3:26:31 PM Thread[Thread-20,5,main] Receive message:  BrokerMessage(

_e.ErrorsTo=com.acta.adapter..client.dataAndMetadata_166

_e.Timestamp=Mon Aug 24 15:26:31 2015

_e.SourceTimeoutLength=90000

_e.MessageID=372

_e.Destination=com.acta.adapter.salesforce.SalesForceAdapter.data_116

_e.MessageType=MSG_ADAPTER_BROWSE_ROOT

_e.ReplyTo=com.acta.adapter..client.dataAndMetadata_166

_e.CorrelationID=371_com.acta.adapter..client.dataAndMetadata_166

_a.MSGFIELD_ADAPTER_SESSION_ID=18

_e.Source=com.acta.adapter..client.dataAndMetadata_166)

8/24/15 3:26:31 PM Thread[Thread-20,5,main] Process Browse request. Message: BrokerMessage(

_e.ErrorsTo=com.acta.adapter..client.dataAndMetadata_166

_e.Timestamp=Mon Aug 24 15:26:31 2015

_e.SourceTimeoutLength=90000

_e.MessageID=372

_e.Destination=com.acta.adapter.salesforce.SalesForceAdapter.data_116

_e.MessageType=MSG_ADAPTER_BROWSE_ROOT

_e.ReplyTo=com.acta.adapter..client.dataAndMetadata_166

_e.CorrelationID=371_com.acta.adapter..client.dataAndMetadata_166

_a.MSGFIELD_ADAPTER_SESSION_ID=18

_e.Source=com.acta.adapter..client.dataAndMetadata_166)

8/24/15 3:26:33 PM Thread[Thread-20,5,main] There was a communication error when talking to Salesforce.com: Connection has been shutdown: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target

8/24/15 3:26:33 PM Thread[Thread-20,5,main] Error browsing root nodes. Xml generated so far: []. com.acta.adapter.salesforce.exceptions.CommunicationFailureException: There was a communication error when talking to Salesforce.com: Connection has been shutdown: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target

  at com.acta.adapter.salesforce.SForceMetadata.describeGlobal(SForceMetadata.java:46)

  at com.acta.adapter.salesforce.metadata.SForceBrowsing.getRootNodes(SForceBrowsing.java:72)

  at com.acta.adapter.sdk.AdapterRunnerImpl.processBrowseRoot(AdapterRunnerImpl.java:2532)

  at com.acta.adapter.sdk.AdapterServiceDataListener.handleBrokerMessage(AdapterServiceDataListener.java:106)

  at com.acta.brokerclient.BrokerClient.handleMessage(BrokerClient.java:406)

  at com.acta.brokerclient.BrokerClient.access$100(BrokerClient.java:53)

  at com.acta.brokerclient.BrokerClient$MessageHandler.run(BrokerClient.java:1559)

  at com.acta.brokerclient.ThreadPool$PoolThread.run(ThreadPool.java:100)

8/24/15 3:27:03 PM Thread[Thread-20,5,main] Receive message:  BrokerMessage(

_e.ErrorsTo=com.acta.adapter..client.dataAndMetadata_166

_e.Timestamp=Mon Aug 24 15:27:03 2015

_e.SourceTimeoutLength=90000

_e.MessageID=374

_e.Destination=com.acta.adapter.salesforce.SalesForceAdapter.data_116

_e.MessageType=MSG_ADAPTER_SHUTDOWN_SESSION

_e.ReplyTo=com.acta.adapter..client.dataAndMetadata_166

_e.CorrelationID=373_com.acta.adapter..client.dataAndMetadata_166

_a.MSGFIELD_ADAPTER_SESSION_ID=18

_e.Source=com.acta.adapter..client.dataAndMetadata_166)

8/24/15 3:27:03 PM Thread[Thread-20,5,main] Process Stop request. Message: BrokerMessage(

_e.ErrorsTo=com.acta.adapter..client.dataAndMetadata_166

_e.Timestamp=Mon Aug 24 15:27:03 2015

_e.SourceTimeoutLength=90000

_e.MessageID=374

_e.Destination=com.acta.adapter.salesforce.SalesForceAdapter.data_116

_e.MessageType=MSG_ADAPTER_SHUTDOWN_SESSION

_e.ReplyTo=com.acta.adapter..client.dataAndMetadata_166

_e.CorrelationID=373_com.acta.adapter..client.dataAndMetadata_166

_a.MSGFIELD_ADAPTER_SESSION_ID=18

_e.Source=com.acta.adapter..client.dataAndMetadata_166)

8/24/15 3:27:03 PM Thread[Thread-20,5,main] com.acta.adapter.salesforce.SForceSession@1b020bff Stopping the Salesforce.com session

8/24/15 3:27:03 PM Thread[Thread-20,5,main] Stopping SForceMetadata Session

8/24/15 3:27:16 PM Thread[Thread-5,5,main] Receive message: BrokerMessage(

_e.ErrorsTo=com.acta.adapter.Manager

_e.Timestamp=Mon Aug 24 15:27:16 2015

_e.SourceTimeoutLength=10000

_e.MessageID=666

_e.Destination=adapter.Salesforce_Adapter

_e.MessageType=MSG_ADAPTER_STATUS

_e.ReplyTo=com.acta.adapter.Manager

_e.CorrelationID=665_com.acta.adapter.Manager

_e.Source=com.acta.adapter.Manager)

8/24/15 3:27:16 PM Thread[Thread-5,5,main] Process adapter status request. Message: BrokerMessage(

_e.ErrorsTo=com.acta.adapter.Manager

_e.Timestamp=Mon Aug 24 15:27:16 2015

_e.SourceTimeoutLength=10000

_e.MessageID=666

_e.Destination=adapter.Salesforce_Adapter

_e.MessageType=MSG_ADAPTER_STATUS

_e.ReplyTo=com.acta.adapter.Manager

_e.CorrelationID=665_com.acta.adapter.Manager

_e.Source=com.acta.adapter.Manager)

8/24/15 3:27:20 PM Thread[Thread-5,5,main] Receive message: BrokerMessage(

_e.ErrorsTo=com.acta.adapter.Manager

_e.Timestamp=Mon Aug 24 15:27:20 2015

_e.SourceTimeoutLength=10000

_e.MessageID=673

_e.Destination=adapter.Salesforce_Adapter

_e.MessageType=MSG_ADAPTER_STATUS

_e.ReplyTo=com.acta.adapter.Manager

_e.CorrelationID=672_com.acta.adapter.Manager

_e.Source=com.acta.adapter.Manager)

8/24/15 3:27:20 PM Thread[Thread-5,5,main] Process adapter status request. Message: BrokerMessage(

_e.ErrorsTo=com.acta.adapter.Manager

_e.Timestamp=Mon Aug 24 15:27:20 2015

_e.SourceTimeoutLength=10000

_e.MessageID=673

_e.Destination=adapter.Salesforce_Adapter

_e.MessageType=MSG_ADAPTER_STATUS

_e.ReplyTo=com.acta.adapter.Manager

_e.CorrelationID=672_com.acta.adapter.Manager

_e.Source=com.acta.adapter.Manager)

8/24/15 3:28:19 PM Thread[Thread-10,5,main] Login to Salesforce, attempt : 3

8/24/15 3:28:21 PM Thread[Thread-10,5,main] There was a communication error when talking to Salesforce.com: Connection has been shutdown: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target

8/24/15 3:28:21 PM Thread[Thread-10,5,main] Fault-tolerance-login-failed : There was a communication error when talking to Salesforce.com: Connection has been shutdown: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target

8/24/15 3:28:21 PM Thread[Thread-10,5,main] Retry : 3. Waiting 45 mins before trying to login to Salesforce.com again.

8/24/15 3:29:50 PM Thread[Thread-13,5,main] Login to Salesforce, attempt : 3

8/24/15 3:29:51 PM Thread[Thread-13,5,main] There was a communication error when talking to Salesforce.com: Connection has been shutdown: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target

8/24/15 3:29:51 PM Thread[Thread-13,5,main] Fault-tolerance-login-failed : There was a communication error when talking to Salesforce.com: Connection has been shutdown: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target

8/24/15 3:29:51 PM Thread[Thread-13,5,main] Retry : 3. Waiting 45 mins before trying to login to Salesforce.com again.

8/24/15 3:31:21 PM Thread[Thread-14,5,main] Login to Salesforce, attempt : 3

8/24/15 3:31:23 PM Thread[Thread-14,5,main] There was a communication error when talking to Salesforce.com: Connection has been shutdown: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target

8/24/15 3:31:23 PM Thread[Thread-14,5,main] Fault-tolerance-login-failed : There was a communication error when talking to Salesforce.com: Connection has been shutdown: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target

8/24/15 3:31:23 PM Thread[Thread-14,5,main] Retry : 3. Waiting 45 mins before trying to login to Salesforce.com again.

8/24/15 3:32:52 PM Thread[Thread-15,5,main] Login to Salesforce, attempt : 3

8/24/15 3:32:53 PM Thread[Thread-15,5,main] There was a communication error when talking to Salesforce.com: Connection has been shutdown: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target

8/24/15 3:32:53 PM Thread[Thread-15,5,main] Fault-tolerance-login-failed : There was a communication error when talking to Salesforce.com: Connection has been shutdown: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target

8/24/15 3:32:53 PM Thread[Thread-15,5,main] Retry : 3. Waiting 45 mins before trying to login to Salesforce.com again.

8/24/15 3:34:46 PM Thread[Thread-16,5,main] Login to Salesforce, attempt : 3

8/24/15 3:34:48 PM Thread[Thread-16,5,main] There was a communication error when talking to Salesforce.com: Connection has been shutdown: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target

8/24/15 3:34:48 PM Thread[Thread-16,5,main] Fault-tolerance-login-failed : There was a communication error when talking to Salesforce.com: Connection has been shutdown: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target

8/24/15 3:34:48 PM Thread[Thread-16,5,main] Retry : 3. Waiting 45 mins before trying to login to Salesforce.com again.

8/24/15 3:36:18 PM Thread[Thread-17,5,main] Login to Salesforce, attempt : 3

8/24/15 3:36:19 PM Thread[Thread-17,5,main] There was a communication error when talking to Salesforce.com: Connection has been shutdown: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target

8/24/15 3:36:19 PM Thread[Thread-17,5,main] Fault-tolerance-login-failed : There was a communication error when talking to Salesforce.com: Connection has been shutdown: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target

8/24/15 3:36:19 PM Thread[Thread-17,5,main] Retry : 3. Waiting 45 mins before trying to login to Salesforce.com again.

8/24/15 3:37:48 PM Thread[Thread-18,5,main] Login to Salesforce, attempt : 3

8/24/15 3:37:50 PM Thread[Thread-18,5,main] There was a communication error when talking to Salesforce.com: Connection has been shutdown: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target

8/24/15 3:37:50 PM Thread[Thread-18,5,main] Fault-tolerance-login-failed : There was a communication error when talking to Salesforce.com: Connection has been shutdown: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target

8/24/15 3:37:50 PM Thread[Thread-18,5,main] Retry : 3. Waiting 45 mins before trying to login to Salesforce.com again.

8/24/15 3:39:19 PM Thread[Thread-19,5,main] Login to Salesforce, attempt : 3

8/24/15 3:39:21 PM Thread[Thread-19,5,main] There was a communication error when talking to Salesforce.com: Connection has been shutdown: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target

8/24/15 3:39:21 PM Thread[Thread-19,5,main] Fault-tolerance-login-failed : There was a communication error when talking to Salesforce.com: Connection has been shutdown: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target

8/24/15 3:39:21 PM Thread[Thread-19,5,main] Retry : 3. Waiting 45 mins before trying to login to Salesforce.com again.

8/24/15 3:44:32 PM Thread[Thread-20,5,main] Receive message:  BrokerMessage(

_e.ErrorsTo=com.acta.adapter..client.dataAndMetadata_194

_e.Timestamp=Mon Aug 24 15:44:32 2015

_e.SourceTimeoutLength=90000

_e.MessageID=382

_e.Destination=com.acta.adapter.salesforce.SalesForceAdapter.data_116

_e.MessageType=MSG_ADAPTER_START_SESSION

_e.ReplyTo=com.acta.adapter..client.dataAndMetadata_194

_e.CorrelationID=381_com.acta.adapter..client.dataAndMetadata_194

_e.Source=com.acta.adapter..client.dataAndMetadata_194

Data=<com.acta.adapter.salesforce.SForceSession>

<username Choices="" Default="" Description="Enter your Salesforce.com username" DisplayName="Username" Order="1" echo="true" isEditable="true" isHidden="false" isRequired="true">marvin.aquino@softplan.com.br</username>

<password Choices="" Default="" Description="Enter your Salesforce.com password" DisplayName="Password" Order="2" echo="false" isEditable="true" isHidden="false" isRequired="true">UNJteste1529ACFObfkv8UctcoxNzP9qSD5e</password>

<endPoint Choices="" Default="https://www.salesforce.com/services/Soap/u/21.0" Description="" DisplayName="Web service end point" Order="3" echo="true" isEditable="true" isHidden="false" isRequired="true">https://login.salesforce.com/services/Soap/u/32.0</endPoint>

<batchSize Choices="" Default="200" Description="Enter the batch size to use in Salesforce.com queries" DisplayName="Batch size" Order="4" echo="true" isEditable="true" isHidden="false" isRequired="true">200</batchSize>

<metadataResilience Choices="no|yes" Default="no" Description="Should the adapter be resilient with regard to metadata errors?" DisplayName="Metadata resilience?" Order="5" echo="true" isEditable="true" isHidden="false" isRequired="true">no</metadataResilience>

<cdc_enabled Choices="no|yes" Default="no" Description="Enable changed data capture for this datastore?" DisplayName="Enable CDC" Order="6" echo="true" isEditable="true" isHidden="false" isRequired="true">yes</cdc_enabled>

<defaultBase64BinarySize Choices="" Default="255" Description="Enter the default length for a Salesforce.com Base64Binary field" DisplayName="Default Base64Binary field length" Order="7" echo="true" isEditable="true" isHidden="false" isRequired="true">255</defaultBase64BinarySize>

<checkpointColumnName Choices="" Default="SFDC_TIMESTAMP" Description="" DisplayName="checkpointColumnName" Order="8" echo="true" isEditable="true" isHidden="true" isRequired="true">SFDC_TIMESTAMP</checkpointColumnName>

<disableDeleted Choices="true|false" Default="false" Description="In CDC load, disable retrieving deleted records." DisplayName="Disable CDC deleted records" Order="9" echo="true" isEditable="true" isHidden="false" isRequired="true">false</disableDeleted>

<disableUpserted Choices="true|false" Default="false" Description="In CDC load, disable retrieving updated or inserted records." DisplayName="Disable CDC upserted records" Order="10" echo="true" isEditable="true" isHidden="false" isRequired="true">false</disableUpserted>

<ConvertDate Choices="yes|no" Default="yes" Description="Convert Date to UTC format while reading and loading." DisplayName="Convert Date value to UTC" Order="11" echo="true" isEditable="true" isHidden="false" isRequired="true">yes</ConvertDate>

</com.acta.adapter.salesforce.SForceSession>)

8/24/15 3:44:32 PM Thread[Thread-20,5,main] processStartSession. Message =  BrokerMessage(

_e.ErrorsTo=com.acta.adapter..client.dataAndMetadata_194

_e.Timestamp=Mon Aug 24 15:44:32 2015

_e.SourceTimeoutLength=90000

_e.MessageID=382

_e.Destination=com.acta.adapter.salesforce.SalesForceAdapter.data_116

_e.MessageType=MSG_ADAPTER_START_SESSION

_e.ReplyTo=com.acta.adapter..client.dataAndMetadata_194

_e.CorrelationID=381_com.acta.adapter..client.dataAndMetadata_194

_e.Source=com.acta.adapter..client.dataAndMetadata_194

Data=<com.acta.adapter.salesforce.SForceSession>

<username Choices="" Default="" Description="Enter your Salesforce.com username" DisplayName="Username" Order="1" echo="true" isEditable="true" isHidden="false" isRequired="true">marvin.aquino@softplan.com.br</username>

<password Choices="" Default="" Description="Enter your Salesforce.com password" DisplayName="Password" Order="2" echo="false" isEditable="true" isHidden="false" isRequired="true">UNJteste1529ACFObfkv8UctcoxNzP9qSD5e</password>

<endPoint Choices="" Default="https://www.salesforce.com/services/Soap/u/21.0" Description="" DisplayName="Web service end point" Order="3" echo="true" isEditable="true" isHidden="false" isRequired="true">https://login.salesforce.com/services/Soap/u/32.0</endPoint>

<batchSize Choices="" Default="200" Description="Enter the batch size to use in Salesforce.com queries" DisplayName="Batch size" Order="4" echo="true" isEditable="true" isHidden="false" isRequired="true">200</batchSize>

<metadataResilience Choices="no|yes" Default="no" Description="Should the adapter be resilient with regard to metadata errors?" DisplayName="Metadata resilience?" Order="5" echo="true" isEditable="true" isHidden="false" isRequired="true">no</metadataResilience>

<cdc_enabled Choices="no|yes" Default="no" Description="Enable changed data capture for this datastore?" DisplayName="Enable CDC" Order="6" echo="true" isEditable="true" isHidden="false" isRequired="true">yes</cdc_enabled>

<defaultBase64BinarySize Choices="" Default="255" Description="Enter the default length for a Salesforce.com Base64Binary field" DisplayName="Default Base64Binary field length" Order="7" echo="true" isEditable="true" isHidden="false" isRequired="true">255</defaultBase64BinarySize>

<checkpointColumnName Choices="" Default="SFDC_TIMESTAMP" Description="" DisplayName="checkpointColumnName" Order="8" echo="true" isEditable="true" isHidden="true" isRequired="true">SFDC_TIMESTAMP</checkpointColumnName>

<disableDeleted Choices="true|false" Default="false" Description="In CDC load, disable retrieving deleted records." DisplayName="Disable CDC deleted records" Order="9" echo="true" isEditable="true" isHidden="false" isRequired="true">false</disableDeleted>

<disableUpserted Choices="true|false" Default="false" Description="In CDC load, disable retrieving updated or inserted records." DisplayName="Disable CDC upserted records" Order="10" echo="true" isEditable="true" isHidden="false" isRequired="true">false</disableUpserted>

<ConvertDate Choices="yes|no" Default="yes" Description="Convert Date to UTC format while reading and loading." DisplayName="Convert Date value to UTC" Order="11" echo="true" isEditable="true" isHidden="false" isRequired="true">yes</ConvertDate>

</com.acta.adapter.salesforce.SForceSession>)

8/24/15 3:44:32 PM Thread[Thread-20,5,main] Session XML: <com.acta.adapter.salesforce.SForceSession>

<username Choices="" Default="" Description="Enter your Salesforce.com username" DisplayName="Username" Order="1" echo="true" isEditable="true" isHidden="false" isRequired="true">marvin.aquino@softplan.com.br</username>

<password Choices="" Default="" Description="Enter your Salesforce.com password" DisplayName="Password" Order="2" echo="false" isEditable="true" isHidden="false" isRequired="true">UNJteste1529ACFObfkv8UctcoxNzP9qSD5e</password>

<endPoint Choices="" Default="https://www.salesforce.com/services/Soap/u/21.0" Description="" DisplayName="Web service end point" Order="3" echo="true" isEditable="true" isHidden="false" isRequired="true">https://login.salesforce.com/services/Soap/u/32.0</endPoint>

<batchSize Choices="" Default="200" Description="Enter the batch size to use in Salesforce.com queries" DisplayName="Batch size" Order="4" echo="true" isEditable="true" isHidden="false" isRequired="true">200</batchSize>

<metadataResilience Choices="no|yes" Default="no" Description="Should the adapter be resilient with regard to metadata errors?" DisplayName="Metadata resilience?" Order="5" echo="true" isEditable="true" isHidden="false" isRequired="true">no</metadataResilience>

<cdc_enabled Choices="no|yes" Default="no" Description="Enable changed data capture for this datastore?" DisplayName="Enable CDC" Order="6" echo="true" isEditable="true" isHidden="false" isRequired="true">yes</cdc_enabled>

<defaultBase64BinarySize Choices="" Default="255" Description="Enter the default length for a Salesforce.com Base64Binary field" DisplayName="Default Base64Binary field length" Order="7" echo="true" isEditable="true" isHidden="false" isRequired="true">255</defaultBase64BinarySize>

<checkpointColumnName Choices="" Default="SFDC_TIMESTAMP" Description="" DisplayName="checkpointColumnName" Order="8" echo="true" isEditable="true" isHidden="true" isRequired="true">SFDC_TIMESTAMP</checkpointColumnName>

<disableDeleted Choices="true|false" Default="false" Description="In CDC load, disable retrieving deleted records." DisplayName="Disable CDC deleted records" Order="9" echo="true" isEditable="true" isHidden="false" isRequired="true">false</disableDeleted>

<disableUpserted Choices="true|false" Default="false" Description="In CDC load, disable retrieving updated or inserted records." DisplayName="Disable CDC upserted records" Order="10" echo="true" isEditable="true" isHidden="false" isRequired="true">false</disableUpserted>

<ConvertDate Choices="yes|no" Default="yes" Description="Convert Date to UTC format while reading and loading." DisplayName="Convert Date value to UTC" Order="11" echo="true" isEditable="true" isHidden="false" isRequired="true">yes</ConvertDate>

</com.acta.adapter.salesforce.SForceSession>

8/24/15 3:44:32 PM Thread[Thread-20,5,main] Starting the Salesforce.com session

8/24/15 3:44:32 PM Thread[Thread-20,5,main] Login to Salesforce, attempt : 1

8/24/15 3:44:33 PM Thread[Thread-20,5,main] Receive message:  BrokerMessage(

_e.ErrorsTo=com.acta.adapter..client.dataAndMetadata_194

_e.Timestamp=Mon Aug 24 15:44:33 2015

_e.SourceTimeoutLength=90000

_e.MessageID=384

_e.Destination=com.acta.adapter.salesforce.SalesForceAdapter.data_116

_e.MessageType=MSG_ADAPTER_BROWSE_STOP

_e.ReplyTo=com.acta.adapter..client.dataAndMetadata_194

_e.CorrelationID=383_com.acta.adapter..client.dataAndMetadata_194

_a.MSGFIELD_ADAPTER_SESSION_ID=19

_e.Source=com.acta.adapter..client.dataAndMetadata_194)

8/24/15 3:44:33 PM Thread[Thread-20,5,main] Process Browse request. Message: BrokerMessage(

_e.ErrorsTo=com.acta.adapter..client.dataAndMetadata_194

_e.Timestamp=Mon Aug 24 15:44:33 2015

_e.SourceTimeoutLength=90000

_e.MessageID=384

_e.Destination=com.acta.adapter.salesforce.SalesForceAdapter.data_116

_e.MessageType=MSG_ADAPTER_BROWSE_STOP

_e.ReplyTo=com.acta.adapter..client.dataAndMetadata_194

_e.CorrelationID=383_com.acta.adapter..client.dataAndMetadata_194

_a.MSGFIELD_ADAPTER_SESSION_ID=19

_e.Source=com.acta.adapter..client.dataAndMetadata_194)

8/24/15 3:44:33 PM Thread[Thread-20,5,main] Receive message:  BrokerMessage(

_e.ErrorsTo=com.acta.adapter..client.dataAndMetadata_194

_e.Timestamp=Mon Aug 24 15:44:33 2015

_e.SourceTimeoutLength=90000

_e.MessageID=386

_e.Destination=com.acta.adapter.salesforce.SalesForceAdapter.data_116

_e.MessageType=MSG_ADAPTER_BROWSE_START

_e.ReplyTo=com.acta.adapter..client.dataAndMetadata_194

_e.CorrelationID=385_com.acta.adapter..client.dataAndMetadata_194

_a.MSGFIELD_ADAPTER_SESSION_ID=19

_e.Source=com.acta.adapter..client.dataAndMetadata_194)

8/24/15 3:44:33 PM Thread[Thread-20,5,main] Process Browse request. Message: BrokerMessage(

_e.ErrorsTo=com.acta.adapter..client.dataAndMetadata_194

_e.Timestamp=Mon Aug 24 15:44:33 2015

_e.SourceTimeoutLength=90000

_e.MessageID=386

_e.Destination=com.acta.adapter.salesforce.SalesForceAdapter.data_116

_e.MessageType=MSG_ADAPTER_BROWSE_START

_e.ReplyTo=com.acta.adapter..client.dataAndMetadata_194

_e.CorrelationID=385_com.acta.adapter..client.dataAndMetadata_194

_a.MSGFIELD_ADAPTER_SESSION_ID=19

_e.Source=com.acta.adapter..client.dataAndMetadata_194)

8/24/15 3:44:33 PM Thread[Thread-20,5,main] Starting SForceMetadata Session

8/24/15 3:44:33 PM Thread[Thread-20,5,main] Receive message:  BrokerMessage(

_e.ErrorsTo=com.acta.adapter..client.dataAndMetadata_194

_e.Timestamp=Mon Aug 24 15:44:33 2015

_e.SourceTimeoutLength=90000

_e.MessageID=388

_e.Destination=com.acta.adapter.salesforce.SalesForceAdapter.data_116

_e.MessageType=MSG_ADAPTER_BROWSE_ROOT

_e.ReplyTo=com.acta.adapter..client.dataAndMetadata_194

_e.CorrelationID=387_com.acta.adapter..client.dataAndMetadata_194

_a.MSGFIELD_ADAPTER_SESSION_ID=19

_e.Source=com.acta.adapter..client.dataAndMetadata_194)

8/24/15 3:44:33 PM Thread[Thread-20,5,main] Process Browse request. Message: BrokerMessage(

_e.ErrorsTo=com.acta.adapter..client.dataAndMetadata_194

_e.Timestamp=Mon Aug 24 15:44:33 2015

_e.SourceTimeoutLength=90000

_e.MessageID=388

_e.Destination=com.acta.adapter.salesforce.SalesForceAdapter.data_116

_e.MessageType=MSG_ADAPTER_BROWSE_ROOT

_e.ReplyTo=com.acta.adapter..client.dataAndMetadata_194

_e.CorrelationID=387_com.acta.adapter..client.dataAndMetadata_194

_a.MSGFIELD_ADAPTER_SESSION_ID=19

_e.Source=com.acta.adapter..client.dataAndMetadata_194)

8/24/15 3:44:34 PM Thread[Thread-20,5,main] There was a communication error when talking to Salesforce.com: Connection has been shutdown: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target

8/24/15 3:44:34 PM Thread[Thread-20,5,main] Error browsing root nodes. Xml generated so far: []. com.acta.adapter.salesforce.exceptions.CommunicationFailureException: There was a communication error when talking to Salesforce.com: Connection has been shutdown: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target

  at com.acta.adapter.salesforce.SForceMetadata.describeGlobal(SForceMetadata.java:46)

  at com.acta.adapter.salesforce.metadata.SForceBrowsing.getRootNodes(SForceBrowsing.java:72)

  at com.acta.adapter.sdk.AdapterRunnerImpl.processBrowseRoot(AdapterRunnerImpl.java:2532)

  at com.acta.adapter.sdk.AdapterServiceDataListener.handleBrokerMessage(AdapterServiceDataListener.java:106)

  at com.acta.brokerclient.BrokerClient.handleMessage(BrokerClient.java:406)

  at com.acta.brokerclient.BrokerClient.access$100(BrokerClient.java:53)

  at com.acta.brokerclient.BrokerClient$MessageHandler.run(BrokerClient.java:1559)

  at com.acta.brokerclient.ThreadPool$PoolThread.run(ThreadPool.java:100)

8/24/15 3:44:40 PM Thread[Thread-5,5,main] Receive message: BrokerMessage(

_e.ErrorsTo=com.acta.adapter.Manager

_e.Timestamp=Mon Aug 24 15:44:40 2015

_e.SourceTimeoutLength=10000

_e.MessageID=696

_e.Destination=adapter.Salesforce_Adapter

_e.MessageType=MSG_ADAPTER_STATUS

_e.ReplyTo=com.acta.adapter.Manager

_e.CorrelationID=695_com.acta.adapter.Manager

_e.Source=com.acta.adapter.Manager)

8/24/15 3:44:40 PM Thread[Thread-5,5,main] Process adapter status request. Message: BrokerMessage(

_e.ErrorsTo=com.acta.adapter.Manager

_e.Timestamp=Mon Aug 24 15:44:40 2015

_e.SourceTimeoutLength=10000

_e.MessageID=696

_e.Destination=adapter.Salesforce_Adapter

_e.MessageType=MSG_ADAPTER_STATUS

_e.ReplyTo=com.acta.adapter.Manager

_e.CorrelationID=695_com.acta.adapter.Manager

_e.Source=com.acta.adapter.Manager)

Any help would be appreciated.

The machine used pentaho kettle to access the same web service.

Accepted Solutions (1)

Accepted Solutions (1)

0 Kudos

Hi Marvin,

The error you are seeing will happen if you do not have the correct Salesforce certificates. See the following Salesforce article about the certificate changes:

https://help.salesforce.com/apex/HTViewSolution?urlname=HTTPS-Security-Certificate-Switch-from-SHA-1...

You will need to download the new certificates from Salesforce. Once you have those, refer to SAP Note 2158979 which contains a link to a Word doc with steps for applying the certificates. I hope that helps.

Doug

Former Member
0 Kudos

It helped, but now i'm in another error:

8/25/15 10:44:21 AM[SAX Parser Error] :1:23 : cvc-elt.1: Cannot find the declaration of element 'AdapterConfiguration'.
8/25/15 10:47:32 AMThere was a communication error when talking to Salesforce.com: org.apache.axis2.databinding.ADBException: Unexpected subelement {urn:partner.soap.sforce.com}compactLayoutable
8/25/15 10:47:32 AMError browsing root nodes. Xml generated so far: []. com.acta.adapter.salesforce.exceptions.CommunicationFailureException: There was a communication error when talking to Salesforce.com: org.apache.axis2.databinding.ADBException: Unexpected subelement {urn:partner.soap.sforce.com}compactLayoutable
at com.acta.adapter.salesforce.SForceMetadata.getTableMetadata(SForceMetadata.java:72)
at com.acta.adapter.salesforce.metadata.SForceBrowsing.getRootNodes(SForceBrowsing.java:79)
at com.acta.adapter.sdk.AdapterRunnerImpl.processBrowseRoot(AdapterRunnerImpl.java:2532)
at com.acta.adapter.sdk.AdapterServiceDataListener.handleBrokerMessage(AdapterServiceDataListener.java:106)
at com.acta.brokerclient.BrokerClient.handleMessage(BrokerClient.java:406)
at com.acta.brokerclient.BrokerClient.access$100(BrokerClient.java:53)
at com.acta.brokerclient.BrokerClient$MessageHandler.run(BrokerClient.java:1559)
at com.acta.brokerclient.ThreadPool$PoolThread.run(ThreadPool.java:100)

I'm looking into this one now.

By the way i'm on DS 4.2 SP5

0 Kudos

Hi Marvin,

Looking at your logs, it looks like you are using Salesforce API version 32 (endpoint URL https://login.salesforce.com/services/Soap/u/32.0). According to the Product Availability Matrix for Data Services 4.2 SP5, Salesforce API 21 is the latest supported version. The error is most likely due to this incompatibility.

Doug

Former Member
0 Kudos

You're right, thanks Doug, working as intended now

Answers (0)