QVX_UNKNOWN_ERROR - GeoAnalytics error while connecting to the route module with https
Article Number: 000052862 | Last Modified: 2018/11/21
In Qlik Sense, running travel areas operation using Qlik GeoAnalytics connector fails and we receive the following error message. QVX_UNKNOWN_ERROR: Could not connect to route module: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
Qlik GeoAnalytics has been deployed with https and proxy is enabled on both the servers and there has been dissimilarities in the version of Java installed on these servers.
Certificate not upadated.
Updating Java versions to be the same on both machines and adding GeoAnalytics cert into java keystore on QS servers where GeoAnalytics connector is installed as below resolves this issue.
1. Go to URL in your browser, click on HTTPS certificate chain (next to URL address). Click "more info" > "security" > "show certificate" > "details" > "export..". Pickup the name and choose file type example.cer. Now you have file with keystore and you have to add it to your JVM 2. Determine location of cacerts files, eg. C:\Program Files (x86)\Java\jre1.6.0_22\lib\security\cacerts. 3. Next import the example.cer file into cacerts in command line:
keytool -import -alias example -keystore C:\Program Files (x86)\Java\jre1.6.0_22\lib\security\cacerts -file example.cer
You will be asked for password which default is changeit