VirtualSven
Hot Shot
Hot Shot

vCenter Operations for View - Event Database

I'm having issues configuring the vCOPS for View adapter. When I want to configure the event database, I get the error:

Connecting to the View event database...FAILED (View event database is not configured)
Failed to connect to the View event database.
I'm using VMware View 5.1 and a SQL database for event logging. Is VMware View 5.1 supported?
Sven Huisman VMware vExpert 2009-2016 Twitter: @svenh blog: svenhuisman.com
Tags (2)
0 Kudos
21 Replies
IamTHEvilONE
Immortal
Immortal

Per the release notes:

Product Compatibility

vCenter Operations for View is compatible with these releases:

  • vCenter Operations Manager Enterprise (vApp) 5.0.1 or later
  • View 5.0 or later

Both the View VDI environment and vCenter Operations Enterprise must be up and running.

I haven't used this integration as of yet, but at least I can answer part of what you are asking.

VirtualSven
Hot Shot
Hot Shot

Thanks.

In the logfile I see the following error:

Could not read View event database information...retrying

The View connection server has been updated from 5.0 to 5.1. I don't know if that has something to do with it.

Sven Huisman VMware vExpert 2009-2016 Twitter: @svenh blog: svenhuisman.com
0 Kudos
JasonV1
Enthusiast
Enthusiast

What type of SQL authentication are you using? Mine is working and I used SQL auth.

Any errors on your database server?

Did you have any issues running the EnableViewPS.cmd script on your connection server?

- Jason

Was my post helpful? If so please remember to award points by using the Helpful/Correct buttons. Twitter: http://twitter.com/jasonventresco Blog: http://vjason.com
0 Kudos
VirtualSven
Hot Shot
Hot Shot

I'm using SQL authentication and there was no error when I executed the script on the connection server.

The problem seems to be that the vCOPS for View adapter config utility can't read the configuration for the event database.

Sven Huisman VMware vExpert 2009-2016 Twitter: @svenh blog: svenhuisman.com
0 Kudos
VirtualSven
Hot Shot
Hot Shot

I've tested with a View 5.0 server which I still had available, and now I'm able to succesfully connect to the View Event database. So View 5.0 works, View 5.1 doesn't. I will now upgrade the View 5.0 server and see if it still works.

Sven Huisman VMware vExpert 2009-2016 Twitter: @svenh blog: svenhuisman.com
0 Kudos
VirtualSven
Hot Shot
Hot Shot

Tested it. After the upgrade, it can't read the eventdatabase configuration anymore.

Sven Huisman VMware vExpert 2009-2016 Twitter: @svenh blog: svenhuisman.com
0 Kudos
ShakespearsGhos
Contributor
Contributor

The DB connection information is gathered using the get-monitor View PowerCLI API. You may try running the following command on the View Connection Server from the View PowerCLI command window and report what it returns.

"get-monitor -monitor DBMonitor"
Charlie Rizor | Knowledge Champion - Enterprise Desktop | View the Knowledge Base at http://kb.vmware.com | View the Support Insider Blog http://blogs.vmware.com/kb/
0 Kudos
VirtualSven
Hot Shot
Hot Shot

When I run that command on a View 5.0 server I get a correct result. When I run that command on a View 5.1 server, I get the following result:

Get-Monitor : PowershellService::GetMonitor FAILED, error=
At line:1 char:12
+ get-monitor <<<<  -monitor DBMonitor
    + CategoryInfo          : InvalidResult: (vmware.view.pow...lets.GetMonito
   r:GetMonitor) [Get-Monitor], Exception
    + FullyQualifiedErrorId : PowershellService::GetMonitor FAILED,vmware.view
   .powershell.cmdlets.GetMonitor
Sven Huisman VMware vExpert 2009-2016 Twitter: @svenh blog: svenhuisman.com
0 Kudos
admin
Immortal
Immortal

Can you please check the view server events console to see if everything is ok with the events DB configuration on the view server side.

0 Kudos
VirtualSven
Hot Shot
Hot Shot

Everything is ok with the event DB config. The View 5.0 and the View 5.1 server are in the same View "farm".

Sven Huisman VMware vExpert 2009-2016 Twitter: @svenh blog: svenhuisman.com
0 Kudos
VirtualSven
Hot Shot
Hot Shot

I have removed View 5.1 from one of the servers and reinstalled View as a replica server. Still got the same error. Other powershell command work correctly like: get-viewVC.

Sven Huisman VMware vExpert 2009-2016 Twitter: @svenh blog: svenhuisman.com
0 Kudos
twhiffen
VMware Employee
VMware Employee

Try the View PolwerCLI command "get-monitor" without any arguments and see what that returns.

0 Kudos
ShakespearsGhos
Contributor
Contributor

Can you confirm your build numbers for 5.0 and 5.1?

Charlie Rizor | Knowledge Champion - Enterprise Desktop | View the Knowledge Base at http://kb.vmware.com | View the Support Insider Blog http://blogs.vmware.com/kb/
0 Kudos
VirtualSven
Hot Shot
Hot Shot

I've tried to use get-monitor without parameters, same error.

I've tried to uninstall View 5.1 and reinstall it as a clean server (standard), then the command works.

Buildnumber View 5.1: 704644

Buildnumber View 5.0: 481677

Sven Huisman VMware vExpert 2009-2016 Twitter: @svenh blog: svenhuisman.com
0 Kudos
ShakespearsGhos
Contributor
Contributor

Looks like the issue has been identified, and a workaround is being sought.  If something becomes available, I'll post as a reply.  Thank you for helping to identify this concern.

Charlie Rizor | Knowledge Champion - Enterprise Desktop | View the Knowledge Base at http://kb.vmware.com | View the Support Insider Blog http://blogs.vmware.com/kb/
VirtualSven
Hot Shot
Hot Shot

Thanks!

Sven Huisman VMware vExpert 2009-2016 Twitter: @svenh blog: svenhuisman.com
0 Kudos
AWaldenD3
Contributor
Contributor

We are seeing the same issues - is there a KB for this?

Thanks anyway - looking forward to the fix.

0 Kudos
ShakespearsGhos
Contributor
Contributor

There may be a work around developing for this.

Can you verify that the credentials configured for the View Adapter have an Administrators role in the View Admin console either directly or by group membership?

Charlie Rizor | Knowledge Champion - Enterprise Desktop | View the Knowledge Base at http://kb.vmware.com | View the Support Insider Blog http://blogs.vmware.com/kb/
0 Kudos
Brandon_Sarrade
Contributor
Contributor

Just in case people are still having this issue.

As of 5.1, you must now grant the account used in your View Adapter Configuration at least the "Administrator (Read Only)" privilege to the View Connection server.

Fixed everything up for me.

0 Kudos