At the moment a user tries to launch the exam, an ORA error is thrown. With it, it is not possible to complete it.
SAP SuccessFactors Learning Management System (LMS)
Reproducing the Issue
In the LMS admin side, click:
- Content > Assessments > Either add or edit an exam >
- Assign it to a user
- Navigate to LMS user side, click:
- 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".
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.
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.
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