Anaplan Connect issue:- sun.security.validator.ValidatorException: PKIX path building failed

anildudam · 2023-04-03T08:08:06+00:00

There was an error rendering this rich post.

Hi Expert,

Anaplan Connect scripts were working fine since 1 year, not sure what happen suddenly I'm getting below error messages while executing.

error:

sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target (Validator: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target (Sun cert path builder: unable to find valid certification path to requested target

We didn't install/setup any kind certificates and so far Java jdk 1.8

Kindly help me.

Thanks,

Anil

Accepted answers

All comments

ben_speight

This means that Anaplan Connect cannot establish a secure connection, perhaps because a firewall is performing stateful packet inspection or the Java runtime's trusted root certificates are missing/damaged. You may be able to debug by setting the environment variable

JAVA_OPTS=-Djavax.net.debug=ssl,trustManager

before running Anaplan Connect, though it will likely produce a lot of output to sift through.

You could also try opening https://auth.anaplan.com/in a browser and inspecting the server certificate chain by clicking the padlock icon.

anildudam

Hi Ben,

Thank for your support.

Currently is certificates installed so far. I don't see any JAVA_OPTS in environment variable list. So I have added as per the above. Now script showing below error message.

I'm getting below screen while connect to the url

Sorry, I'm not good in setup enviroment variables. Please let me know, if I'm doing any thing wrong.

Thanks & regards,

Anil

ben_speight

Looks like its feeding in correctly, you just need to remove the leading "JAVA_OPTS=" from the value itself. It may be easier to set it in a batch file that calls out to AnaplanClient.bat.

In your browser if you click on the padlock in the address bar you should be able to view the certificate chain, from my machine it looks like

If it is substantively different, I'd suggest contacting your network administrator for guidance.

(If anyone finds this in a years time, the details will be different as the server certificate has a finite lifespan)

anildudam

Hi Ben,

Thanks for the assistance and appreciate for the quick response.

Out internal IT admin provided the solution and it's I'm able to run script now.

Thanks & regards,

Anil

Quick Links

Can you help?

Unanswered questions

Request for Workflow Design: End-User Report Finalization & Stakeholder Notification with Version Co
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…
Generating Failure Dump - even though no warnings/error in Actions
I've few actions in our Supply model which when run takes some time on the "generating failure dump" step at the end of the action even though the import is a full success without warning or errors. This is just a few seconds when run for a single action, however we have a process with 120 actions, and most of these…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…