2887426 - Scheduled reports sent to SFTP failed

Scheduled jobs for specific reports are in status FAILED with the following error: error SAP DBTech JDBC: [1033]: error while parsing protocol: invalid lob locator id (piecewise lob reading).

• SAP SuccessFactors Learning
• Reports
• Scheduled reports

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

Example:

• 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.

2326249 - How to find the latest version of LMS data dictionary

PRD guide in attachment of this Community post

2075193 - Configure REPORT_SYSTEM to Send Reports Directly to SFTP in SuccessFactors Learning

SAP, SF, LMS, learning, custom, scheduled jobs, recurring report, SFTP, FAILED, error SAP DBTech JDBC: [1033]: 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