How To Fix SOI599 - Table &1: Table change other than row/column store is not supported

SAP Error Message - Details

• Message type: E = Error

• Message class: SOI - Safe Online Import/Upgrade Messages

• Message number: 599

• Message text: Table &1: Table change other than row/column store is not supported

Self-Explanatory Message

Since SAP believes that this specific error message is 'self-explanatory,' no more information has been given.The majority of messages in the SAP system have a message text, however this is frequently insufficient to comprehend or resolve the problem.

To make things easier, more detailed information is frequently added to describe the issue, how to fix it, and the necessary steps or configuration modifications.

Unfortunately, there isn't any extra information in this error notice.

What else can you do?

First, use our AnswerBot below to get a possible cause and solution (requires a premium subscription).

Also, review the in-depth Common Questions & Answers listed below; you could discover a solution there or be able to connect with others who have faced similar challenges.

You can also try searching the SAP support portal (support.sap.com) but you need a special user ID to access it. It is possible that an SAP support note exists that provides additional details about the mistake or even steps for fixing it.

Smart SAP Assistant

• What is the cause and solution for SAP error message SOI599 - Table &1: Table change other than row/column store is not supported ?

  The SAP error message SOI599 indicates that there is an issue with the way a table is being modified in the context of SAP HANA. Specifically, it suggests that a change is being attempted on a table that is not supported because it is not a simple row or column store operation. This error typically arises when there are attempts to change the storage type of a table or when trying to perform operations that are not compatible with the current table structure.
  Cause:
  
  Storage Type Change: The error often occurs when there is an attempt to change a table from row store to column store or vice versa, which is not allowed directly.
  Unsupported Operations: Certain operations on tables that are not compatible with the current storage type or structure can trigger this error.
  Database Constraints: The table may have constraints or dependencies that prevent the change from being executed.
  
  Solution:
  
  Check Table Definition: Review the table definition and ensure that the operations you are trying to perform are valid for the current storage type.
  Use Appropriate SQL Commands: If you need to change the storage type, you may need to create a new table with the desired storage type and migrate the data from the old table to the new one.
  Data Migration: If changing the storage type is necessary, consider the following steps:
  
  Create a new table with the desired storage type.
  Use INSERT INTO new_table SELECT * FROM old_table to migrate the data.
  Drop the old table if it is no longer needed.
  
  
  Consult Documentation: Refer to the SAP HANA documentation for specific guidelines on table storage types and supported operations.
  Check for Dependencies: Ensure that there are no dependencies or constraints that would prevent the operation from being executed.
  
  Related Information:
  
  SAP HANA Storage Types: Understand the differences between row store and column store in SAP HANA, as well as the implications of each on performance and data retrieval.
  SAP Notes: Check for any relevant SAP Notes or updates that may address this specific error or provide additional context.
  Database Administration: If you are not familiar with database administration tasks, consider consulting with a database administrator or an SAP expert to assist with the changes.
  
  By following these steps, you should be able to resolve the SOI599 error and successfully manage your SAP HANA tables.