Ask Your Question
2

HTTP Post with Token

asked 2019-09-27 12:55:35 -0500

jonas_souza gravatar image

updated 2019-09-27 15:33:37 -0500

metadaddy gravatar image

Hi :)

Streamsets is new to me... and I'm fighting with a simple integration hehe basically what I want to do is:

  1. Extract data from a JDBC,
  2. then parse the data to an Json,
  3. use an HTTP to get the access token,
  4. remove the fields to keep only Json field and the access token
  5. http to load data

image description

The step #3 is working fine and returning the token... but when ran the step #5 it fails saying:

"unable to find valid certification path to requested target"

The token that I'm giving in the step #5 is in the "header" field with the field returned from step #3.....

Thanks in advance :)

** Full message

ERROR   Pipeline execution failed   ProductionPipelineRunner        ProductionPipelineRunnable-CDOMktCloudTrfm-CDO_MktCloud_Trfm
**com.streamsets.pipeline.api.base.OnRecordErrorException: HTTP_41 - Error sending resource. Reason: java.util.concurrent.ExecutionException: javax.ws.rs.ProcessingException: **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.streamsets.pipeline.stage.destination.http.HttpClientTarget.processResponse(HttpClientTarget.java:269)
    at com.streamsets.pipeline.stage.destination.http.HttpClientTarget.writeOneRequestPerRecord(HttpClientTarget.java:205)
    at com.streamsets.pipeline.stage.destination.http.HttpClientTarget.write(HttpClientTarget.java:98)
    at com.streamsets.pipeline.api.base.configurablestage.DTarget.write(DTarget.java:34)
    at com.streamsets.datacollector.runner.StageRuntime.lambda$execute$2(StageRuntime.java:290)
    at com.streamsets.pipeline.api.impl.CreateByRef.call(CreateByRef.java:40)
    at com.streamsets.datacollector.runner.StageRuntime.execute(StageRuntime.java:235)
    at com.streamsets.datacollector.runner.StageRuntime.execute(StageRuntime.java:298)
    at com.streamsets.datacollector.runner.StagePipe.process(StagePipe.java:219)
    at com.streamsets.datacollector.execution.runner.common.ProductionPipelineRunner.processPipe(Productio
edit retag flag offensive close merge delete

Comments

Can you please post the full stack trace showing the error message? Also, the image is broken somehow. Can you please try re-attaching it?

jeff gravatar imagejeff ( 2019-09-27 13:10:14 -0500 )edit

Sorry... just updated it.... I haven't enough points to attach an image :)

jonas_souza gravatar imagejonas_souza ( 2019-09-27 13:16:10 -0500 )edit

This is to post data to Market Cloud a Salesforce tool.... I'm checking with the guys here if all certificates has been added.... because I can retrieve the token... and initially it was returning error too, after add the certf, the token worked fine...

jonas_souza gravatar imagejonas_souza ( 2019-09-27 15:06:56 -0500 )edit

2 Answers

Sort by ยป oldest newest most voted
1

answered 2019-09-27 13:40:09 -0500

jeff gravatar image

updated 2019-09-27 13:49:03 -0500

metadaddy gravatar image

This kind of error means that you do not have the appropriate root certificate added to the trust store. What is your HTTP server? It must be using some type of self signed certificate? You will need to add that root cert to your truststore for the HTTP client stage.

edit flag offensive delete link more
0

answered 2019-09-30 11:25:35 -0500

jonas_souza gravatar image

Hi guys.... thanks for the support on it.

Just sorted the issue adding the certificates to the server as Jeff mentioned.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-09-27 12:55:35 -0500

Seen: 290 times

Last updated: Sep 30