SAP Knowledge Base Article - Public

3693467 - In-Memory Storage of remote table shows as ON despite Storage being set to Disk in SAP Datasphere

Symptom

In SAP Datasphere, the In-Memory Storage of remote table is On, which should be Off.
Even though the storage is set to disk.


"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental." 

Environment

SAP Datasphere

Reproducing the Issue

  1. Access the SAP Datasphere tenant.
  2. Navigate to the Data Integration Monitor and then select a remote table.
  3. Observe that the table shows "In-Memory Storage" as On.

Cause

Program error

Resolution

This issue has been fixed and delivered in the datasphere wave 2025.20. Please note even after the fix in 2025.20, there is not an mechanism in place to autocorrect such tables which already have been deployed before the fix was delivered. So in such cases,

  1. Switch on the UI to General of Remote table.
  2. Change Disk to In Memory under Storage.
  3. Click Deploy.
  4. While remote table deployed successfully, switch back to Disk on the same table.
  5. Click Deploy again, this will show the correct statistics in the monitor.

Keywords

oom, out-of-memory, datasphere, development tenant, in-memory storage, table persistency, data integration monitor,  local tables, memory issues, table deployment , KBA , DS-DI-TAB , Table Persistency , DS-DI-RT , Remote Tables , Problem

Product

SAP Datasphere all versions