<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: SQL Plugin 1.1.0 fail to load databases on startup in VMware Aria Automation Orchestrator Discussions</title>
    <link>https://communities.vmware.com/t5/VMware-Aria-Automation/SQL-Plugin-1-1-0-fail-to-load-databases-on-startup/m-p/382674#M1098</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;vCO 5.5.2 ships with SQL plugin 1.1.1&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Fri, 05 Dec 2014 21:55:07 GMT</pubDate>
    <dc:creator>igaydajiev</dc:creator>
    <dc:date>2014-12-05T21:55:07Z</dc:date>
    <item>
      <title>SQL Plugin 1.1.0 fail to load databases on startup</title>
      <link>https://communities.vmware.com/t5/VMware-Aria-Automation/SQL-Plugin-1-1-0-fail-to-load-databases-on-startup/m-p/382667#M1091</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hello,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;i updates Vcenter Server + orchestrator from 5.5 to 5.51.&lt;/P&gt;&lt;P&gt;Nearly all is working now fine but i have a single bug.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;The SQL Plugin 1.1.0 gives me an error in the client when i want to expand the Databases.&lt;/P&gt;&lt;P&gt;If I add new Databases and add the new databases to workflows - it is working until i restart the Orchestrator Server service.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;The Error is:&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;2014-06-05 23:45:52.170+0200 [http-bio-10.77.1.31-8281-exec-1] ERROR {} [VcoDelegatingWebFacade] Server Error...&lt;/P&gt;&lt;P&gt;ch.dunes.model.sdk.SDKFinderException: Unable to execute 'fetchRelation' for type : RootFinder : com.vmware.o11n.plugin.database.DatabaseException&lt;STRONG&gt;: &lt;SPAN style="text-decoration: underline;"&gt;Table content_field_vmhost is not found in database.&lt;/SPAN&gt;&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; at ch.dunes.vso.sdk.SDKFinder.logAndThrow(SDKFinder.java:858)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; at ch.dunes.vso.sdk.SDKFinder.fetchRelation(SDKFinder.java:342)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; at ch.dunes.vso.sdk.SDKFinder._findRelation(SDKFinder.java:306)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; at ch.dunes.vso.sdk.SDKFinder.findRelation(SDKFinder.java:224)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; at ch.dunes.vso.sdk.ModulesFactory.findRelation(ModulesFactory.java:521)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; at com.vmware.o11n.sdk.EnhancedScriptingSDK.findRelation(EnhancedScriptingSDK.java:99)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; at com.vmware.o11n.service.sdk.SdkModuleServiceImpl.findRelation(SdkModuleServiceImpl.java:57)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; at com.vmware.o11n.service.factory.VcoFactoryFacade.findRelation(VcoFactoryFacade.java:1633)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; at java.lang.reflect.Method.invoke(Unknown Source)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; at com.vmware.o11n.service.security.AccessRightsInterceptor.invoke(AccessRightsInterceptor.java:92)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; at com.vmware.o11n.service.security.AccessRightsInterceptor.invoke(AccessRightsInterceptor.java:83)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; at com.vmware.o11n.service.webremoting.VcoDelegatingWebFacade.invokeOperation(VcoDelegatingWebFacade.java:106)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; at com.vmware.o11n.integration.initialization.VcoFactoryServiceFacadeProxy.invokeOperation(VcoFactoryServiceFacadeProxy.java:86)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; at sun.reflect.GeneratedMethodAccessor104.invoke(Unknown Source)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; at java.lang.reflect.Method.invoke(Unknown Source)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:319)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:196)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; at com.sun.proxy.$Proxy105.invokeOperation(Unknown Source)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; at sun.reflect.GeneratedMethodAccessor103.invoke(Unknown Source)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; at java.lang.reflect.Method.invoke(Unknown Source)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.springframework.remoting.support.RemoteInvocation.invoke(RemoteInvocation.java:205)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.springframework.remoting.support.DefaultRemoteInvocationExecutor.invoke(DefaultRemoteInvocationExecutor.java:38)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.springframework.remoting.support.RemoteInvocationBasedExporter.invoke(RemoteInvocationBasedExporter.java:78)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.springframework.remoting.support.RemoteInvocationBasedExporter.invokeAndCreateResult(RemoteInvocationBasedExporter.java:114)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.springframework.remoting.httpinvoker.HttpInvokerServiceExporter.handleRequest(HttpInvokerServiceExporter.java:73)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.springframework.web.context.support.HttpRequestHandlerServlet.service(HttpRequestHandlerServlet.java:67)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; at net.sf.ehcache.constructs.web.filter.GzipFilter.doFilter(GzipFilter.java:95)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; at net.sf.ehcache.constructs.web.filter.Filter.doFilter(Filter.java:86)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:581)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.apache.catalina.valves.RemoteIpValve.invoke(RemoteIpValve.java:680)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:929)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1002)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:585)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; at java.lang.Thread.run(Unknown Source)&lt;/P&gt;&lt;P&gt;Caused by: java.lang.reflect.InvocationTargetException&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; at java.lang.reflect.Method.invoke(Unknown Source)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; at ch.dunes.vso.sdk.DirectInvoker.invoke(DirectInvoker.java:55)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; at ch.dunes.vso.sdk.SDKDatasourceInvoker.fetchRelation(SDKDatasourceInvoker.java:67)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; at ch.dunes.vso.sdk.SDKFinder.fetchRelation(SDKFinder.java:332)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; ... 51 more&lt;/P&gt;&lt;P&gt;Caused by: com.vmware.o11n.plugin.database.DatabaseException: Table content_field_vmhost is not found in database.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; at com.vmware.o11n.plugin.database.Database.addTables(Database.java:181)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; at com.vmware.o11n.plugin.database.configuration.DataBaseConfigPersister.getDatabaseFrom(DataBaseConfigPersister.java:140)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; at com.vmware.o11n.plugin.database.configuration.DataBaseConfigPersister.getAll(DataBaseConfigPersister.java:82)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; at com.vmware.o11n.plugin.database.configuration.ConfigurationServiceImpl.reload(ConfigurationServiceImpl.java:67)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; at com.vmware.o11n.plugin.database.configuration.ConfigurationServiceImpl.getAll(ConfigurationServiceImpl.java:124)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; at com.vmware.o11n.plugin.database.model.DatabaseManager.getDatabases(DatabaseManager.java:415)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; at com.vmware.o11n.plugin.database.DatabasePluginFactory.findRelation(DatabasePluginFactory.java:150)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; ... 58 more&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;OK .. as i can read: a table in database seems to be missing.&lt;/P&gt;&lt;P&gt;Questions:&lt;/P&gt;&lt;P&gt;1) how can I reinstall the SQL Plugin 1.1.0 and maybe recreate the database?&lt;/P&gt;&lt;P&gt;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.&lt;/P&gt;&lt;P&gt;How can I access the vDB? I have a second, working&amp;nbsp; Orchestrator Server where I could copy the damaged table structure to the damaged Server.&lt;/P&gt;&lt;P&gt;3) IF i change now from vDB to MS SQL Database .. I'm right that all my Workflows are lost?&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Thanks for help in advantage.&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Thu, 05 Jun 2014 22:25:21 GMT</pubDate>
      <guid>https://communities.vmware.com/t5/VMware-Aria-Automation/SQL-Plugin-1-1-0-fail-to-load-databases-on-startup/m-p/382667#M1091</guid>
      <dc:creator>Kagome</dc:creator>
      <dc:date>2014-06-05T22:25:21Z</dc:date>
    </item>
    <item>
      <title>Re: SQL Plugin 1.1.0 fail to load databases on startup</title>
      <link>https://communities.vmware.com/t5/VMware-Aria-Automation/SQL-Plugin-1-1-0-fail-to-load-databases-on-startup/m-p/382668#M1092</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;I 'fixed' that issue by the following steps:&lt;/P&gt;&lt;P&gt;- create a package in the orchestrator Client with all Workflows, Actions, resources, ...)&lt;/P&gt;&lt;P&gt;- Export that packages&lt;/P&gt;&lt;P&gt;- document schudle Workflows (paramtertes, time and so on)&lt;/P&gt;&lt;P&gt;- document how you Setup AD-Connection, SQL Connection for the workflows&lt;/P&gt;&lt;P&gt;- Change in Orchestrator webkonfiguration the database (and konfigure it)&lt;/P&gt;&lt;P&gt;- press under 'troublshooting' in the webkonfiguration to reinstall all plugins&lt;/P&gt;&lt;P&gt;- restart orchestrator service&lt;/P&gt;&lt;P&gt;- Import the package in the 'new' orchestrator&lt;/P&gt;&lt;P&gt;- create the SQL Databases for my Workflows again&lt;/P&gt;&lt;P&gt;- add the schedudle Workflows again (&lt;STRONG&gt;Feature request:&lt;/STRONG&gt;. a automated way to Export / Import scheduled Workflows)&lt;/P&gt;&lt;P&gt;- finish&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;What I dislike ....&lt;/P&gt;&lt;P&gt;after checking the new database there was still no Table c&lt;STRONG&gt;ontent_field_vmhost .. &lt;/STRONG&gt;and there it made 'click' in my head.&lt;/P&gt;&lt;P&gt;That was one of a old, since months deleted&amp;nbsp; table of one MySQL Connection i stored in the SQL-Ressources...&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Can maybe someone confirm this as a bug:&lt;/P&gt;&lt;P&gt;- create a mysql Database on a serer&lt;/P&gt;&lt;P&gt;- add some tables with content to that database&lt;/P&gt;&lt;P&gt;- add that database to the Orchestrator SQL Ressources&lt;/P&gt;&lt;P&gt;- delete a table in the MySQL database with any Database-Tool ( i used MySQl Query Browser)&lt;/P&gt;&lt;P&gt;- upgrade Orchestrator and vCenter from 5.5 to 5.5.1&lt;/P&gt;&lt;P&gt;- check if there is an error if you try to expand the SQL Ressources in the Orchestrator Client.&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Sat, 07 Jun 2014 01:23:46 GMT</pubDate>
      <guid>https://communities.vmware.com/t5/VMware-Aria-Automation/SQL-Plugin-1-1-0-fail-to-load-databases-on-startup/m-p/382668#M1092</guid>
      <dc:creator>Kagome</dc:creator>
      <dc:date>2014-06-07T01:23:46Z</dc:date>
    </item>
    <item>
      <title>Re: SQL Plugin 1.1.0 fail to load databases on startup</title>
      <link>https://communities.vmware.com/t5/VMware-Aria-Automation/SQL-Plugin-1-1-0-fail-to-load-databases-on-startup/m-p/382669#M1093</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P style="margin: 2px; font-size: 14px; font-family: proxima-nova, Arial, sans-serif; color: #666666;"&gt;&amp;gt;Can maybe someone confirm this as a bug:&lt;/P&gt;&lt;P style="margin: 2px; font-size: 14px; font-family: proxima-nova, Arial, sans-serif; color: #666666;"&gt;&amp;gt;- create a mysql Database on a serer&lt;/P&gt;&lt;P style="margin: 2px; font-size: 14px; font-family: proxima-nova, Arial, sans-serif; color: #666666;"&gt;&amp;gt;- add some tables with content to that database&lt;/P&gt;&lt;P style="margin: 2px; font-size: 14px; font-family: proxima-nova, Arial, sans-serif; color: #666666;"&gt;&amp;gt;- add that database to the Orchestrator SQL Ressources&lt;/P&gt;&lt;P style="margin: 2px; font-size: 14px; font-family: proxima-nova, Arial, sans-serif; color: #666666;"&gt;&amp;gt;- delete a table in the MySQL database with any Database-Tool ( i used MySQl Query Browser)&lt;/P&gt;&lt;P style="margin: 2px; font-size: 14px; font-family: proxima-nova, Arial, sans-serif; color: #666666;"&gt;&amp;gt;- upgrade Orchestrator and vCenter from 5.5 to 5.5.1&lt;/P&gt;&lt;P style="margin: 2px; font-size: 14px; font-family: proxima-nova, Arial, sans-serif; color: #666666;"&gt;&amp;gt;- check if there is an error if you try to expand the SQL Ressources in the Orchestrator Client.&lt;/P&gt;&lt;P style="margin: 2px; font-size: 14px; font-family: proxima-nova, Arial, sans-serif; color: #666666;"&gt;&lt;/P&gt;&lt;P style="margin: 2px; font-size: 14px; font-family: proxima-nova, Arial, sans-serif; color: #666666;"&gt;&lt;SPAN style="line-height: 1.5em;"&gt;If I understand it correctly after the last step when vCO is restarted SQL plugin for vCenter Orchestrator has a configuration pointing toward database that is deleted and does not exist ant the moment of server restart? &lt;/SPAN&gt;&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Mon, 09 Jun 2014 11:55:47 GMT</pubDate>
      <guid>https://communities.vmware.com/t5/VMware-Aria-Automation/SQL-Plugin-1-1-0-fail-to-load-databases-on-startup/m-p/382669#M1093</guid>
      <dc:creator>igaydajiev</dc:creator>
      <dc:date>2014-06-09T11:55:47Z</dc:date>
    </item>
    <item>
      <title>Re: SQL Plugin 1.1.0 fail to load databases on startup</title>
      <link>https://communities.vmware.com/t5/VMware-Aria-Automation/SQL-Plugin-1-1-0-fail-to-load-databases-on-startup/m-p/382670#M1094</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hello,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;the database is present. only one table (content_field_vmhost) in that database got deleted months ago.&lt;/P&gt;&lt;P&gt;I restarted in the past the vCenter Orchestrator Service 5.5.0 (Windows, build in with vCenter Server) a lots of time before I upgraded to 5.5.1. With Version 5.5.0 was no Problem after restarting, only after the upgrade to 5.5.1 i run into the error.&lt;/P&gt;&lt;P&gt;Sems to be that the database Content is somewhere (outdated) cached.&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Mon, 09 Jun 2014 12:13:47 GMT</pubDate>
      <guid>https://communities.vmware.com/t5/VMware-Aria-Automation/SQL-Plugin-1-1-0-fail-to-load-databases-on-startup/m-p/382670#M1094</guid>
      <dc:creator>Kagome</dc:creator>
      <dc:date>2014-06-09T12:13:47Z</dc:date>
    </item>
    <item>
      <title>Re: SQL Plugin 1.1.0 fail to load databases on startup</title>
      <link>https://communities.vmware.com/t5/VMware-Aria-Automation/SQL-Plugin-1-1-0-fail-to-load-databases-on-startup/m-p/382671#M1095</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;&lt;SPAN style="font-size: 10pt;"&gt;We were able to reproduce similar behavior and will provide fix in the next plugin release.&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 10pt; line-height: 1.5em;"&gt;Here are the steps we have used to reproduce the issue with plugin version 1.1.0&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 10pt; line-height: 1.5em;"&gt;1. Run workflow "Add database"&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 10pt; line-height: 1.5em;"&gt;2. Remove table from SQL server &lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 10pt; line-height: 1.5em;"&gt;3. Restart vCO server and there is error while loading plugin configuration. Inventory also get corupted.&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 10pt; line-height: 1.5em;"&gt; &lt;BR /&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;To avoid this error :&lt;/P&gt;&lt;P&gt;1. You can run "Update a database"&amp;nbsp; workflow after the table has been deleted and prior to restart vCO server.&lt;/P&gt;&lt;P&gt;OR&lt;/P&gt;&lt;P&gt;2. You can run "Remove a table from a database"&amp;nbsp; workflow to remove table form plugin inventory. And after that delete it physically from the SQL server.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;In current state of your environment you can try to temporary create a table with the same name as deleted one.&lt;/P&gt;&lt;P&gt;Restart vCO server.&lt;/P&gt;&lt;P&gt;Rung "Remove a table from database"&lt;/P&gt;&lt;P&gt;Delete table from SQL server.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Hope it helps... &lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Mon, 09 Jun 2014 14:34:08 GMT</pubDate>
      <guid>https://communities.vmware.com/t5/VMware-Aria-Automation/SQL-Plugin-1-1-0-fail-to-load-databases-on-startup/m-p/382671#M1095</guid>
      <dc:creator>igaydajiev</dc:creator>
      <dc:date>2014-06-09T14:34:08Z</dc:date>
    </item>
    <item>
      <title>Re: SQL Plugin 1.1.0 fail to load databases on startup</title>
      <link>https://communities.vmware.com/t5/VMware-Aria-Automation/SQL-Plugin-1-1-0-fail-to-load-databases-on-startup/m-p/382672#M1096</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Is there any planned schedule when new SQL plugin might be released?&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 03 Dec 2014 12:32:24 GMT</pubDate>
      <guid>https://communities.vmware.com/t5/VMware-Aria-Automation/SQL-Plugin-1-1-0-fail-to-load-databases-on-startup/m-p/382672#M1096</guid>
      <dc:creator>thakala</dc:creator>
      <dc:date>2014-12-03T12:32:24Z</dc:date>
    </item>
    <item>
      <title>Re: SQL Plugin 1.1.0 fail to load databases on startup</title>
      <link>https://communities.vmware.com/t5/VMware-Aria-Automation/SQL-Plugin-1-1-0-fail-to-load-databases-on-startup/m-p/382673#M1097</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;&amp;gt;&amp;gt; &lt;SPAN style="color: #666666; font-family: proxima-nova, Arial, sans-serif; font-size: 14px;"&gt;Is there any planned schedule when new SQL plugin might be released?&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;+1&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Also would like to know this answer...&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Fri, 05 Dec 2014 18:19:01 GMT</pubDate>
      <guid>https://communities.vmware.com/t5/VMware-Aria-Automation/SQL-Plugin-1-1-0-fail-to-load-databases-on-startup/m-p/382673#M1097</guid>
      <dc:creator>SeanKohler</dc:creator>
      <dc:date>2014-12-05T18:19:01Z</dc:date>
    </item>
    <item>
      <title>Re: SQL Plugin 1.1.0 fail to load databases on startup</title>
      <link>https://communities.vmware.com/t5/VMware-Aria-Automation/SQL-Plugin-1-1-0-fail-to-load-databases-on-startup/m-p/382674#M1098</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;vCO 5.5.2 ships with SQL plugin 1.1.1&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Fri, 05 Dec 2014 21:55:07 GMT</pubDate>
      <guid>https://communities.vmware.com/t5/VMware-Aria-Automation/SQL-Plugin-1-1-0-fail-to-load-databases-on-startup/m-p/382674#M1098</guid>
      <dc:creator>igaydajiev</dc:creator>
      <dc:date>2014-12-05T21:55:07Z</dc:date>
    </item>
  </channel>
</rss>

