SAP Knowledge Base Article - Preview

3633100 - Query Performance Issues After Upgrading from DP Agent 2.7.3.1 to 2.7.6.1

Symptom

  • After upgrading to DPAgent 2.7.6.1, a query that once took seconds now takes several minutes or more.
  • Small fetch sizes are indicated in the dpagent log file framework.trc: "... [INFO ] [*] DPFramework | WorkerThread.setFedRequestParameters [] - Setting fetch size to 30 rows based on max row size = 2170 bytes, max data size = 65536 bytes"


Read more...

Environment

SAP HANA smart data integration (SDI)

Keywords

dpagent, dtp execution, performance issues, dpagentconfig.ini, fetch size, insert statement, SAP HANA, SDI, upgrade, troubleshooting , 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 for Me (Login required).

Search for additional results

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