SAP Knowledge Base Article - Preview

3788275 - Amazon redshift odbc load misses final rows when rows per commit leaves remainder - SAP Data Services

Symptom

  • Source table contains 3,164 rows, but only 3,000 rows appear in the target after load.
  • With Rows per commit = 1,000, the SAP Data Services log shows all rows transferred, while the row count in Amazon Redshift shows only 3,000.
  • Missing rows match the remainder of total_rows ÷ rows_per_commit (for example, 3,164 % 1,000 = 164 missing; 3,164 % 100 = 64 missing).
  • All rows load successfully when Rows per commit = 1,582 (no remainder).


Read more...

Environment

SAP Data Services XI4.3 and higher version

Product

SAP Data Services all versions

Keywords

DS, data services, redshift, odbc, rows, per commit, missing, partial, commit, remainder, load incomplete, sql, ODBC , KBA , EIM-DS-CON , Connectivity , 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.