Error: "java.lang.NullPointerException at com.vmware.ssdc.backendbase.dao.impl.HibernateRightsDao.getRightsBundlesPublishedToAllManagedOrgs" causes out of space issues on Transfer server storage

Products

• VMware Cloud Director

Issue/Introduction

• Out of space in Transfer directory in VMware Cloud Director
• Transfer Session Cleaner Job is running as scheduled when checking with below:
  
  /opt/vmware/vcloud-director/bin/cell-management-tool cell -u administrator -p <password> -tt | grep "+--\|UUID\|Transfer"
  
  
• In the /opt/vmware/vcloud-director/logs/vcloud-container-debug.log, the following error stack is logged:
  
  DEBUG    | Backend-activity-pool-#######| essionCleanerJob$TransferSessionCleanerJobActivity | [Activity Execution] Removing orphaned completed transfer session: ########-####-####-####-############ - Handle: urn:uuid:########-####-####-####-############, Current Phase: TransferSessionCleanerJob$TransferSessionCleanerJobActivity$TransferSessionCleanerJobPhase
...
ERROR    | Backend-activity-pool-#######| essionCleanerJob$TransferSessionCleanerJobActivity | [Activity Execution] Uncaught Exception during Activity execution. Recent phase: com.vmware.vcloud.vdc.TransferSessionCleanerJob$TransferSessionCleanerJobActivity$TransferSessionCleanerJobPhase@########- Handle: urn:uuid:########-####-####-####-############, Current Phase: TransferSessionCleanerJob$TransferSessionCleanerJobActivity$TransferSessionCleanerJobPhase |
java.util.concurrent.ExecutionException: java.lang.NullPointerException
...
Caused by: java.lang.NullPointerException
        at com.vmware.ssdc.backendbase.dao.impl.HibernateRightsDao.getRightsBundlesPublishedToAllManagedOrgs(HibernateRightsDao.java:523)
        at com.vmware.ssdc.backendbase.dao.impl.HibernateRightsDao.lambda$getRightsBundlesForOrg$3(HibernateRightsDao.java:496)
        at java.base/java.util.Optional.orElseGet(Optional.java:369)

Environment

• VMware Cloud Director 10.5.1
• VMware Cloud Director 10.6.x

Cause

This issue occurs when a stale uploaded item exists in the database which belongs to an organisation that does not exist anymore.

Resolution

The workaround for this issue requires modification of the Cloud Director database.

For assistance, contact Broadcom Support and note this Article ID (434932) in the problem description. For more information, see Creating and managing Broadcom support cases .

Additional Information

See following KB Article for any stale data that may be present in the Transfer server storage which does not exist in the Database:

NFS shared storage volume getting full when executing vApp copy/move in Cloud Director