Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-82876

Update SampleSQLBuilder according to LPS-79882

    Details

    • Type: Bug
    • Status: Closed
    • Resolution: Fixed
    • Affects Version/s: Master
    • Fix Version/s: 7.1.X, Master
    • Component/s: Util
    • Labels:
      None

      Description

      After LPS-79882, NoSuchGroupException appeared when start portal with the data that generated by SampleSQLBuilder

      This root cause of this issue is SampleSQLBuilder does not generate any data for Group about groupKey is User Personal Site which is necessary for VerifyRole.addViewSiteAdministrationPermission(Role) which will be invoked by VerifyRole.doVerify().

      Before LPS-79882, these data will be populated by the VerifyGroup.verifyCompanyGroups(), but LPS-79882 removed the method verifyCompanyGroups() in VerifyGroup. 

      2018-06-12 07:57:20.534 ERROR [main][DBUpgrader:251] Unable to execute verify process: com.liferay.portal.verify.VerifyException: com.liferay.portal.kernel.exception.NoSuchGroupException: No Group exists with the key {companyId=143, groupKey=User Personal Site}
      com.liferay.portal.verify.VerifyException: com.liferay.portal.verify.VerifyException: com.liferay.portal.kernel.exception.NoSuchGroupException: No Group exists with the key {companyId=143, groupKey=User Personal Site}
      at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:75)
      at com.liferay.portal.verify.VerifyProcessUtil._verifyProcess(VerifyProcessUtil.java:113)
      at com.liferay.portal.verify.VerifyProcessUtil._verifyProcess(VerifyProcessUtil.java:78)
      at com.liferay.portal.verify.VerifyProcessUtil.verifyProcess(VerifyProcessUtil.java:47)
      at com.liferay.portal.events.StartupHelper.verifyProcess(StartupHelper.java:160)
      at com.liferay.portal.events.StartupHelperUtil.verifyProcess(StartupHelperUtil.java:91)
      at com.liferay.portal.tools.DBUpgrader.verify(DBUpgrader.java:245)
      at com.liferay.portal.events.StartupAction.doRun(StartupAction.java:240)
      at com.liferay.portal.events.StartupAction.run(StartupAction.java:83)
      at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:1335)
      at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:270)
      at javax.servlet.GenericServlet.init(GenericServlet.java:158)
      at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1124)
      at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1079)
      at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:971)
      at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4765)
      at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5075)
      at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
      at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:742)
      at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:718)
      at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:703)
      at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:630)
      at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1840)
      at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
      at java.util.concurrent.FutureTask.run(FutureTask.java:266)
      at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
      at java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:112)
      at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:525)
      at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:424)
      at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1586)
      at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:308)
      at org.apache.catalina.util.LifecycleBase.fireLifecycleEvent(LifecycleBase.java:123)
      at org.apache.catalina.util.LifecycleBase.setStateInternal(LifecycleBase.java:424)
      at org.apache.catalina.util.LifecycleBase.setState(LifecycleBase.java:367)
      at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:966)
      at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:839)
      at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
      at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1427)
      at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1417)
      at java.util.concurrent.FutureTask.run(FutureTask.java:266)
      at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
      at java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:134)
      at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:943)
      at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:258)
      at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
      at org.apache.catalina.core.StandardService.startInternal(StandardService.java:422)
      at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
      at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:770)
      at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
      at org.apache.catalina.startup.Catalina.start(Catalina.java:682)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      at java.lang.reflect.Method.invoke(Method.java:498)
      at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:353)
      at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:493)
      Caused by: com.liferay.portal.verify.VerifyException: com.liferay.portal.kernel.exception.NoSuchGroupException: No Group exists with the key {companyId=143, groupKey=User Personal Site}
      at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:75)
      at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:92)
      at com.liferay.portal.verify.VerifyProcessSuite.doVerify(VerifyProcessSuite.java:28)
      at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:72)
      ... 55 more
      Caused by: com.liferay.portal.kernel.exception.NoSuchGroupException: No Group exists with the key {companyId=143, groupKey=User Personal Site}
      at com.liferay.portal.service.persistence.impl.GroupPersistenceImpl.findByC_GK(GroupPersistenceImpl.java:3297)
      at com.liferay.portal.service.impl.GroupLocalServiceImpl.loadGetGroup(GroupLocalServiceImpl.java:2434)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      at java.lang.reflect.Method.invoke(Method.java:498)
      at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:158)
      at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:56)
      at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:135)
      at com.liferay.portal.spring.aop.ServiceBeanAopProxy.invoke(ServiceBeanAopProxy.java:145)
      at com.sun.proxy.$Proxy106.loadGetGroup(Unknown Source)
      at com.liferay.portal.service.impl.GroupLocalServiceImpl.getGroup(GroupLocalServiceImpl.java:1567)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      at java.lang.reflect.Method.invoke(Method.java:498)
      at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:158)
      at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:56)
      at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:135)
      at com.liferay.portal.spring.aop.ServiceBeanAopProxy.invoke(ServiceBeanAopProxy.java:145)
      at com.sun.proxy.$Proxy106.getGroup(Unknown Source)
      at com.liferay.portal.kernel.service.GroupLocalServiceUtil.getGroup(GroupLocalServiceUtil.java:637)
      at com.liferay.portal.verify.VerifyRole.addViewSiteAdministrationPermission(VerifyRole.java:42)
      at com.liferay.portal.verify.VerifyRole.verifyRoles(VerifyRole.java:80)
      at com.liferay.portal.verify.VerifyRole.doVerify(VerifyRole.java:68)
      at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:72)
      ... 58 more
      2018-06-12 07:57:20.535 ERROR [main][MainServlet:273] com.liferay.portal.kernel.events.ActionException: com.liferay.portal.verify.VerifyException: com.liferay.portal.verify.VerifyException: com.liferay.portal.kernel.exception.NoSuchGroupException: No Group exists with the key {companyId=143, groupKey=User Personal Site}
      com.liferay.portal.kernel.events.ActionException: com.liferay.portal.verify.VerifyException: com.liferay.portal.verify.VerifyException: com.liferay.portal.kernel.exception.NoSuchGroupException: No Group exists with the key {companyId=143, groupKey=User Personal Site}
      at com.liferay.portal.events.StartupAction.run(StartupAction.java:89)
      at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:1335)
      at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:270)
      at javax.servlet.GenericServlet.init(GenericServlet.java:158)
      at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1124)
      at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1079)
      at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:971)
      at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4765)
      at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5075)
      at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
      at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:742)
      at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:718)
      at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:703)
      at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:630)
      at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1840)
      at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
      at java.util.concurrent.FutureTask.run(FutureTask.java:266)
      at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
      at java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:112)
      at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:525)
      at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:424)
      at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1586)
      at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:308)
      at org.apache.catalina.util.LifecycleBase.fireLifecycleEvent(LifecycleBase.java:123)
      at org.apache.catalina.util.LifecycleBase.setStateInternal(LifecycleBase.java:424)
      at org.apache.catalina.util.LifecycleBase.setState(LifecycleBase.java:367)
      at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:966)
      at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:839)
      at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
      at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1427)
      at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1417)
      at java.util.concurrent.FutureTask.run(FutureTask.java:266)
      at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
      at java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:134)
      at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:943)
      at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:258)
      at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
      at org.apache.catalina.core.StandardService.startInternal(StandardService.java:422)
      at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
      at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:770)
      at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
      at org.apache.catalina.startup.Catalina.start(Catalina.java:682)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      at java.lang.reflect.Method.invoke(Method.java:498)
      at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:353)
      at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:493)
      Caused by: com.liferay.portal.verify.VerifyException: com.liferay.portal.verify.VerifyException: com.liferay.portal.kernel.exception.NoSuchGroupException: No Group exists with the key {companyId=143, groupKey=User Personal Site}
      at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:75)
      at com.liferay.portal.verify.VerifyProcessUtil._verifyProcess(VerifyProcessUtil.java:113)
      at com.liferay.portal.verify.VerifyProcessUtil._verifyProcess(VerifyProcessUtil.java:78)
      at com.liferay.portal.verify.VerifyProcessUtil.verifyProcess(VerifyProcessUtil.java:47)
      at com.liferay.portal.events.StartupHelper.verifyProcess(StartupHelper.java:160)
      at com.liferay.portal.events.StartupHelperUtil.verifyProcess(StartupHelperUtil.java:91)
      at com.liferay.portal.tools.DBUpgrader.verify(DBUpgrader.java:245)
      at com.liferay.portal.events.StartupAction.doRun(StartupAction.java:240)
      at com.liferay.portal.events.StartupAction.run(StartupAction.java:83)
      ... 47 more
      Caused by: com.liferay.portal.verify.VerifyException: com.liferay.portal.kernel.exception.NoSuchGroupException: No Group exists with the key {companyId=143, groupKey=User Personal Site}
      at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:75)
      at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:92)
      at com.liferay.portal.verify.VerifyProcessSuite.doVerify(VerifyProcessSuite.java:28)
      at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:72)
      ... 55 more
      Caused by: com.liferay.portal.kernel.exception.NoSuchGroupException: No Group exists with the key {companyId=143, groupKey=User Personal Site}
      at com.liferay.portal.service.persistence.impl.GroupPersistenceImpl.findByC_GK(GroupPersistenceImpl.java:3297)
      at com.liferay.portal.service.impl.GroupLocalServiceImpl.loadGetGroup(GroupLocalServiceImpl.java:2434)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      at java.lang.reflect.Method.invoke(Method.java:498)
      at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:158)
      at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:56)
      at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:135)
      at com.liferay.portal.spring.aop.ServiceBeanAopProxy.invoke(ServiceBeanAopProxy.java:145)
      at com.sun.proxy.$Proxy106.loadGetGroup(Unknown Source)
      at com.liferay.portal.service.impl.GroupLocalServiceImpl.getGroup(GroupLocalServiceImpl.java:1567)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      at java.lang.reflect.Method.invoke(Method.java:498)
      at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:158)
      at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:56)
      at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:135)
      at com.liferay.portal.spring.aop.ServiceBeanAopProxy.invoke(ServiceBeanAopProxy.java:145)
      at com.sun.proxy.$Proxy106.getGroup(Unknown Source)
      at com.liferay.portal.kernel.service.GroupLocalServiceUtil.getGroup(GroupLocalServiceUtil.java:637)
      at com.liferay.portal.verify.VerifyRole.addViewSiteAdministrationPermission(VerifyRole.java:42)
      at com.liferay.portal.verify.VerifyRole.verifyRoles(VerifyRole.java:80)
      at com.liferay.portal.verify.VerifyRole.doVerify(VerifyRole.java:68)
      at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:72)
      ... 58 more
      Stopping the server due to unexpected startup errors

        Attachments

          Activity

            People

            • Assignee:
              brian.chan Brian Chan
              Reporter:
              lily.chi Lily Chi
              Participants of an Issue:
              Recent user:
              Enterprise Release HU
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:
                Days since last comment:
                2 years, 6 weeks, 5 days ago

                Packages

                Version Package
                7.1.X
                Master