Error Code 128: Exceeded Maximum Number of Transactions

Issue

Connection tests succeed, but schema discovery fails with the following error:

ErrorCode=128 - transaction error: exceed maximum number of transactions.

Environment

• Connector: SAP ERP on HANA
• Version:
  • S/4HANA 1909 on HANA
  • NetWeaver API version 1.900.313

Resolution

To resolve this issue, do the following:

Ask your SAP team to review the transaction and RFC conversation limits on the application server. This error may indicate that the /FIVETRAN/FETCH process has reached an SAP-side resource limit.

1. Ask your SAP team to review the transaction and RFC conversation limits on the application server. This error may indicate that the /FIVETRAN/FETCH process has reached an SAP-side resource limit.
2. Check the following specific parameters:
   • rdisp/max_comm_entries
   • Gateway conversation limits, such as CPIC_MAX_CONV
3. Check for inactive or leaked transactions on the HANA tenant. Transactions that remain open without being committed or rolled back can exhaust the max_transactions limit. Work with your HANA DBA to identify and clean up any stuck or orphaned sessions.
4. In Fivetran, go to your SAP ERP on HANA connection page and select Sync in the top right.

Cause

This issue occurs when SAP-side transaction or RFC conversation resource limits are exceeded during the /FIVETRAN/FETCH operation. The error message indicates that SAP rejected the retrieval call after the connection was established. It doesn't indicate a timeout or wait condition.