Scheduled jobs for specific reports are in status FAILED with the following error: error SAP DBTech JDBC: : error while parsing protocol: invalid lob locator id (piecewise lob reading).
SAP SuccessFactors Learning
Reproducing the Issue
You have received a notification or you have observed a failed status in your recurring report results page
The issue is caused when a report used a column with CLOB/BLOB data.
The CLOB/BLOB is read after the result-set is closed. Instead of reading it as a CLOB, the JDBC framework is reading it as a String therefore facing an issue trying to read it.
Check if the query uses a CLOB column and modify the query
- Old Query: select LST_UPD_TSTMP, ADDL_TEXT as message, ERROR_TEXT, CONTEXT_INFO,INTERFACE_RUN_ID from pa_conn_exceptions ;
- New Query: select LST_UPD_TSTMP, ADDL_TEXT as message, cast(BINTOSTR(cast(ERROR_TEXT as binary)) as varchar) as ERROR_TEXT, CONTEXT_INFO,INTERFACE_RUN_ID from pa_conn_exceptions ;
NOTE : The issue is not code related but due to an issue in the query which is not allowing to read a column with CLOB data correctly.
If the same report works in one LMS instance but not in the other (For Ex., it works in Stage but not in PROD LMS), the reason is most likely because said column does not have data in the table in that instance therefore the JDBC framework is not facing the issue trying to read it.
PRD guide in attachment of this Community post
SAP, SF, LMS, learning, custom, scheduled jobs, recurring report, SFTP, FAILED, error SAP DBTech JDBC: : error while parsing protocol: invalid lob locator id (piecewise lob reading) , KBA , LOD-SF-LMS-CRI , Custom Report Issues , LOD-SF-LMS , Learning Management System , LOD-SF-LMS-REP , Reporting Data , Problem