SAP Knowledge Base Article - Preview

3637909 - Import Remote Tables feature in DataSphere Data Builder using an SAP HANA Database connection type does not find the table

Symptom

  • The remote table search fails to locate the desired table.
  • Before searching for the table, activate the Debug Tool of the browser and navigate to Network tab.
  • Now, reproducing the issue while debugging by searching for the table, the following error occurs:

    {
        "code": "searchChildrenFailed",
        "details": {
            "stack": "See correlation id xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx",
            "message": "transaction rolled back by an internal error: Allocation failed; Reason: configured statement memory limit from global configuration reached , Code: 129, SQL State: 40000",
            "code": 129,
            "sqlState": "40000",
            "name": "HanaError",
            "originalMessage": "transaction rolled back by an internal error: Allocation failed; Reason: configured statement memory limit from global configuration reached "
        }
    }


Read more...

Environment

  • HANA Cloud Services
  • HANA Cloud
  • DataSphere

Keywords

remote table search, sap hana database, allocation failed, memory limit, out of memory, hana cloud, table not found, sap note 3191224, sap note 3220622, get_remote_source_object_tree_as_table, hana instance size, qrc 2025/2., data builder, import remote tables, no data found , KBA , HAN-CLS-HC , HANA Cloud Services HANA Cloud , DS-DI-RT , Remote Tables , 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.