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
- Access LMS instance using an admin account.
- Go to Learning Administration.
- Go to Learning > Curricula.
- Open the Subcurricula filter.
- Set the Curriculum ID criteria to starts with "STARTS_WITH_CURR_ID" and submit criteria.*
- Click Search button on Curricula Search page. An error message will display in the search results area.
- Clear the Subcurricula filter.
- Open the Subcurricula filter.
- Set the Curriculum ID equals "EXACT_CURR_ID", search, add to filter and submit filter.**
- 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