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
- Learning Homepage >
- Launch an online item with a SCORM 2004 exam >
- Complete the exam >
- Learning Administration >
- Reports >
- Run the SCORM Exam Details report >
- 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
SAP Knowledge Base Article - Public