SAP Knowledge Base Article - Public

2713551 - Unable to create assesments.

Symptom

Customer is unable to create assessments (quiz or exam) and receiving the following exception:

com.successfactors.lms.eqb.client.assessment.api.AssessmentClientException: Could not add the supplied assessment

Environment

SuccessFactors Learning Management System (LMS) - All Supported Versions

Reproducing the Issue

  1. After logging as LMS Admin, Navigate to Content>Assessments;
  2. Click at Add New;
  3. Select Quiz or Exam;
  4. Inform the ID and name;
  5. Click Create

Cause

This has been identified as data issue related to the migration from on-premise to Cloud.

Oracle error:

"Error to create assessments - ORA-01400: cannot insert NULL into ("CUSTOMER_SCHEMA_NAME"."PA_EQB_QUIZ"."FEEBACK_LEVEL")"

Resolution

Engineering is working in a long term fix and until then, we can engage Engineering and OPs to drop the incorrect column.

See Also

Internal reference: LRN-46992

Keywords

sap, lms, quiz, exam, lms assessment, ora, error, exception, unable, Could not add the supplied assessment, cannot insert NULL into, ORA-01400 , KBA , LOD-SF-LMS-ASB , Assessment Builder , LOD-SF-LMS , SuccessFactors Learning , Problem

Product

SAP SuccessFactors Learning all versions