Kagome
Enthusiast
Enthusiast

SQL Plugin 1.1.0 fail to load databases on startup

Hello,

i updates Vcenter Server + orchestrator from 5.5 to 5.51.

Nearly all is working now fine but i have a single bug.

The SQL Plugin 1.1.0 gives me an error in the client when i want to expand the Databases.

If I add new Databases and add the new databases to workflows - it is working until i restart the Orchestrator Server service.

The Error is:

2014-06-05 23:45:52.170+0200 [http-bio-10.77.1.31-8281-exec-1] ERROR {} [VcoDelegatingWebFacade] Server Error...

ch.dunes.model.sdk.SDKFinderException: Unable to execute 'fetchRelation' for type : RootFinder : com.vmware.o11n.plugin.database.DatabaseException: Table content_field_vmhost is not found in database.

    at ch.dunes.vso.sdk.SDKFinder.logAndThrow(SDKFinder.java:858)

    at ch.dunes.vso.sdk.SDKFinder.fetchRelation(SDKFinder.java:342)

    at ch.dunes.vso.sdk.SDKFinder._findRelation(SDKFinder.java:306)

    at ch.dunes.vso.sdk.SDKFinder.findRelation(SDKFinder.java:224)

    at ch.dunes.vso.sdk.ModulesFactory.findRelation(ModulesFactory.java:521)

    at com.vmware.o11n.sdk.EnhancedScriptingSDK.findRelation(EnhancedScriptingSDK.java:99)

    at com.vmware.o11n.service.sdk.SdkModuleServiceImpl.findRelation(SdkModuleServiceImpl.java:57)

    at com.vmware.o11n.service.factory.VcoFactoryFacade.findRelation(VcoFactoryFacade.java:1633)

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

    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

    at java.lang.reflect.Method.invoke(Unknown Source)

    at com.vmware.o11n.service.security.AccessRightsInterceptor.invoke(AccessRightsInterceptor.java:92)

    at com.vmware.o11n.service.security.AccessRightsInterceptor.invoke(AccessRightsInterceptor.java:83)

    at com.vmware.o11n.service.webremoting.VcoDelegatingWebFacade.invokeOperation(VcoDelegatingWebFacade.java:106)

    at com.vmware.o11n.integration.initialization.VcoFactoryServiceFacadeProxy.invokeOperation(VcoFactoryServiceFacadeProxy.java:86)

    at sun.reflect.GeneratedMethodAccessor104.invoke(Unknown Source)

    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

    at java.lang.reflect.Method.invoke(Unknown Source)

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

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

    at com.sun.proxy.$Proxy105.invokeOperation(Unknown Source)

    at sun.reflect.GeneratedMethodAccessor103.invoke(Unknown Source)

    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

    at java.lang.reflect.Method.invoke(Unknown Source)

    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:305)

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

    at net.sf.ehcache.constructs.web.filter.GzipFilter.doFilter(GzipFilter.java:95)

    at net.sf.ehcache.constructs.web.filter.Filter.doFilter(Filter.java:86)

    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:222)

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

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

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

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

    at org.apache.catalina.valves.RemoteIpValve.invoke(RemoteIpValve.java:680)

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

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

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

    at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1002)

    at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:585)

    at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)

    at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

    at java.lang.Thread.run(Unknown Source)

Caused by: java.lang.reflect.InvocationTargetException

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

    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

    at java.lang.reflect.Method.invoke(Unknown Source)

    at ch.dunes.vso.sdk.DirectInvoker.invoke(DirectInvoker.java:55)

    at ch.dunes.vso.sdk.SDKDatasourceInvoker.fetchRelation(SDKDatasourceInvoker.java:67)

    at ch.dunes.vso.sdk.SDKFinder.fetchRelation(SDKFinder.java:332)

    ... 51 more

Caused by: com.vmware.o11n.plugin.database.DatabaseException: Table content_field_vmhost is not found in database.

    at com.vmware.o11n.plugin.database.Database.addTables(Database.java:181)

    at com.vmware.o11n.plugin.database.configuration.DataBaseConfigPersister.getDatabaseFrom(DataBaseConfigPersister.java:140)

    at com.vmware.o11n.plugin.database.configuration.DataBaseConfigPersister.getAll(DataBaseConfigPersister.java:82)

    at com.vmware.o11n.plugin.database.configuration.ConfigurationServiceImpl.reload(ConfigurationServiceImpl.java:67)

    at com.vmware.o11n.plugin.database.configuration.ConfigurationServiceImpl.getAll(ConfigurationServiceImpl.java:124)

    at com.vmware.o11n.plugin.database.model.DatabaseManager.getDatabases(DatabaseManager.java:415)

    at com.vmware.o11n.plugin.database.DatabasePluginFactory.findRelation(DatabasePluginFactory.java:150)

    ... 58 more

OK .. as i can read: a table in database seems to be missing.

Questions:

1) how can I reinstall the SQL Plugin 1.1.0 and maybe recreate the database?

2) I don't know why .. but I set the Orchestrator to use the vDB Database in the past while installation instead of a MS SQL Database...so there is no backup.

How can I access the vDB? I have a second, working  Orchestrator Server where I could copy the damaged table structure to the damaged Server.

3) IF i change now from vDB to MS SQL Database .. I'm right that all my Workflows are lost?

Thanks for help in advantage.

Reply
0 Kudos