SAP Knowledge Base Article - Public

3726617 - Datasphere Local Table in memory cannot be switched to disk storage

Symptom

An option to switch storage from memory to disk of apparently normal hana local table is not present.

Environment

SAP Datasphere

Reproducing the Issue

Open local table on data builder and notice no option to use other type of storage despite the same being created in a space with SAP HANA Cloud, where SAP HANA database storage the values can be "Disk" or "In-Memory".

Cause

This can be related to the object not being a normal table.
Run-time artifacts of local tables created on top of objects residing in open-sql schema are not HANA column tables but SQL views. 

Resolution

These objects being SQL views do not hold data, therefore can't use 'Disk' storage.
If the load unit of related object is not optimal, you can change it by running DDL statement ALTER TABLE: Setting the Load Unit
If the data in memory is not required, you can test if the opensqlschema user has the privilege to run upload statement to upload data from memory: Load a Column Table into Memory, and Unload It from Memory


Keywords

in-memory, disk storage , KBA , DS-DI-TAB , Table Persistency , Problem

Product

SAP Datasphere 1.0