Funny! 🙂 but what did you do to have your pasta all a Norma (great!!!) poisoned? Did you propose oci to the chef? Thanks for info and I'm waiting for details by emai. But, why I did not experienced this with 6.x version? That was not the first time me or the customer ran OCI fm Italian localized pc... And last, do I have to expect this behaviour always? I'm going to setup another OCI 7.0.1 at another customer site. For the other issues I agree. Too mysterious for me, I told to customer to open a case. Thanks a lot! ... View more

Did it. Bye ... View more

Maybe here the cause...lost connection to MySQL... 2014-11-05 16:26:40,834 ERROR (http-443-49) [com.onaro.util.sessions] Session Cache - Failed to communicate with the server ( PhoneHomeSession) - unrecoverable error: Failed to get FilePath for action com.onaro.sanscreen.phonehome.PhoneHomeException: Failed to get FilePath for action at com.onaro.sanscreen.phonehome.sessions.PhoneHomeSessionImpl.getFilePath(PhoneHomeSessionImpl.java:359) at com.onaro.sanscreen.phonehome.sessions.PhoneHomeSessionImpl.getBackupGzFilePath(PhoneHomeSessionImpl.java:302) 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.jboss.aop.joinpoint.MethodInvocation.invokeTarget(MethodInvocation.java:122) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:111) at org.jboss.ejb3.EJBContainerInvocationWrapper.invokeNext(EJBContainerInvocationWrapper.java:69) at org.jboss.ejb3.interceptors.aop.InterceptorSequencer.invoke(InterceptorSequencer.java:73) at org.jboss.ejb3.interceptors.aop.InterceptorSequencer.aroundInvoke(InterceptorSequencer.java:59) at sun.reflect.GeneratedMethodAccessor376.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.jboss.aop.advice.PerJoinpointAdvice.invoke(PerJoinpointAdvice.java:174) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor.fillMethod(InvocationContextInterceptor.java:72) at org.jboss.aop.advice.org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor_z_fillMethod_527343967.invoke(InvocationContextInterceptor_z_fillMethod_527343967.java) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor.setup(InvocationContextInterceptor.java:88) at org.jboss.aop.advice.org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor_z_setup_527343967.invoke(InvocationContextInterceptor_z_setup_527343967.java) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.ejb3.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:62) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.ejb3.entity.TransactionScopedEntityManagerInterceptor.invoke(TransactionScopedEntityManagerInterceptor.java:56) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.ejb3.AllowedOperationsInterceptor.invoke(AllowedOperationsInterceptor.java:47) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.ejb3.tx.NullInterceptor.invoke(NullInterceptor.java:42) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.ejb3.stateless.StatelessInstanceInterceptor.invoke(StatelessInstanceInterceptor.java:68) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.aspects.tx.TxPolicy.invokeInOurTx(TxPolicy.java:79) at org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java:190) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationInterceptor.java:76) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.ejb3.tx.NullInterceptor.invoke(NullInterceptor.java:42) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.ejb3.security.Ejb3AuthenticationInterceptorv2.invoke(Ejb3AuthenticationInterceptorv2.java:186) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.ejb3.ENCPropagationInterceptor.invoke(ENCPropagationInterceptor.java:41) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.ejb3.BlockContainerShutdownInterceptor.invoke(BlockContainerShutdownInterceptor.java:67) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.aspects.currentinvocation.CurrentInvocationInterceptor.invoke(CurrentInvocationInterceptor.java:67) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.ejb3.stateless.StatelessContainer.dynamicInvoke(StatelessContainer.java:421) at org.jboss.ejb3.remoting.IsLocalInterceptor.invokeLocal(IsLocalInterceptor.java:85) at org.jboss.ejb3.remoting.IsLocalInterceptor.invoke(IsLocalInterceptor.java:72) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.aspects.remoting.PojiProxy.invoke(PojiProxy.java:62) at $Proxy728.invoke(Unknown Source) at org.jboss.ejb3.proxy.impl.handler.session.SessionProxyInvocationHandlerBase.invoke(SessionProxyInvocationHandlerBase.java:207) at org.jboss.ejb3.proxy.impl.handler.session.SessionProxyInvocationHandlerBase.invoke(SessionProxyInvocationHandlerBase.java:164) at $Proxy899.getBackupGzFilePath(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 com.onaro.util.sessions.SessionCache$ProxyInvocationHandler.invoke(SessionCache.java:228) at $Proxy900.getBackupGzFilePath(Unknown Source) at com.onaro.sanscreen.web.admin.actions.BackupAction.execute(BackupAction.java:47) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196) at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432) at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:235) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:190) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:525) at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:92) at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.process(SecurityContextEstablishmentValve.java:126) at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:70) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158) at org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java:402) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:829) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:598) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) at java.lang.Thread.run(Thread.java:662) Caused by: com.onaro.sanscreen.phonehome.PhoneHomeException: Failed launching 'stderr.error: null stderr.output: mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table `volume_member` at row: 3518   ... View more

Using Chrome (I know is not supported on 6.3) form external connection (not on localhost using RDP) I've noted this:   In download.war folder has been created a Backup_WSANSCREEN_V6-3-2_B141_725858092777279745.gz reporting 0 kB while in E:\SANscreen\SANscreen\backup\db a first Backup_WSANSCREEN_V6-3-2_B141_725858092777279745.sql growing...after some minuts the first .gz has been renamed with another id (the long number) and another .SQL appeared in ...\backup\db...growing together the first. Whet the 2 SQL files reached 1.2 GB I've noted that my Chrome connection was reset and nevertheles those two files still grow. Another couple of mins passes and those 2 files...disapperead while the 0 kB gz file in download.war is still there. Really disappointed 😕   Using IE 8 (supported) on the server does not work at all!   Using Firefox, from another PC, I've got the usual 0 kB file in .war and, this time, only one SQL growing. When it reached the end (roughly 2 GB) the Firefox client timed out and the 2 GB SQL file disappeared...   I think I will set up all DS from scratch...hoping to be able to have in DWH historical data...           ... View more

It will be the fourth time 🙂 Anyway...what's about the fact the the generated file is a SQL one (not a gz)?   Regards and...thanks as usual!   PS) this had to be an easy job! 😉 ... View more

Ok. This is a thing I've performed on and old backup, the file is readable inside, but the restore fails. But, the current backup I've generated is a SQL native file, not a gz!!! And it's only 12 MB respect the old that, compressed, is 80/90 MB!!! I've also tried to compress to gz and pass it to the restore: no way. Internal error the same.   Sorry for (silly?) question, but the backup I've generated using the web 6.3 console choosing to backup "Assure and perform" data. Is it correct?   This is the first part of the SQL file generated by the backup. It's fine and readable and it contains the instructions to recreate the ds and so on...   - MySQL dump 10.13 Distrib 5.1.63, for Win64 (unknown) -- -- Host: localhost Database: acquisition -- ------------------------------------------------------ -- Server version 5.1.63-community /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Current Database: `acquisition` -- CREATE DATABASE /*!32312 IF NOT EXISTS*/ `acquisition` /*!40100 DEFAULT CHARACTER SET utf8 */; USE `acquisition`; -- -- Table structure for table `acquisition_storage_identify` -- DROP TABLE IF EXISTS `acquisition_storage_identify`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `acquisition_storage_identify` ( `storageidentifier` varchar(255) NOT NULL, `storageip` varchar(255) NOT NULL, PRIMARY KEY (`storageidentifier`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `acquisition_storage_identify` -- LOCK TABLES `acquisition_storage_identify` WRITE; /*!40000 ALTER TABLE `acquisition_storage_identify` DISABLE KEYS */; set autocommit=0; INSERT INTO `acquisition_storage_identify` VALUES ('50:06:01:60:C6:E0:29:45','CKM00104600582'),('50:06:01:60:C6:E0:2A:45','CKM00104600587'); /*!40000 ALTER TABLE `acquisition_storage_identify` ENABLE KEYS */; UNLOCK TABLES; commit; -- -- Table structure for table `acquisition_volume_identify` -- DROP TABLE IF EXISTS `acquisition_volume_identify`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `acquisition_volume_identify` ( `storageidentifier` varchar(255) NOT NULL, `volumeidentifier` varchar(255) NOT NULL, `volumename` varchar(255) NOT NULL, PRIMARY KEY (`storageidentifier`,`volumeidentifier`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `acquisition_volume_identify` -- LOCK TABLES `acquisition_volume_identify` WRITE; /*!40000 ALTER TABLE `acquisition_volume_identify` DISABLE KEYS */; set autocommit=0; INSERT INTO `acquisition_volume_identify` VALUES ('50:06:01:60:C6:E0:29:45','60:06:01:60:46:B0:2A:00:16:63:8E:EF:18:40:E0:11','28'),('50:06:01:60:C6:E0:29:45','60:06:01:60:46:B0:2A:00:18:87:CC:A4:18:40:E0:11','24'),('50:06:01:60:C6:E0:29:45','60:06:01:60:46:B0:2A:00:2A:B4:4E:2D:76:F8:DF:11','5'),('50:06:01:60:C6:E0:29:45','60:06:01:60:46:B0:2A:00:32:30:81:C3:18:40:E0:11','201'),('50:06:01:60:C6:E0:29:45','60:06:01:60:46:B0:2A:00:3C:F0:D4:2D:18:40:E0:11','18'),('50:06:01:60:C6:E0:29:45','60:06:01:60:46:B0:2A:00:40:F3:6C:6A:19:40:E0:11','36'),('50:06:01:60:C6:E0:29:45','60:06:01:60:46:B0:2A:00:42:A5:8F:1F:76:F8:DF:11','3'),('50:06:01:60:C6:E0:29:45','60:06:01:60:46:B0:2A:00:46:05:19:19:76:F8:DF:11','2'),('50:06:01:60:C6:E0:29:45','60:06:01:60:46:B0:2A:00:48:2B:8E:26:76:F8:DF:11','4'),('50:06:01:60:C6:E0:29:45','60:06:01:60:46:B0:2A:00:58:32:20:B0:19:40:E0:11','202'),('50:06:01:60:C6:E0:29:45','60:06:01:60:46:B0:2A:00:58:72:6B:FC:19:40:E0:11','42'),('50:06:01:60:C6:E0:29:45','60:06:01:60:46:B0:2A:00:5E:23:8B:0C:76:F8:DF:11','0'),('50:06:01:60:C6:E0:29:45','60:06:01:60:46:B0:2A:00:5F:23:8B:0C:76:F8:DF:11','1'),('50:06:01:60:C6:E0:29:45','60:06:01:60:46:B0:2A:00:60:E7:C7:87:19:40:E0:11','38'),('50:06:01:60:C6:E0:29:45','60:06:01:60:46:B0:2A:00:8E:B3:05:8D:18:40:E0:11','22'),('50:06:01:60:C6:E0:29:45','60:06:01:60:46:B0:2A:00:9A:7F:B7:4E:18:40:E0:11','20'),('50:06:01:60:C6:E0:29:45','60:06:01:60:46:B0:2A:00:9C:CF:F5:02:76:F8:DF:11','200'),('50:06:01:60:C6:E0:29:45','60:06:01:60:46:B0:2A:00:BE:2B:F4:40:19:40:E0:11','32'),('50:06:01:60:C6:E0:29:45','60:06:01:60:46:B0:2A:00:D0:DC:F9:4F:19:40:E0:11','34'),('50:06:01:60:C6:E0:29:45','60:06:01:60:46:B0:2A:00:D6:AD:89:E3:7A:F8:DF:11','16'),('50:06:01:60:C6:E0:29:45','60:06:01:60:46:B0:2A:00:D8:4B:DE:03:19:40:E0:11','30'),('50:06:01:60:C6:E0:29:45','60:06:01:60:46:B0:2A:00:DA:37:AD:CD:19:40:E0:11','40'),('50:06:01:60:C6:E0:29:45','60:06:01:60:46:B0:2A:00:F0:99:3D:E4:18:40:E0:11','26'),('50:06:01:60:C6:E0:29:45','60:06:01:60:80:B0:2A:00:0A:75:54:91:19:40:E0:11','35'),('50:06:01:60:C6:E0:29:45','60:06:01:60:80:B0:2A:00:1C:6D:A2:57:19:40:E0:11','31'),('50:06:01:60:C6:E0:29:45','60:06:01:60:80:B0:2A:00:1C:C6:52:95:18:40:E0:11','23'),('50:06:01:60:C6:E0:29:45','60:06:01:60:80:B0:2A:00:2C:D6:6C:73:19:40:E0:11','33'),('50:06:01:60:C6:E0:29:45','60:06:01:60:80:B0:2A:00:3C:D9:B7:AC:18:40:E0:11','25'),('50:06:01:60:C6:E0:29:45','60:06:01:60:80:B0:2A:00:4E:0E:C2:04:1A:40:E0:11','39'),('50:06:01:60:C6:E0:29:45','60:06:01:60:80:B0:2A:00:A8:CC:30:2E:19:40:E0:11','29'),('50:06:01:60:C6:E0:29:45','60:06:01:60:80:B0:2A:00:BE:39:2C:60:18:40:E0:11','21'),('50:06:01:60:C6:E0:29:45','60:06:01:60:80:B0:2A:00:C0:23:C4:D1:18:40:E0:11','27'),('50:06:01:60:C6:E0:29:45','60:06:01:60:80:B0:2A:00:E8:87:88:36:18:40:E0:11','19'),('50:06:01:60:C6:E0:29:45','60:06:01:60:80:B0:2A:00:F2:40:1E:EB:7A:F8:DF:11','17'),('50:06:01:60:C6:E0:29:45','60:06:01:60:80:B0:2A:00:F8:D3:AC:E1:19:40:E0:11','37'),('50:06:01:60:C6:E0:2A:45','60:06:01:60:0E:A0:2A:00:16:82:0E:B2:EF:48:E0:11','33'),('50:06:01:60:C6:E0:2A:45','60:06:01:60:0E:A0:2A:00:18:7F:93:3D:EF:48:E0:11','29'),('50:06:01:60:C6:E0:2A:45','60:06:01:60:0E:A0:2A:00:4A:3F:90:B3:EE:48:E0:11','19'),('50:06:01:60:C6:E0:2A:45','60:06:01:60:0E:A0:2A:00:56:33:AD:63:EF:48:E0:11','31'),('50:06:01:60:C6:E0:2A:45','60:06:01:60:0E:A0:2A:00:7A:14:96:B4:37:F9:DF:11','17'),('50:06:01:60:C6:E0:2A:45','60:06:01:60:0E:A0:2A:00:A4:25:6A:CB:EE:48:E0:11','21'),('50:06:01:60:C6:E0:2A:45','60:06:01:60:0E:A0:2A:00:B8:48:20:E3:EE:48:E0:11','23'),('50:06:01:60:C6:E0:2A:45','60:06:01:60:0E:A0:2A:00:D8:88:B6:FB:EE:48:E0:11','25'),('50:06:01:60:C6:E0:2A:45','60:06:01:60:0E:A0:2A:00:F8:3E:FD:24:EF:48:E0:11','27'),('50:06:01:60:C6:E0:2A:45','60:06:01:60:2D:70:2A:00:00:23:52:F0:32:F9:DF:11','2'),('50:06:01:60:C6:E0:2A:45','60:06:01:60:2D:70:2A:00:02:5D:D9:CA:EF:48:E0:11','36'),('50:06:01:60:C6:E0:2A:45','60:06:01:60:2D:70:2A:00:2C:7D:52:DB:EE:48:E0:11','22'),('50:06:01:60:C6:E0:2A:45','60:06:01:60:2D:70:2A:00:32:9F:35:89:EF:48:E0:11','30'),('50:06:01:60:C6:E0:2A:45','60:06:01:60:2D:70:2A:00:38:A0:64:F6:32:F9:DF:11','3'),('50:06:01:60:C6:E0:2A:45','60:06:01:60:2D:70:2A:00:39:A0:64:F6:32:F9:DF:11','4'),('50:06:01:60:C6:E0:2A:45','60:06:01:60:2D:70:2A:00:42:4B:DA:AB:EE:48:E0:11','18'),('50:06:01:60:C6:E0:2A:45','60:06:01:60:2D:70:2A:00:6C:AD:02:92:EF:48:E0:11','32'),('50:06:01:60:C6:E0:2A:45','60:06:01:60:2D:70:2A:00:78:14:E7:35:EF:48:E0:11','28'),('50:06:01:60:C6:E0:2A:45','60:06:01:60:2D:70:2A:00:7C:EE:1B:02:33:F9:DF:11','5'),('50:06:01:60:C6:E0:2A:45','60:06:01:60:2D:70:2A:00:80:F7:FE:E4:32:F9:DF:11','0'),('50:06:01:60:C6:E0:2A:45','60:06:01:60:2D:70:2A:00:81:F7:FE:E4:32:F9:DF:11','1'),('50:06:01:60:C6:E0:2A:45','60:06:01:60:2D:70:2A:00:94:1D:25:AD:37:F9:DF:11','16'),('50:06:01:60:C6:E0:2A:45','60:06:01:60:2D:70:2A:00:9C:31:B4:C3:EE:48:E0:11','20'),('50:06:01:60:C6:E0:2A:45','60:06:01:60:2D:70:2A:00:A4:8C:B3:DB:32:F9:DF:11','200'),('50:06:01:60:C6:E0:2A:45','60:06:01:60:2D:70:2A:00:AC:4D:BE:50:EF:48:E0:11','202'),('50:06:01:60:C6:E0:2A:45','60:06:01:60:2D:70:2A:00:BE:D6:85:A2:EF:48:E0:11','34'),('50:06:01:60:C6:E0:2A:45','60:06:01:60:2D:70:2A:00:C4:9E:D9:1C:EF:48:E0:11','26'),('50:06:01:60:C6:E0:2A:45','60:06:01:60:2D:70:2A:00:CA:EF:F7:F2:EE:48:E0:11','24'),('50:06:01:60:C6:E0:2A:45','60:06:01:60:2D:70:2A:00:D6:63:7E:0A:EF:48:E0:11','201'); /*!40000 ALTER TABLE `acquisition_volume_identify` ENABLE KEYS */; UNLOCK TABLES; commit; -- -- Table structure for table `au` -- DROP TABLE IF EXISTS `au`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `au` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `ip` varchar(45) NOT NULL, `status` varchar(255) NOT NULL, `leaseperiod` bigint(20) unsigned NOT NULL DEFAULT '0', `nextleaserenewal` bigint(20) unsigned NOT NULL DEFAULT '0', `version` bigint(20) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`), KEY `name_index` (`name`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `au` -- LOCK TABLES `au` WRITE; /*!40000 ALTER TABLE `au` DISABLE KEYS */; set autocommit=0; INSERT INTO `au` VALUES (1,'local','1.5.4.86','ok',40000,1415184919469,4344905); /*!40000 ALTER TABLE `au` ENABLE KEYS */; UNLOCK TABLES; commit; -- -- Table structure for table `au_attrs` -- DROP TABLE IF EXISTS `au_attrs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `au_attrs` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `au_id` bigint(20) unsigned NOT NULL, `type` varchar(255) NOT NULL, `subtype` varchar(255) NOT NULL, `name` varchar(255) NOT NULL, `value` text NOT NULL, `version` bigint(20) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `business_key` (`au_id`,`type`,`subtype`,`name`), CONSTRAINT `FK_au_id_attrs` FOREIGN KEY (`au_id`) REFERENCES `au` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=159 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `au_attrs` -- LOCK TABLES `au_attrs` WRITE; /*!40000 ALTER TABLE `au_attrs` DISABLE KEYS */; set autocommit=0; INSERT INTO `au_attrs` VALUES (1,1,'env_variable','','ALLUSERSPROFILE','C:\\ProgramData',0),(2,1,'env_variable','','APPDATA','C:\\Windows\\system32\\config\\systemprofile\\AppData\\Roaming',0),(3,1,'env_variable','','CommonProgramFiles','C:\\Program Files\\Common Files',1),(4,1,'env_variable','','CommonProgramFiles(x86)','C:\\Program Files (x86)\\Common Files',0),(5,1,'env_variable','','CommonProgramW6432','C:\\Program Files\\Common Files',0),(6,1,'env_variable','','COMPUTERNAME','WSANSCREEN',0),(7,1,'env_variable','','ComSpec','C:\\Windows\\system32\\cmd.exe',0),(8,1,'env_variable','','FP_NO_HOST_CHECK','NO',0),(9,1,'env_variable','','JAVA_HOME','E:\\SANscreen\\SANscreen\\java64',1),(10,1,'env_variable','','LOCALAPPDATA','C:\\Windows\\system32\\config\\systemprofile\\AppData\\Local',0),(11,1,'env_variable','','NUMBER_OF_PROCESSORS','2',0),(12,1,'env_variable','','OS','Windows_NT',0),(13,1,'env_variable','','Path','C:\\Windows\\system32;C:\\Windows;C:\\Windows\\System32\\Wbem;C:\\Windows\\System32\\WindowsPowerShell\\v1.0\\;C:\\Program Files (x86)\\EMC\\Navisphere CLI;;E:/SANscreen/SANscreen/acq/bin',3),(14,1,'env_variable','','PATHEXT','.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC',0),(15,1,'env_variable','','PROCESSOR_ARCHITECTURE','AMD64',1),(16,1,'env_variable','','PROCESSOR_ARCHITEW6432','AMD64',0),(17,1,'env_variable','','PROCESSOR_IDENTIFIER','AMD64 Family 16 Model 2 Stepping 3, AuthenticAMD',0),(18,1,'env_variable','','PROCESSOR_LEVEL','16',0),(19,1,'env_variable','','PROCESSOR_REVISION','0203',0),(20,1,'env_variable','','ProgramData','C:\\ProgramData',0),(21,1,'env_variable','','ProgramFiles','C:\\Program Files',1),(22,1,'env_variable','','ProgramFiles(x86)','C:\\Program Files (x86)',0),(23,1,'env_variable','','ProgramW6432','C:\\Program Files',0),(24,1,'env_variable','','PSModulePath','C:\\Windows\\system32\\WindowsPowerShell\\v1.0\\Modules\\',0),(25,1,'env_variable','','PUBLIC','C:\\Users\\Public',0),(26,1,'env_variable','','SANSCREEN_HOME','E:\\SANscreen\\SANscreen\\',1),(27,1,'env_variable','','SYMCLI_CONNECT','SYMAPI_SERVER',0),(28,1,'env_variable','','SYMCLI_CONNECT_TYPE','REMOTE',0),(29,1,'env_variable','','SystemDrive','C:',0),(30,1,'env_variable','','SystemRoot','C:\\Windows',0),(31,1,'env_variable','','TEMP','C:\\Windows\\TEMP',0),(32,1,'env_variable','','TMP','C:\\Windows\\TEMP',0),(33,1,'env_variable','','USERDOMAIN','ICSRV',1),(34,1,'env_variable','','USERNAME','WSANSCREEN$',0),(35,1,'env_variable','','USERPROFILE','C:\\Windows\\system32\\config\\systemprofile',0),(36,1,'env_variable','','windir','C:\\Windows',0),(37,1,'jar','acquisition-conf.jar','size','33320',2),(38,1,'jar','acquisition-conf.jar','timestamp','Wed Sep 26 19:24:44 CEST 2012',2),(39,1,'jar','acquisition.jar','onaro-jar-build-time','Wed Sep 26 18:16:23 EDT 2012',2),(40,1,'jar','acquisition.jar','onaro-jar-interfaces-checksum','',0),(41,1,'jar','acquisition.jar','onaro-oschema-checksum','a90d7e9e56558933875a920cb737d09a',2),(42,1,'jar','acquisition.jar','onaro-oschema-version','6.3',2),(43,1,'jar','acquisition.jar','size','269944',2),(44,1,'jar','acquisition.jar','timestamp','Wed Sep 26 19:24:44 CEST 2012',2),(45,1,'jar','ext-algorithms.jar','size','5085',2),(46,1,'jar','ext-algorithms.jar','timestamp','Wed Sep 26 19:24:44 CEST 2012',2),(47,1,'jar','foundation.jar','onaro-oschema-checksum','be0dc7a623d1673cdf3301b0fbd0430b',0),(48,1,'jar','foundation.jar','onaro-oschema-version','6.0',0),(49,1,'jar','foundation.jar','onaro-version-customer','Onaro',0),(50,1,'jar','foundation.jar','onaro-version-time','Tue Nov 09 16:26:41 EST 2010',0),(51,1,'jar','foundation.jar','size','579489',0),(52,1,'jar','foundation.jar','timestamp','Tue Nov 09 16:36:58 CET 2010',0),(53,1,'jar','hostvirtualization.jar','onaro-oschema-checksum','be0dc7a623d1673cdf3301b0fbd0430b',0),(54,1,'jar','hostvirtualization.jar','onaro-oschema-version','6.0',0),(55,1,'jar','hostvirtualization.jar','onaro-version-customer','Onaro',0),(56,1,'jar','hostvirtualization.jar','onaro-version-time','Tue Nov 09 16:26:41 EST 2010',0),(57,1,'jar','hostvirtualization.jar','size','24471',0),(58,1,'jar','hostvirtualization.jar','timestamp','Tue Nov 09 16:37:00 CET 2010',0),(59,1,'jar','performance.jar','onaro-oschema-checksum','be0dc7a623d1673cdf3301b0fbd0430b',0),(60,1,'jar','performance.jar','onaro-oschema-version','6.0',0),(61,1,'jar','performance.jar','onaro-version-customer','Onaro',0),(62,1,'jar','performance.jar','onaro-version-time','Tue Nov 09 16:26:41 EST 2010',0),(63,1,'jar','performance.jar','size','24957',0),(64,1,'jar','performance.jar','timestamp','Tue Nov 09 16:37:00 CET 2010',0),(65,1,'jar','remotelogger.jar','size','14630',2),(66,1,'jar','remotelogger.jar','timestamp','Wed Sep 26 19:24:44 CEST 2012',2),(67,1,'jar','rpo.jar','onaro-oschema-checksum','be0dc7a623d1673cdf3301b0fbd0430b',0),(68,1,'jar','rpo.jar','onaro-oschema-version','6.0',0),(69,1,'jar','rpo.jar','onaro-version-customer','Onaro',0),(70,1,'jar','rpo.jar','onaro-version-time','Tue Nov 09 16:26:41 EST 2010',0),(71,1,'jar','rpo.jar','size','11938',0),(72,1,'jar','rpo.jar','timestamp','Tue Nov 09 16:36:58 CET 2010',0),(73,1,'jar','server_interfaces.jar','size','2100032',2),(74,1,'jar','server_interfaces.jar','timestamp','Wed Sep 26 19:24:44 CEST 2012',2),(75,1,'jar','storageperformance.jar','onaro-oschema-checksum','be0dc7a623d1673cdf3301b0fbd0430b',0),(76,1,'jar','storageperformance.jar','onaro-oschema-version','6.0',0),(77,1,'jar','storageperformance.jar','onaro-version-customer','Onaro',0),(78,1,'jar','storageperformance.jar','onaro-version-time','Tue Nov 09 16:26:41 EST 2010',0),(79,1,'jar','storageperformance.jar','size','33894',0),(80,1,'jar','storageperformance.jar','timestamp','Tue Nov 09 16:37:00 CET 2010',0),(81,1,'jvm_arg','','acq.home','E:/SANscreen/SANscreen/acq',1),(82,1,'jvm_arg','','awt.toolkit','sun.awt.windows.WToolkit',0),(83,1,'jvm_arg','','codebase','https://WSANSCREEN:443',0),(84,1,'jvm_arg','','com.onaro.rmiOverHttp','true',1),(85,1,'jvm_arg','','com.sun.management.jmxremote','true',0),(86,1,'jvm_arg','','com.sun.management.jmxremote.authenticate','false',0),(87,1,'jvm_arg','','com.sun.management.jmxremote.port','5679',0),(88,1,'jvm_arg','','com.sun.management.jmxremote.ssl','false',0),(89,1,'jvm_arg','','file.encoding','Cp1252',0),(90,1,'jvm_arg','','file.encoding.pkg','sun.io',0),(91,1,'jvm_arg','','file.separator','\\',0),(92,1,'jvm_arg','','java.awt.graphicsenv','sun.awt.Win32GraphicsEnvironment',0),(93,1,'jvm_arg','','java.awt.printerjob','sun.awt.windows.WPrinterJob',0),(94,1,'jvm_arg','','java.class.path','E:/SANscreen/SANscreen/acq/conf;E:/SANscreen/SANscreen/acq/acq_interfaces.jar;E:/SANscreen/SANscreen/acq/acquisition-conf.jar;E:/SANscreen/SANscreen/acq/acquisition.jar;E:/SANscreen/SANscreen/acq/com.onaro.commons.jar;E:/SANscreen/SANscreen/acq/ext-algorithms.jar;E:/SANscreen/SANscreen/acq/performance-engine-interfaces.jar;E:/SANscreen/SANscreen/acq/remotelogger.jar;E:/SANscreen/SANscreen/acq/server_interfaces.jar;E:/SANscreen/SANscreen/acq/lib/xml/xerces/xercesImpl.jar;E:/SANscreen/SANscreen/acq/lib/xml/xerces/xml-apis.jar;E:/SANscreen/SANscreen/acq/lib/xml/jdom/jaxen-core.jar;E:/SANscreen/SANscreen/acq/lib/xml/jdom/jaxen-jdom.jar;E:/SANscreen/SANscreen/acq/lib/xml/jdom/jdom.jar;E:/SANscreen/SANscreen/acq/lib/xml/jdom/saxpath.jar;E:/SANscreen/SANscreen/acq/lib/jboss/client/ejb3-persistence.jar;E:/SANscreen/SANscreen/acq/lib/jboss/client/jbossall-client.jar;E:/SANscreen/SANscreen/acq/lib/jboss/client/hibernate-core.jar;E:/SANscreen/SANscreen/acq/lib/xml-3rd/saxon.jar;E:/SANscreen/SANscreen/acq/lib/snmp/AdventNetLogging.jar;E:/SANscreen/SANscreen/acq/lib/snmp/AdventNetSnmp.jar;E:/SANscreen/SANscreen/acq/lib/log4j/log4j-1.2.14.jar',2),(95,1,'jvm_arg','','java.class.version','50.0',0),(96,1,'jvm_arg','','java.endorsed.dirs','E:\\SANscreen\\SANscreen\\java64\\lib\\endorsed',1),(97,1,'jvm_arg','','java.ext.dirs','E:\\SANscreen\\SANscreen\\java64\\lib\\ext;C:\\Windows\\Sun\\Java\\lib\\ext',1),(98,1,'jvm_arg','','java.home','E:\\SANscreen\\SANscreen\\java64',1),(99,1,'jvm_arg','','java.io.tmpdir','C:\\Windows\\TEMP\\',0),(100,1,'jvm_arg','','java.library.path','E:/SANscreen/SANscreen/acq/bin',1),(101,1,'jvm_arg','','java.naming.factory.initial','org.jboss.naming.HttpNamingContextFactory',1),(102,1,'jvm_arg','','java.naming.provider.url','https://WSANSCREEN:443/invoker/JNDIFactorySSL',1),(103,1,'jvm_arg','','java.rmi.server.randomIDs','true',0),(104,1,'jvm_arg','','java.runtime.name','Java(TM) SE Runtime Environment',0),(105,1,'jvm_arg','','java.runtime.version','1.6.0_33-b05',2),(106,1,'jvm_arg','','java.security.properties','E:/SANscreen/SANscreen/acq/conf/java.security',1),(107,1,'jvm_arg','','java.specification.name','Java Platform API Specification',0),(108,1,'jvm_arg','','java.specification.vendor','Sun Microsystems Inc.',0),(109,1,'jvm_arg','','java.specification.version','1.6',0),(110,1,'jvm_arg','','java.vendor','Sun Microsystems Inc.',0),(111,1,'jvm_arg','','java.vendor.url','http://java.sun.com/',0),(112,1,'jvm_arg','','java.vendor.url.bug','http://java.sun.com/cgi-bin/bugreport.cgi',0),(113,1,'jvm_arg','','java.version','1.6.0_33',2),(114,1,'jvm_arg','','java.vm.info','mixed mode',0),(115,1,'jvm_arg','','java.vm.name','Java HotSpot(TM) 64-Bit Server VM',1),(116,1,'jvm_arg','','java.vm.specification.name','Java Virtual Machine Specification',0),(117,1,'jvm_arg','','java.vm.specification.vendor','Sun Microsystems Inc.',0),(118,1,'jvm_arg','','java.vm.specification.version','1.0',0),(119,1,'jvm_arg','','java.vm.vendor','Sun Microsystems Inc.',0),(120,1,'jvm_arg','','java.vm.version','20.8-b03',2),(121,1,'jvm_arg','','javax.net.ssl.trustStore','E:/SANscreen/SANscreen/acq/conf/cert/client.keystore',1),(122,1,'jvm_arg','','javax.xml.transform.TransformerFactory','com.icl.saxon.TransformerFactoryImpl',0),(123,1,'jvm_arg','','jboss.remoting.version','22',0),(124,1,'jvm_arg','','line.separator','\r\n',0),(125,1,'jvm_arg','','log4j.configuration','production.xml',0),(126,1,'jvm_arg','','no.trap','false',0),(127,1,'jvm_arg','','onaro.home','E:/SANscreen/SANscreen',1),(128,1,'jvm_arg','','os.arch','amd64',1),(129,1,'jvm_arg','','os.name','Windows Server 2008 R2',1),(130,1,'jvm_arg','','os.version','6.1',0),(131,1,'jvm_arg','','path.separator',';',0),(132,1,'jvm_arg','','sun.arch.data.model','64',1),(133,1,'jvm_arg','','sun.boot.class.path','E:\\SANscreen\\SANscreen\\java64\\lib\\resources.jar;E:\\SANscreen\\SANscreen\\java64\\lib\\rt.jar;E:\\SANscreen\\SANscreen\\java64\\lib\\sunrsasign.jar;E:\\SANscreen\\SANscreen\\java64\\lib\\jsse.jar;E:\\SANscreen\\SANscreen\\java64\\lib\\jce.jar;E:\\SANscreen\\SANscreen\\java64\\lib\\charsets.jar;E:\\SANscreen\\SANscreen\\java64\\lib\\modules\\jdk.boot.jar;E:\\SANscreen\\SANscreen\\java64\\classes',1),(134,1,'jvm_arg','','sun.boot.library.path','E:\\SANscreen\\SANscreen\\java64\\bin',1),(135,1,'jvm_arg','','sun.cpu.endian','little',0),(136,1,'jvm_arg','','sun.cpu.isalist','amd64',1),(137,1,'jvm_arg','','sun.desktop','windows',0),(138,1,'jvm_arg','','sun.io.unicode.encoding','UnicodeLittle',0),(139,1,'jvm_arg','','sun.jnu.encoding','Cp1252',0),(140,1,'jvm_arg','','sun.management.compiler','HotSpot 64-Bit Tiered Compilers',1),(141,1,'jvm_arg','','sun.os.patch.level','Service Pack 1',1),(142,1,'jvm_arg','','user.country','IT',0),(143,1,'jvm_arg','','user.dir','E:\\SANscreen\\SANscreen\\bin',1),(144,1,'jvm_arg','','user.home','C:\\',0),(145,1,'jvm_arg','','user.language','it',0),(146,1,'jvm_arg','','user.name','WSANSCREEN$',0),(147,1,'jvm_arg','','user.timezone','Europe/Berlin',0),(148,1,'jvm_arg','','user.variant','',0),(149,1,'jar','acq_interfaces.jar','timestamp','Wed Sep 26 19:24:44 CEST 2012',1),(150,1,'jar','acq_interfaces.jar','size','38152',0),(151,1,'jvm_arg','','javax.xml.parsers.SAXParserFactory','org.apache.xerces.jaxp.SAXParserFactoryImpl',0),(152,1,'jvm_arg','','java.protocol.handler.pkgs','org.apache.axis.transport|',0),(153,1,'jar','com.onaro.commons.jar','size','236279',0),(154,1,'jar','performance-engine-interfaces.jar','size','4723',0),(155,1,'jvm_arg','','com.onaro.http.invoker','https://WSANSCREEN:443/invoker/JMXInvokerServlet',0),(156,1,'jvm_arg','','java.naming.factory.url.pkgs','org.jboss.naming:org.jnp.interfaces',0),(157,1,'jar','com.onaro.commons.jar','timestamp','Wed Sep 26 19:24:44 CEST 2012',0),(158,1,'jar','performance-engine-interfaces.jar','timestamp','Wed Sep 26 19:24:44 CEST 2012',0); /*!40000 ALTER TABLE `au_attrs` ENABLE KEYS */; UNLOCK TABLES; commit; -- -- Table structure for table `au_audit` -- DROP TABLE IF EXISTS `au_audit`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `au_audit` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `time` bigint(20) NOT NULL DEFAULT '0', `au_id` bigint(20) unsigned NOT NULL, `status` text, `version` bigint(20) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `au_id` (`au_id`,`time`), CONSTRAINT `FK_au_id_audit` FOREIGN KEY (`au_id`) REFERENCES `au` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `au_audit` -- LOCK TABLES `au_audit` WRITE; /*!40000 ALTER TABLE `au_audit` DISABLE KEYS */; set autocommit=0; INSERT INTO `au_audit` VALUES (1,1325069482828,1,'Could not load implementation class com.onaro.sanscreen.acquisition.datasource.netapp_api.config.NetAppConfiguration for data source NetAppMO',0),(2,1325069482859,1,'Could not load implementation class com.onaro.sanscreen.acquisition.datasource.netapp_api.config.NetAppConfiguration for data source NetAppICS',0),(3,1325069483438,1,'Could not load implementation class com.onaro.sanscreen.acquisition.datasource.netapp_api.config.NetAppConfiguration for data source NetAppMI',0),(4,1325069483500,1,'Could not load implementation class com.onaro.sanscreen.acquisition.datasource.netapp_api.config.NetAppConfiguration for data source NetappBI',0),(5,1325069483563,1,'Could not load implementation class com.onaro.sanscreen.acquisition.datasource.netapp_api.config.NetAppConfiguration for data source NetAppPD',0),(6,1325069483578,1,'Could not load implementation class com.onaro.sanscreen.acquisition.datasource.netapp_api.config.NetAppConfiguration for data source NetAppAV',0),(7,1325069483703,1,'Could not load implementation class com.onaro.sanscreen.acquisition.datasource.netapp_api.config.NetAppConfiguration for data source NetAppLI',0),(8,1338765072927,1,'Failed to listen to acquisition events!',0); /*!40000 ALTER TABLE `au_audit` ENABLE KEYS */; UNLOCK TABLES; commit; -- -- Table structure for table `ds` -- DROP TABLE IF EXISTS `ds`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ds` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `ds_type_id` bigint(20) unsigned NOT NULL, `au_id` bigint(20) unsigned NOT NULL, `name` varchar(255) NOT NULL, `vendor` varchar(255) NOT NULL, `model` varchar(255) NOT NULL, `status` varchar(255) NOT NULL DEFAULT 'Stopped', `statusext` varchar(255) NOT NULL DEFAULT '', `time` bigint(20) unsigned NOT NULL DEFAULT '0', `manual` int(11) DEFAULT NULL, `active` tinyint(1) DEFAULT NULL, `version` bigint(20) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`), KEY `FK_au_id_ds` (`au_id`), CONSTRAINT `FK_au_id_ds` FOREIGN KEY (`au_id`) REFERENCES `au` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ds` -- LOCK TABLES `ds` WRITE; /*!40000 ALTER TABLE `ds` DISABLE KEYS */; set autocommit=0; INSERT INTO `ds` VALUES (1,57,1,'Gianopd0','Cisco','All models using SNMP','Inventory stand-by, Perform: FC Switch stand-by','',0,1,1,0),(2,57,1,'Gianopd1','Cisco','All models using SNMP','Inventory stand-by, Perform: FC Switch stand-by','',0,1,1,0),(3,70,1,'VirtualCenter_PADOVA','VMware','VMware','Inventory: VM success, Perform: VM success','',0,1,1,0),(4,62,1,'NetAppPD','NetApp','NetApp filers using ONTAPI','Inventory stand-by, Perform: Storage stand-by','',0,1,1,0),(7,70,1,'VirtualCenter_MILANO','VMware','VMware','Inventory: VM success, Perform: VM not running','',0,1,1,0),(8,57,1,'Gianomi0','Cisco','All models using SNMP','Inventory success, Perform: FC Switch success','',0,1,1,0),(11,62,1,'NetAppMI','NetApp','NetApp filers using ONTAPI','Inventory stand-by, Perform: Storage stand-by','',0,1,1,0),(12,62,1,'NetappBI','NetApp','NetApp filers using ONTAPI','Inventory stand-by, Perform: Storage not running','',0,1,1,0),(13,62,1,'NetAppMO','NetApp','NetApp filers using ONTAPI','Inventory stand-by, Perform: Storage not running','',0,1,1,0),(14,62,1,'NetAppICS','NetApp','NetApp filers using ONTAPI','','',0,2,0,0),(16,80,1,'ns480pd1','EMC','EMC Celerra SSH','Inventory stand-by','',0,1,1,0),(17,80,1,'ns480mi1','EMC','EMC Celerra SSH','Inventory stand-by','',0,1,1,0),(18,62,1,'NetAppAV','NetApp','NetApp filers using ONTAPI','Inventory success, Perform: Storage not running','',0,1,1,0),(19,62,1,'NetAppLI','NetApp','NetApp filers using ONTAPI','Inventory stand-by, Perform: Storage not running','',0,1,1,0),(20,43,1,'clariion_PD','EMC','Clariion CLI','Inventory success, Perform: Storage failed','',0,1,1,0),(21,43,1,'clariion_MI','EMC','Clariion CLI','Inventory success, Perform: Storage success','',0,1,1,0),(22,62,1,'NetappCB','NetApp','NetApp filers using ONTAPI','Inventory success, Perform: Storage not running','',0,1,1,0),(23,62,1,'NetappICRM','NetApp','NetApp filers using ONTAPI','Inventory success, Perform: Storage not running','',0,1,1,0),(24,62,1,'NetappPR','NetApp','NetApp filers using ONTAPI','Inventory success, Perform: Storage not running','',0,1,1,0),(25,62,1,'NetappTO','NetApp','NetApp filers using ONTAPI','Inventory stand-by, Perform: Storage not running','',0,1,1,0),(26,62,1,'NetappUD','NetApp','NetApp filers using ONTAPI','Inventory success, Perform: Storage not running','',0,1,1,0),(27,62,1,'NetappVA','NetApp','NetApp filers using ONTAPI','Inventory stand-by, Perform: Storage not running','',0,1,1,0),(28,62,1,'NetappTest','NetApp','NetApp filers using ONTAPI','Inventory success, Perform: Storage not running','',0,1,1,0),(29,62,1,'NetappDarsVDI','NetApp','NetApp filers using ONTAPI','Inventory success, Perform: Storage not running','',0,1,1,0),(30,62,1,'NetAppAR','NetApp','NetApp filers using ONTAPI','Inventory success, Perform: Storage not running','',0,1,1,0),(31,70,1,'VirtualCenter_VDI_PD','VMware','VMware','Inventory: VM stand-by, Perform: VM failed','',0,1,1,0),(32,62,1,'NetAppPD2','NetApp','NetApp filers using ONTAPI','Inventory stand-by, Perform: Storage stand-by','',0,1,1,0),(33,62,1,'NetAppPN','NetApp','NetApp filers using ONTAPI','Inventory acquiring, Perform: Storage not running','',0,1,1,0),(34,62,1,'NetAppPV','NetApp','NetApp filers using ONTAPI','Inventory success, Perform: Storage not running','',0,1,1,0),(35,62,1,'NetAppFI','NetApp','NetApp filers using ONTAPI','Inventory stand-by, Perform: Storage not running','',0,1,1,0),(36,62,1,'NetAppPDFMC','NetApp','NetApp filers using ONTAPI','Inventory stand-by, Perform: Storage stand-by','',0,1,1,0),(37,73,1,'EMC_VMAX','EMC','Solutions Enabler (CLI) with SMI-S Performance','Inventory stand-by, Perform: Storage stand-by','',0,1,1,0),(38,73,1,'EMC_DMX4_MI','EMC','Solutions Enabler (CLI) with SMI-S Performance','Inventory acquiring, Perform: Storage failed','',0,1,1,0); /*!40000 ALTER TABLE `ds` ENABLE KEYS */; UNLOCK TABLES; commit; -- -- Table structure for table `ds_attrs` -- DROP TABLE IF EXISTS `ds_attrs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ds_attrs` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `ds_id` bigint(20) unsigned NOT NULL, `name` varchar(255) NOT NULL, `value` varchar(10240) NOT NULL, `version` bigint(20) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `ds_id` (`ds_id`,`name`), CONSTRAINT `FK_ds_id_attr` FOREIGN KEY (`ds_id`) REFERENCES `ds` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=648 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ds_attrs`       ... View more

We've performed two times the backup. I've also tried a very old (and big) same error. Those messages "restore already in progress" I think were logged while I've attempted this old backup. Anyway the scope is to restore the last one.   Regards,   ... View more

Thank you very much for prompt answer Matt.  I suspected it. Well, considering that an upgrade to 7.0.1 has been planeed it will be better to directly pass to this new version instead to patch the current one. About Solution Enabler I did not discover of its presence so in the matrix I limited to look for the model of VMAX that customer reported me. I will have more details in few days planning for the upgrade.   Regards     ... View more

Hi Matt, in the operational client, out of the box, we only store 7 days of performance data. So, if you customize the time slice to show > 7 days of data, there is probably not any data to display. There are some ways to increase the amount of performance the OCI operational server stores.           Ok. But this also means that if the customer wants to display more than a week, the last one, this isn't possible. I can understand that having more than 7 days of perf data           can be a non sense but the other question I guess customer will ask me will be: "using DWH should it be possible to report more than 7 days?" The "Volume Performance Distribution" microview displays hourly summarization data, not the raw performance samples, which are typically more granular. This is why this view displays hourly data. Additionally, this view I believe it limited to a max of 40 objects.          Ok. This is also by design. But I would be prepared for same kind of question fm customer like this. "Using DWH can I have this granularity?". After all which is the sense to           poll every 5 minutes if I will an hourly  mean? This is very important for the customer being a provider that wants to know exactly what and where happens something during the live of a VM i.e.           If I well got you there's no chance to customize the 40 objs or the time granularity. It is not clear to me why the "Volume Performance Chart" is not rendering - OCI does have some requirements for the minimum number of perf samples per hour - if performance collection is unreliable, the charts may not render.                     I remember that this happens only for arrays fm HDS got by HiCommand (the most used by this customer and so the most important to him). Not only the Volume Perf           Chart does not display but also the Storage Perf Chart and so on (there are two pics for two different arrays). And this happens nevertheless the data are somewhere in the db! And, again, what if the customer will ask  "Can I have these data using DWH?" I'm waiting for other answers regarding the strange behaviour of the DWH. Thank you very much. Regards, ... View more