2616979 - Exam launch error - ORA-01795: maximum number of expressions in a list is 1000

SAP Knowledge Base Article - Public

2616979 - Exam launch error - ORA-01795: maximum number of expressions in a list is 1000

Symptom

At the moment a user tries to launch the exam, an ORA error is thrown. With it, it is not possible to complete it.

Environment

SAP SuccessFactors Learning Management System (LMS)

Reproducing the Issue

In the LMS admin side, click:

  1. Content > Assessments > Either add or edit an exam >
  2. Assign it to a user
  3. Navigate to LMS user side, click:
  4. Start Course > The error is thrown, where the caused by is "Caused by: java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in a list is 1000".

Cause

The exam created that was assigned to the user has over 1.000 questions. With it, when the user tries to launch it, the error will be thrown. At this moment, the limit of the number of questions to be launched is 300.

Resolution

A system enhancement will be delivered in the 1805 release. After it, there is not going to be a limit of the number of questions to be launched.

Keywords

ORA-01795: maximum number of expressions in a list is 1000, exam, error, launch, error while getting the quiz launch dto , KBA , LOD-SF-LMS , SuccessFactors Learning , LOD-SF-LMS-CNT , Content , Product Enhancement

Product

SAP SuccessFactors Learning all versions