How To Fix SCTS_HDI561 - HDI container &1 cannot be deleted; is still referenced

SAP Error Message - Details

• Message type: E = Error

• Message class: SCTS_HDI - Messages for CTS HDI API

• Message number: 561

• Message text: HDI container &1 cannot be deleted; is still referenced

What causes this issue?

You tried to delete the ABAP-managed HDI container &v1&. This is not
possible, however, since &v1& is referenced by at least one HDI
container.

System Response

The system specifies the HDI containers that reference the HDI container
in question in the following lines.

How to fix this error?

If you want to delete the HDI container &v1&, first make sure that the
referencing HDI containers no longer contain any HDI objects that
reference the HDI objects in the HDI container that you want to delete.
If you no longer need HDI objects in the referencing HDI container,
delete them. If you still need the HDI objects in the referencing HDI
container, modify them so that the HDI objects no longer reference the
HDI container you want to delete. If you still need the HDI container,
do not delete it.
You can use the tool you used to develop the HDI objects (usually SAP
Web IDE for SAP HANA) to modify or delete HDI objects.
Finally, remove the references to this HDI container. To do this, follow
the procedure below:
On the initial screen of the transaction SCTS_AMHC, enter the name of
one of the specified ABAP-managed HDI containers and choose <LS>Change
</>.
Under <LS>References to Containers/Schemas</>, select the HDI container
&v1& and choose <LS>Delete Row</>.
Save the change.
Choose the same transport request that you used to delete the HDI
container &v1&.
Note: If you choose a separate transport request, you must ensure that
the transport request containing the change to the references is
imported in the target system before the transport request containing
the deletion of the HDI container.
Activate the HDI container.
Note: If the referencing HDI container still contains HDI objects that
reference HDI objects in &v1&, the activation does not work. One
possible error message is as follows: <NP>The file requires
?logicalschema://<(><<)>logical container>" which is not provided by any
file</>. Here, <(><<)>logical container> is the name of the removed
reference or the HDI container you actually want to delete.
Repeat the previous steps for all specified HDI containers that have
references to the HDI container &v1& that you want to delete, before you
attempt to delete the container &v1& again.

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message SCTS_HDI561 - HDI container &1 cannot be deleted; is still referenced ?

  The SAP error message SCTS_HDI561 indicates that an HDI (HANA Deployment Infrastructure) container cannot be deleted because it is still being referenced by other objects or entities. This typically occurs in SAP HANA environments when there are dependencies that prevent the deletion of the container.
  Cause:
  The error is caused by one or more of the following reasons:
  
  Active References: There are active references to the HDI container from other objects, such as tables, views, or procedures that are still using the container.
  Dependent Objects: There may be dependent objects that rely on the HDI container, which need to be removed or modified before the container can be deleted.
  User Sessions: There might be active user sessions or transactions that are currently using the HDI container.
  
  Solution:
  To resolve this error, you can follow these steps:
  
  
  Identify Dependencies:
  
  Use SQL queries to check for any dependent objects that reference the HDI container. You can query the system catalog views to find out what objects are still referencing the container.
  Example SQL query to find dependencies:
  SELECT * FROM _SYS_REPO.OBJECTS WHERE CONTAINER_NAME = '<your_container_name>';
  
  
  
  
  Remove or Alter Dependent Objects:
  
  If you find any dependent objects, you will need to either drop or alter them to remove the references to the HDI container.
  Ensure that you have backups or that you are aware of the implications of removing these objects.
  
  
  
  Check for Active Sessions:
  
  Check if there are any active sessions that are using the HDI container. You can use the following SQL to find active sessions:
  SELECT * FROM M_SESSION WHERE CONTAINER_NAME = '<your_container_name>';
  
  If there are active sessions, you may need to terminate them before proceeding with the deletion.
  
  
  
  Retry Deletion:
  
  Once all dependencies have been resolved and there are no active references, you can attempt to delete the HDI container again.
  
  
  
  Consult Documentation:
  
  If you are unsure about the dependencies or how to proceed, consult the SAP HANA documentation or reach out to your SAP support team for guidance.
  
  
  
  Related Information:
  
  HDI Containers: HDI containers are used in SAP HANA to manage database artifacts and their lifecycle. Understanding how they work and their dependencies is crucial for effective management.
  SAP HANA Studio: You can use SAP HANA Studio or SAP Web IDE to visually inspect and manage HDI containers and their dependencies.
  SAP Notes: Check for any relevant SAP Notes that may provide additional insights or solutions related to this error message.
  
  By following these steps, you should be able to resolve the SCTS_HDI561 error and successfully delete the HDI container.