How To Fix RSODSO_IMOACT100 - Not all database requests are supported

RSODSO_IMOACT100 - Overview

• Message type: E = Error

• Message class: RSODSO_IMOACT - Data-specific messages for DataStore activation

• Message number: 100

• Message text: Not all database requests are supported

What causes this issue?

Note that selections on the change log for a SAP HANA-optimized
DataStore object should only restrict the request. Otherwise, long run
times or terminations can occur.
Background
You are using an SAP HANA-optimized DataStore object. In this case, the
change log is not persisted. Instead, it is calculated from the active
data at the time of access. This optimization saves memory (no redundant
data is stored) and also significantly improves runtime performance
during data activation.
The calculation view (which the calculation is based on) maps typical
accesses to the change log, such as extraction or rollback of requests,
to optimal access plans. This means high performance be reached in these
cases.
Non-optimized accesses - which can occur, for example, when any data is
selected or the result set is restricted in the Data Browser (SE16) -
can cause longer runtimes or terminations. In this case, change your
selection in such a way that only the request is restricted.

System Response

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

How to fix this error?

Procedure for System Administrators

Error message extract from SAP system. Copyright SAP SE.

RSODSO_IMOACT100 - Details

• The SAP error message RSODSO_IMOACT100: Not all database requests are supported typically occurs in the context of SAP BW (Business Warehouse) when working with InfoObjects and DataStore Objects (DSOs). This error indicates that there are certain database requests that cannot be processed due to limitations in the underlying database or the way the data is structured.
  Causes:
  
  
  Unsupported Database Operations: The error may arise when the system attempts to execute a database operation that is not supported by the underlying database. This can happen if the DSO is configured in a way that requires operations that the database cannot perform.
  
  
  Data Model Issues: There may be inconsistencies or issues in the data model, such as incorrect relationships between InfoObjects or problems with the DSO configuration.
  
  
  Data Volume: Large volumes of data being processed in a single request can lead to performance issues or unsupported operations.
  
  
  Database Configuration: The database settings or configurations may not be