Subscribe

OCI Upgrade to 7.0.1-db restore fails with "Internal error"

[ Edited ]

Following the procedure I've performed a backup of database of 6.3 version.

After the successuful setup of 7.0.1 the restore operation fails with "Internal error" reported on the web page.

Looking for logs I've discovered some file (don't remember now the name) in E:\SANscreen\jboss\server\onaro\log that states something like this:

 

"failed to restore Cassandra and MYSQL...upgrade failed...cannot find an SQL file in E:\SANScreen\.....\backup7"...

 

I don't understand the reason.

 

Thanks,

 

HERE'S THE LOG. There's also another issue. Cannot login with admin using localhost!!!

 

2014-11-05 14:44:26,134 INFO [http-443-55] RestoreService (null:-1) - ----------------------------------- Restore Started -----------------------------------
2014-11-05 14:44:26,150 INFO [http-443-55] RestoreService (null:-1) - Restore Backup_WSANSCREEN_V6-3-2_B141_5919119548788890804.sql
2014-11-05 14:44:31,547 ERROR [http-443-55] RestoreService (null:-1) - Failed to upgrade: com.onaro.sanscreen.upgrade.UpgraderException: Failed to restore Cassandra and MySQL from E:\SANscreen\jboss\server\onaro\deploy\download.war\upgrade\backup2
at com.onaro.sanscreen.upgrade.UpgradeRunner.restore(UpgradeRunner.java:512)
at com.onaro.sanscreen.sessions.UpgradeSessionEJB.restore(UpgradeSessionEJB.java:61)
at com.onaro.sanscreen.sessions.UpgradeSessionEJB.restoreAndReboot(UpgradeSessionEJB.java:68)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.jboss.aop.joinpoint.MethodInvocation.invokeTarget(MethodInvocation.java:122)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:111)
at org.jboss.ejb3.interceptors.container.ContainerMethodInvocationWrapper.invokeNext(ContainerMethodInvocationWrapper.java:72)
at org.jboss.ejb3.interceptors.aop.InterceptorSequencer.invoke(InterceptorSequencer.java:76)
at org.jboss.ejb3.interceptors.aop.InterceptorSequencer.aroundInvoke(InterceptorSequencer.java:62)
at sun.reflect.GeneratedMethodAccessor646.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
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:74)
at org.jboss.aop.advice.org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor_z_fillMethod_2020741719.invoke(InvocationContextInterceptor_z_fillMethod_2020741719.java)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
at org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor.setup(InvocationContextInterceptor.java:90)
at org.jboss.aop.advice.org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor_z_setup_2020741719.invoke(InvocationContextInterceptor_z_setup_2020741719.java)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
at org.jboss.ejb3.async.impl.interceptor.AsynchronousServerInterceptor.invoke(AsynchronousServerInterceptor.java:128)
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.ejb3.core.context.SessionInvocationContextAdapter.proceed(SessionInvocationContextAdapter.java:95)
at org.jboss.ejb3.tx2.impl.CMTTxInterceptor.invokeInNoTx(CMTTxInterceptor.java:234)
at org.jboss.ejb3.tx2.impl.CMTTxInterceptor.never(CMTTxInterceptor.java:296)
at org.jboss.ejb3.tx2.impl.CMTTxInterceptor.invoke(CMTTxInterceptor.java:205)
at org.jboss.ejb3.tx2.aop.CMTTxInterceptorWrapper.invoke(CMTTxInterceptorWrapper.java:52)
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.security.RunAsSecurityInterceptorv2.invoke(RunAsSecurityInterceptorv2.java:94)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
at org.jboss.ejb3.security.RoleBasedAuthorizationInterceptorv2.invoke(RoleBasedAuthorizationInterceptorv2.java:201)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
at org.jboss.ejb3.security.Ejb3AuthenticationInterceptorv2.invoke(Ejb3AuthenticationInterceptorv2.java:182)
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.ejb3.core.context.CurrentInvocationContextInterceptor.invoke(CurrentInvocationContextInterceptor.java:47)
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.interceptor.EJB3TCCLInterceptor.invoke(EJB3TCCLInterceptor.java:86)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
at org.jboss.ejb3.stateless.StatelessContainer.dynamicInvoke(StatelessContainer.java:392)
at org.jboss.ejb3.remoting.IsLocalInterceptor.invokeLocal(IsLocalInterceptor.java:88)
at org.jboss.ejb3.remoting.IsLocalInterceptor.invoke(IsLocalInterceptor.java:75)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
at org.jboss.ejb3.async.impl.interceptor.AsynchronousClientInterceptor.invoke(AsynchronousClientInterceptor.java:143)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
at org.jboss.aspects.remoting.PojiProxy.invoke(PojiProxy.java:62)
at com.sun.proxy.$Proxy396.invoke(Unknown Source)
at org.jboss.ejb3.proxy.impl.handler.session.SessionProxyInvocationHandlerBase.invoke(SessionProxyInvocationHandlerBase.java:185)
at com.sun.proxy.$Proxy410.restoreAndReboot(Unknown Source)
at com.onaro.sanscreen.sessions.UpgradeSession$restoreAndReboot.call(Unknown Source)
at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:45)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:108)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:120)
at com.netapp.oci.rest.management.RestoreService.restore(RestoreService.groovy:205)
at com.netapp.oci.rest.management.RestoreService$$FastClassByCGLIB$$2dfe2a6e.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:191)
at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:689)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:622)
at com.netapp.oci.rest.management.RestoreService$$EnhancerByCGLIB$$da1c816.restore(<generated>)
at com.netapp.oci.rest.management.RestoreService$restore.call(Unknown Source)
at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:45)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:108)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:120)
at com.netapp.oci.rest.management.RestoreController.restore(RestoreController.groovy:26)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.codehaus.groovy.grails.web.servlet.mvc.MixedGrailsControllerHelper.invoke(MixedGrailsControllerHelper.java:69)
at org.codehaus.groovy.grails.web.servlet.mvc.AbstractGrailsControllerHelper.handleAction(AbstractGrailsControllerHelper.java:334)
at org.codehaus.groovy.grails.web.servlet.mvc.AbstractGrailsControllerHelper.executeAction(AbstractGrailsControllerHelper.java:217)
at org.codehaus.groovy.grails.web.servlet.mvc.AbstractGrailsControllerHelper.handleURI(AbstractGrailsControllerHelper.java:183)
at org.codehaus.groovy.grails.web.servlet.mvc.AbstractGrailsControllerHelper.handleURI(AbstractGrailsControllerHelper.java:116)
at org.codehaus.groovy.grails.web.servlet.mvc.SimpleGrailsController.handleRequest(SimpleGrailsController.java:72)
at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)
at org.codehaus.groovy.grails.web.servlet.GrailsDispatcherServlet.doDispatch(GrailsDispatcherServlet.java:328)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:852)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:882)
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:789)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:754)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:847)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:324)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:242)
at grails.plugin.cache.web.filter.PageFragmentCachingFilter.doFilter(PageFragmentCachingFilter.java:195)
at grails.plugin.cache.web.filter.AbstractFilter.doFilter(AbstractFilter.java:63)
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:274)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:242)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:70)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:274)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:242)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:70)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:274)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:242)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:70)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:274)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:242)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:734)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:541)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:479)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:407)
at org.codehaus.groovy.grails.web.util.WebUtils.forwardRequestForUrlMappingInfo(WebUtils.java:314)
at org.codehaus.groovy.grails.web.util.WebUtils.forwardRequestForUrlMappingInfo(WebUtils.java:279)
at org.codehaus.groovy.grails.web.util.WebUtils.forwardRequestForUrlMappingInfo(WebUtils.java:270)
at org.codehaus.groovy.grails.web.mapping.filter.UrlMappingsFilter.doFilterInternal(UrlMappingsFilter.java:221)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:274)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:242)
at org.codehaus.groovy.grails.web.sitemesh.GrailsPageFilter.obtainContent(GrailsPageFilter.java:200)
at org.codehaus.groovy.grails.web.sitemesh.GrailsPageFilter.doFilter(GrailsPageFilter.java:151)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:274)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:242)
at org.codehaus.groovy.grails.web.servlet.mvc.GrailsWebRequestFilter.doFilterInternal(GrailsWebRequestFilter.java:69)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:274)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:242)
at org.codehaus.groovy.grails.web.filters.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:66)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:274)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:242)
at com.brandseye.cors.CorsFilter.doFilter(CorsFilter.java:69)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:274)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:242)
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:274)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:242)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:181)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:593)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:88)
at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:100)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:159)
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:416)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.jboss.web.tomcat.service.request.ActiveRequestResponseCacheValve.invoke(ActiveRequestResponseCacheValve.java:53)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:362)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:654)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:951)
at java.lang.Thread.run(Thread.java:744)
Caused by: com.onaro.sanscreen.upgrade.UpgraderException: Failed to find an sql file in E:\SANscreen\jboss\server\onaro\deploy\download.war\upgrade\backup2
at com.onaro.sanscreen.upgrade.UpgradeRunner.restore(UpgradeRunner.java:501)
... 169 more

2014-11-05 14:44:31,547 INFO [http-443-55] RestoreService (null:-1) - ----------------------------------- Failed Restore Ended -----------------------------------
2014-11-05 14:44:31,828 INFO [http-443-55] ExceptionController (null:-1) - REST API call for [POST] /rest/v1/admin/restore returning code 400, error type: OPERATION_FAILED, message: Error: Restore failed. Reason : Failed to restore Cassandra and MySQL from E:\SANscreen\jboss\server\onaro\deploy\download.war\upgrade\backup2
2014-11-05 14:45:02,980 INFO [http-443-54] RestoreService (null:-1) - ----------------------------------- Restore Started -----------------------------------
2014-11-05 14:45:02,980 INFO [http-443-54] RestoreService (null:-1) - Restore Backup_WSANSCREEN_V6-2-2_B649_4930140862953998833.gz
2014-11-05 14:45:06,895 INFO [http-443-62] ExceptionController (null:-1) - REST API call for [GET] /rest/v1/admin/badgesInfo?expand=default&_=1415195016357 returning code 400, error type: RESTORE_IN_PROGRESS, message: Restore of DB in progress, operation denied
2014-11-05 14:46:06,887 INFO [http-443-15] ExceptionController (null:-1) - REST API call for [GET] /rest/v1/admin/badgesInfo?expand=default&_=1415195016358 returning code 400, error type: RESTORE_IN_PROGRESS, message: Restore of DB in progress, operation denied
2014-11-05 14:46:36,869 INFO [http-443-24] ExceptionController (null:-1) - REST API call for [GET] /rest/v1/admin/badgesInfo?expand=default&_=1415195016359 returning code 400, error type: RESTORE_IN_PROGRESS, message: Restore of DB in progress, operation denied
2014-11-05 14:47:09,598 INFO [http-443-24] ExceptionController (null:-1) - REST API call for [GET] /rest/v1/admin/users/current returning code 400, error type: RESTORE_IN_PROGRESS, message: Restore of DB in progress, operation denied
2014-11-05 14:47:19,098 INFO [http-443-2] ExceptionController (null:-1) - REST API call for [GET] /rest/v1/admin/users/current returning code 400, error type: RESTORE_IN_PROGRESS, message: Restore of DB in progress, operation denied
2014-11-05 14:47:32,732 INFO [http-443-15] ExceptionController (null:-1) - REST API call for [GET] /rest/v1/admin/users/current returning code 400, error type: RESTORE_IN_PROGRESS, message: Restore of DB in progress, operation denied
2014-11-05 14:48:10,780 INFO [http-443-2] ExceptionController (null:-1) - REST API call for [GET] /rest/v1/admin/users/current returning code 400, error type: RESTORE_IN_PROGRESS, message: Restore of DB in progress, operation denied
2014-11-05 14:48:16,599 INFO [http-443-15] ExceptionController (null:-1) - REST API call for [GET] /rest/v1/admin/users/current returning code 400, error type: RESTORE_IN_PROGRESS, message: Restore of DB in progress, operation denied
2014-11-05 14:49:39,091 INFO [http-443-22] ExceptionController (null:-1) - REST API call for [GET] /rest/v1/admin/users/current returning code 400, error type: RESTORE_IN_PROGRESS, message: Restore of DB in progress, operation denied
2014-11-05 14:49:45,939 INFO [http-443-22] ExceptionController (null:-1) - REST API call for [GET] /rest/v1/admin/users/current returning code 400, error type: RESTORE_IN_PROGRESS, message: Restore of DB in progress, operation denied
2014-11-05 14:49:52,709 INFO [http-443-15] ExceptionController (null:-1) - REST API call for [GET] /rest/v1/admin/users/current returning code 400, error type: RESTORE_IN_PROGRESS, message: Restore of DB in progress, operation denied
2014-11-05 14:50:04,172 INFO [http-443-24] ExceptionController (null:-1) - REST API call for [GET] /rest/v1/admin/badgesInfo?expand=default&_=1415195403390 returning code 400, error type: RESTORE_IN_PROGRESS, message: Restore of DB in progress, operation denied
2014-11-05 14:50:04,192 INFO [http-443-55] ExceptionController (null:-1) - REST API call for [GET] /rest/v1/admin/datasources?_=1415195403392 returning code 400, error type: RESTORE_IN_PROGRESS, message: Restore of DB in progress, operation denied
2014-11-05 14:50:04,235 INFO [http-443-63] ExceptionController (null:-1) - REST API call for [GET] /rest/v1/admin/badgesInfo?expand=default&_=1415195403391 returning code 400, error type: RESTORE_IN_PROGRESS, message: Restore of DB in progress, operation denied
2014-11-05 14:50:04,250 INFO [http-443-62] ExceptionController (null:-1) - REST API call for [GET] /rest/v1/admin/acquisitionUnits?_=1415195403393 returning code 400, error type: RESTORE_IN_PROGRESS, message: Restore of DB in progress, operation denied
2014-11-05 14:50:04,334 INFO [http-443-63] ExceptionController (null:-1) - REST API call for [GET] /rest/v1/admin/datasourceTypes?_=1415195403395 returning code 400, error type: RESTORE_IN_PROGRESS, message: Restore of DB in progress, operation denied
2014-11-05 14:50:04,339 INFO [http-443-62] ExceptionController (null:-1) - REST API call for [GET] /rest/v1/admin/vendorModels?_=1415195403394 returning code 400, error type: RESTORE_IN_PROGRESS, message: Restore of DB in progress, operation denied
2014-11-05 14:50:04,351 INFO [http-443-55] ExceptionController (null:-1) - REST API call for [GET] /rest/v1/admin/datasources?_=1415195403396 returning code 400, error type: RESTORE_IN_PROGRESS, message: Restore of DB in progress, operation denied
2014-11-05 14:50:31,371 INFO [http-443-22] ExceptionController (null:-1) - REST API call for [GET] /rest/v1/admin/users/current returning code 400, error type: RESTORE_IN_PROGRESS, message: Restore of DB in progress, operation denied

 

 

 

Re: OCI Upgrade to 7.0.1-db restore fails with "Internal error"

It looks like the source backup file may be bad. Can you perform another backup of the 6.3.x server?

Re: OCI Upgrade to 7.0.1-db restore fails with "Internal error"

[ Edited ]

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,

 

Re: OCI Upgrade to 7.0.1-db restore fails with "Internal error"

A quick thing worth a try is to install 7-zip , and see if you can open the backup....gz file -if you get any errors, that is a sign the .gz is bad. OCI 6.4.x and earlier backup files contain one .sql file.

Re: OCI Upgrade to 7.0.1-db restore fails with "Internal error"

[ Edited ]

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:F8Smiley Very HappyF: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:F0Smiley Very Happy4: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:F8Smiley Very HappyF:11','3'),('50:06:01:60:C6:E0:29:45','60:06:01:60:46:B0:2A:00:46:05:19:19:76:F8Smiley Very HappyF:11','2'),('50:06:01:60:C6:E0:29:45','60:06:01:60:46:B0:2A:00:48:2B:8E:26:76:F8Smiley Very HappyF: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:F8Smiley Very HappyF:11','0'),('50:06:01:60:C6:E0:29:45','60:06:01:60:46:B0:2A:00:5F:23:8B:0C:76:F8Smiley Very HappyF: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:F8Smiley Very HappyF: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:00Smiley Very Happy0Smiley Very HappyC:F9:4F:19:40:E0:11','34'),('50:06:01:60:C6:E0:29:45','60:06:01:60:46:B0:2A:00Smiley Very Happy6:AD:89:E3:7A:F8Smiley Very HappyF:11','16'),('50:06:01:60:C6:E0:29:45','60:06:01:60:46:B0:2A:00Smiley Very Happy8:4BSmiley Very HappyE:03:19:40:E0:11','30'),('50:06:01:60:C6:E0:29:45','60:06:01:60:46:B0:2A:00Smiley Very HappyA: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:2CSmiley Very Happy6:6C:73:19:40:E0:11','33'),('50:06:01:60:C6:E0:29:45','60:06:01:60:80:B0:2A:00:3CSmiley Very Happy9: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:C4Smiley Very Happy1: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:F8Smiley Very HappyF:11','17'),('50:06:01:60:C6:E0:29:45','60:06:01:60:80:B0:2A:00:F8Smiley Very Happy3: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:F9Smiley Very HappyF: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:00Smiley Very Happy8: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:F9Smiley Very HappyF:11','2'),('50:06:01:60:C6:E0:2A:45','60:06:01:60:2D:70:2A:00:02:5DSmiley Very Happy9:CA:EF:48:E0:11','36'),('50:06:01:60:C6:E0:2A:45','60:06:01:60:2D:70:2A:00:2C:7D:52Smiley Very HappyB: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:F9Smiley Very HappyF:11','3'),('50:06:01:60:C6:E0:2A:45','60:06:01:60:2D:70:2A:00:39:A0:64:F6:32:F9Smiley Very HappyF:11','4'),('50:06:01:60:C6:E0:2A:45','60:06:01:60:2D:70:2A:00:42:4BSmiley Very HappyA: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:F9Smiley Very HappyF:11','5'),('50:06:01:60:C6:E0:2A:45','60:06:01:60:2D:70:2A:00:80:F7:FE:E4:32:F9Smiley Very HappyF:11','0'),('50:06:01:60:C6:E0:2A:45','60:06:01:60:2D:70:2A:00:81:F7:FE:E4:32:F9Smiley Very HappyF:11','1'),('50:06:01:60:C6:E0:2A:45','60:06:01:60:2D:70:2A:00:94:1D:25:AD:37:F9Smiley Very HappyF: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:B3Smiley Very HappyB:32:F9Smiley Very HappyF: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:BESmiley Very Happy6:85:A2:EF:48:E0:11','34'),('50:06:01:60:C6:E0:2A:45','60:06:01:60:2D:70:2A:00:C4:9ESmiley Very Happy9: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:00Smiley Very Happy6: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','... 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`

 

 

 

Re: OCI Upgrade to 7.0.1-db restore fails with "Internal error"

I would try to create a new backup via the web portal. Assure + Perform will be a full backup

Re: OCI Upgrade to 7.0.1-db restore fails with "Internal error"

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! ;-)

Highlighted

Re: OCI Upgrade to 7.0.1-db restore fails with "Internal error"

The OCI web portal backup will only generate a .gz file. If it does not, it is likely something weird about your web browser - like a zip file handle attempting to open files automatically - I would attempt the backup with a different browser. The backup may also be stored in C:\Program Files\SANscreen\jboss\server\onaro\deploy\download.war But that is somewhat risky, as that is a dynamic place, and the files may be incomplete

Re: OCI Upgrade to 7.0.1-db restore fails with "Internal error"

[ Edited ]

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...

 

 

 

 

 

Re: OCI Upgrade to 7.0.1-db restore fails with "Internal error"

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