Symptom
-
Compensation pipeline run fails with an SQL syntax error originating from the SAP HANA database layer.
- The error is thrown during the execution of a query function within the compensation pipeline.
-
The following exception is observed in the application logs:
SAP DBTech JDBC: [257]: sql syntax error: incorrect syntax near "<token>": line <N> col <N> (at pos <N>)
com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: [257]: sql syntax error: incorrect syntax near "<token>": line <N> col <N> (at pos <N>)
-
The pipeline does complete successfully but compensation results are not generated.
-
The issue is consistently reproducible when the specific query function involved in the error is triggered during the pipeline run.
Read more...
Environment
- SAP Sales Performance Management
- Incentive Management
Product
Keywords
SAP, DBTech, JDBC, 257, sql, syntax, error, incorrect, syntax, near, token, compensation, pipeline, query, function, rule, HANA, JDBCDriverException, cs_pluginquery, Incentive, Management, execution, failure, parsing, delimiter, space, malformed, formatting, results, pipeline run, pos, line, col, column, statement, database, IM, SPM, Sales, Performance, Management, fix, resolve, error code, new line, Enter, whitespace. , KBA , CEC-SAL-COM-PIP , Pipeline Runs and Calculations , CEC-SAL-COM , Incentive Management , CEC-SAL-COM-TITAN , SPM Titan Ref Architecture and Migration Incentive Mgmt , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview