SAP Knowledge Base Article - Preview

2487081 - OFFSET and LIMIT compatibility with SAP HANA Smart Data Integration


You have created a virtual table in Hana using the SDI OracleLogReader Adapter. You set a task to ransfer the data from Oracle to Hana via an Hana Insert statement using OFFSET and LIMIT. However, the loading the test table fails in Hana on an Out-Of-Memory exception.



  • SAP HANA Smart Data Integration
  • OracleLogReader Adapter


SAP HANA 1.0 smart data integration ; SAP HANA smart data integration 2.0


HAN-DP-SDI, DP, Data Provisioning, 11g, Rownum , KBA , HAN-DP-SDI , SAP HANA smart data integration (SDI) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.