SAP Knowledge Base Article - Public

3618463 - Error happens when connecting to LMS database using Plateau Report Designer

Symptom

  • Error occurred when connecting to the LMS Database via Plateau Report Designer.
  • Error message There is an error in get connection, java.sql.SQLException: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target 

Environment

SAP SuccessFactors Learning

Reproducing the Issue

  1. Open Plateua Report Designer
  2. Set up a new connection to LMS Database
  3. Input all necessary parameters such as Drive Class, Database URL, User Name, Password
  4. Click on Test Connection

Cause

A wrong LMS Database URL was filled.

The LMS environment was migrated to Common Super Domain (CSD) after VJDBC was setup. And the initial setup was using the URL of old LMS URL.

Resolution

Even though the Database URL is shown like jdbc:vjdbc:servlet:https://xxxxx-stage.lms.hr.cloud.sap/vjdbc/vjdbc,db10g in LMS Frontend Page, however, please use the old URL jdbc:vjdbc:servlet:https://xxxxx-stage.plateau.com/vjdbc/vjdbc,db10g in Plateau Report Designer when trying to connect to LMS DB.

See Also

2581167 - PRD error "unable to find valid certification path to requested target"

Keywords

LMS, database connection, VJDBC, URL discrepancy, Common Super Domain, connection error, jdbc, servlet, plateau, unable to find valid certification path to requested target  , KBA , LOD-SF-LMS-PRD , VJDBC Setup or Connection Issues , Problem

Product

SAP SuccessFactors Learning all versions