[LPS-43533] Add a site using Site Template with Panel type page cause IllegalArgumentException - Liferay Issues

Details

Type: Regression Bug
Status: Closed
Resolution: Fixed
Affects Version/s: 7.0.0 M3
Fix Version/s: 6.2.2 CE GA3 , 6.2.X EE, 7.0.0 M1
Component/s: Site Templates
Labels:
Environment:
Tomcat 7.0 + MySQL 5. Portal master GIT ID: adf9b4fecd813aea2e3d97e174a187ee197eb9cd.

Branch Version/s:

6.2.x
Backported to Branch:

Committed
Story Points:
6
Fix Priority:
4
Git Pull Request:
https://github.com/hhuijser/liferay-portal/pull/1673

Description

Admin -> Control Panel -> Site Templates.
Manage Community/Intranet Site -> add a page with Panel type -> Flag the wiki/collaboration folder.
Add a site with newly updated site Template.

Expected result:
It should be no exception in the console.

Actual result:
Console will throw exception.

05:50:04,780 ERROR [http-bio-8080-exec-4][BasePersistenceImpl:244] Caught unexpected exception java.lang.IllegalArgumentException
05:50:04,788 ERROR [http-bio-8080-exec-4][SitesImpl:1279] com.liferay.portal.kernel.exception.SystemException: java.lang.IllegalArgumentException: Positional parameter does not exist: 10 in query: SELECT resourcePermission FROM ResourcePermission resourcePermission WHERE (resourcePermission.companyI
d = ?) AND ((resourcePermission.name IS NULL OR resourcePermission.name = '')) AND (resourcePermission.scope = ?) AND (resourcePermission.primKey = ?) AND ((resourcePermission.roleId = ?) OR (resourcePermission.roleId = ?) OR (resourcePermission.roleId = ?) OR (resourcePermission.roleId = ?) OR (res
ourcePermission.roleId = ?) OR (resourcePermission.roleId = ?) OR (resourcePermission.roleId = ?))
com.liferay.portal.kernel.exception.SystemException: java.lang.IllegalArgumentException: Positional parameter does not exist: 10 in query: SELECT resourcePermission FROM ResourcePermission resourcePermission WHERE (resourcePermission.companyId = ?) AND ((resourcePermission.name IS NULL OR resourcePe
rmission.name = '')) AND (resourcePermission.scope = ?) AND (resourcePermission.primKey = ?) AND ((resourcePermission.roleId = ?) OR (resourcePermission.roleId = ?) OR (resourcePermission.roleId = ?) OR (resourcePermission.roleId = ?) OR (resourcePermission.roleId = ?) OR (resourcePermission.roleId
= ?) OR (resourcePermission.roleId = ?))
        at com.liferay.portal.service.persistence.impl.BasePersistenceImpl.processException(BasePersistenceImpl.java:251)
        at com.liferay.portal.service.persistence.ResourcePermissionPersistenceImpl.findByC_N_S_P_R(ResourcePermissionPersistenceImpl.java:3512)
        at com.liferay.portal.service.persistence.ResourcePermissionPersistenceImpl.findByC_N_S_P_R(ResourcePermissionPersistenceImpl.java:3275)
        at com.liferay.portal.service.impl.ResourcePermissionLocalServiceImpl.getAvailableResourcePermissionActionIds(ResourcePermissionLocalServiceImpl.java:384)
        at sun.reflect.GeneratedMethodAccessor1076.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:115)
        at com.liferay.portal.spring.transaction.DefaultTransactionExecutor.execute(DefaultTransactionExecutor.java:62)
        at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:55)
        at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:111)
        at com.liferay.portal.spring.aop.ServiceBeanAopProxy.invoke(ServiceBeanAopProxy.java:175)
        at $Proxy86.getAvailableResourcePermissionActionIds(Unknown Source)
        at com.liferay.portal.service.ResourcePermissionLocalServiceUtil.getAvailableResourcePermissionActionIds(ResourcePermissionLocalServiceUtil.java:444)
        at com.liferay.portal.lar.PermissionExporter.exportPermissions(PermissionExporter.java:96)
        at com.liferay.portal.lar.PermissionExporter.exportPortletPermissions(PermissionExporter.java:184)
        at com.liferay.portal.lar.PortletExporter.exportPortlet(PortletExporter.java:1089)
        at com.liferay.portal.lar.LayoutExporter.doExportLayoutsAsFile(LayoutExporter.java:529)
        at com.liferay.portal.lar.LayoutExporter.exportLayoutsAsFile(LayoutExporter.java:219)
        at com.liferay.portal.service.impl.LayoutLocalServiceImpl.exportLayoutsAsFile(LayoutLocalServiceImpl.java:875)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:115)
        at com.liferay.portal.service.impl.LayoutLocalServiceVirtualLayoutsAdvice.invoke(LayoutLocalServiceVirtualLayoutsAdvice.java:65)
        at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:111)
        at com.liferay.portal.service.impl.LayoutLocalServiceStagingAdvice.invoke(LayoutLocalServiceStagingAdvice.java:140)
        at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:111)
        at com.liferay.portal.spring.transaction.DefaultTransactionExecutor.execute(DefaultTransactionExecutor.java:62)
        at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:55)
        at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:111)
        at com.liferay.portal.spring.aop.ServiceBeanAopProxy.invoke(ServiceBeanAopProxy.java:175)
        at $Proxy31.exportLayoutsAsFile(Unknown Source)
        at com.liferay.portal.service.LayoutLocalServiceUtil.exportLayoutsAsFile(LayoutLocalServiceUtil.java:707)
        at com.liferay.portlet.sites.util.SitesImpl.importLayoutSetPrototype(SitesImpl.java:1807)
        at com.liferay.portlet.sites.util.SitesImpl.mergeLayoutSetPrototypeLayouts(SitesImpl.java:1274)
        at com.liferay.portlet.sites.util.SitesUtil.mergeLayoutSetPrototypeLayouts(SitesUtil.java:284)
        at com.liferay.portal.service.impl.LayoutLocalServiceVirtualLayoutsAdvice.mergeLayoutSetPrototypeLayouts(LayoutLocalServiceVirtualLayoutsAdvice.java:295)
        at com.liferay.portal.service.impl.LayoutLocalServiceVirtualLayoutsAdvice.invoke(LayoutLocalServiceVirtualLayoutsAdvice.java:135)
        at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:111)
        at com.liferay.portal.service.impl.LayoutLocalServiceStagingAdvice.invoke(LayoutLocalServiceStagingAdvice.java:178)
        at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:111)
        at com.liferay.portal.spring.transaction.DefaultTransactionExecutor.execute(DefaultTransactionExecutor.java:62)
        at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:55)
        at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:111)
        at com.liferay.portal.spring.aop.ServiceBeanAopProxy.invoke(ServiceBeanAopProxy.java:175)
        at $Proxy31.getLayouts(Unknown Source)
        at com.liferay.portal.service.LayoutLocalServiceUtil.getLayouts(LayoutLocalServiceUtil.java:979)
        at org.apache.jsp.html.portlet.sites_005fadmin.site.details_jsp._jspService(details_jsp.java:807)
        at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
        at com.liferay.portal.servlet.DirectRequestDispatcher.include(DirectRequestDispatcher.java:57)
        at com.liferay.portal.servlet.ClassLoaderRequestDispatcherWrapper.doDispatch(ClassLoaderRequestDispatcherWrapper.java:78)
        at com.liferay.portal.servlet.ClassLoaderRequestDispatcherWrapper.include(ClassLoaderRequestDispatcherWrapper.java:53)
        at com.liferay.taglib.util.IncludeTag.include(IncludeTag.java:295)
        at com.liferay.taglib.util.IncludeTag.doInclude(IncludeTag.java:192)
        at com.liferay.taglib.util.IncludeTag.doEndTag(IncludeTag.java:83)
        at org.apache.jsp.html.taglib.ui.form_005fnavigator.page_jsp._jspService(page_jsp.java:1008)
        at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
        at com.liferay.portal.servlet.DirectRequestDispatcher.include(DirectRequestDispatcher.java:57)
        at com.liferay.portal.servlet.ClassLoaderRequestDispatcherWrapper.doDispatch(ClassLoaderRequestDispatcherWrapper.java:78)
        at com.liferay.portal.servlet.ClassLoaderRequestDispatcherWrapper.include(ClassLoaderRequestDispatcherWrapper.java:53)
        at com.liferay.taglib.util.IncludeTag.include(IncludeTag.java:295)
        at com.liferay.taglib.util.IncludeTag.doInclude(IncludeTag.java:192)
        at com.liferay.taglib.util.IncludeTag.doEndTag(IncludeTag.java:83)
        at org.apache.jsp.html.portlet.sites_005fadmin.edit_005fsite_jsp._jspService(edit_005fsite_jsp.java:1077)
        at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
        at com.liferay.portal.servlet.DirectRequestDispatcher.include(DirectRequestDispatcher.java:57)
        at com.liferay.portal.servlet.ClassLoaderRequestDispatcherWrapper.doDispatch(ClassLoaderRequestDispatcherWrapper.java:78)
        at com.liferay.portal.servlet.ClassLoaderRequestDispatcherWrapper.include(ClassLoaderRequestDispatcherWrapper.java:53)
        at com.liferay.taglib.util.IncludeTag.include(IncludeTag.java:295)
        at com.liferay.taglib.util.IncludeTag.doInclude(IncludeTag.java:192)
        at com.liferay.taglib.util.IncludeTag.doEndTag(IncludeTag.java:83)
        at org.apache.jsp.html.common.themes.portlet_jsp._jspService(portlet_jsp.java:3810)
        at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
        at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)
        at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)
        at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
        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:97)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
        at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:749)
        at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:605)
        at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:544)
        at com.liferay.portlet.PortletRequestDispatcherImpl.dispatch(PortletRequestDispatcherImpl.java:331)
        at com.liferay.portlet.PortletRequestDispatcherImpl.include(PortletRequestDispatcherImpl.java:128)
        at com.liferay.portal.struts.PortletRequestProcessor.doInclude(PortletRequestProcessor.java:370)
        at com.liferay.portal.struts.PortletRequestProcessor.doForward(PortletRequestProcessor.java:338)
        at org.apache.struts.tiles.TilesRequestProcessor.processTilesDefinition(TilesRequestProcessor.java:239)
        at org.apache.struts.tiles.TilesRequestProcessor.processForwardConfig(TilesRequestProcessor.java:302)
        at com.liferay.portal.struts.PortletRequestProcessor.processForwardConfig(PortletRequestProcessor.java:478)
        at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:241)
        at com.liferay.portal.struts.PortletRequestProcessor.process(PortletRequestProcessor.java:234)
        at com.liferay.portlet.StrutsPortlet.include(StrutsPortlet.java:296)
        at com.liferay.portlet.StrutsPortlet.doView(StrutsPortlet.java:157)
        at com.liferay.portal.kernel.portlet.LiferayPortlet.doDispatch(LiferayPortlet.java:213)
        at javax.portlet.GenericPortlet.render(GenericPortlet.java:233)
        at com.liferay.portlet.FilterChainImpl.doFilter(FilterChainImpl.java:103)
        at com.liferay.portlet.ScriptDataPortletFilter.doFilter(ScriptDataPortletFilter.java:55)
        at com.liferay.portlet.FilterChainImpl.doFilter(FilterChainImpl.java:100)
        at com.liferay.portal.kernel.portlet.PortletFilterUtil.doFilter(PortletFilterUtil.java:64)
        at com.liferay.portlet.InvokerPortletImpl.invoke(InvokerPortletImpl.java:618)
        at com.liferay.portlet.InvokerPortletImpl.invokeRender(InvokerPortletImpl.java:677)
        at com.liferay.portlet.InvokerPortletImpl.render(InvokerPortletImpl.java:379)
        at org.apache.jsp.html.portal.render_005fportlet_jsp._jspService(render_005fportlet_jsp.java:1233)
        at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
        at com.liferay.portal.servlet.DirectRequestDispatcher.include(DirectRequestDispatcher.java:57)
        at com.liferay.portal.servlet.ClassLoaderRequestDispatcherWrapper.doDispatch(ClassLoaderRequestDispatcherWrapper.java:78)
        at com.liferay.portal.servlet.ClassLoaderRequestDispatcherWrapper.include(ClassLoaderRequestDispatcherWrapper.java:53)
        at com.liferay.portlet.PortletContainerImpl._doRender(PortletContainerImpl.java:655)
        at com.liferay.portlet.PortletContainerImpl.render(PortletContainerImpl.java:138)
        at com.liferay.portlet.SecurityPortletContainerWrapper.render(SecurityPortletContainerWrapper.java:141)
        at com.liferay.portlet.RestrictPortletContainerWrapper.render(RestrictPortletContainerWrapper.java:126)
        at com.liferay.portal.kernel.portlet.PortletContainerUtil.render(PortletContainerUtil.java:156)
        at com.liferay.portal.layoutconfiguration.util.velocity.TemplateProcessor.processMax(TemplateProcessor.java:168)
        at sun.reflect.GeneratedMethodAccessor1080.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.doInvoke(UberspectImpl.java:389)
        at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:378)
        at org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:270)
        at org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:262)
        at org.apache.velocity.runtime.parser.node.ASTReference.render(ASTReference.java:342)
        at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:336)
        at org.apache.velocity.Template.merge(Template.java:328)
        at org.apache.velocity.Template.merge(Template.java:235)
        at com.liferay.portal.velocity.VelocityTemplate.processTemplate(VelocityTemplate.java:112)
        at com.liferay.portal.template.AbstractTemplate.processTemplate(AbstractTemplate.java:108)
        at com.liferay.portal.layoutconfiguration.util.RuntimePageImpl.doProcessTemplate(RuntimePageImpl.java:375)
        at com.liferay.portal.layoutconfiguration.util.RuntimePageImpl.doDispatch(RuntimePageImpl.java:284)
        at com.liferay.portal.layoutconfiguration.util.RuntimePageImpl.getProcessedTemplate(RuntimePageImpl.java:96)
        at com.liferay.portal.layoutconfiguration.util.RuntimePageUtil.getProcessedTemplate(RuntimePageUtil.java:38)
        at org.apache.jsp.html.portal.layout.view.control_005fpanel_jsp._jspService(control_005fpanel_jsp.java:1410)
        at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
        at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)
        at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)
        at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
        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:97)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
        at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:749)

Attachments

Issue Links

is caused by

LPS-32141 No need to bind blank string query parameter, it can be embeded into SQL string

Closed

is duplicated by

LPS-45735 Finder method with array parameter throws IllegalArgumentException for empty string element

Closed

relates

LPE-11801 Adding a site using a Site Template with a "Panel" type page throws an IllegalArgumentException in the platform

Closed

LPS-43734 Create unit test coverage for persistence finder methods

Closed

LPE-11889 Add a site using Site Template with Panel type page cause IllegalArgumentException - asset-framework component

Closed

LPE-11890 Creating a site using a site template with panel type causes a Illegal Argument Exception

Closed

LPE-11891 Adding a site using a Site Template with a "Panel" type page throws an IllegalArgumentException - development component

Closed

(2 relates)

Add a site using Site Template with Panel type page cause IllegalArgumentException

Details

Description

Attachments

Issue Links

Activity

People

Dates

Packages

Version	Package
6.2.2 CE GA3
6.2.X EE
7.0.0 M1