Error while connecting to Embedded Duplicate Store
Hi,
I am getting error as below when I am trying to connect to the Embedded Duplicate store in my Data studio server(2.10.10).
Please let me know if you have faced similar issue and help me with the steps to resolve this.
PS: We do have a remote duplicate store(3.8.15) which is working fine and we have secured the Data studio login using SSL which is working fine as well.
2023-05-17 12:29:11,981 INFO c.e.d.j.w.DefaultWorkflowProcessor [jobControllerSystem-akka.actor.default-dispatcher-9] Workflow execution starting. Context: WorkflowId=179; WorkflowName=embedStoreTest; ExecutionId=d71c4975-d67e-4a9b-9177-47229e72bf8f; EnvironmentId=1; EnvironmentName=Default; SpaceId=1; SpaceId=29; SpaceName=administrator's space; SpaceName=sp_Deduplication; UserName=administrator;
2023-05-17 12:29:12,177 INFO c.e.d.r.i.f.FindDuplicatesEstablishResourceBuilder [workpool-server-fixmem-executor-worker-1] Find duplicates establish operation started on store with id 'EmbeddedStore_New'.
2023-05-17 12:29:14,180 INFO c.e.d.r.i.f.FindDuplicatesEstablishResourceBuilder [workpool-server-fixmem-executor-closer-1] Find duplicates establish operation on store with id 'EmbeddedStore_New' completed. Processing output...
2023-05-17 12:29:14,180 ERROR c.e.d.r.i.f.FindDuplicatesEstablishResourceBuilder [workpool-server-fixmem-executor-closer-1] Find Duplicates step failed. Please check logging output for more information
com.experian.match.api.MatchInstance.call(MatchInstance.java:54) com.experian.match.api.client.ApiException: An unexpected error occurred when running Find Duplicates step.
org.glassfish.jersey.client.internal.HttpUrlConnector.apply(HttpUrlConnector.java:269) javax.ws.rs.ProcessingException: javax.net.ssl.SSLHandshakeException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
java.base/sun.security.ssl.Alert.createSSLException(Alert.java:131) javax.net.ssl.SSLHandshakeException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
java.base/sun.security.validator.PKIXValidator.doBuild(PKIXValidator.java:439) sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
java.base/sun.security.provider.certpath.SunCertPathBuilder.build(SunCertPathBuilder.java:146) sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
2023-05-17 12:29:14,242 ERROR c.e.d.c.e.ErrorLogger [workpool-server-fixmem-executor-closer-1] Error 1: 4009: Error closing builder
com.experian.datastudio.common.exceptions.ExecutionException: 4009: Error closing builder
at com.experian.datastudio.resource.ExecutorServiceBuilderWorkPool.closeBuilder(ExecutorServiceBuilderWorkPool.java:420) ~[resource-2.10.10.jar:?]
at com.experian.datastudio.resource.ExecutorServiceBuilderWorkPool.lambda$new$2(ExecutorServiceBuilderWorkPool.java:108) ~[resource-2.10.10.jar:?]
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:539) [?:?]
at java.util.concurrent.FutureTask.run(FutureTask.java:264) [?:?]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136) [?:?]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) [?:?]
at java.lang.Thread.run(Thread.java:833) [?:?]
Caused by: java.io.IOException: Find Duplicates step failed. Please check logging output for more information
at com.experian.datastudio.resource.indexer.findduplicates.FindDuplicatesEstablishResourceBuilder.checkStatus(FindDuplicatesEstablishResourceBuilder.java:137) ~[resource-2.10.10.jar:?]
at com.experian.datastudio.resource.indexer.findduplicates.FindDuplicatesEstablishResourceBuilder.processResults(FindDuplicatesEstablishResourceBuilder.java:54) ~[resource-2.10.10.jar:?]
at com.experian.datastudio.resource.indexer.findduplicates.FindDuplicatesResourceBuilder.closeImpl(FindDuplicatesResourceBuilder.java:87) ~[resource-2.10.10.jar:?]
at com.experian.datastudio.resource.AbstractResourceBuilder.close(AbstractResourceBuilder.java:151) ~[resource-2.10.10.jar:?]
at com.experian.datastudio.resource.ExecutorServiceBuilderWorkPool.closeBuilder(ExecutorServiceBuilderWorkPool.java:416) ~[resource-2.10.10.jar:?]
... 6 more
2023-05-17 12:29:14,273 INFO c.e.d.j.w.DefaultWorkflowProcessor [jobControllerSystem-akka.actor.default-dispatcher-9] Executed workflow in 2255 ms
2023-05-17 12:29:14,291 ERROR c.e.d.j.a.WorkflowExecutionMonitorActor [jobControllerSystem-akka.actor.default-dispatcher-11] Catching
com.experian.datastudio.jobcontroller.exception.JobControllerException: 9003: An unexpected error has occurred during Workflow execution
at com.experian.datastudio.jobcontroller.actors.WorkflowExecutionActor.getWorkflowException(WorkflowExecutionActor.java:270) ~[jobcontroller-2.10.10.jar:?]
at com.experian.datastudio.jobcontroller.actors.WorkflowExecutionActor.onExecuteWorkflow(WorkflowExecutionActor.java:199) ~[jobcontroller-2.10.10.jar:?]
at akka.japi.pf.UnitCaseStatement.apply(CaseStatements.scala:24) ~[akka-actor_2.13-2.5.23.jar:2.5.23]
at akka.japi.pf.UnitCaseStatement.apply(CaseStatements.scala:20) ~[akka-actor_2.13-2.5.23.jar:2.5.23]
at scala.PartialFunction.applyOrElse(PartialFunction.scala:214) ~[scala-library-2.13.10.jar:?]
at scala.PartialFunction.applyOrElse$(PartialFunction.scala:213) ~[scala-library-2.13.10.jar:?]
at akka.japi.pf.UnitCaseStatement.applyOrElse(CaseStatements.scala:20) ~[akka-actor_2.13-2.5.23.jar:2.5.23]
at scala.PartialFunction$OrElse.applyOrElse(PartialFunction.scala:269) [scala-library-2.13.10.jar:?]
at scala.PartialFunction$OrElse.applyOrElse(PartialFunction.scala:270) [scala-library-2.13.10.jar:?]
at akka.actor.Actor.aroundReceive(Actor.scala:539) [akka-actor_2.13-2.5.23.jar:2.5.23]
at akka.actor.Actor.aroundReceive$(Actor.scala:537) [akka-actor_2.13-2.5.23.jar:2.5.23]
at akka.actor.AbstractActor.aroundReceive(AbstractActor.scala:227) [akka-actor_2.13-2.5.23.jar:2.5.23]
at akka.actor.ActorCell.receiveMessage(ActorCell.scala:612) [akka-actor_2.13-2.5.23.jar:2.5.23]
at akka.actor.ActorCell.invoke(ActorCell.scala:581) [akka-actor_2.13-2.5.23.jar:2.5.23]
at akka.dispatch.Mailbox.processMailbox(Mailbox.scala:268) [akka-actor_2.13-2.5.23.jar:2.5.23]
at akka.dispatch.Mailbox.run(Mailbox.scala:229) [akka-actor_2.13-2.5.23.jar:2.5.23]
at akka.dispatch.Mailbox.exec(Mailbox.scala:241) [akka-actor_2.13-2.5.23.jar:2.5.23]
at akka.dispatch.forkjoin.ForkJoinTask.doExec(ForkJoinTask.java:260) [akka-actor_2.13-2.5.23.jar:2.5.23]
at akka.dispatch.forkjoin.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:1339) [akka-actor_2.13-2.5.23.jar:2.5.23]
at akka.dispatch.forkjoin.ForkJoinPool.runWorker(ForkJoinPool.java:1979) [akka-actor_2.13-2.5.23.jar:2.5.23]
at akka.dispatch.forkjoin.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:107) [akka-actor_2.13-2.5.23.jar:2.5.23]
Best Answer
-
Hi Shreya
From one of our developers "It looks like they have applied their own certificate. Their CA must be in the trust store of the java installation. (We make an exception for localhost connections only with Experian issued certificates)."
If you follow the instructions in the "Using a private CA root certificate" section of the docs
If that does not work or you still cannot get this to work then please can you raise a Support case so that we can help you to resolve:1
Answers
-
Thanks @Josh Boxer this solution worked.
1