Hybris 5.4 System Update Issue - critical

[Former Member]

We took a backup from production database and refreshed our development environment database from same. We promoted next release items to dev and ran system update everything looks ok. Now support team again refreshed dev db with production db thinking there were some issue in first refresh which wiped out our new changes. Now issue is when we try to run system update again we get below error and system update doesn't work. Any pointers will be appreciated.

 enter code he ERROR [hybrisHTTP26] [10.140.26.132] [DefaultInitUpdateFacade] [executeInitUpdate] Failed to initialize
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.903 | java.lang.IllegalStateException: Cannot determine function name and column name from function expression: TO_CHAR("MODIFIEDTS",'MM/DD/YYYY HH24:MI:SS')
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.903 |     at de.hybris.bootstrap.ddl.HybrisOraclePlatform$HybrisOracleModelReader.getIndexColumn(HybrisOraclePlatform.java:485)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.903 |     at de.hybris.bootstrap.ddl.HybrisOraclePlatform$HybrisOracleModelReader.readIndex(HybrisOraclePlatform.java:462)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.903 |     at de.hybris.bootstrap.ddl.HybrisOraclePlatform$HybrisOracleModelReader.fillIndicesCacheIfNeeded(HybrisOraclePlatform.java:365)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.903 |     at de.hybris.bootstrap.ddl.HybrisOraclePlatform$HybrisOracleModelReader.readIndices(HybrisOraclePlatform.java:312)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.903 |     at org.apache.ddlutils.platform.JdbcModelReader.readTable(JdbcModelReader.java:567)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.903 |     at org.apache.ddlutils.platform.oracle.Oracle8ModelReader.readTable(Oracle8ModelReader.java:102)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.903 |     at org.apache.ddlutils.platform.oracle.Oracle10ModelReader.readTable(Oracle10ModelReader.java:80)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.903 |     at org.apache.ddlutils.platform.JdbcModelReader.readTables(JdbcModelReader.java:516)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.903 |     at org.apache.ddlutils.platform.JdbcModelReader.getDatabase(JdbcModelReader.java:472)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.903 |     at org.apache.ddlutils.platform.PlatformImplBase.readModelFromDatabase(PlatformImplBase.java:1920)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.903 |     at org.apache.ddlutils.platform.PlatformImplBase.readModelFromDatabase(PlatformImplBase.java:1904)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.903 |     at de.hybris.bootstrap.ddl.HybrisOraclePlatform.readModelFromDatabase(HybrisOraclePlatform.java:90)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.903 |     at de.hybris.bootstrap.ddl.HybrisSchemaGenerator.update(HybrisSchemaGenerator.java:218)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.903 |     at de.hybris.platform.core.Initialization.initializeSchemaAndTypeSystemFullyNewStyle(Initialization.java:1233)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.903 |     at de.hybris.platform.core.Initialization.initialize(Initialization.java:1105)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.903 |     at de.hybris.platform.core.Initialization.createEmptySystemOrUpdate(Initialization.java:796)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.903 |     at de.hybris.platform.core.Initialization.access$4(Initialization.java:775)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.903 |     at de.hybris.platform.core.Initialization$4.call(Initialization.java:590)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.903 |     at de.hybris.platform.core.Initialization$4.call(Initialization.java:1)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.903 |     at de.hybris.platform.core.Initialization$SessionRecoveryAfterRegistryStartupAwareExecutor.execute(Initialization.java:717)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.903 |     at de.hybris.platform.core.Initialization.doInitializeImpl(Initialization.java:593)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.903 |     at de.hybris.platform.core.Initialization.access$5(Initialization.java:506)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at de.hybris.platform.core.Initialization$5.call(Initialization.java:829)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at de.hybris.platform.core.Initialization$5.call(Initialization.java:1)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at de.hybris.platform.core.system.InitializationLockHandler.performLocked(InitializationLockHandler.java:83)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at de.hybris.platform.core.Initialization.doInitialize(Initialization.java:861)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at de.hybris.platform.hac.facade.impl.DefaultInitUpdateFacade.executeInitUpdate(DefaultInitUpdateFacade.java:71)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at de.hybris.platform.hac.controller.platform.InitUpdateController.initExecuteWrap(InitUpdateController.java:96)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at java.lang.reflect.Method.invoke(Method.java:606)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:215)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:745)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:686)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:80)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:925)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:856)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:953)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:855)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at javax.servlet.http.HttpServlet.service(HttpServlet.java:646)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:829)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at org.sitemesh.webapp.contentfilter.ContentBufferingFilter.bufferAndPostProcess(ContentBufferingFilter.java:169)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at org.sitemesh.webapp.contentfilter.ContentBufferingFilter.doFilter(ContentBufferingFilter.java:126)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at org.sitemesh.config.ConfigurableSiteMeshFilter.doFilter(ConfigurableSiteMeshFilter.java:163)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at org.springframework.web.multipart.support.MultipartFilter.doFilterInternal(MultipartFilter.java:119)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:103)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at org.springframework.security.web.authentication.rememberme.RememberMeAuthenticationFilter.doFilter(RememberMeAuthenticationFilter.java:146)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:154)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:150)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:199)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:110)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at org.springframework.security.web.csrf.CsrfFilter.doFilterInternal(CsrfFilter.java:105)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:50)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:77)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at de.hybris.platform.servicelayer.web.AbstractPlatformFilterChain$InternalFilterChain.doFilter(AbstractPlatformFilterChain.java:256)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at de.hybris.platform.servicelayer.web.AbstractPlatformFilterChain$StatisticsGatewayFilter.doFilter(AbstractPlatformFilterChain.java:345)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at de.hybris.platform.servicelayer.web.AbstractPlatformFilterChain$InternalFilterChain.doFilter(AbstractPlatformFilterChain.java:226)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at de.hybris.platform.servicelayer.web.SecureMediaFilter.doFilter(SecureMediaFilter.java:97)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at de.hybris.platform.servicelayer.web.SecureMediaFilter$$FastClassBySpringCGLIB$$130f661e.invoke(<generated>)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:700)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:132)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:120)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:633)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at de.hybris.platform.servicelayer.web.SecureMediaFilter$$EnhancerBySpringCGLIB$$6c14c71b.doFilter(<generated>)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at de.hybris.platform.servicelayer.web.AbstractPlatformFilterChain$InternalFilterChain.doFilter(AbstractPlatformFilterChain.java:226)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at de.hybris.platform.servicelayer.web.DataSourceSwitchingFilter.doFilter(DataSourceSwitchingFilter.java:73)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at de.hybris.platform.servicelayer.web.AbstractPlatformFilterChain$InternalFilterChain.doFilter(AbstractPlatformFilterChain.java:226)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at de.hybris.platform.servicelayer.web.SessionFilter.doFilter(SessionFilter.java:73)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at de.hybris.platform.servicelayer.web.AbstractPlatformFilterChain$InternalFilterChain.doFilter(AbstractPlatformFilterChain.java:226)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at de.hybris.platform.servicelayer.web.RedirectWhenSystemIsNotInitializedFilter.doFilter(RedirectWhenSystemIsNotInitializedFilter.java:104)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at de.hybris.platform.servicelayer.web.AbstractPlatformFilterChain$InternalFilterChain.doFilter(AbstractPlatformFilterChain.java:226)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at de.hybris.platform.servicelayer.web.Log4JFilter.doFilter(Log4JFilter.java:47)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at de.hybris.platform.servicelayer.web.AbstractPlatformFilterChain$InternalFilterChain.doFilter(AbstractPlatformFilterChain.java:226)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at de.hybris.platform.servicelayer.web.AbstractPlatformFilterChain.doFilterInternal(AbstractPlatformFilterChain.java:156)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at de.hybris.platform.servicelayer.web.XSSFilter.doFilter(XSSFilter.java:230)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.904 |     at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.905 |     at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1070)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.905 |     at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.905 |     at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:314)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.905 |     at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.905 |     at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.905 |     at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
 INFO   | jvm 1    | main    | 2016/05/16 10:28:41.905 |     at java.lang.Thread.run(Thread.java:745)
 INFO   | jvm 1    | main    | 2016/05/16 10:44:49.242 |re

[Former Member]

Hello,

Exception

mjava.lang.IllegalStateException: Cannot determine function name and column name

from function expression: TO_CHAR("MODIFIEDTS",'MM/DD/YYYY HH24:MI:SS')

For one of the indexes, INDEX_TYPE is Function based. For this Index, when trying to add index Column to index, Function Expression pattern is matched with index_expression

where FUNCTION_EXPRESSION_PATTERN is (.+)\(\"(.+)\"\)

and index_expression is TO_CHAR("MODIFIEDTS",'MM/DD/YYYY HH24:MI:SS')

You mentioned that support team again refreshed dev db with production db thinking there were some issues in first refresh which wiped out our new changes.

Are these changes related to adding indexes, modifying index type or adding index expression? Please verify your index_expression TO_CHAR("MODIFIEDTS",'MM/DD/YYYY HH24:MI:SS') for Function based index.

Best Regards,

Reena