SAP Knowledge Base Article - Public

2104602 - Error "Unknown user <User Name>" occurs when testing connection to PRD

Symptom

The following error is generating when attempting to connect to PRD:

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 ID>

Environment

SAP SuccessFactors Learning - All Supported Versions

Plateau Report Designer - PRD

Reproducing the Issue

  1. Set up the connection details as normal.
  2. Select 'Test Connection' and error is generated

    PRD Error.jpg

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

report developer, report_developer, unknown user, , KBA , LOD-SF-LMS-PRD , VJDBC Setup or Connection Issues , LOD-SF-LMS-REP , Reporting Data , Problem

Product

SAP SuccessFactors Learning all versions