SAP Knowledge Base Article - Public

3700015 - Unable to create exams in multiple locales using Import Data tool

Symptom

The Import Data tool in SAP SuccessFactors Learning fails to create and publish exams in multiple locales. 

  • Error: com.successfactors.lms.eqb.service.assessment.api.AssessmentServiceException: com.plateausystems.elms.util.helper.ElmsDuplicateKeyDataAccessException: SqlMapClient operation; nested exception is com.sap.db.jdbc.exceptions.SQLIntegrityConstraintViolationExceptionSapDB: [301]: unique constraint violated

Environment

SAP SuccessFactors Learning

Reproducing the Issue

  1. Access Learning Administration.
  2. Navigate to System Administration -> System Management Tool-> Import Data
  3. Download template for Exam, and Fill the required data
  4. Select Action as 'Import Data', Entity Type 'Exam', Import option 'Add and update', Select Time Zone.
  5. Choose Import file -> Submit.
  6. Import process fails with an error and comments

Cause

Resolution

The Learning engineering team has addressed the issue by correcting the backend code.

Workaround:

  • As a temporary workaround, leave all message-related columns (such as 'Welcome Message', 'Proctor Message', 'Success Message', 'Completion Message', and 'Failure Message') empty. This will allow you to create the exam with the same IDs in multiple locales, including any associated questions and objectives.

Click on the star icon to bookmark this article and receive updates about this issue. For more information about updates from subscribed KBAs, refer to the KB Article 2171560 - How to be notified of new or updated SAP Notes or KBAs. 

See Also

Keywords

KI2H2025, LRN-205932, import data tool, SAP SuccessFactors Learning, exam import, multiple languages, import failure, invalid feedback display, invalid quiz type, exam creation problem, import field errors, simultaneous language exam import, import tool issue. , KBA , LOD-SF-LMS-IMP , Import Data Tool , Known Error

Product

SAP SuccessFactors Learning 2511