PKIX path building failed unable to find valid certification path to requested target

Issue

PKIX path building failed unable to find valid certification path to requested target

Cause

Missing SQL certificate in cacert (for DS MC RS). 

 

Solution

After extracting the certificate you need to install it in the DS and MC and RS using the keytool command.

This will update the cacert file (Java Store Certificate).

 

Instruction on page 86 of the Admin guide linked below:

https://docshield.kofax.com/RPA/en_US/11.2.0_ea1ydbmwk9/print/KofaxRPAAdministratorsGuide_EN.pdf

 

After adding the SQL certificate to DS and MC and RS you should be able to login.

 

cacerts paths:

1) Design Studio (windows): (C:\Program Files\Kofax RPA 11.2.x.x.xxx x64\jre\lib\security\cacerts)

2) Roboservers (Linux): /opt/KofaxRPA/jre/lib/security/cacerts

3) Management Console (Tomcat Linux): /usr/lib/jvm/java-11-openjdk-11.0.14.1.1-1.el7_9.x86_64/lib/security/cacerts

 

Workaround

Source:

https://techcommunity.microsoft.com/...n/ba-p/2591304

Add trustServerCertificate=true in the JDBC connection string

To do so it is required to create a new Database type in Management Console copying the connection scoring from the Microsoft SQL Server type and adding the option trustServerCertificate=true

Level of Complexity 

 High

 

Applies to  

Product	Version	Build	Environment	Hardware
Kofax RPA	11.x

References

Add any references to other internal or external articles