Symptom
Curriculum Connector failed with error: "Unexpected Error.Error while removing Qualification Content Vos".
Environment
SAP SuccessFactors Learning
Reproducing the Issue
- Prepare a Curriculum Connector input file that includes the same curriculum item twice in a single run with conflicting REMOVE_FLAG values (one line with REMOVE_FLAG=Y and another with REMOVE_FLAG=N).
- Ensure the curriculum item is of type that supports tasks/checklists assigned to a curriculum.
- Run the Curriculum Connector job.
- Observe that the run fails with a NOT NULL constraint violation and “Unexpected Error.Error while removing Qualification Content Vos”.
Cause
Product defect when processing mixed remove/add (REMOVE_FLAG=Y and N) for the same curriculum item in the same batch, specifically for items with associated tasks.
Resolution
Workaround: Split operations into separate runs. First run only records with REMOVE_FLAG=Y (removals). Then run only records with REMOVE_FLAG=N (adds/updates).
A permanent fix will be delivered in 2H2026 release, which contains the fix to properly handle mixed remove/add operations for the same curriculum item within a single batch.
If the issue persists after the upgrade, collect the connector result report and error logs and contact support.
See Also
Keywords
Curriculum Connector, removing Qualification Content Vos, Fatal 1001, JDBCDriverException, NOT NULL violation, LST_UPD_USR, PA_TODO_EVENT, checklist, tasks, item, REMOVE_FLAG, mixed operations, batch processing, curriculum import, connector failure , KBA , LOD-SF-LMS-CUR , Curricula , Problem
SAP Knowledge Base Article - Public