I'm unable to remove/delete a couple of vApps or a External Newtork in vCloud 1.5 as each has a status of Pending
Here’s an typical error
Operation: Deleted Virtual Application 'vAPP NAME' (ef7f3332-6035-45b2-b84b-69a0a7bf4c01)
Details: could not delete: [com.vmware.vcloud.common.model.net.LogicalNetworkModel#e1945bf9-345c-4039-b304-fdf4b0bb3e63]
- The DELETE statement conflicted with the REFERENCE constraint "logical_net_fk". The conflict occurred in database "vCloud", table "dbo.network_assigned_ip", column 'logical_net_id'.
Is there a SQL cleanup script to remove these errors?
My setup, vCloud 1.5 on RHEL 5.6 with SQL2008. I want to clean-up the database errors before proceeding with an upgrade to vCloud 1.5.1
I have the same problem, when install VCD on the external SQL Server 2008 R2 with non-latin SQL Server Collation. When I install a SQL Server with
SQL_Latin1_General_CP1_CI_AS collation, the problem was resolved.