Error during update in hac

[Former Member]

Dear Experts: We meet an error during the update process in hac. The database we use is SAP HANA. And the error log show as below: ERROR | de.hybris.platform.core.Initialization:initialize:1119 | error during platform core type initializer initializeRemoveObjects() : table 'PRODUCTS' already esists within schema SYSTEM@null(459644267) 2015/11/27 11:34:48.777 | de.hybris.platform.jalo.JaloSystemException: error during platform core type initializer initializeRemoveObjects() : table 'PRODUCTS' already esists within schema SYSTEM@null(459644267)[HY--1] 2015/11/27 11:34:48.777 | at de.hybris.platform.persistence.AbstractTypeInitializer.initializeRemoveObjects(AbstractTypeInitializer.java:3000) 2015/11/27 11:34:48.777 | at de.hybris.platform.persistence.NotifyManagerEJB.initializeRemoveObjects(NotifyManagerEJB.java:129) 2015/11/27 11:34:48.777 | at de.hybris.platform.core.Initialization.initializeSchemaAndTypeSystemOldStyle(Initialization.java:1262) 2015/11/27 11:34:48.777 | at de.hybris.platform.core.Initialization.initialize(Initialization.java:1101) 2015/11/27 11:34:48.777 | at de.hybris.platform.core.Initialization.createEmptySystemOrUpdate(Initialization.java:796) 2015/11/27 11:34:48.777 | at de.hybris.platform.core.Initialization.access$4(Initialization.java:775) 2015/11/27 11:34:48.777 | at de.hybris.platform.core.Initialization$4.call(Initialization.java:590) 2015/11/27 11:34:48.777 | at de.hybris.platform.core.Initialization$4.call(Initialization.java:1) 2015/11/27 11:34:48.777 | at de.hybris.platform.core.Initialization$SessionRecoveryAfterRegistryStartupAwareExecutor.execute(Initialization.java:717) 2015/11/27 11:34:48.777 | at de.hybris.platform.core.Initialization.doInitializeImpl(Initialization.java:593) 2015/11/27 11:34:48.777 | at de.hybris.platform.core.Initialization.access$5(Initialization.java:506) 2015/11/27 11:34:48.777 | at de.hybris.platform.core.Initialization$5.call(Initialization.java:829) 2015/11/27 11:34:48.777 | at de.hybris.platform.core.Initialization$5.call(Initialization.java:1) 2015/11/27 11:34:48.777 | at de.hybris.platform.core.system.InitializationLockHandler.performLocked(InitializationLockHandler.java:83) 2015/11/27 11:34:48.777 | at de.hybris.platform.core.Initialization.doInitialize(Initialization.java:861) 2015/11/27 11:34:48.777 | at de.hybris.platform.hac.facade.impl.DefaultInitUpdateFacade.executeInitUpdate(DefaultInitUpdateFacade.java:71) 2015/11/27 11:34:48.777 | at de.hybris.platform.hac.controller.platform.InitUpdateController.initExecuteWrap(InitUpdateController.java:101) 2015/11/27 11:34:48.777 | at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 2015/11/27 11:34:48.777 | at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) 2015/11/27 11:34:48.777 | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 2015/11/27 11:34:48.777 | at java.lang.reflect.Method.invoke(Method.java:497) 2015/11/27 11:34:48.777 | at org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:215) 2015/11/27 11:34:48.777 | at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132) 2015/11/27 11:34:48.777 | at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104) 2015/11/27 11:34:48.777 | at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:745) 2015/11/27 11:34:48.777 | at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:686) 2015/11/27 11:34:48.777 | at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:80) 2015/11/27 11:34:48.777 | at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:925) 2015/11/27 11:34:48.777 | at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:856) 2015/11/27 11:34:48.777 | at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:953) 2015/11/27 11:34:48.777 | at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:855) 2015/11/27 11:34:48.777 | at javax.servlet.http.HttpServlet.service(HttpServlet.java:646) 2015/11/27 11:34:48.777 | at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:829) 2015/11/27 11:34:48.777 | at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) 2015/11/27 11:34:48.777 | at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) 2015/11/27 11:34:48.777 | at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) 2015/11/27 11:34:48.777 | at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) 2015/11/27 11:34:48.777 | at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) 2015/11/27 11:34:48.777 | at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) 2015/11/27 11:34:48.777 | at org.sitemesh.webapp.contentfilter.ContentBufferingFilter.bufferAndPostProcess(ContentBufferingFilter.java:169) 2015/11/27 11:34:48.777 | at org.sitemesh.webapp.contentfilter.ContentBufferingFilter.doFilter(ContentBufferingFilter.java:126) 2015/11/27 11:34:48.777 | at org.sitemesh.config.ConfigurableSiteMeshFilter.doFilter(ConfigurableSiteMeshFilter.java:163) 2015/11/27 11:34:48.777 | at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) 2015/11/27 11:34:48.777 | at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) 2015/11/27 11:34:48.777 | at org.springframework.web.multipart.support.MultipartFilter.doFilterInternal(MultipartFilter.java:119) 2015/11/27 11:34:48.777 | at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) 2015/11/27 11:34:48.777 | at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) 2015/11/27 11:34:48.777 | at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) 2015/11/27 11:34:48.777 | at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330) 2015/11/27 11:34:48.777 | at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118) 2015/11/27 11:34:48.777 | at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84) 2015/11/27 11:34:48.777 | at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) 2015/11/27 11:34:48.777 | at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113) 2015/11/27 11:34:48.777 | at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) 2015/11/27 11:34:48.777 | at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:103) 2015/11/27 11:34:48.777 | at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) 2015/11/27 11:34:48.777 | at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113) 2015/11/27 11:34:48.777 | at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) 2015/11/27 11:34:48.777 | at org.springframework.security.web.authentication.rememberme.RememberMeAuthenticationFilter.doFilter(RememberMeAuthenticationFilter.java:146) 2015/11/27 11:34:48.777 | at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) 2015/11/27 11:34:48.777 | at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:154) 2015/11/27 11:34:48.777 | at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) 2015/11/27 11:34:48.777 | at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45) 2015/11/27 11:34:48.777 | at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) 2015/11/27 11:34:48.777 | at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:150) 2015/11/27 11:34:48.777 | at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) 2015/11/27 11:34:48.777 | at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:199) 2015/11/27 11:34:48.777 | at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) 2015/11/27 11:34:48.777 | at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:110) 2015/11/27 11:34:48.777 | at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) 2015/11/27 11:34:48.777 | at org.springframework.security.web.csrf.CsrfFilter.doFilterInternal(CsrfFilter.java:105) 2015/11/27 11:34:48.777 | at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) 2015/11/27 11:34:48.777 | at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) 2015/11/27 11:34:48.777 | at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:57) 2015/11/27 11:34:48.777 | at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) 2015/11/27 11:34:48.777 | at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) 2015/11/27 11:34:48.777 | at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:50) 2015/11/27 11:34:48.777 | at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) 2015/11/27 11:34:48.777 | at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) 2015/11/27 11:34:48.777 | at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87) 2015/11/27 11:34:48.777 | at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) 2015/11/27 11:34:48.777 | at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192) 2015/11/27 11:34:48.777 | at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160) 2015/11/27 11:34:48.777 | at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343) 2015/11/27 11:34:48.777 | at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260) 2015/11/27 11:34:48.777 | at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) 2015/11/27 11:34:48.777 | at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) 2015/11/27 11:34:48.777 | at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:77) 2015/11/27 11:34:48.777 | at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) 2015/11/27 11:34:48.777 | at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) 2015/11/27 11:34:48.777 | at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) 2015/11/27 11:34:48.777 | at de.hybris.platform.servicelayer.web.AbstractPlatformFilterChain$InternalFilterChain.doFilter(AbstractPlatformFilterChain.java:256) 2015/11/27 11:34:48.778 | at de.hybris.platform.servicelayer.web.AbstractPlatformFilterChain$StatisticsGatewayFilter.doFilter(AbstractPlatformFilterChain.java:345) 2015/11/27 11:34:48.778 | at de.hybris.platform.servicelayer.web.AbstractPlatformFilterChain$InternalFilterChain.doFilter(AbstractPlatformFilterChain.java:226) 2015/11/27 11:34:48.778 | at de.hybris.platform.servicelayer.web.SecureMediaFilter.doFilter(SecureMediaFilter.java:97) 2015/11/27 11:34:48.778 | at de.hybris.platform.servicelayer.web.SecureMediaFilter$$FastClassBySpringCGLIB$$130f661e.invoke() 2015/11/27 11:34:48.778 | at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204) 2015/11/27 11:34:48.778 | at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:700) 2015/11/27 11:34:48.778 | at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) 2015/11/27 11:34:48.778 | at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:132) 2015/11/27 11:34:48.778 | at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:120) 2015/11/27 11:34:48.778 | at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) 2015/11/27 11:34:48.778 | at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:633) 2015/11/27 11:34:48.778 | at de.hybris.platform.servicelayer.web.SecureMediaFilter$$EnhancerBySpringCGLIB$$667e06e5.doFilter() 2015/11/27 11:34:48.778 | at de.hybris.platform.servicelayer.web.AbstractPlatformFilterChain$InternalFilterChain.doFilter(AbstractPlatformFilterChain.java:226) 2015/11/27 11:34:48.778 | at de.hybris.platform.servicelayer.web.DataSourceSwitchingFilter.doFilter(DataSourceSwitchingFilter.java:73) 2015/11/27 11:34:48.778 | at de.hybris.platform.servicelayer.web.AbstractPlatformFilterChain$InternalFilterChain.doFilter(AbstractPlatformFilterChain.java:226) 2015/11/27 11:34:48.778 | at de.hybris.platform.servicelayer.web.SessionFilter.doFilter(SessionFilter.java:73) 2015/11/27 11:34:48.778 | at de.hybris.platform.servicelayer.web.AbstractPlatformFilterChain$InternalFilterChain.doFilter(AbstractPlatformFilterChain.java:226) 2015/11/27 11:34:48.778 | at de.hybris.platform.servicelayer.web.RedirectWhenSystemIsNotInitializedFilter.doFilter(RedirectWhenSystemIsNotInitializedFilter.java:104) 2015/11/27 11:34:48.778 | at de.hybris.platform.servicelayer.web.AbstractPlatformFilterChain$InternalFilterChain.doFilter(AbstractPlatformFilterChain.java:226) 2015/11/27 11:34:48.778 | at de.hybris.platform.servicelayer.web.Log4JFilter.doFilter(Log4JFilter.java:47) 2015/11/27 11:34:48.778 | at de.hybris.platform.servicelayer.web.AbstractPlatformFilterChain$InternalFilterChain.doFilter(AbstractPlatformFilterChain.java:226) 2015/11/27 11:34:48.778 | at de.hybris.platform.servicelayer.web.AbstractPlatformFilterChain.doFilterInternal(AbstractPlatformFilterChain.java:156) 2015/11/27 11:34:48.778 | at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) 2015/11/27 11:34:48.778 | at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343) 2015/11/27 11:34:48.778 | at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260) 2015/11/27 11:34:48.778 | at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) 2015/11/27 11:34:48.778 | at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) 2015/11/27 11:34:48.778 | at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88) 2015/11/27 11:34:48.778 | at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) 2015/11/27 11:34:48.778 | at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) 2015/11/27 11:34:48.778 | at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) 2015/11/27 11:34:48.778 | at de.hybris.platform.servicelayer.web.XSSFilter.doFilter(XSSFilter.java:230) 2015/11/27 11:34:48.778 | at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) 2015/11/27 11:34:48.778 | at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) 2015/11/27 11:34:48.778 | at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220) 2015/11/27 11:34:48.778 | at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122) 2015/11/27 11:34:48.778 | at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171) 2015/11/27 11:34:48.778 | at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) 2015/11/27 11:34:48.778 | at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) 2015/11/27 11:34:48.778 | at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950) 2015/11/27 11:34:48.778 | at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408) 2015/11/27 11:34:48.778 | at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1070) 2015/11/27 11:34:48.778 | at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611) 2015/11/27 11:34:48.778 | at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316) 2015/11/27 11:34:48.778 | at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) 2015/11/27 11:34:48.778 | at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) 2015/11/27 11:34:48.778 | at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) 2015/11/27 11:34:48.778 | at java.lang.Thread.run(Thread.java:745) 2015/11/27 11:34:48.778 | Caused by: java.lang.IllegalStateException: table 'PRODUCTS' already esists within schema SYSTEM@null(459644267) 2015/11/27 11:34:48.778 | at de.hybris.platform.util.jdbc.DBSchema.addExistingTable(DBSchema.java:198) 2015/11/27 11:34:48.778 | at de.hybris.platform.util.jdbc.SchemaAnalyzer.fetchTables(SchemaAnalyzer.java:138) 2015/11/27 11:34:48.778 | at de.hybris.platform.util.jdbc.SchemaAnalyzer.fetchSchemaCompletely(SchemaAnalyzer.java:94) 2015/11/27 11:34:48.778 | at de.hybris.platform.util.jdbc.SchemaAnalyzer.readSchemaMetaData(SchemaAnalyzer.java:79) 2015/11/27 11:34:48.778 | at de.hybris.platform.util.jdbc.SchemaAnalyzer.readTableMetaData(SchemaAnalyzer.java:65) 2015/11/27 11:34:48.778 | at de.hybris.platform.persistence.AbstractTypeInitializer.loadFullDatabaseSchemaInfo(AbstractTypeInitializer.java:2440) 2015/11/27 11:34:48.778 | at de.hybris.platform.persistence.AbstractTypeInitializer.assertDatabaseSchemaLoaded(AbstractTypeInitializer.java:2409) 2015/11/27 11:34:48.778 | at de.hybris.platform.persistence.AbstractTypeInitializer.tableExists(AbstractTypeInitializer.java:2472) 2015/11/27 11:34:48.778 | at de.hybris.platform.persistence.AbstractTypeInitializer.initializeTable(AbstractTypeInitializer.java:2599) 2015/11/27 11:34:48.778 | at de.hybris.platform.persistence.AbstractTypeInitializer.initializeTables(AbstractTypeInitializer.java:2549) 2015/11/27 11:34:48.778 | at de.hybris.platform.persistence.AbstractTypeInitializer.initializeRemoveObjects(AbstractTypeInitializer.java:2995) 2015/11/27 11:34:48.778 | ... 139 more

[yaroslav_bondarenko1]

Hi, do you found a resolution of this issue?

[Former Member]

The deployment 'PRODUCTS' already exists. Can you check if an item type is redeclared incorrectly in your items.xml or with the same deployment table name ?

[Former Member]

Are you selecting any specific extension or all ? and also are you giving deployment for any itemtype as 'PRODUCTS' try by changing name like MYPRODUCTS .

[Former Member]

Dear Expert: My localextensions.xml is in the attachment. And also there is no there is no deploy table name 'PRODUCTS' in my *items.xml file. Also my hybris version is 5.5.0.0. Very thanks for your help.