Desktops disconnected due to SQL error

[Super6VCA]

All of our View users got kicked off their desktops and after looking for teh cause i found in the event database on teh view conection server that there was an SQL error of some kind.  That seems to be teh only place i can see the error.  Here is what the error says..."Unable to create events tables: Cannot drop the view 'user_events', because it does not exist or you do not have permission."  This sql server has been running the same way for teh last year plus. No changes were made in the past few months but all of the sudden...  I can't fnd any other event in the SQL server and the only errors that show up are in the conection broker app log.  Event ID 104 Broker_Machine_Not_Ready.  Anyone have any ideas on this?  Thanks for looking!

Horizon View 6.0

ESXi 5.5

[gmtx · Accepted solution]

Anything in the Windows Event logs on the connection server, or in the SQL Server Logs or Event logs on the SQL machine? Almost sounds like you lost connectivity to the DB.

Geoff

[SanjaySP1]

Hi,

I don't think event DB will have any impact on View desktop connections.

The error message regarding events tables which you see is a known bug in View 6.0. Please check the release notes link below for more info.

• On rare occasions, the system health status of Event Database may be displayed as red on the View Administrator dashboard, with the error message "Cannot drop the view 'VE_user_events', because it does not exist or you do not have permission." This condition does not indicate a real error and will resolve itself after a short period of time.

Workaround: None.

View Release Notes

[Gaurav_Baghla]

Hello Super6VCA,

I agree to Sanjay that Database might not be the cause of the issue. However you fix that problem by using the article below http://kb.vmware.com/kb/2043231

For the Disconnect issue if this is a Horizon View 6.0 Environment please have a look at the article in the link below http://kb.vmware.com/kb/2091458

Regards

Gaurav Baghla