SAP Knowledge Base Article - Preview

3383148 - "org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException"

Symptom

The iFlow encounters an error within the JDBC adapter, as indicated below:

org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException; SQL state [S0001]; error code [11739]; NEXT VALUE FOR function cannot be used if ROWCOUNT option has been set, or the query contains TOP or OFFSET.; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: NEXT VALUE FOR function cannot be used if ROWCOUNT option has been set, or the query contains TOP or OFFSET., cause: com.microsoft.sqlserver.jdbc.SQLServerException: NEXT VALUE FOR function cannot be used if ROWCOUNT option has been set, or the query contains TOP or OFFSET. 


Read more...

Environment

  • SAP Integration Suite
  • SAP Cloud Platform Integration

Product

Cloud Integration all versions ; SAP Integration Suite 1.0

Keywords

SAP Cloud Integration, SAP HCI, SAP CPI, SCPI, tenant, IFlow, Integration Flow, deployment, model configurator, properties, CPI integration flow, , Cloud Integration, SAP JDBC,JDBC adapter , KBA , LOD-HCI-PI-CON-JDBC , JDBC Adapter , 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.