Super6VCA
Expert
Expert

Desktops disconnected due to SQL error

Jump to solution

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

Thank you, Perry
0 Kudos
1 Solution

Accepted Solutions
gmtx
Hot Shot
Hot Shot

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

View solution in original post

0 Kudos
3 Replies
gmtx
Hot Shot
Hot Shot

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

0 Kudos
SanjaySP1
VMware Employee
VMware Employee

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
VMware Employee
VMware Employee

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

Regards Gaurav Baghla Opinions are my own and not the views of my employer. https://twitter.com/garry_14