SAP Knowledge Base Article - Public

3792634 - SCORM Exam Detail report not recording user responses for SCORM 2004 contents

Symptom

  • User responses on SCORM content are not being recorded on the SCORM Exam Detail report.
  • When the SCORM 2004 content attempts to register interactions, an intermittent error is occurring: 
    • Error: "com.sap.db.jdbc.exceptions.SQLIntegrityConstraintViolationExceptionSapDB: [301]: unique constraint violated: Table(PA_CBT_SCO_INT_OBJ), Index(PK_CBT_SCO_INT_OBJ)".

Environment

SAP SuccessFactors Learning

Reproducing the Issue

  1. Learning Homepage >
  2. Launch an online item with a SCORM 2004 exam >
  3. Complete the exam >
  4. Learning Administration >
  5. Reports >
  6. Run the SCORM Exam Details report >
  7. See that the answers were not recorded.

Cause

A code defect caused a unique constraint violation on PA_CBT_SCO_INT_OBJ when SCORM 2004 content registered interactions/objectives, preventing responses from being written to the database.

Resolution

Our Engineering has developed a code correction to fix the error received, which is planned to be delivered as part of P19. For further details regarding the patch schedule, please refer to SAP SuccessFactors - Patch Details - SAP Community.

See Also

SAP Community - SAP SuccessFactors - Patch Details

Keywords

successfactors, sf, sfsf, learning, lms, scorm exam detail, report, scorm, scorm 2004, responses missing, interaction, not recorded, PA_CBT_SCO_INTERACTION, PA_CBT_SCO_INT_OBJ, unique constraint violated, reporting, exam, KI2H2026 , KBA , LOD-SF-LMS-CNT , Content , LOD-SF-LMS-REP , Reporting Data , Known Error

Product

SAP SuccessFactors Learning all versions