SAP Knowledge Base Article - Public

3365834 - View persistency fails due "too many statement recompile requests" "max recompile limit exceeded"


Error occurs when persisting view in SAP Datasphere:

{"correlationId":"XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX","errorMessage":"transaction rolled back by an internal error: \"SCHEMA$VIEW\".\"$$VIEW_MATERIALIZATION_ON$$\": line 413 col 5 (at pos 14692): \"SCHEMA$VIEW\".\"$$VIEW_MATERIALIZATION_CREATE_INSERT_DATA_TABLE$$\": line 46 col 5 (at pos 1954): too many statement recompile requests: max recompile limit exceeded, Code: 129, SQL State: 40000"}


SAP Datasphere

Reproducing the Issue

In Data Integration Monitor, persisting a view generates the error.


Recently SAP Datasphere upgraded HANA Cloud instance to QRC2.2023 version.
One of new enhancement in Query Processing was enable from QRC2.2023 version and it causes this problem.


Report a ticket for HAN-CLS-HC Component, copy and paste the text below in ticket's problem description:

"Hello SAP Support, 

I'm being impacted by issue reported in KBA 3365834.
Therefore, I'd like to request the workaround (
    alter system alter configuration('indexserver.ini','DATABASE', 'H00') set ('sql','hex_enable_for_validation') = 'false'
) to be applied in my Datasphere tenant: <Include here your Datasphere tenant URL>

Additional info from Datasphere's System->About:

  • Tenant UUID: <Include here your Datasphere's Tenant UUID collected from System -> About>
  • Database UUID: <Include here your Datasphere's Database UUID collected from System -> About>

Thank you."

As workaround HANA team will then turn "Query Processing" off, while works on a permanent fix.

Once the problematic enhancement was turned off, this issue should not happen again.


view snapshot, load, replicate , KBA , DS-DI-VIW , View Persistency and Runtime , HAN-CLS-HC , HANA Cloud Services HANA Cloud , Known Error


SAP Datasphere all versions