Kagome's Posts

In the VRO Release Notes is everytime written, that feedback is appreciated in the forum so ... Well this should be a "first impression" after now two weeks of usage. I "updated" a 5.5.3 Windows vCenter Orchestrator to vRealize Orchestrator 7.1 Appliance. A few information that I asked before the "update": https://communities.vmware.com/thread/542417 Here we go: 1) (Dislike) upgrade documentation & migration tool There is no real upgrade path document which describes how to upgrade or migrate to the new plattform in detail. Somewhere i read about a configuration-migration "tool" which is included in the OVA. So if you want to reuse the old Hostname and IP you have to deploy the OVA with an other IP one time to "download" this migration-tool. Why is there no direct download of the .zip on the vmware website? 2) (Bug?) First fails: I read somewhere that vRO 7.1 is out - but on our Download Page under "My Products" was only 7.0.1. After a SR I got a tip from an VMware employe and found the 7.1 OVA files. If you deploy a fresh 7.1 OVA - the Update Page (Port 5480) displays an error (HTTP 404) when checking for updates. Proxy and Networksettings should be correct ... If you deploy a fresh 7.0.1 and update via update page to 7.1 - the updatecheck it is still working after the update. 3) (Dislike) Import of migration-tool-export After running the migration-Tool, exporting all Workflows, ressources and so on - the import for the certificate (Company CA signed) and passwordencryptor.key on the new Orchestrator OVA fucked it totally up. Pages were not loading correctly, everywhere are red errors on the page and so on. Even after reconfiguration of the database and so on - there were zillion of errors in the log of the Orchestrator. That was not a good starting ... So I skipped that step, rolled back the snapshot, deleted the database and started again - this time with a new CA-signed certificate. 4) (Dislike) documentation for implementing CA signed certificates There is no documentation for "how to implement Company CA signed certificates for vRO 7.x" If you don't work 24/7 with certificates and so on .. some instructions for "dummies" would be fantastic. How to create the certificate files, sign them agains a Windows CA, implement them to the OVA ... I merged something from vCenter 5.5 Certificate replacement and  other sources ... Also why is there no collaboration with the Plattform Service Controller? Our Plattform Service Controller is included as sub-CA. 5) (Big Like) Control Center After implementing the new certificate and the basic seems to be working (before importing my workflows and so on) ... WOW! The new control center is simple and clean. Easy to understand - i like it very much. The "Runtime Metrics" are very nice, "Validate Configuration" is a good point to see if everything is working And hell "Live Log Stream" - fantastic thing... 'view fullscreen' is even better - realy good job. Also the logging integration is very good - you can now define for every plugin the log level - very nice, too. 5.2) (Missing) "Startup Options" Configuration - Roll Back You can see on the Startup Options" that i have an "Active configuration Fingerprint" and a "Pending Configuration Fingerprint" - where is the option to rollback to any older configuration? 5.1) (Dislike) New Database: The Orchestrator detects on the database setting that it is "empty" and ask for creation of the tables or so ... WHY do i have to run "install all plugins again" to get all workflows? Why can't do the OVA this automatically if the database was empty? 6) (Missing) Find Elements that use this Attribute-Type: SecureString So after importing all my Workflows, ressources and so on it starts the never ending story: Passwords and their encryption. I have a few workflows that have as Attribute a password as Secure String. So I have to edit all workflows with a SecureString, enter the password again and save it. Could you please include a finder for workflows that have a attribute with type SecurePassword? Also searching for AD:Object / SQL:Database and other types would be fine. 6.1) (Bug?) SQL Plugin 1.1.4 imported ressource To avoid editing a lot of workflows i do the following: I generate a test-database connection with the workflow "SQl -> Configuration -> Add a database". After that is a new ressource generated with the encrypted password. I copy that password-hash and edit the ressource-file for the real-database connection. After that i import the ressource. All Workflows with that database connection are working again - so basicly no problem. That is only a "cosmetic bug": But If i try to run the workflow "SQl -> Configuration -> Update a database" it fails if i choose an imported Database-resource. [2016-09-22 21:33:20.400] [E] Workflow execution stack: *** item: 'Update a database/item2', state: 'failed', business state: 'null', exception: 'java.lang.NullPointerException (Dynamic Script Module name : updateDatabase#17)' workflow: 'Update a database' (18541090831854109083178946495518541090830303030303030303030303030) |  'attribute': name=errorCode type=string value=java.lang.NullPointerException (Dynamic Script Module name : updateDatabase#17) |  'input': name=database type=SQL:Database value=dunes://service.dunes.ch/CustomSDKObject?id='c643c1fc-f459-4396-b7d3-c450976c9790'&dunesName='SQL:Database' |  'input': name=name type=string value=db_server |  'input': name=type type=string value=MySQL |  'input': name=connectionURL type=string value=jdbc:mysql://my.sexy.mysql.server:3306/databaseName |  'input': name=username type=string value=mySexyMySQLUser |  'input': name=password type=SecureString value=__NULL__ |  'input': name=sessionMode type=string value=Shared Session |  'output': name=result type=SQL:Database value=null *** End of execution stack. 7) (Bug) Orchestrator Client -> "Scheduler" Well that is an old Bug. If you have e.g. 10 scheduled Workflows in that list you can do at the bottom of the list in the free area a right-click and "delete all finished workflows". If you have so many scheduled workflows that you get a scroll-bar at the side - there is no free area where you get in the context menu "delete all finished workflows". Sometimes I have the feeling that I'm 1 of million people that uses the orchestrator so excessive for daily business jobs... (Dislike) Orchestrator Client - Presentation -> Select value as In the new Orchestrator Client the "Select value as" has changed a litte bit. On some of the first workflows i thought "nice - I like it" If you search for VirtualMachine "VM123" it was a good designed solution - until I came to my VM-Deploy Workflow. Based on some Values (which vCenter, Datacenter, Cluster...) i filtered e.g. the Datastores. If I plan to deploy a VM to Cluster B - I don't need to see the datastores of cluster A. Now, when i select the datastore i got a small list with datastores that can be accessed by this cluster. In the past I was able to sort that Datastores by capacity, free Space, name or whatever - now I see only the Datastorenames and "somewhere" some information. 9) (Bug) vSpehere Webclient - Plugin Registration fails In the vSpehere Webclient 5.5 was an extra Page to configure the Orchestrator for the Webclient (context menue, ...). In the vSphere Webclient 6.0U2 that page says everytime how i can get started with the Orchestrator. In the vCenter MOB - there is no com.vmware.vco registered. So I started the Workflow: vCenter -> Configuration -> Register vCenter Orchestrator as vCenter Server extension. That workflow is running without any problems and tells me that everything is good. Somewhere I read that I have to restart the Webclient after plugin registration - but even that didn't helped. And still there is no com.vmware.vco or similiar in the vCenter MOB. Even if that posting sounds very negative - in generally i love the new Orchestrator. It is a rock-solide workflow engine - easy to start with it and use it.

Hello, I'm looking for a way to get the "Select value as" for an own object. (or any other solution) e.g. If we deploy VM's we have to add in a database a "customer" who is using the VM. To add the entry to a database and so on is no problem - but i want it "nice" to select the customer in the orchestrator client. So i can query a database, get all Customers (Name, Street, City, State, whatever) and put it in an array of Customer-Object. In the Presentation i would like to have it like if i use a Array of VC:VirtualMachine Object and define the input-paramater as "Select value as" - so i can sort the objects by Name, can search and so on ....

Hello, i trie to get the Energy-Information from  an single ESXi Host via the PerformanceManager. (see attached picture) I used Onyx Proxy to get the Informations which classes are used there. I used as basic this example: https://communities.vmware.com/thread/419294 and modified a little bit to a single query. This is my code of a Scriptable Task (Input to this Scriptable Task is a single Host (VC:HostSystem) named: host) : var currentTime = System.getCurrentTime(); // reduce 15 Minutes var startTime = currentTime - (900 * 1000); var myEndDate = new Date(); myEndDate.setTime(currentTime); var myStartDate = new Date(); myStartDate.setTime(startTime); // https://communities.vmware.com/thread/419294 var myQuery = new Array(); myQuery[0] = new VcPerfQuerySpec(); myQuery[0].startTime = myStartDate; myQuery[0].endTime = myEndDate; myQuery[0].format = VcPerfFormat.normal; myQuery[0].entity = host.reference; myQuery[0].intervalId = 20; myQuery[0].metricId = host.sdkConnection.perfManager.queryAvailablePerfMetric(host.reference,null,null,20); /* Return Type: VcPerfEntityMetricBase[] -> Base type for the various VcPerfEntityMetric encodings. */ var result = host.sdkConnection.perfManager.queryPerf(myQuery); for(var i in result) {        var perfMetricSeries = result[i].value; //VcPerfMetricSeries[]     var perfSampleInfo = result[i].sampleInfo; //VcPerfSampleInfo[]     for(var j in perfSampleInfo)     {         //System.log(j+"->"+perfSampleInfo[j].timestamp);     }     var y = 0;     for(var k in perfMetricSeries)     {         if(host.sdkConnection.perfManager.perfCounter[perfMetricSeries[k].id.counterId] != null)         {             var labelInfo = host.sdkConnection.perfManager.perfCounter[perfMetricSeries[k].id.counterId].nameInfo.label             var groupInfo = host.sdkConnection.perfManager.perfCounter[perfMetricSeries[k].id.counterId].groupInfo.label;             var unitInfo = host.sdkConnection.perfManager.perfCounter[perfMetricSeries[k].id.counterId].unitInfo.label;                        if(unitInfo == "Joule")             {                 // this was a try to find which Group / Label has "Joule" as unit                 //System.log("Group: "+groupInfo+ " - "+ labelInfo);             }             if(groupInfo == "Power")             {                 // this wa a test to see what is in the group "Power"                 // System.log("Label: " +labelInfo +" - "+ unitInfo);             }             if(perfMetricSeries[k].id.counterId == 314)             {                 // CounterID 314 was displayed in Onyx Proxy                 System.log("314!!!! Group: "+groupInfo+ " - "+ labelInfo +" - "+ unitInfo);             }                        if(groupInfo == "Power" && labelInfo == "Host Power Capacity Provisioned" && unitInfo =="Percent")             {                 System.log("Power -> Host Power Capacity Provisioned -> Percent")                 var m = 0;                 for(var z in perfMetricSeries[k].value)                 {                     if(perfMetricSeries[k].value[z] != 0 && perfMetricSeries[k].value[z]!= "0")                     {                         System.log(m+"->"+perfMetricSeries[k].value[z]);                         m++;                     }                 }                            }             if(groupInfo == "Power" && labelInfo == "Energy usage" && unitInfo =="Joule")             {                 System.log("Power -> Energy usage -> Joule")                 // System.log(y + "-> Power");                 y++;                 var m = 0;                 for(var z in perfMetricSeries[k].value)                 {                     if(perfMetricSeries[k].value[z] != 0 && perfMetricSeries[k].value[z]!= "0")                     {                         System.log(m+"->"+perfMetricSeries[k].value[z]);                         m++;                         // System.log(perfSampleInfo[k].timestamp[z]);                     }                 }                            }             if(groupInfo == "System" && labelInfo == "Resource memory zero" && unitInfo =="KB")             {                 System.log("System - Resource memory zero - KB")                                var m = 0;                 for(var z in perfMetricSeries[k].value)                 {                     if(perfMetricSeries[k].value[z] != 0 && perfMetricSeries[k].value[z]!= "0")                     {                         System.log(m +"->"+perfMetricSeries[k].value[z]);                         m++;                     }                 }                            }                    }                    } } After now hours of testing I have a few Questions: If you have a value of the Type VCPerfCounterInfo.unitInfo "Percent" (https://www.vmware.com/support/orchestrator/doc/vco_vsphere55_api/html/VcPerfCounterInfo.html#key )  why is that somewhere around 10 000 000 ? In my case the "Host Power Capacity Provisioned" was between 9 700 000 and 9 900 000. groupInfo == "Power" && labelInfo == "Energy usage" && unitInfo =="Joule" This was my first try because i exspected that the informations i'm looking for are storred here - but it is a static value about 1975. I think it is the power of the two 1000 watt PowerSupplys of the host. Correct? groupInfo == "System" && labelInfo == "Resource memory zero" && unitInfo =="KB" Well, Onyx displayed correct that this are the values I were looking in the vCenter chart - what has "Resource memory zero" to do with the energy that the host is using? Are that real datas or only calculated?

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.