topic External database failover - vRO fails to reconnect in VMware Aria Automation Orchestrator Discussions https://communities.vmware.com/t5/VMware-Aria-Automation/External-database-failover-vRO-fails-to-reconnect/m-p/2678396#M22619 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>We've got a vRO cluster running with an MSSQL database backend that is also clustered. When the SQL database is failed over to the secondary for maintenance we find that both vROs gets disconnected from the database and don't reconnect and require us to restart the application servers to recover. Is this expected behaviour? Is there a way to extend the timeout for the database connection or anything along those lines?</P><P></P><P>Thanks</P><P>DB </P></BODY></HTML> Sat, 21 Nov 2015 09:19:29 GMT DonalB 2015-11-21T09:19:29Z External database failover - vRO fails to reconnect https://communities.vmware.com/t5/VMware-Aria-Automation/External-database-failover-vRO-fails-to-reconnect/m-p/2678396#M22619 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>We've got a vRO cluster running with an MSSQL database backend that is also clustered. When the SQL database is failed over to the secondary for maintenance we find that both vROs gets disconnected from the database and don't reconnect and require us to restart the application servers to recover. Is this expected behaviour? Is there a way to extend the timeout for the database connection or anything along those lines?</P><P></P><P>Thanks</P><P>DB </P></BODY></HTML> Sat, 21 Nov 2015 09:19:29 GMT https://communities.vmware.com/t5/VMware-Aria-Automation/External-database-failover-vRO-fails-to-reconnect/m-p/2678396#M22619 DonalB 2015-11-21T09:19:29Z Re: External database failover - vRO fails to reconnect https://communities.vmware.com/t5/VMware-Aria-Automation/External-database-failover-vRO-fails-to-reconnect/m-p/2678397#M22620 <HTML><HEAD></HEAD><BODY><P>Upgrade to vRO 6.0.3. VMware added a watchdog timer that will keep the vco-server process running during MSSQL failover or reboot. I've only tested reboots and it works as advertised.</P></BODY></HTML> Sun, 22 Nov 2015 15:33:23 GMT https://communities.vmware.com/t5/VMware-Aria-Automation/External-database-failover-vRO-fails-to-reconnect/m-p/2678397#M22620 Auslndr 2015-11-22T15:33:23Z