VMware Cloud Community
NigMan
Contributor
Contributor

Cannot Delete vAPP or Extenal Network in vCloud 1.5

Hi all,

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

Reply
0 Kudos
2 Replies
Jabuin
Contributor
Contributor

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.

Reply
0 Kudos
NigMan
Contributor
Contributor

Unfortunately I cannot do that as it will affect other databases on the server.  I'lll try to set it on the actual database when no-one is using vCloud over the weekend.

Reply
0 Kudos