Last active
January 24, 2020 00:09
-
-
Save tainguyen100/65284aca45dfde1a31c03ccf463c4ad1 to your computer and use it in GitHub Desktop.
SQL Server 2016 on 7.2.10.1
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
2020-01-23 23:15:44.557 ERROR [http-nio-8080-exec-5][JDBCExceptionReporter:234] Cannot insert duplicate key row in object 'dbo.PortletPreferences' with unique index 'IX_C7057FF7'. The duplicate key value is (0, 3, 40970, com_liferay_product_navigation_product_menu_web_portlet_ProductMenuPortlet). | |
2020-01-23 23:15:44.561 ERROR [http-nio-8080-exec-5][RuntimeTag:389] org.springframework.dao.InvalidDataAccessResourceUsageException: Could not execute JDBC batch update; SQL [insert into PortletPreferences (mvccVersion, companyId, ownerId, ownerType, plid, portletId, preferences, portletPreferencesId) values (?, ?, ?, ?, ?, ?, ?, ?)]; nested exception is org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update | |
org.springframework.dao.InvalidDataAccessResourceUsageException: Could not execute JDBC batch update; SQL [insert into PortletPreferences (mvccVersion, companyId, ownerId, ownerType, plid, portletId, preferences, portletPreferencesId) values (?, ?, ?, ?, ?, ?, ?, ?)]; nested exception is org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update | |
at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:643) | |
at org.springframework.orm.hibernate3.HibernateTransactionManager.convertHibernateAccessException(HibernateTransactionManager.java:800) | |
at org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:671) | |
at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:765) | |
at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:734) | |
at com.liferay.portal.spring.transaction.DefaultTransactionExecutor.commit(DefaultTransactionExecutor.java:41) | |
at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:77) | |
at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:57) | |
at com.liferay.portal.spring.aop.AopInvocationHandler.invoke(AopInvocationHandler.java:49) | |
at com.sun.proxy.$Proxy51.addPortletPreferences(Unknown Source) | |
at com.liferay.portal.service.impl.PortletPreferencesLocalServiceImpl.getPreferences(PortletPreferencesLocalServiceImpl.java:455) | |
at sun.reflect.GeneratedMethodAccessor185.invoke(Unknown Source) | |
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) | |
at java.lang.reflect.Method.invoke(Method.java:498) | |
at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:50) | |
at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:69) | |
at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:57) | |
at com.liferay.portal.spring.aop.RetryAdvice.invoke(RetryAdvice.java:99) | |
at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:57) | |
at com.liferay.portal.spring.aop.AopInvocationHandler.invoke(AopInvocationHandler.java:49) | |
at com.sun.proxy.$Proxy51.getPreferences(Unknown Source) | |
at com.liferay.portal.kernel.service.PortletPreferencesLocalServiceUtil.getPreferences(PortletPreferencesLocalServiceUtil.java:459) | |
at com.liferay.portlet.PortletPreferencesFactoryImpl.getLayoutPortletSetup(PortletPreferencesFactoryImpl.java:282) | |
at com.liferay.portlet.PortletPreferencesFactoryImpl.getLayoutPortletSetup(PortletPreferencesFactoryImpl.java:272) | |
at com.liferay.portal.kernel.portlet.PortletPreferencesFactoryUtil.getLayoutPortletSetup(PortletPreferencesFactoryUtil.java:89) | |
at com.liferay.taglib.portletext.RuntimeTag.doTag(RuntimeTag.java:308) | |
at com.liferay.taglib.portletext.RuntimeTag.doEndTag(RuntimeTag.java:379) | |
at com.liferay.taglib.DirectTag.doTag(DirectTag.java:128) | |
at com.liferay.product.navigation.product.menu.web.internal.product.navigation.control.menu.ProductMenuProductNavigationControlMenuEntry._processBodyBottomContent(ProductMenuProductNavigationControlMenuEntry.java:228) | |
at com.liferay.product.navigation.product.menu.web.internal.product.navigation.control.menu.ProductMenuProductNavigationControlMenuEntry.includeBody(ProductMenuProductNavigationControlMenuEntry.java:92) | |
at org.apache.jsp.control_005fmenu.page_jsp._jspService(page_jsp.java:227) | |
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:111) | |
at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) | |
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:411) | |
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:473) | |
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:377) | |
at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) | |
at com.liferay.portal.osgi.web.servlet.jsp.compiler.internal.JspServlet.service(JspServlet.java:325) | |
at com.liferay.portal.osgi.web.servlet.jsp.compiler.internal.JspServlet.service(JspServlet.java:336) | |
at org.eclipse.equinox.http.servlet.internal.registration.EndpointRegistration.service(EndpointRegistration.java:153) | |
at org.eclipse.equinox.http.servlet.internal.servlet.ResponseStateHandler.processRequest(ResponseStateHandler.java:62) | |
at org.eclipse.equinox.http.servlet.internal.context.DispatchTargets.doDispatch(DispatchTargets.java:120) | |
at org.eclipse.equinox.http.servlet.internal.servlet.RequestDispatcherAdaptor.include(RequestDispatcherAdaptor.java:48) | |
at com.liferay.portal.servlet.DirectServletPathRegisterDispatcher.include(DirectServletPathRegisterDispatcher.java:67) | |
at com.liferay.portal.servlet.DirectRequestDispatcherFactoryImpl$IndirectRequestDispatcher.include(DirectRequestDispatcherFactoryImpl.java:199) | |
at com.liferay.portal.servlet.ClassLoaderRequestDispatcherWrapper.doDispatch(ClassLoaderRequestDispatcherWrapper.java:79) | |
at com.liferay.portal.servlet.ClassLoaderRequestDispatcherWrapper.include(ClassLoaderRequestDispatcherWrapper.java:53) | |
at com.liferay.taglib.util.IncludeTag.includePage(IncludeTag.java:398) | |
at com.liferay.product.navigation.taglib.servlet.taglib.ProductNavigationControlMenuTag.includePage(ProductNavigationControlMenuTag.java:68) | |
at com.liferay.taglib.util.IncludeTag.include(IncludeTag.java:374) | |
at com.liferay.taglib.util.IncludeTag.doInclude(IncludeTag.java:217) | |
at com.liferay.taglib.util.IncludeTag.doEndTag(IncludeTag.java:88) | |
at freemarker.ext.jsp.TagTransformModel$TagWriter.endEvaluation(TagTransformModel.java:400) | |
at freemarker.ext.jsp.TagTransformModel$TagWriter.afterBody(TagTransformModel.java:388) | |
at freemarker.core.Environment.visitAndTransform(Environment.java:427) | |
at freemarker.core.UnifiedCall.accept(UnifiedCall.java:107) | |
at freemarker.core.Environment.visitByHiddingParent(Environment.java:345) | |
at freemarker.core.ConditionalBlock.accept(ConditionalBlock.java:48) | |
at freemarker.core.Environment.visit(Environment.java:324) | |
at freemarker.core.Macro$Context.runMacro(Macro.java:184) | |
at freemarker.core.Environment.invoke(Environment.java:701) | |
at freemarker.core.UnifiedCall.accept(UnifiedCall.java:84) | |
at freemarker.core.Environment.visit(Environment.java:324) | |
at freemarker.core.MixedContent.accept(MixedContent.java:54) | |
at freemarker.core.Environment.visit(Environment.java:324) | |
at freemarker.core.Environment.process(Environment.java:302) | |
at freemarker.template.Template.process(Template.java:325) | |
at com.liferay.portal.template.freemarker.internal.FreeMarkerTemplate.processTemplate(FreeMarkerTemplate.java:137) | |
at com.liferay.portal.template.BaseTemplate.processTemplate(BaseTemplate.java:127) | |
at com.liferay.taglib.util.ThemeUtil.doIncludeFTL(ThemeUtil.java:300) | |
at com.liferay.taglib.util.ThemeUtil.include(ThemeUtil.java:116) | |
at com.liferay.taglib.util.ThemeUtil.include(ThemeUtil.java:80) | |
at com.liferay.taglib.theme.IncludeTag.doEndTag(IncludeTag.java:34) | |
at org.apache.jsp.html.common.themes.portal_jsp._jspx_meth_liferay_002dtheme_005finclude_005f1(portal_jsp.java:746) | |
at org.apache.jsp.html.common.themes.portal_jsp._jspService(portal_jsp.java:678) | |
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) | |
at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) | |
at com.liferay.portal.servlet.DirectRequestDispatcher.forward(DirectRequestDispatcher.java:49) | |
at com.liferay.portal.servlet.DirectRequestDispatcherFactoryImpl$IndirectRequestDispatcher.forward(DirectRequestDispatcherFactoryImpl.java:182) | |
at com.liferay.portal.servlet.ClassLoaderRequestDispatcherWrapper.doDispatch(ClassLoaderRequestDispatcherWrapper.java:82) | |
at com.liferay.portal.servlet.ClassLoaderRequestDispatcherWrapper.forward(ClassLoaderRequestDispatcherWrapper.java:45) | |
at com.liferay.portal.struts.StrutsUtil.forward(StrutsUtil.java:63) | |
at com.liferay.portal.struts.PortalRequestProcessor._internalModuleRelativeForward(PortalRequestProcessor.java:364) | |
at com.liferay.portal.struts.PortalRequestProcessor._process(PortalRequestProcessor.java:419) | |
at com.liferay.portal.struts.PortalRequestProcessor.process(PortalRequestProcessor.java:155) | |
at com.liferay.portal.internal.servlet.MainServlet.doGet(MainServlet.java:205) | |
at javax.servlet.http.HttpServlet.service(HttpServlet.java:634) | |
at com.liferay.portal.internal.servlet.MainServlet.service(MainServlet.java:622) | |
at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) | |
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) | |
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) | |
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) | |
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) | |
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:124) | |
at com.liferay.portal.servlet.filters.password.modified.PasswordModifiedFilter.processFilter(PasswordModifiedFilter.java:62) | |
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:49) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:215) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:116) | |
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:147) | |
at com.liferay.portal.servlet.filters.secure.BaseAuthFilter.processFilter(BaseAuthFilter.java:357) | |
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:49) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:215) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:116) | |
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:147) | |
at com.liferay.portal.monitoring.internal.servlet.filter.MonitoringFilter.processFilter(MonitoringFilter.java:182) | |
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:49) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:215) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:116) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilter.doFilter(InvokerFilter.java:104) | |
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) | |
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) | |
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:712) | |
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:459) | |
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:384) | |
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:312) | |
at com.liferay.friendly.url.internal.servlet.FriendlyURLServlet.service(FriendlyURLServlet.java:409) | |
at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) | |
at com.liferay.portal.servlet.ServletAdapter.service(ServletAdapter.java:99) | |
at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) | |
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) | |
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) | |
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) | |
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) | |
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:124) | |
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:147) | |
at com.liferay.portal.servlet.filters.i18n.I18nFilter.processFilter(I18nFilter.java:368) | |
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:49) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:215) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:116) | |
at com.liferay.portal.servlet.filters.password.modified.PasswordModifiedFilter.processFilter(PasswordModifiedFilter.java:62) | |
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:49) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:215) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:116) | |
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:147) | |
at com.liferay.portal.servlet.filters.secure.BaseAuthFilter.processFilter(BaseAuthFilter.java:357) | |
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:49) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:215) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:116) | |
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:147) | |
at com.liferay.portal.servlet.filters.etag.ETagFilter.processFilter(ETagFilter.java:87) | |
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:49) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:215) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:116) | |
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:147) | |
at com.liferay.portal.servlet.filters.autologin.AutoLoginFilter.processFilter(AutoLoginFilter.java:264) | |
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:49) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:215) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:116) | |
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:147) | |
at com.liferay.portal.sharepoint.SharepointFilter.processFilter(SharepointFilter.java:88) | |
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:49) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:215) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:116) | |
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:147) | |
at com.liferay.portal.servlet.filters.virtualhost.VirtualHostFilter.processFilter(VirtualHostFilter.java:268) | |
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:49) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:215) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:116) | |
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:147) | |
at com.liferay.portal.monitoring.internal.servlet.filter.MonitoringFilter.processFilter(MonitoringFilter.java:182) | |
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:49) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:215) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:116) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDirectCallFilter(InvokerFilterChain.java:196) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:99) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDirectCallFilter(InvokerFilterChain.java:196) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:99) | |
at org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:176) | |
at org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:145) | |
at org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:92) | |
at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:389) | |
at com.liferay.portal.servlet.filters.urlrewrite.UrlRewriteFilter.processFilter(UrlRewriteFilter.java:65) | |
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:49) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:215) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:116) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDirectCallFilter(InvokerFilterChain.java:175) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:99) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDirectCallFilter(InvokerFilterChain.java:175) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:99) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDirectCallFilter(InvokerFilterChain.java:196) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:99) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilter.doFilter(InvokerFilter.java:104) | |
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) | |
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) | |
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:200) | |
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) | |
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490) | |
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) | |
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) | |
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) | |
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) | |
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408) | |
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) | |
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:834) | |
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1415) | |
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) | |
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) | |
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) | |
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) | |
at java.lang.Thread.run(Thread.java:748) | |
Caused by: org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update | |
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92) | |
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) | |
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275) | |
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:268) | |
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:184) | |
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321) | |
at com.liferay.portal.dao.orm.hibernate.event.NestableFlushEventListener.onFlush(NestableFlushEventListener.java:61) | |
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216) | |
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:383) | |
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:133) | |
at org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:663) | |
... 199 more | |
Caused by: java.sql.BatchUpdateException: Cannot insert duplicate key row in object 'dbo.PortletPreferences' with unique index 'IX_C7057FF7'. The duplicate key value is (0, 3, 40970, com_liferay_product_navigation_product_menu_web_portlet_ProductMenuPortlet). | |
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeBatch(SQLServerPreparedStatement.java:1132) | |
at com.zaxxer.hikari.pool.ProxyStatement.executeBatch(ProxyStatement.java:125) | |
at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeBatch(HikariProxyPreparedStatement.java) | |
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70) | |
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268) | |
... 207 more | |
2020-01-23 23:15:44.569 ERROR [http-nio-8080-exec-5][IncludeTag:128] Current URL /web/guest/search?_com_liferay_blogs_web_portlet_BlogsPortlet_redirect=http%3A%2F%2Flocalhost%3A8080%2Fweb%2Fguest%2Fhome%3Fp_p_id%3Dcom_liferay_blogs_web_portlet_BlogsPortlet%26p_p_lifecycle%3D0%26p_p_state%3Dnormal%26p_p_mode%3Dview%26_com_liferay_blogs_web_portlet_BlogsPortlet_cur%3D1%26_com_liferay_blogs_web_portlet_BlogsPortlet_delta%3D20&q=Journal generates exception: org.springframework.dao.InvalidDataAccessResourceUsageException: Could not execute JDBC batch update; SQL [insert into PortletPreferences (mvccVersion, companyId, ownerId, ownerType, plid, portletId, preferences, portletPreferencesId) values (?, ?, ?, ?, ?, ?, ?, ?)]; nested exception is org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update | |
java.sql.BatchUpdateException: Cannot insert duplicate key row in object 'dbo.PortletPreferences' with unique index 'IX_C7057FF7'. The duplicate key value is (0, 3, 40970, com_liferay_product_navigation_product_menu_web_portlet_ProductMenuPortlet). | |
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeBatch(SQLServerPreparedStatement.java:1132) | |
at com.zaxxer.hikari.pool.ProxyStatement.executeBatch(ProxyStatement.java:125) | |
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70) | |
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268) | |
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:268) | |
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:184) | |
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321) | |
at com.liferay.portal.dao.orm.hibernate.event.NestableFlushEventListener.onFlush(NestableFlushEventListener.java:61) | |
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216) | |
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:383) | |
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:133) | |
at com.liferay.portal.spring.transaction.DefaultTransactionExecutor.commit(DefaultTransactionExecutor.java:41) | |
at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:77) | |
at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:57) | |
at com.liferay.portal.spring.aop.AopInvocationHandler.invoke(AopInvocationHandler.java:49) | |
at com.liferay.portal.service.impl.PortletPreferencesLocalServiceImpl.getPreferences(PortletPreferencesLocalServiceImpl.java:455) | |
at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:50) | |
at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:69) | |
at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:57) | |
at com.liferay.portal.spring.aop.RetryAdvice.invoke(RetryAdvice.java:99) | |
2020-01-23 23:15:44.579 ERROR [http-nio-8080-exec-2][JDBCExceptionReporter:234] Cannot insert duplicate key row in object 'dbo.PortletPreferences' with unique index 'IX_C7057FF7'. The duplicate key value is (0, 3, 40970, com_liferay_portal_search_web_search_bar_portlet_SearchBarPortlet_INSTANCE_templateSearch). | |
2020-01-23 23:15:44.583 ERROR [http-nio-8080-exec-2][RuntimeTag:389] org.springframework.dao.InvalidDataAccessResourceUsageException: Could not execute JDBC batch update; SQL [insert into PortletPreferences (mvccVersion, companyId, ownerId, ownerType, plid, portletId, preferences, portletPreferencesId) values (?, ?, ?, ?, ?, ?, ?, ?)]; nested exception is org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update | |
org.springframework.dao.InvalidDataAccessResourceUsageException: Could not execute JDBC batch update; SQL [insert into PortletPreferences (mvccVersion, companyId, ownerId, ownerType, plid, portletId, preferences, portletPreferencesId) values (?, ?, ?, ?, ?, ?, ?, ?)]; nested exception is org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update | |
at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:643) | |
at org.springframework.orm.hibernate3.HibernateTransactionManager.convertHibernateAccessException(HibernateTransactionManager.java:800) | |
at org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:671) | |
at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:765) | |
at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:734) | |
at com.liferay.portal.spring.transaction.DefaultTransactionExecutor.commit(DefaultTransactionExecutor.java:41) | |
at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:77) | |
at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:57) | |
at com.liferay.portal.spring.aop.AopInvocationHandler.invoke(AopInvocationHandler.java:49) | |
at com.sun.proxy.$Proxy51.addPortletPreferences(Unknown Source) | |
at com.liferay.portal.service.impl.PortletPreferencesLocalServiceImpl.getPreferences(PortletPreferencesLocalServiceImpl.java:455) | |
at sun.reflect.GeneratedMethodAccessor185.invoke(Unknown Source) | |
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) | |
at java.lang.reflect.Method.invoke(Method.java:498) | |
at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:50) | |
at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:69) | |
at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:57) | |
at com.liferay.portal.spring.aop.RetryAdvice.invoke(RetryAdvice.java:99) | |
at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:57) | |
at com.liferay.portal.spring.aop.AopInvocationHandler.invoke(AopInvocationHandler.java:49) | |
at com.sun.proxy.$Proxy51.getPreferences(Unknown Source) | |
at com.liferay.portal.kernel.service.PortletPreferencesLocalServiceUtil.getPreferences(PortletPreferencesLocalServiceUtil.java:459) | |
at com.liferay.portlet.PortletPreferencesFactoryImpl.getLayoutPortletSetup(PortletPreferencesFactoryImpl.java:282) | |
at com.liferay.portlet.PortletPreferencesFactoryImpl.getLayoutPortletSetup(PortletPreferencesFactoryImpl.java:272) | |
at com.liferay.portal.kernel.portlet.PortletPreferencesFactoryUtil.getLayoutPortletSetup(PortletPreferencesFactoryUtil.java:89) | |
at com.liferay.taglib.portletext.RuntimeTag.doTag(RuntimeTag.java:308) | |
at com.liferay.taglib.portletext.RuntimeTag.doTag(RuntimeTag.java:94) | |
at com.liferay.taglib.portletext.RuntimeTag.doEndTag(RuntimeTag.java:372) | |
at freemarker.ext.jsp.TagTransformModel$TagWriter.endEvaluation(TagTransformModel.java:400) | |
at freemarker.ext.jsp.TagTransformModel$TagWriter.onStart(TagTransformModel.java:344) | |
at freemarker.core.Environment.visitAndTransform(Environment.java:422) | |
at freemarker.core.UnifiedCall.accept(UnifiedCall.java:107) | |
at freemarker.core.Environment.visitByHiddingParent(Environment.java:345) | |
at freemarker.core.ConditionalBlock.accept(ConditionalBlock.java:48) | |
at freemarker.core.Environment.visit(Environment.java:324) | |
at freemarker.core.Macro$Context.runMacro(Macro.java:184) | |
at freemarker.core.Environment.invoke(Environment.java:701) | |
at freemarker.core.UnifiedCall.accept(UnifiedCall.java:84) | |
at freemarker.core.Environment.visit(Environment.java:324) | |
at freemarker.core.MixedContent.accept(MixedContent.java:54) | |
at freemarker.core.Environment.visitByHiddingParent(Environment.java:345) | |
at freemarker.core.ConditionalBlock.accept(ConditionalBlock.java:48) | |
at freemarker.core.Environment.visit(Environment.java:324) | |
at freemarker.core.MixedContent.accept(MixedContent.java:54) | |
at freemarker.core.Environment.visitByHiddingParent(Environment.java:345) | |
at freemarker.core.ConditionalBlock.accept(ConditionalBlock.java:48) | |
at freemarker.core.Environment.visit(Environment.java:324) | |
at freemarker.core.MixedContent.accept(MixedContent.java:54) | |
at freemarker.core.Environment.visit(Environment.java:324) | |
at freemarker.core.Environment.process(Environment.java:302) | |
at freemarker.template.Template.process(Template.java:325) | |
at com.liferay.portal.template.freemarker.internal.FreeMarkerTemplate.processTemplate(FreeMarkerTemplate.java:137) | |
at com.liferay.portal.template.BaseTemplate.processTemplate(BaseTemplate.java:127) | |
at com.liferay.taglib.util.ThemeUtil.doIncludeFTL(ThemeUtil.java:300) | |
at com.liferay.taglib.util.ThemeUtil.include(ThemeUtil.java:116) | |
at com.liferay.taglib.util.ThemeUtil.include(ThemeUtil.java:80) | |
at com.liferay.taglib.theme.IncludeTag.doEndTag(IncludeTag.java:34) | |
at org.apache.jsp.html.common.themes.portal_jsp._jspx_meth_liferay_002dtheme_005finclude_005f1(portal_jsp.java:746) | |
at org.apache.jsp.html.common.themes.portal_jsp._jspService(portal_jsp.java:678) | |
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) | |
at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) | |
at com.liferay.portal.servlet.DirectRequestDispatcher.forward(DirectRequestDispatcher.java:49) | |
at com.liferay.portal.servlet.DirectRequestDispatcherFactoryImpl$IndirectRequestDispatcher.forward(DirectRequestDispatcherFactoryImpl.java:182) | |
at com.liferay.portal.servlet.ClassLoaderRequestDispatcherWrapper.doDispatch(ClassLoaderRequestDispatcherWrapper.java:82) | |
at com.liferay.portal.servlet.ClassLoaderRequestDispatcherWrapper.forward(ClassLoaderRequestDispatcherWrapper.java:45) | |
at com.liferay.portal.struts.StrutsUtil.forward(StrutsUtil.java:63) | |
at com.liferay.portal.struts.PortalRequestProcessor._internalModuleRelativeForward(PortalRequestProcessor.java:364) | |
at com.liferay.portal.struts.PortalRequestProcessor._process(PortalRequestProcessor.java:419) | |
at com.liferay.portal.struts.PortalRequestProcessor.process(PortalRequestProcessor.java:155) | |
at com.liferay.portal.internal.servlet.MainServlet.doGet(MainServlet.java:205) | |
at javax.servlet.http.HttpServlet.service(HttpServlet.java:634) | |
at com.liferay.portal.internal.servlet.MainServlet.service(MainServlet.java:622) | |
at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) | |
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) | |
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) | |
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) | |
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) | |
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:124) | |
at com.liferay.portal.servlet.filters.password.modified.PasswordModifiedFilter.processFilter(PasswordModifiedFilter.java:62) | |
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:49) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:215) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:116) | |
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:147) | |
at com.liferay.portal.servlet.filters.secure.BaseAuthFilter.processFilter(BaseAuthFilter.java:357) | |
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:49) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:215) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:116) | |
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:147) | |
at com.liferay.portal.monitoring.internal.servlet.filter.MonitoringFilter.processFilter(MonitoringFilter.java:182) | |
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:49) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:215) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:116) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilter.doFilter(InvokerFilter.java:104) | |
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) | |
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) | |
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:712) | |
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:459) | |
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:384) | |
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:312) | |
at com.liferay.friendly.url.internal.servlet.FriendlyURLServlet.service(FriendlyURLServlet.java:409) | |
at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) | |
at com.liferay.portal.servlet.ServletAdapter.service(ServletAdapter.java:99) | |
at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) | |
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) | |
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) | |
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) | |
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) | |
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:124) | |
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:147) | |
at com.liferay.portal.servlet.filters.i18n.I18nFilter.processFilter(I18nFilter.java:368) | |
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:49) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:215) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:116) | |
at com.liferay.portal.servlet.filters.password.modified.PasswordModifiedFilter.processFilter(PasswordModifiedFilter.java:62) | |
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:49) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:215) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:116) | |
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:147) | |
at com.liferay.portal.servlet.filters.secure.BaseAuthFilter.processFilter(BaseAuthFilter.java:357) | |
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:49) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:215) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:116) | |
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:147) | |
at com.liferay.portal.servlet.filters.etag.ETagFilter.processFilter(ETagFilter.java:87) | |
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:49) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:215) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:116) | |
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:147) | |
at com.liferay.portal.servlet.filters.autologin.AutoLoginFilter.processFilter(AutoLoginFilter.java:264) | |
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:49) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:215) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:116) | |
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:147) | |
at com.liferay.portal.sharepoint.SharepointFilter.processFilter(SharepointFilter.java:88) | |
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:49) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:215) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:116) | |
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:147) | |
at com.liferay.portal.servlet.filters.virtualhost.VirtualHostFilter.processFilter(VirtualHostFilter.java:268) | |
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:49) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:215) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:116) | |
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:147) | |
at com.liferay.portal.monitoring.internal.servlet.filter.MonitoringFilter.processFilter(MonitoringFilter.java:182) | |
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:49) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:215) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:116) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDirectCallFilter(InvokerFilterChain.java:196) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:99) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDirectCallFilter(InvokerFilterChain.java:196) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:99) | |
at org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:176) | |
at org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:145) | |
at org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:92) | |
at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:389) | |
at com.liferay.portal.servlet.filters.urlrewrite.UrlRewriteFilter.processFilter(UrlRewriteFilter.java:65) | |
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:49) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:215) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:116) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDirectCallFilter(InvokerFilterChain.java:175) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:99) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDirectCallFilter(InvokerFilterChain.java:175) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:99) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDirectCallFilter(InvokerFilterChain.java:196) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:99) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilter.doFilter(InvokerFilter.java:104) | |
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) | |
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) | |
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:200) | |
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) | |
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490) | |
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) | |
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) | |
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) | |
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) | |
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408) | |
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) | |
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:834) | |
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1415) | |
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) | |
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) | |
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) | |
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) | |
at java.lang.Thread.run(Thread.java:748) | |
Caused by: org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update | |
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92) | |
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) | |
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275) | |
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:268) | |
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:184) | |
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321) | |
at com.liferay.portal.dao.orm.hibernate.event.NestableFlushEventListener.onFlush(NestableFlushEventListener.java:61) | |
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216) | |
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:383) | |
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:133) | |
at org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:663) | |
... 183 more | |
Caused by: java.sql.BatchUpdateException: Cannot insert duplicate key row in object 'dbo.PortletPreferences' with unique index 'IX_C7057FF7'. The duplicate key value is (0, 3, 40970, com_liferay_portal_search_web_search_bar_portlet_SearchBarPortlet_INSTANCE_templateSearch). | |
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeBatch(SQLServerPreparedStatement.java:1132) | |
at com.zaxxer.hikari.pool.ProxyStatement.executeBatch(ProxyStatement.java:125) | |
at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeBatch(HikariProxyPreparedStatement.java) | |
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70) | |
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268) | |
... 191 more | |
2020-01-23 23:15:44.592 ERROR [http-nio-8080-exec-2][runtime:60] Error executing FreeMarker template | |
FreeMarker template error: | |
Error while invoking the "runtime" JSP custom tag; see cause exception | |
---- | |
FTL stack trace ("~" means nesting-related): | |
- Failed at: @liferay_portlet["runtime"] defaultPr... [in template "com.liferay.portal.template.freemarker_5.0.14_CLASS_LOADER_CONTEXT_FTL_liferay.ftl" in macro "search_bar" at line 137, column 17] | |
- Reached through: @liferay.search_bar default_preferenc... [in template "classic-theme_SERVLET_CONTEXT_/templates/portal_normal.ftl" at line 42, column 73] | |
---- | |
Java stack trace (for programmers): | |
---- | |
freemarker.core._TemplateModelException: [... Exception message was already printed; see it above ...] | |
at freemarker.ext.jsp.JspTagModelBase.toTemplateModelExceptionOrRethrow(JspTagModelBase.java:154) | |
at freemarker.ext.jsp.TagTransformModel$TagWriter.onStart(TagTransformModel.java:367) | |
at freemarker.core.Environment.visitAndTransform(Environment.java:422) | |
at freemarker.core.UnifiedCall.accept(UnifiedCall.java:107) | |
at freemarker.core.Environment.visitByHiddingParent(Environment.java:345) | |
at freemarker.core.ConditionalBlock.accept(ConditionalBlock.java:48) | |
at freemarker.core.Environment.visit(Environment.java:324) | |
at freemarker.core.Macro$Context.runMacro(Macro.java:184) | |
at freemarker.core.Environment.invoke(Environment.java:701) | |
at freemarker.core.UnifiedCall.accept(UnifiedCall.java:84) | |
at freemarker.core.Environment.visit(Environment.java:324) | |
at freemarker.core.MixedContent.accept(MixedContent.java:54) | |
at freemarker.core.Environment.visitByHiddingParent(Environment.java:345) | |
at freemarker.core.ConditionalBlock.accept(ConditionalBlock.java:48) | |
at freemarker.core.Environment.visit(Environment.java:324) | |
at freemarker.core.MixedContent.accept(MixedContent.java:54) | |
at freemarker.core.Environment.visitByHiddingParent(Environment.java:345) | |
at freemarker.core.ConditionalBlock.accept(ConditionalBlock.java:48) | |
at freemarker.core.Environment.visit(Environment.java:324) | |
at freemarker.core.MixedContent.accept(MixedContent.java:54) | |
at freemarker.core.Environment.visit(Environment.java:324) | |
at freemarker.core.Environment.process(Environment.java:302) | |
at freemarker.template.Template.process(Template.java:325) | |
at com.liferay.portal.template.freemarker.internal.FreeMarkerTemplate.processTemplate(FreeMarkerTemplate.java:137) | |
at com.liferay.portal.template.BaseTemplate.processTemplate(BaseTemplate.java:127) | |
at com.liferay.taglib.util.ThemeUtil.doIncludeFTL(ThemeUtil.java:300) | |
at com.liferay.taglib.util.ThemeUtil.include(ThemeUtil.java:116) | |
at com.liferay.taglib.util.ThemeUtil.include(ThemeUtil.java:80) | |
at com.liferay.taglib.theme.IncludeTag.doEndTag(IncludeTag.java:34) | |
at org.apache.jsp.html.common.themes.portal_jsp._jspx_meth_liferay_002dtheme_005finclude_005f1(portal_jsp.java:746) | |
at org.apache.jsp.html.common.themes.portal_jsp._jspService(portal_jsp.java:678) | |
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) | |
at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) | |
at com.liferay.portal.servlet.DirectRequestDispatcher.forward(DirectRequestDispatcher.java:49) | |
at com.liferay.portal.servlet.DirectRequestDispatcherFactoryImpl$IndirectRequestDispatcher.forward(DirectRequestDispatcherFactoryImpl.java:182) | |
at com.liferay.portal.servlet.ClassLoaderRequestDispatcherWrapper.doDispatch(ClassLoaderRequestDispatcherWrapper.java:82) | |
at com.liferay.portal.servlet.ClassLoaderRequestDispatcherWrapper.forward(ClassLoaderRequestDispatcherWrapper.java:45) | |
at com.liferay.portal.struts.StrutsUtil.forward(StrutsUtil.java:63) | |
at com.liferay.portal.struts.PortalRequestProcessor._internalModuleRelativeForward(PortalRequestProcessor.java:364) | |
at com.liferay.portal.struts.PortalRequestProcessor._process(PortalRequestProcessor.java:419) | |
at com.liferay.portal.struts.PortalRequestProcessor.process(PortalRequestProcessor.java:155) | |
at com.liferay.portal.internal.servlet.MainServlet.doGet(MainServlet.java:205) | |
at javax.servlet.http.HttpServlet.service(HttpServlet.java:634) | |
at com.liferay.portal.internal.servlet.MainServlet.service(MainServlet.java:622) | |
at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) | |
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) | |
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) | |
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) | |
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) | |
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:124) | |
at com.liferay.portal.servlet.filters.password.modified.PasswordModifiedFilter.processFilter(PasswordModifiedFilter.java:62) | |
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:49) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:215) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:116) | |
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:147) | |
at com.liferay.portal.servlet.filters.secure.BaseAuthFilter.processFilter(BaseAuthFilter.java:357) | |
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:49) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:215) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:116) | |
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:147) | |
at com.liferay.portal.monitoring.internal.servlet.filter.MonitoringFilter.processFilter(MonitoringFilter.java:182) | |
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:49) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:215) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:116) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilter.doFilter(InvokerFilter.java:104) | |
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) | |
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) | |
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:712) | |
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:459) | |
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:384) | |
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:312) | |
at com.liferay.friendly.url.internal.servlet.FriendlyURLServlet.service(FriendlyURLServlet.java:409) | |
at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) | |
at com.liferay.portal.servlet.ServletAdapter.service(ServletAdapter.java:99) | |
at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) | |
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) | |
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) | |
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) | |
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) | |
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:124) | |
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:147) | |
at com.liferay.portal.servlet.filters.i18n.I18nFilter.processFilter(I18nFilter.java:368) | |
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:49) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:215) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:116) | |
at com.liferay.portal.servlet.filters.password.modified.PasswordModifiedFilter.processFilter(PasswordModifiedFilter.java:62) | |
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:49) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:215) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:116) | |
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:147) | |
at com.liferay.portal.servlet.filters.secure.BaseAuthFilter.processFilter(BaseAuthFilter.java:357) | |
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:49) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:215) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:116) | |
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:147) | |
at com.liferay.portal.servlet.filters.etag.ETagFilter.processFilter(ETagFilter.java:87) | |
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:49) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:215) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:116) | |
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:147) | |
at com.liferay.portal.servlet.filters.autologin.AutoLoginFilter.processFilter(AutoLoginFilter.java:264) | |
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:49) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:215) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:116) | |
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:147) | |
at com.liferay.portal.sharepoint.SharepointFilter.processFilter(SharepointFilter.java:88) | |
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:49) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:215) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:116) | |
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:147) | |
at com.liferay.portal.servlet.filters.virtualhost.VirtualHostFilter.processFilter(VirtualHostFilter.java:268) | |
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:49) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:215) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:116) | |
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:147) | |
at com.liferay.portal.monitoring.internal.servlet.filter.MonitoringFilter.processFilter(MonitoringFilter.java:182) | |
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:49) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:215) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:116) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDirectCallFilter(InvokerFilterChain.java:196) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:99) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDirectCallFilter(InvokerFilterChain.java:196) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:99) | |
at org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:176) | |
at org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:145) | |
at org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:92) | |
at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:389) | |
at com.liferay.portal.servlet.filters.urlrewrite.UrlRewriteFilter.processFilter(UrlRewriteFilter.java:65) | |
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:49) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:215) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:116) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDirectCallFilter(InvokerFilterChain.java:175) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:99) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDirectCallFilter(InvokerFilterChain.java:175) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:99) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDirectCallFilter(InvokerFilterChain.java:196) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:99) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilter.doFilter(InvokerFilter.java:104) | |
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) | |
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) | |
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:200) | |
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) | |
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490) | |
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) | |
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) | |
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) | |
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) | |
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408) | |
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) | |
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:834) | |
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1415) | |
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) | |
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) | |
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) | |
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) | |
at java.lang.Thread.run(Thread.java:748) | |
Caused by: javax.servlet.jsp.JspException: org.springframework.dao.InvalidDataAccessResourceUsageException: Could not execute JDBC batch update; SQL [insert into PortletPreferences (mvccVersion, companyId, ownerId, ownerType, plid, portletId, preferences, portletPreferencesId) values (?, ?, ?, ?, ?, ?, ?, ?)]; nested exception is org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update | |
at com.liferay.taglib.portletext.RuntimeTag.doEndTag(RuntimeTag.java:391) | |
at freemarker.ext.jsp.TagTransformModel$TagWriter.endEvaluation(TagTransformModel.java:400) | |
at freemarker.ext.jsp.TagTransformModel$TagWriter.onStart(TagTransformModel.java:344) | |
... 156 more | |
Caused by: org.springframework.dao.InvalidDataAccessResourceUsageException: Could not execute JDBC batch update; SQL [insert into PortletPreferences (mvccVersion, companyId, ownerId, ownerType, plid, portletId, preferences, portletPreferencesId) values (?, ?, ?, ?, ?, ?, ?, ?)]; nested exception is org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update | |
at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:643) | |
at org.springframework.orm.hibernate3.HibernateTransactionManager.convertHibernateAccessException(HibernateTransactionManager.java:800) | |
at org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:671) | |
at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:765) | |
at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:734) | |
at com.liferay.portal.spring.transaction.DefaultTransactionExecutor.commit(DefaultTransactionExecutor.java:41) | |
at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:77) | |
at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:57) | |
at com.liferay.portal.spring.aop.AopInvocationHandler.invoke(AopInvocationHandler.java:49) | |
at com.sun.proxy.$Proxy51.addPortletPreferences(Unknown Source) | |
at com.liferay.portal.service.impl.PortletPreferencesLocalServiceImpl.getPreferences(PortletPreferencesLocalServiceImpl.java:455) | |
at sun.reflect.GeneratedMethodAccessor185.invoke(Unknown Source) | |
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) | |
at java.lang.reflect.Method.invoke(Method.java:498) | |
at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:50) | |
at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:69) | |
at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:57) | |
at com.liferay.portal.spring.aop.RetryAdvice.invoke(RetryAdvice.java:99) | |
at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:57) | |
at com.liferay.portal.spring.aop.AopInvocationHandler.invoke(AopInvocationHandler.java:49) | |
at com.sun.proxy.$Proxy51.getPreferences(Unknown Source) | |
at com.liferay.portal.kernel.service.PortletPreferencesLocalServiceUtil.getPreferences(PortletPreferencesLocalServiceUtil.java:459) | |
at com.liferay.portlet.PortletPreferencesFactoryImpl.getLayoutPortletSetup(PortletPreferencesFactoryImpl.java:282) | |
at com.liferay.portlet.PortletPreferencesFactoryImpl.getLayoutPortletSetup(PortletPreferencesFactoryImpl.java:272) | |
at com.liferay.portal.kernel.portlet.PortletPreferencesFactoryUtil.getLayoutPortletSetup(PortletPreferencesFactoryUtil.java:89) | |
at com.liferay.taglib.portletext.RuntimeTag.doTag(RuntimeTag.java:308) | |
at com.liferay.taglib.portletext.RuntimeTag.doTag(RuntimeTag.java:94) | |
at com.liferay.taglib.portletext.RuntimeTag.doEndTag(RuntimeTag.java:372) | |
... 158 more | |
Caused by: org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update | |
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92) | |
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) | |
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275) | |
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:268) | |
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:184) | |
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321) | |
at com.liferay.portal.dao.orm.hibernate.event.NestableFlushEventListener.onFlush(NestableFlushEventListener.java:61) | |
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216) | |
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:383) | |
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:133) | |
at org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:663) | |
... 183 more | |
Caused by: java.sql.BatchUpdateException: Cannot insert duplicate key row in object 'dbo.PortletPreferences' with unique index 'IX_C7057FF7'. The duplicate key value is (0, 3, 40970, com_liferay_portal_search_web_search_bar_portlet_SearchBarPortlet_INSTANCE_templateSearch). | |
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeBatch(SQLServerPreparedStatement.java:1132) | |
at com.zaxxer.hikari.pool.ProxyStatement.executeBatch(ProxyStatement.java:125) | |
at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeBatch(HikariProxyPreparedStatement.java) | |
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70) | |
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268) | |
... 191 more | |
2020-01-23 23:15:45.022 ERROR [http-nio-8080-exec-2][error_jsp:616] User ID 20155 | |
2020-01-23 23:15:45.023 ERROR [http-nio-8080-exec-2][error_jsp:617] Current URL /web/guest/search?_com_liferay_blogs_web_portlet_BlogsPortlet_redirect=http%3A%2F%2Flocalhost%3A8080%2Fweb%2Fguest%2Fhome%3Fp_p_id%3Dcom_liferay_blogs_web_portlet_BlogsPortlet%26p_p_lifecycle%3D0%26p_p_state%3Dnormal%26p_p_mode%3Dview%26_com_liferay_blogs_web_portlet_BlogsPortlet_cur%3D1%26_com_liferay_blogs_web_portlet_BlogsPortlet_delta%3D20&q=Journal | |
2020-01-23 23:15:45.023 ERROR [http-nio-8080-exec-2][error_jsp:618] Referer http://localhost:8080/web/guest/home/-/blogs/my-blog-posts510?_com_liferay_blogs_web_portlet_BlogsPortlet_redirect=http%3A%2F%2Flocalhost%3A8080%2Fweb%2Fguest%2Fhome%3Fp_p_id%3Dcom_liferay_blogs_web_portlet_BlogsPortlet%26p_p_lifecycle%3D0%26p_p_state%3Dnormal%26p_p_mode%3Dview%26_com_liferay_blogs_web_portlet_BlogsPortlet_cur%3D1%26_com_liferay_blogs_web_portlet_BlogsPortlet_delta%3D20 | |
2020-01-23 23:15:45.023 ERROR [http-nio-8080-exec-2][error_jsp:619] Remote address 127.0.0.1 | |
2020-01-23 23:15:45.024 ERROR [http-nio-8080-exec-2][error_jsp:621] com.liferay.portal.kernel.template.TemplateException: Unable to process template classic-theme_SERVLET_CONTEXT_/templates/portal_normal.ftl | |
com.liferay.portal.kernel.template.TemplateException: Unable to process template classic-theme_SERVLET_CONTEXT_/templates/portal_normal.ftl | |
at com.liferay.portal.template.BaseTemplate.processTemplate(BaseTemplate.java:132) | |
at com.liferay.taglib.util.ThemeUtil.doIncludeFTL(ThemeUtil.java:300) | |
at com.liferay.taglib.util.ThemeUtil.include(ThemeUtil.java:116) | |
at com.liferay.taglib.util.ThemeUtil.include(ThemeUtil.java:80) | |
at com.liferay.taglib.theme.IncludeTag.doEndTag(IncludeTag.java:34) | |
at org.apache.jsp.html.common.themes.portal_jsp._jspx_meth_liferay_002dtheme_005finclude_005f1(portal_jsp.java:746) | |
at org.apache.jsp.html.common.themes.portal_jsp._jspService(portal_jsp.java:678) | |
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) | |
at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) | |
at com.liferay.portal.servlet.DirectRequestDispatcher.forward(DirectRequestDispatcher.java:49) | |
at com.liferay.portal.servlet.DirectRequestDispatcherFactoryImpl$IndirectRequestDispatcher.forward(DirectRequestDispatcherFactoryImpl.java:182) | |
at com.liferay.portal.servlet.ClassLoaderRequestDispatcherWrapper.doDispatch(ClassLoaderRequestDispatcherWrapper.java:82) | |
at com.liferay.portal.servlet.ClassLoaderRequestDispatcherWrapper.forward(ClassLoaderRequestDispatcherWrapper.java:45) | |
at com.liferay.portal.struts.StrutsUtil.forward(StrutsUtil.java:63) | |
at com.liferay.portal.struts.PortalRequestProcessor._internalModuleRelativeForward(PortalRequestProcessor.java:364) | |
at com.liferay.portal.struts.PortalRequestProcessor._process(PortalRequestProcessor.java:419) | |
at com.liferay.portal.struts.PortalRequestProcessor.process(PortalRequestProcessor.java:155) | |
at com.liferay.portal.internal.servlet.MainServlet.doGet(MainServlet.java:205) | |
at javax.servlet.http.HttpServlet.service(HttpServlet.java:634) | |
at com.liferay.portal.internal.servlet.MainServlet.service(MainServlet.java:622) | |
at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) | |
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) | |
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) | |
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) | |
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) | |
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:124) | |
at com.liferay.portal.servlet.filters.password.modified.PasswordModifiedFilter.processFilter(PasswordModifiedFilter.java:62) | |
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:49) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:215) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:116) | |
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:147) | |
at com.liferay.portal.servlet.filters.secure.BaseAuthFilter.processFilter(BaseAuthFilter.java:357) | |
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:49) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:215) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:116) | |
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:147) | |
at com.liferay.portal.monitoring.internal.servlet.filter.MonitoringFilter.processFilter(MonitoringFilter.java:182) | |
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:49) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:215) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:116) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilter.doFilter(InvokerFilter.java:104) | |
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) | |
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) | |
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:712) | |
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:459) | |
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:384) | |
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:312) | |
at com.liferay.friendly.url.internal.servlet.FriendlyURLServlet.service(FriendlyURLServlet.java:409) | |
at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) | |
at com.liferay.portal.servlet.ServletAdapter.service(ServletAdapter.java:99) | |
at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) | |
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) | |
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) | |
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) | |
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) | |
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:124) | |
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:147) | |
at com.liferay.portal.servlet.filters.i18n.I18nFilter.processFilter(I18nFilter.java:368) | |
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:49) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:215) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:116) | |
at com.liferay.portal.servlet.filters.password.modified.PasswordModifiedFilter.processFilter(PasswordModifiedFilter.java:62) | |
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:49) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:215) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:116) | |
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:147) | |
at com.liferay.portal.servlet.filters.secure.BaseAuthFilter.processFilter(BaseAuthFilter.java:357) | |
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:49) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:215) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:116) | |
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:147) | |
at com.liferay.portal.servlet.filters.etag.ETagFilter.processFilter(ETagFilter.java:87) | |
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:49) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:215) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:116) | |
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:147) | |
at com.liferay.portal.servlet.filters.autologin.AutoLoginFilter.processFilter(AutoLoginFilter.java:264) | |
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:49) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:215) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:116) | |
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:147) | |
at com.liferay.portal.sharepoint.SharepointFilter.processFilter(SharepointFilter.java:88) | |
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:49) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:215) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:116) | |
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:147) | |
at com.liferay.portal.servlet.filters.virtualhost.VirtualHostFilter.processFilter(VirtualHostFilter.java:268) | |
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:49) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:215) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:116) | |
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:147) | |
at com.liferay.portal.monitoring.internal.servlet.filter.MonitoringFilter.processFilter(MonitoringFilter.java:182) | |
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:49) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:215) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:116) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDirectCallFilter(InvokerFilterChain.java:196) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:99) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDirectCallFilter(InvokerFilterChain.java:196) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:99) | |
at org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:176) | |
at org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:145) | |
at org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:92) | |
at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:389) | |
at com.liferay.portal.servlet.filters.urlrewrite.UrlRewriteFilter.processFilter(UrlRewriteFilter.java:65) | |
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:49) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:215) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:116) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDirectCallFilter(InvokerFilterChain.java:175) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:99) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDirectCallFilter(InvokerFilterChain.java:175) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:99) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDirectCallFilter(InvokerFilterChain.java:196) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:99) | |
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilter.doFilter(InvokerFilter.java:104) | |
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) | |
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) | |
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:200) | |
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) | |
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490) | |
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) | |
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) | |
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) | |
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) | |
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408) | |
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) | |
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:834) | |
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1415) | |
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) | |
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) | |
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) | |
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) | |
at java.lang.Thread.run(Thread.java:748) | |
Caused by: freemarker.core._TemplateModelException: Error while invoking the "runtime" JSP custom tag; see cause exception__----_FTL stack trace ("~" means nesting-related):_ - Failed at: @liferay_portlet["runtime"] defaultPr... [in template "com.liferay.portal.template.freemarker_5.0.14_CLASS_LOADER_CONTEXT_FTL_liferay.ftl" in macro "search_bar" at line 137, column 17]_ - Reached through: @liferay.search_bar default_preferenc... [in template "classic-theme_SERVLET_CONTEXT_/templates/portal_normal.ftl" at line 42, column 73]_---- [Sanitized] | |
at freemarker.ext.jsp.JspTagModelBase.toTemplateModelExceptionOrRethrow(JspTagModelBase.java:154) | |
at freemarker.ext.jsp.TagTransformModel$TagWriter.onStart(TagTransformModel.java:367) | |
at freemarker.core.Environment.visitAndTransform(Environment.java:422) | |
at freemarker.core.UnifiedCall.accept(UnifiedCall.java:107) | |
at freemarker.core.Environment.visitByHiddingParent(Environment.java:345) | |
at freemarker.core.ConditionalBlock.accept(ConditionalBlock.java:48) | |
at freemarker.core.Environment.visit(Environment.java:324) | |
at freemarker.core.Macro$Context.runMacro(Macro.java:184) | |
at freemarker.core.Environment.invoke(Environment.java:701) | |
at freemarker.core.UnifiedCall.accept(UnifiedCall.java:84) | |
at freemarker.core.Environment.visit(Environment.java:324) | |
at freemarker.core.MixedContent.accept(MixedContent.java:54) | |
at freemarker.core.Environment.visitByHiddingParent(Environment.java:345) | |
at freemarker.core.ConditionalBlock.accept(ConditionalBlock.java:48) | |
at freemarker.core.Environment.visit(Environment.java:324) | |
at freemarker.core.MixedContent.accept(MixedContent.java:54) | |
at freemarker.core.Environment.visitByHiddingParent(Environment.java:345) | |
at freemarker.core.ConditionalBlock.accept(ConditionalBlock.java:48) | |
at freemarker.core.Environment.visit(Environment.java:324) | |
at freemarker.core.MixedContent.accept(MixedContent.java:54) | |
at freemarker.core.Environment.visit(Environment.java:324) | |
at freemarker.core.Environment.process(Environment.java:302) | |
at freemarker.template.Template.process(Template.java:325) | |
at com.liferay.portal.template.freemarker.internal.FreeMarkerTemplate.processTemplate(FreeMarkerTemplate.java:137) | |
at com.liferay.portal.template.BaseTemplate.processTemplate(BaseTemplate.java:127) | |
... 133 more | |
Caused by: javax.servlet.jsp.JspException: org.springframework.dao.InvalidDataAccessResourceUsageException: Could not execute JDBC batch update; SQL [insert into PortletPreferences (mvccVersion, companyId, ownerId, ownerType, plid, portletId, preferences, portletPreferencesId) values (?, ?, ?, ?, ?, ?, ?, ?)]; nested exception is org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update | |
at com.liferay.taglib.portletext.RuntimeTag.doEndTag(RuntimeTag.java:391) | |
at freemarker.ext.jsp.TagTransformModel$TagWriter.endEvaluation(TagTransformModel.java:400) | |
at freemarker.ext.jsp.TagTransformModel$TagWriter.onStart(TagTransformModel.java:344) | |
... 156 more | |
Caused by: org.springframework.dao.InvalidDataAccessResourceUsageException: Could not execute JDBC batch update; SQL [insert into PortletPreferences (mvccVersion, companyId, ownerId, ownerType, plid, portletId, preferences, portletPreferencesId) values (?, ?, ?, ?, ?, ?, ?, ?)]; nested exception is org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update | |
at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:643) | |
at org.springframework.orm.hibernate3.HibernateTransactionManager.convertHibernateAccessException(HibernateTransactionManager.java:800) | |
at org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:671) | |
at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:765) | |
at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:734) | |
at com.liferay.portal.spring.transaction.DefaultTransactionExecutor.commit(DefaultTransactionExecutor.java:41) | |
at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:77) | |
at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:57) | |
at com.liferay.portal.spring.aop.AopInvocationHandler.invoke(AopInvocationHandler.java:49) | |
at com.sun.proxy.$Proxy51.addPortletPreferences(Unknown Source) | |
at com.liferay.portal.service.impl.PortletPreferencesLocalServiceImpl.getPreferences(PortletPreferencesLocalServiceImpl.java:455) | |
at sun.reflect.GeneratedMethodAccessor185.invoke(Unknown Source) | |
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) | |
at java.lang.reflect.Method.invoke(Method.java:498) | |
at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:50) | |
at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:69) | |
at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:57) | |
at com.liferay.portal.spring.aop.RetryAdvice.invoke(RetryAdvice.java:99) | |
at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:57) | |
at com.liferay.portal.spring.aop.AopInvocationHandler.invoke(AopInvocationHandler.java:49) | |
at com.sun.proxy.$Proxy51.getPreferences(Unknown Source) | |
at com.liferay.portal.kernel.service.PortletPreferencesLocalServiceUtil.getPreferences(PortletPreferencesLocalServiceUtil.java:459) | |
at com.liferay.portlet.PortletPreferencesFactoryImpl.getLayoutPortletSetup(PortletPreferencesFactoryImpl.java:282) | |
at com.liferay.portlet.PortletPreferencesFactoryImpl.getLayoutPortletSetup(PortletPreferencesFactoryImpl.java:272) | |
at com.liferay.portal.kernel.portlet.PortletPreferencesFactoryUtil.getLayoutPortletSetup(PortletPreferencesFactoryUtil.java:89) | |
at com.liferay.taglib.portletext.RuntimeTag.doTag(RuntimeTag.java:308) | |
at com.liferay.taglib.portletext.RuntimeTag.doTag(RuntimeTag.java:94) | |
at com.liferay.taglib.portletext.RuntimeTag.doEndTag(RuntimeTag.java:372) | |
... 158 more | |
Caused by: org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update | |
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92) | |
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) | |
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275) | |
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:268) | |
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:184) | |
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321) | |
at com.liferay.portal.dao.orm.hibernate.event.NestableFlushEventListener.onFlush(NestableFlushEventListener.java:61) | |
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216) | |
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:383) | |
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:133) | |
at org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:663) | |
... 183 more | |
Caused by: java.sql.BatchUpdateException: Cannot insert duplicate key row in object 'dbo.PortletPreferences' with unique index 'IX_C7057FF7'. The duplicate key value is (0, 3, 40970, com_liferay_portal_search_web_search_bar_portlet_SearchBarPortlet_INSTANCE_templateSearch). | |
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeBatch(SQLServerPreparedStatement.java:1132) | |
at com.zaxxer.hikari.pool.ProxyStatement.executeBatch(ProxyStatement.java:125) | |
at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeBatch(HikariProxyPreparedStatement.java) | |
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70) | |
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268) | |
... 191 more |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment