Zoho Reports sync failure_PKIX path building failed

Zoho Reports sync failure_PKIX path building failed

While syncing Zoho Reports, this error may appear where the self-signed certificate to sync both Zoho Reports and SDP MSP will be missing. These traces (mentioned below) can be viewed in the file zrmeinteglog0.txt under the location  \ManageEngine\ServiceDeskPlus-MSP\Logs.

Error Trace in logs:
12:53:49:586]|[06-01-2020]|[com.manageengine.zrmeinteg.framework.ZRSDPFrameWorkImpl]|[SEVERE]|[253181]: FAILURE :Could not update the configuration settings as an exception while saving the Advanced Analytics Configuration Details.<br><br> Please report the problem to the system administrator. Support file will have the error trace to analyze the problem and which can be created at Support -> Create Support File.|
[12:53:49:907]|[06-01-2020]|[com.manageengine.zrmeinteg.framework.ZRSDPFrameWorkImpl]|[INFO]|[253181]: Exception in connecting reports.zoho.comsun.security.validator.ValidatorException: PKIX path building failed:
sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target|

1. Stop the application service.

2. Download the file from the link given below and extract the contents of "certgeneration_windows" folder to the Service Desk Plus MSP Home directory using 7zip so that lib folder is merged:

Windows:

Linux:

3. Execute the below command:
Windows:
<Drive>:\ManageEngine\Servicedesk Plus MSP> gencert.bat  analyticsapi.domain.com:443
ex : gencert.bat analyticsapi.zoho.com:443

Linux:
\ManageEngine\ServicedeskPlus-MSP gencert.sh analyticsapi.zoho.com:443

4. You will receive an exception PKIX. On supplying the value 1, a file called jssecacerts is generated in the ServiceDesk Plus MSP Home Directory.

5. Copy and place the jssecacerts file under \ManageEngine\ServicedeskPlus-MSP\jre\lib\security folder and Restart ServiceDeskPlus-MSP application.

6. Start the application and Try the re-sync.


                  New to ADManager Plus?

                    New to ADSelfService Plus?

                      • Related Articles

                      • Mail fetching failed - PKIX path building failed.

                        Cause: If the SSL Certificate in mail server is a self signed certificate then it is not imported in the ServiceDeskPlus-MSP java environment while using the POPS/IMAPS protocol. Error Trace in logs: javax.net.ssl.SSLHandshakeException: ...
                      • ZOHO Reports - Authentication issue Handling - GRID movement

                        Recently we are facing issues if user saves the Zoho reports configuration page after entering email ID and AT key it throws authentication failure even though the email and AT key is correct. It happens as the registered login is in different grid ...
                      • ZOHO Reports - Analytics Plus Sync issue

                        Description: ​ The issue is because of the API call limit exceeding. Error Trace on the logs: ServerException (HttpStatusCode 400 Error Code: 6045 , Action: GETDATABASENAME, Message: API request could not be processed. The number of requests received ...
                      • Unable to Sync Analytics after upgrade to 10500

                        Issue description: The issue occurs when the user has upgraded from 9427 to 1050X builds and then tries the sync for the first time. The sync will fail because we are still maintaining the AMOUNT PAID column in billhistory table in sync xmls even ...
                      • AD Sync issue_Rootpath failure

                        Error trace: 09:48:46:989]|[10-31-2019]|[com.adventnet.servicedesk.asset.util.WorkStationDiscoverUtil]|[INFO]|[62064]: Log message from WMI task : mwc-dc-01 - LDAP Search : Root Path Failure. (0x8007052e)| ...