SAP Knowledge Base Article - Public

2847174 - Error searching for curricula with sub-curricula filter LMS


Getting the error below when searching for curricula using the sub curricula as the filter:

" SAP DBTech JDBC: [257]: sql syntax error: incorrect syntax near "\": line 3 col 233 (at pos 584)...."


SAP SuccessFactors Learning

Reproducing the Issue

  1. Access LMS instance using an admin account.
  2. Go to Learning Administration.
  3. Go to Learning > Curricula.
  4. Open the Subcurricula filter.
  5. Set the Curriculum ID criteria to starts with "STARTS_WITH_CURR_ID" and submit criteria.*
  6. Click Search button on Curricula Search page. An error message will display in the search results area.
  7. Clear the Subcurricula filter.
  8. Open the Subcurricula filter.
  9. Set the Curriculum ID equals "EXACT_CURR_ID", search, add to filter and submit filter.**
  10. Click Search button on Curricula Search page. Search results will display in the search results area.

 * STARTS_WITH_CURR_ID - means any identifier/filter for the curricula that should start with

** EXACT_CURR_ID - means the exact curricula ID


 There is an issue with the sql query that is used to fetch the data.


Our Engineering team had resolved this issue by fixing the sql query to fetch and execute the dynamic sql or sub-query. The fix will resolve the following:

a) Curricula Filter search in Assignment Profiles

b) Sub-Curricula Filter search in Curricula

c) Curricula and Sub-Curricula Filter search in reports

The fix for this issue is applied on b1908 release for non VSAAS customers. for VSAAS customers the fix is not yet deployed.


LRN-53865, sub curricula filter issue, error on sub curricula, error searching curricula, incorrect syntax near "\", error on uing filter, 1908, VSAAS error on curricula search , KBA , LOD-SF-LMS-CUR , Curricula , Problem


SAP SuccessFactors Learning 1705 ; SAP SuccessFactors Learning 1708 ; SAP SuccessFactors Learning 1711 ; SAP SuccessFactors Learning 1802 ; SAP SuccessFactors Learning 1805 ; SAP SuccessFactors Learning 1808 ; SAP SuccessFactors Learning 1811 ; SAP SuccessFactors Learning 1902 ; SAP SuccessFactors Learning 1905 ; SAP SuccessFactors Learning 1908