Error: "500" when attempting to create a VM in VMware Cloud Director

Products

• VMware Cloud Director

Issue/Introduction

• Users are unable to create a Virtual Machine (VM) inside an Org VDC using the VMware Cloud Director (VCD) UI.
• When a user is trying to create the VM an error message appears in the wizard before the task begins:
  
  500
  
  
• Similar errors can be found in the vcloud-container-debug.log files:
  
  

  ERROR    | pool-jetty-###       | DefaultExceptionMapper         | Internal server exception | requestId=########-####-####-############,request=POST https://example.com/api/vdc/########-####-####-############/action/createVm,requestTime=#########,remoteAddress=###.###.###.###:####
  ,userAgent=Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 ...,accept=application/*+xml;version 39.0
  org.hibernate.exception.GenericJDBCException: could not execute query
  ...
  Caused by: org.postgresql.util.PSQLException: ERROR: canceling statement due to statement timeout

• Additional statement timeout errors can be found in the /var/vmware/vpostgres/current/pgdata/log/postgresql-*.log files:
  
  

  ERROR:  canceling statement due to statement timeout
  STATEMENT:  /* Method: unknown */ /* criteria query */ select this_.storage_used_mb as y0_ from dgp_view_vdc_sprofile_metrics this_ where this_.vdc_id=$1 and this_.lr_id=$2

Environment

VMware Cloud Director 10.6.x

Cause

This issue can also occur if the Cloud director DB takes too long to query the dgp_view_vdc_sprofile_metrics view.

Resolution

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