vCenter Server disconnected from vCloud Director

[mjha]

Hi Folks

I am facing an issue in my vCloud director lab.

I am trying to upload an ovf in one of my public catalog but it fails saying "The operation failed because vCenter Server "Alex_vCloud_vCenter" is not connected "

I checked in vCloud console that vCenter server was disconnected from vcd. I tried refreshing and reconnecting the vCenter server but it was failing with error

" Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1"

I checked the vcloud-container-debug.log file in real time and found vcd is trying to connect vcenter time and again but failing each time. Excerpt from debug.log is as follows:

" com.vmware.vcloud.api.presentation.service.InternalServerErrorException: Internal Server Error

at com.vmware.vcloud.vimproxy.internal.impl.VcUpdateListenerImpl.onOuterLoopBreakWithException(VcUpdateListenerImpl.java:727)

at com.vmware.vcloud.vimproxy.internal.impl.VcUpdateListenerImpl.outerWaitForUpdatesLoop(VcUpdateListenerImpl.java:639)

at com.vmware.vcloud.vimproxy.internal.impl.VcUpdateListenerImpl.run(VcUpdateListenerImpl.java:349)

Caused by: org.hibernate.StaleStateException: Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1"

Even the MSSQL database shows listener is disconnected.

Also in vcloud-container-info.log i got

"2015-08-02 16:44:02,651 | ERROR | 1045d40-d030-485b-9987-50a27d59e254Listener (1516) | AbstractFlushingEventListener | Could not synchronize database state with session |

org.hibernate.StaleStateException: Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1"

Please see the attached log files and screenshots.