VMware Cloud Community
Molinator
Contributor
Contributor

Updating Licensing in VCM using JLicense

When I run the JLICENSE.cmd file to update the VCM v5.5.1 license, I am receiving the following error message.  Any one know what this means?


D:\Program Files (x86)\VMware\VCM\Tools>jlicense.cmd -k xxxxx-xxxxx-xxxxx-xxxxx-xxxxx

D:\Program Files (x86)\VMware\VCM\Tools>Exception in thread "main" javax.persistence.PersistenceException: org.hibernate.exce
ption.SQLGrammarException: could not execute query
        at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1215)
        at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1148)
        at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:255)
        at com.googlecode.genericdao.search.jpa.JPASearchProcessor.search(JPASearchProcessor.java:93)
        at com.googlecode.genericdao.search.jpa.JPASearchProcessor.searchAndCount(JPASearchProcessor.java:159)
        at com.googlecode.genericdao.dao.jpa.JPABaseDAO._searchAndCount(JPABaseDAO.java:394)
        at com.googlecode.genericdao.dao.jpa.GenericDAOImpl.searchAndCount(GenericDAOImpl.java:133)
        at com.vmware.vcmapi.persistence.license.hibernate.LicenseDAOImpl.getLicenseInfo(LicenseDAOImpl.java:58)
        at com.vmware.vcmapi.services.licensing.impl.LicensingServices.getLicenseData(LicensingServices.java:235)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
        at org.springframework.remoting.support.RemoteInvocationTraceInterceptor.invoke(RemoteInvocationTraceInterceptor.java
:77)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
        at $Proxy101.getLicenseData(Unknown Source)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.springframework.remoting.support.RemoteInvocation.invoke(RemoteInvocation.java:205)
        at org.springframework.remoting.support.DefaultRemoteInvocationExecutor.invoke(DefaultRemoteInvocationExecutor.java:3
😎
        at org.springframework.remoting.support.RemoteInvocationBasedExporter.invoke(RemoteInvocationBasedExporter.java:78)
        at org.springframework.remoting.support.RemoteInvocationBasedExporter.invokeAndCreateResult(RemoteInvocationBasedExpo
rter.java:114)
        at org.springframework.remoting.httpinvoker.HttpInvokerServiceExporter.handleRequest(HttpInvokerServiceExporter.java:
73)
        at org.springframework.web.context.support.HttpRequestHandlerServlet.service(HttpRequestHandlerServlet.java:67)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:304)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
        at com.vmware.vcmapi.http.filters.LocalHostAccessFilter.doFilter(LocalHostAccessFilter.java:88)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
        at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:77)
        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
        at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:163)
        at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237)
        at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
        at org.springframework.orm.jpa.support.OpenEntityManagerInViewFilter.doFilterInternal(OpenEntityManagerInViewFilter.j
ava:113)
        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
        at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:240)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:164)
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:462)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
        at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:563)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:403)
        at org.apache.coyote.http11.Http11NioProcessor.process(Http11NioProcessor.java:369)
        at org.apache.coyote.http11.Http11NioProtocol$Http11ConnectionHandler.process(Http11NioProtocol.java:317)
        at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1532)
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
        at java.lang.Thread.run(Thread.java:662)
        at org.springframework.remoting.support.RemoteInvocationUtils.fillInClientStackTraceIfPossible(RemoteInvocationUtils.
java:47)
        at org.springframework.remoting.support.RemoteInvocationResult.recreate(RemoteInvocationResult.java:115)
        at org.springframework.remoting.support.RemoteInvocationBasedAccessor.recreateRemoteInvocationResult(RemoteInvocation
BasedAccessor.java:85)
        at org.springframework.remoting.httpinvoker.HttpInvokerClientInterceptor.invoke(HttpInvokerClientInterceptor.java:127
)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
        at $Proxy0.getLicenseData(Unknown Source)
        at com.vmware.vcmapi.jlicense.JLicense.main(JLicense.java:142)
Caused by: org.hibernate.exception.SQLGrammarException: could not execute query
        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
        at org.hibernate.loader.Loader.doList(Loader.java:2536)
        at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
        at org.hibernate.loader.Loader.list(Loader.java:2271)
        at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:452)
        at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363)
        at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
        at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268)
        at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
        at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:246)
        ... 72 more
Caused by: java.sql.SQLException: Invalid object name 'dbo.ecmapi_sysview_license_containers'.
        at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
        at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816)
        at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254)
        at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:631)
        at net.sourceforge.jtds.jdbc.MSCursorResultSet.processOutput(MSCursorResultSet.java:943)
        at net.sourceforge.jtds.jdbc.MSCursorResultSet.cursorCreate(MSCursorResultSet.java:541)
        at net.sourceforge.jtds.jdbc.MSCursorResultSet.<init>(MSCursorResultSet.java:154)
        at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:424)
        at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:777)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
        at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
        at org.hibernate.loader.Loader.getResultSet(Loader.java:1953)
        at org.hibernate.loader.Loader.doQuery(Loader.java:802)
        at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
        at org.hibernate.loader.Loader.doList(Loader.java:2533)
        ... 80 more

Reply
0 Kudos
16 Replies
USPanda
Enthusiast
Enthusiast

We too unable to update the license for VCM 5.5, can some one please suggest how to get it done. Thanks in advance....

c:\Program Files (x86)\VMware\VCM\Tools>JLicense -k xxxxx-xxxxx-xxxxx-xxxxx-xxxxx

c:\Program Files (x86)\VMware\VCM\Tools>Exception in thread "main" javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: Cannotopen connection

       at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1215)

        at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1148)

        at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:255)

        at com.googlecode.genericdao.search.jpa.JPASearchProcessor.search(JPASearchProcessor.java:93)

        at com.googlecode.genericdao.search.jpa.JPASearchProcessor.searchAndCount(JPASearchProcessor.java:159)

        at com.googlecode.genericdao.dao.jpa.JPABaseDAO._searchAndCount(JPABaseDAO.java:394)

        at com.googlecode.genericdao.dao.jpa.GenericDAOImpl.searchAndCount(GenericDAOImpl.java:133)

        at com.vmware.vcmapi.persistence.license.hibernate.LicenseDAOImpl.getLicenseInfo(LicenseDAOImpl.java:58)

        at com.vmware.vcmapi.services.licensing.impl.LicensingServices.getLicenseData(LicensingServices.java:235)

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

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

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

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

        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)

        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)

        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)

        at org.springframework.remoting.support.RemoteInvocationTraceInterceptor.invoke(RemoteInvocationTraceInterceptor.java:77)

        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)

        at $Proxy101.getLicenseData(Unknown Source)

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

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

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

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

        at org.springframework.remoting.support.RemoteInvocation.invoke(RemoteInvocation.java:205)

        at org.springframework.remoting.support.DefaultRemoteInvocationExecutor.invoke(DefaultRemoteInvocationExecutor.java:38)

        at org.springframework.remoting.support.RemoteInvocationBasedExporter.invoke(RemoteInvocationBasedExporter.java:78)

        at org.springframework.remoting.support.RemoteInvocationBasedExporter.invokeAndCreateResult(RemoteInvocationBasedExporter.java:114)

        at org.springframework.remoting.httpinvoker.HttpInvokerServiceExporter.handleRequest(HttpInvokerServiceExporter.java:73)

        at org.springframework.web.context.support.HttpRequestHandlerServlet.service(HttpRequestHandlerServlet.java:67)

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

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

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

        at com.vmware.vcmapi.http.filters.LocalHostAccessFilter.doFilter(LocalHostAccessFilter.java:88)

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

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

        at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:77)

        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)

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

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

        at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:163)

        at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237)

        at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)

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

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

        at org.springframework.orm.jpa.support.OpenEntityManagerInViewFilter.doFilterInternal(OpenEntityManagerInViewFilter.java:113)

        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)

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

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

        at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)

        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)

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

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

        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:240)

        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:164)

        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:462)

        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164)

        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)

        at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:563)

        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)

        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:403)

        at org.apache.coyote.http11.Http11NioProcessor.process(Http11NioProcessor.java:369)

        at org.apache.coyote.http11.Http11NioProtocol$Http11ConnectionHandler.process(Http11NioProtocol.java:317)

        at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1532)

        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)

        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)

        at java.lang.Thread.run(Thread.java:662)

        at org.springframework.remoting.support.RemoteInvocationUtils.fillInClientStackTraceIfPossible(RemoteInvocationUtils.java:47)

        at org.springframework.remoting.support.RemoteInvocationResult.recreate(RemoteInvocationResult.java:115)

        at org.springframework.remoting.support.RemoteInvocationBasedAccessor.recreateRemoteInvocationResult(RemoteInvocationBasedAccessor.java:85)

        at org.springframework.remoting.httpinvoker.HttpInvokerClientInterceptor.invoke(HttpInvokerClientInterceptor.java:127)

        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)

        at $Proxy0.getLicenseData(Unknown Source)

        at com.vmware.vcmapi.jlicense.JLicense.main(JLicense.java:142)Caused by: org.hibernate.exception.GenericJDBCException: Cannot open connection

        at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140)

        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128)

        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)

        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:52)

        at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:449)

        at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167)

        at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161)

        at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1700)

        at org.hibernate.loader.Loader.doQuery(Loader.java:801)

        at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)

        at org.hibernate.loader.Loader.doList(Loader.java:2533)

        at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)

        at org.hibernate.loader.Loader.list(Loader.java:2271)

        at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:452)

        at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363)

        at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)

        at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268)

        at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)

        at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:246)

        ... 72 more

Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Network error IOException: Connection refused: connect)

        at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549)

        at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)

        at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)

        at org.hibernate.ejb.connection.InjectedDataSourceConnectionProvider.get

Connection(InjectedDataSourceConnectionProvider.java:71)

        at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446)

        ... 86 more

Caused by: java.sql.SQLException: Network error IOException: Connection refused: connect

        at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:385)

        at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50)

        at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:182)

        at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)

        at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)

        at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556)

        at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545)         ... 90 more

Caused by: java.net.ConnectException: Connection refused: connect

        at java.net.PlainSocketImpl.socketConnect(Native Method)

        at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:351)

        at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:213)

        at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:200)

        at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)

        at java.net.Socket.connect(Socket.java:529)

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

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

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

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

        at net.sourceforge.jtds.jdbc.SharedSocket.createSocketForJDBC3(SharedSocket.java:304)

        at net.sourceforge.jtds.jdbc.SharedSocket.<init>(SharedSocket.java:255)

        at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:310)

        ... 96 more

Reply
0 Kudos
jddias
VMware Employee
VMware Employee

USPanda, your error message is different than the other one posted.  In your case, it is clearly a problem with connection to the database.

- Make sure you are running this with credentials that are able to access the DB

- Make sure that the vFabric tc server service is running, restart it for good measure

- Make sure the DB is running

Visit my blog for vCloud Management tips and tricks - http://www.storagegumbo.com
Reply
0 Kudos
USPanda
Enthusiast
Enthusiast

- Make sure you are running this with credentials that are able to access the DB : yes it is in place

- Make sure that the vFabric tc server service is running, restart it for good measure : there is no such service on VCM server

- Make sure the DB is running : yes it is running

please help further if you can, that will be great help to resolve this issue. currently VCM got expired and we are unable to update a new license 😞

Reply
0 Kudos
jddias
VMware Employee
VMware Employee

On the collector server, you should see the service "SpringSource tc Runtime instance"

Make sure it is running, and restart it if it is running.springsourcetc.PNG

Visit my blog for vCloud Management tips and tricks - http://www.storagegumbo.com
Reply
0 Kudos
USPanda
Enthusiast
Enthusiast

Yes this service is running fine, however I have restarted it again & there was no error as well.

Reply
0 Kudos
USPanda
Enthusiast
Enthusiast

but still the license is unable to update....

C:\Program Files (x86)\VMware\VCM\Tools>Exception in thread "main" javax.persistence.PersistenceException:org.hibernate.exception.GenericJDBCException: Cannot open connection

Reply
0 Kudos
USPanda
Enthusiast
Enthusiast

Is there any solution available for such issues or this is the known bug in VCM 5.5 due to which all POCs are getting fail.....

Reply
0 Kudos
jddias
VMware Employee
VMware Employee

No bug, that I'm aware.  It sounds like you are not able to connect to the DB which could be a firewall or authentication issue.

Make certain that the VCM database is the default database for the service account in VCM.

Visit my blog for vCloud Management tips and tricks - http://www.storagegumbo.com
Reply
0 Kudos
admin
Immortal
Immortal

I think it's probably the last few messages at the bottom of the stack among the "80 more" or "96 more" that are going to be more useful. Can you post those?

Also, are you logged in as the account that installed VCM when you're running this, or is it a different account?

Reply
0 Kudos
Molinator
Contributor
Contributor

I actually found a resolution to my original problem.  I was logged on with the VCM service acount but what I had to do was set the VCM database as the default database in SQL for this account. The default database was set to Master.  After changing the default database, I restarted the SQL, VCM, and SpringSource services.  I probably didn't need to restart them all but I did anyway.

Reply
0 Kudos
USPanda
Enthusiast
Enthusiast

There is no firewall in between, VCM and SQL because both are installed in a same server.

And also the VCM database is already the default database for the service account in VCM

Reply
0 Kudos
USPanda
Enthusiast
Enthusiast

There is no more error logs after "80 more" or "96 more"

Yes we have logged in as the account that installed VCM when we are running this command i.e. one of the domain administration credential not local

Reply
0 Kudos
USPanda
Enthusiast
Enthusiast

I have already set the VCM database as the default database in SQL for this account & also restarted the SQL, VCM, and SpringSource services but still the error is same during the execution of license update command.....

Reply
0 Kudos
admin
Immortal
Immortal

I spoke with some of the developers who are familiar with JLicense. The other suggestion they had to look at is what account is being used for the Tomcat service (SpringSource tc Runtime instance). It should probably be the same as the VCM Collector service account.

Reply
0 Kudos
USPanda
Enthusiast
Enthusiast

One single account is being used for all of the below listed services and are running through an admin privileged domain account (and also checked with local account system account, local admin account but things are same). But still JLicense is resulting same error. It seems till the time we get a resolution to this error, the new license also which we got for POC will expire on 8th Jan 2013

Tomcat service - <<< there is no Tomcat services but IIS 7 services are fine>>>>

SpringSource tc Runtime instance Services

VCM services

SQL services

Reply
0 Kudos
USPanda
Enthusiast
Enthusiast

as much as possible we did the changes in services & the errors keep on changing but not getting resolved....

C:\Users\administrator.CLOUDCOE>cd "c:\Program Files (x86)\VMware\VCM\Tools"

c:\Program Files (x86)\VMware\VCM\Tools>jlicense -k V5631-57650-N82ZR-AHMHP-2JL00

c:\Program Files (x86)\VMware\VCM\Tools>Exception in thread "main" org.springfra

mework.remoting.RemoteConnectFailureException: Cannot connect to HTTP invoker re

mote service at [http://localhost:8080/vcmapi/remoting/LicenseService]; nested e

xception is java.net.ConnectException: Connection refused: connect

        at org.springframework.remoting.httpinvoker.HttpInvokerClientInterceptor.convertHttpInvokerAccessException(HttpInvokerClientInterceptor.java:156)

        at org.springframework.remoting.httpinvoker.HttpInvokerClientInterceptor.invoke(HttpInvokerClientInterceptor.java:125)

        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)

        at $Proxy0.getLicenseData(Unknown Source)

        at com.vmware.vcmapi.jlicense.JLicense.main(JLicense.java:142)Caused by: java.net.ConnectException: Connection refused: connect

        at java.net.PlainSocketImpl.socketConnect(Native Method)

        at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:351)

        at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:213)

        at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:200)

        at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)

        at java.net.Socket.connect(Socket.java:529)

        at java.net.Socket.connect(Socket.java:478)

        at sun.net.NetworkClient.doConnect(NetworkClient.java:163)

        at sun.net.www.http.HttpClient.openServer(HttpClient.java:395)

        at sun.net.www.http.HttpClient.openServer(HttpClient.java:530)

        at sun.net.www.http.HttpClient.<init>(HttpClient.java:234)

        at sun.net.www.http.HttpClient.New(HttpClient.java:307)

        at sun.net.www.http.HttpClient.New(HttpClient.java:324)

        at sun.net.www.protocol.http.HttpURLConnection.getNewHttpClient(HttpURLConnection.java:970)

        at sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:911)

        at sun.net.www.protocol.http.HttpURLConnection.connect(HttpURLConnection.java:836)

        at sun.net.www.protocol.http.HttpURLConnection.getOutputStream(HttpURLConnection.java:1014)

        at org.springframework.remoting.httpinvoker.SimpleHttpInvokerRequestExecutor.writeRequestBody(SimpleHttpInvokerRequestExecutor.java:118)

        at org.springframework.remoting.httpinvoker.SimpleHttpInvokerRequestExecutor.doExecuteRequest(SimpleHttpInvokerRequestExecutor.java:60)

        at org.springframework.remoting.httpinvoker.AbstractHttpInvokerRequestExecutor.executeRequest(AbstractHttpInvokerRequestExecutor.java:68)

        at org.springframework.remoting.httpinvoker.HttpInvokerClientInterceptor.executeRequest(HttpInvokerClientInterceptor.java:145)

        at org.springframework.remoting.httpinvoker.HttpInvokerClientInterceptor.invoke(HttpInvokerClientInterceptor.java:122)

        ... 4 more

c:\Program Files (x86)\VMware\VCM\Tools>jlicense -k V5631-57650-N82ZR-AHMHP-2JL00

c:\Program Files (x86)\VMware\VCM\Tools>Exception in thread "main" javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: Cannotopen connection

        at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1215)

        at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1148)

        at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:255)

        at com.googlecode.genericdao.search.jpa.JPASearchProcessor.search(JPASearchProcessor.java:93)

        at com.googlecode.genericdao.search.jpa.JPASearchProcessor.searchAndCount(JPASearchProcessor.java:159)

        at com.googlecode.genericdao.dao.jpa.JPABaseDAO._searchAndCount(JPABaseDAO.java:394)

        at com.googlecode.genericdao.dao.jpa.GenericDAOImpl.searchAndCount(GenericDAOImpl.java:133)

        at com.vmware.vcmapi.persistence.license.hibernate.LicenseDAOImpl.getLicenseInfo(LicenseDAOImpl.java:58)

        at com.vmware.vcmapi.services.licensing.impl.LicensingServices.getLicenseData(LicensingServices.java:235)

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

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

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

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

        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)

        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)

        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)

        at org.springframework.remoting.support.RemoteInvocationTraceInterceptor.invoke(RemoteInvocationTraceInterceptor.java:77)

        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)

        at $Proxy101.getLicenseData(Unknown Source)

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

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

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

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

        at org.springframework.remoting.support.RemoteInvocation.invoke(RemoteInvocation.java:205)

        at org.springframework.remoting.support.DefaultRemoteInvocationExecutor.invoke(DefaultRemoteInvocationExecutor.java:38)

        at org.springframework.remoting.support.RemoteInvocationBasedExporter.invoke(RemoteInvocationBasedExporter.java:78)

        at org.springframework.remoting.support.RemoteInvocationBasedExporter.invokeAndCreateResult(RemoteInvocationBasedExporter.java:114)

        at org.springframework.remoting.httpinvoker.HttpInvokerServiceExporter.handleRequest(HttpInvokerServiceExporter.java:73)

        at org.springframework.web.context.support.HttpRequestHandlerServlet.service(HttpRequestHandlerServlet.java:67)

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

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

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

        at com.vmware.vcmapi.http.filters.LocalHostAccessFilter.doFilter(LocalHostAccessFilter.java:88)

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

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

        at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:77)

        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)

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

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

        at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:163)

        at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237)

        at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)

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

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

        at org.springframework.orm.jpa.support.OpenEntityManagerInViewFilter.doFilterInternal(OpenEntityManagerInViewFilter.java:113)

        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)

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

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

        at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)

        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)

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

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

        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:240)

        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:164)

        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:462)

        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164)

        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)

        at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:563)

        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)

        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:403)

        at org.apache.coyote.http11.Http11NioProcessor.process(Http11NioProcessor.java:369)

        at org.apache.coyote.http11.Http11NioProtocol$Http11ConnectionHandler.process(Http11NioProtocol.java:317)

        at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1532)

        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)

        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)

        at java.lang.Thread.run(Thread.java:662)

        at org.springframework.remoting.support.RemoteInvocationUtils.fillInClientStackTraceIfPossible(RemoteInvocationUtils.java:47)

        at org.springframework.remoting.support.RemoteInvocationResult.recreate(RemoteInvocationResult.java:115)

        at org.springframework.remoting.support.RemoteInvocationBasedAccessor.recreateRemoteInvocationResult(RemoteInvocationBasedAccessor.java:85)

        at org.springframework.remoting.httpinvoker.HttpInvokerClientInterceptor.invoke(HttpInvokerClientInterceptor.java:127)

        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)

        at $Proxy0.getLicenseData(Unknown Source)

        at com.vmware.vcmapi.jlicense.JLicense.main(JLicense.java:142)Caused by: org.hibernate.exception.GenericJDBCException: Cannot open connection

        at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140)

        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128)

        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)

        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:52)

        at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:449)

        at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167)

        at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161)

        at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1700)

        at org.hibernate.loader.Loader.doQuery(Loader.java:801)

        at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)

        at org.hibernate.loader.Loader.doList(Loader.java:2533)

        at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)

        at org.hibernate.loader.Loader.list(Loader.java:2271)

        at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:452)

        at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363)

        at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)

        at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268)

        at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)

        at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:246)

        ... 72 more

Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Network error IOException: Connection refused: connect)

        at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549)

        at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)

        at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)

        at org.hibernate.ejb.connection.InjectedDataSourceConnectionProvider.getConnection(InjectedDataSourceConnectionProvider.java:71)

        at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446)

        ... 86 more

Caused by: java.sql.SQLException: Network error IOException: Connection refused: connect

       at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:385)

        at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50)

        at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:182)

        at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)

        at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)

        at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556)

        at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545)

        ... 90 more

Caused by: java.net.ConnectException: Connection refused: connect

        at java.net.PlainSocketImpl.socketConnect(Native Method)

        at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:351)

        at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:213)

        at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:200)

        at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)

        at java.net.Socket.connect(Socket.java:529)

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

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

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

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

        at net.sourceforge.jtds.jdbc.SharedSocket.createSocketForJDBC3(SharedSocket.java:304)

        at net.sourceforge.jtds.jdbc.SharedSocket.<init>(SharedSocket.java:255)

        at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:310)

        ... 96 more

Reply
0 Kudos