VMware Horizon Community
jamesalmed
Contributor
Contributor
Jump to solution

View is not connecting to event db and getting error unable to connect the db

HI ,

while trying to connect the view to event db , I am experiencing a weird issue where in getting "unable to connect " error message.

also in the error log I am getting below errors can you pls help.

TP-Processor1> [ConfigurationManagerBean] ADAM Error code: 2,128 com.vmware.vdi.admin.ui.ConfigurationManagerBean.updateDatabaseConfiguration(SourceFile:181)

com.vmware.vdi.adamwrapper.exceptions.ADAMServerException: database initialization failed, SQL exception when connecting to database: The TCP/IP connection to the host  has failed. java.net.ConnectException: Connection refused: connect

  at com.vmware.vdi.admin.be.ConfigurationManager.a(SourceFile:1703)

  at com.vmware.vdi.admin.be.ConfigurationManager.updateDatabaseConfiguration(SourceFile:1580)

  at com.vmware.vdi.admin.ui.ConfigurationManagerBean.updateDatabaseConfiguration(SourceFile:177)

  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

  at java.lang.reflect.Method.invoke(Method.java:606)

  at com.vmware.vdi.admin.ui.common.ViewFlexFactory$ViewProxy.invoke(SourceFile:113)

  at com.sun.proxy.$Proxy56.updateDatabaseConfiguration(Unknown Source)

  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

  at java.lang.reflect.Method.invoke(Method.java:606)

  at flex.messaging.services.remoting.adapters.JavaAdapter.invoke(JavaAdapter.java:418)

  at flex.messaging.services.RemotingService.serviceMessage(RemotingService.java:183)

  at flex.messaging.MessageBroker.routeMessageToService(MessageBroker.java:1400)

  at flex.messaging.endpoints.AbstractEndpoint.serviceMessage(AbstractEndpoint.java:1011)

  at flex.messaging.endpoints.amf.MessageBrokerFilter.invoke(MessageBrokerFilter.java:103)

  at flex.messaging.endpoints.amf.LegacyFilter.invoke(LegacyFilter.java:158)

  at flex.messaging.endpoints.amf.SessionFilter.invoke(SessionFilter.java:44)

  at flex.messaging.endpoints.amf.BatchProcessFilter.invoke(BatchProcessFilter.java:67)

  at flex.messaging.endpoints.amf.SerializationFilter.invoke(SerializationFilter.java:166)

  at flex.messaging.endpoints.BaseHTTPEndpoint.service(BaseHTTPEndpoint.java:291)

  at flex.messaging.MessageBrokerServlet.service(MessageBrokerServlet.java:353)

  at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)

  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)

  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

  at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)

  at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436)

  at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)

  at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)

  at com.vmware.vdi.admin.ui.servlet.AMFProxyServlet.a(SourceFile:90)

  at com.vmware.vdi.admin.ui.servlet.AMFProxyServlet.doPost(SourceFile:57)

1 Solution

Accepted Solutions
HariRajan
Hot Shot
Hot Shot
Jump to solution

Hi James ,

It is an SQL API based connection to event database , there is no need of a ODBC connection , view will do for you.

Just wanted to know which OS you are using for the connection server and have you done Windows Update on this machine ? , If not done please do that .

reboot the machine try connecting the event database . if not working  please verify the things mentioned in the below KB

http://kb.vmware.com/KB/1029537

You can do one more thing before checking the KB  , if the connection server OS is windows 2012 and the SQL is Windows 2012 , take a snapshot of the conection server VM and go to

below location

C:\Program Files\VMware\VMware View\Server\broker\shared\lib\sqljdbc-1.2.jar

stop all view service in connection server.

rename sqljdbc-1.2.jar to sqljdbc-1.2.jar.backup.


download SQL JDBC 3.0 Driver http://www.microsoft.com/en-us/download/details.aspx?id=21599


extract the download file and copy the sqljdbc4.jar to location (C:\Program Files\VMware\VMware View\Server\broker\shared\lib\)

also copy same file once more and rename the file to sqljdbc-1.2.jar


restart all the connection server services and wait for 10 minutes , then check the view admin page.

Thanks & Regards in Plenteous . Hari Rajan

View solution in original post

3 Replies
HariRajan
Hot Shot
Hot Shot
Jump to solution

Hi James ,

It is an SQL API based connection to event database , there is no need of a ODBC connection , view will do for you.

Just wanted to know which OS you are using for the connection server and have you done Windows Update on this machine ? , If not done please do that .

reboot the machine try connecting the event database . if not working  please verify the things mentioned in the below KB

http://kb.vmware.com/KB/1029537

You can do one more thing before checking the KB  , if the connection server OS is windows 2012 and the SQL is Windows 2012 , take a snapshot of the conection server VM and go to

below location

C:\Program Files\VMware\VMware View\Server\broker\shared\lib\sqljdbc-1.2.jar

stop all view service in connection server.

rename sqljdbc-1.2.jar to sqljdbc-1.2.jar.backup.


download SQL JDBC 3.0 Driver http://www.microsoft.com/en-us/download/details.aspx?id=21599


extract the download file and copy the sqljdbc4.jar to location (C:\Program Files\VMware\VMware View\Server\broker\shared\lib\)

also copy same file once more and rename the file to sqljdbc-1.2.jar


restart all the connection server services and wait for 10 minutes , then check the view admin page.

Thanks & Regards in Plenteous . Hari Rajan
jamesalmed
Contributor
Contributor
Jump to solution

Thanks , I just said the way you said after downloading the JDBC and restart the connection server , then tried to connect the db and it starts working.

klinden
Contributor
Contributor
Jump to solution

I tried this fix, but it still didn't work for me Smiley Sad

Reply
0 Kudos