SAP Knowledge Base Article - Preview

2020550 - ECDA truncating rows beyond 4994149 rows: "Results processing ended, MaxResultSize limit, [2147483646], reached."


  • ECDA (EnterpriseConnect Data Access for ODBC/MSSQL) is used to transfer data to IQ from source of MSSQL Server.
  • Over 5 million rows on source table.
  • ECDA truncates the result set pre-maturely.
  • Error can be found in the srv.log (if used, modify the server.cfg file, prferably with DC Manager, tracing section, TraceOpenServer=59, restart ECDA server).
  • "Results processing ended, MaxResultSize limit, [2147483646], reached."



  • SAP SYBASE ECDA 15.7 (EnterpriseConnect Data Access)
  • SAP SYBASE IQ 15.2/15.4/16.0
  • ECDA running on Winx64 (Windows 2008, etc; also ECDA on windows is a 32-bit application)
  • Microsoft SQL Server 2008/2012


Sybase EnterpriseConnect Data Access 15.7


DirectConnect, DC, Direct Connect , KBA , BC-SYB-ECD , Enterprise Connect (ECDA) , How To

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.