SAP Knowledge Base Article - Public

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

Symptom

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

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

Environment

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

Cause

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

Resolution

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.

Keywords

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

Product

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