SAP Knowledge Base Article - Public

2104602 - Error "de.simplicit.vjdbc.VJdbcException: Unknown user <User Name>" occurs when testing connection to SuccessFactors Learning in Plateau Report Designer

Symptom

  • Error occurs when testing connection to SuccessFactors Learning in Plateau Report Designer
  • Error detail: org.eclipse.birt.report.data.oda.jdbc.JDBCException: There is an error in get connection, java.sql.SQLException: de.simplicit.vjdbc.VJdbcException: Unknown user <User Name>

Environment

  • SuccessFactors Learning
  • Plateau Report Designer (PRD) 

Reproducing the Issue

  1. Create an JDBC Data Source to SuccessFactors Learning in PRD.
    =>For hosted customer, please refer KBA 2104424 about how to build one connection to hosted stage database in PRD.
  2. Click Test Connection button.
    =>Test failed with error "de.simplicit.vjdbc.VJdbcException: Unknown user <User Name>".
    =>Error detail:
        org.eclipse.birt.report.data.oda.jdbc.JDBCException: There is an error in get connection, java.sql.SQLException: de.simplicit.vjdbc.VJdbcException: Unknown user <User Name>
          at com.plateau.vjdbc.PlateauLoginHandler.checkLogin(PlateauLoginHandler.java:80)
          at de.simplicit.vjdbc.server.config.ConnectionConfiguration.checkLogin(ConnectionConfiguration.java:478)
          at de.simplicit.vjdbc.server.config. ....

Cause

There are two possible reasons:

  • The ADMIN account being used does not exist in SuccessFactors Learning.
  • The ADMIN account being used does not have REPORT_DEVELOPER Role assigned to it. 

Resolution

  1. Log in to Go to SuccessFactors Learning ADMIN page(For hosted customer, it must be stage instance).
  2. Go to System Admin > Application Admin > Admin Management.
  3. Search for the ADMIN account being used in PRD.
    =>If the ADMIN exists, edit and assign REPORT_DEVELOPER role to this account.
    =>If the ADMIN doesn't exist, click Add New button to create one ADMIN account with the name and assign REPORT_DEVELOPER Role to it.

Keywords

KBA , LOD-SF-LMS-REP , Reporting Data , Problem

Product

SuccessFactors Learning 1408