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

Unable to manage portal instance when sharded databases are configured

    Details

    • Type: Bug
    • Status: Closed
    • Resolution: Duplicate
    • Affects Version/s: 6.1.0 CE RC1
    • Fix Version/s: --Sprint 11/12, 6.2.0 CE M2
    • Component/s: Legacy
    • Labels:
      None
    • Environment:
      RedHat Linux 5.7, jdk 1.6.0_21, Tomcat 7.0.23, MySQL server 5, 4 sharded databases

      Description

      Enable database sharding

      1. login and create an extra portal instance and point it to another db schema
      2. click on the name of the new created portal instance and you get a black screen

      with the following error in the log

      {nomarkup}
      22:00:03,392 ERROR [IncludeTag:426] Current URL /group/control_panel/manage?p_p_id=135&p_p_lifecycle=0&p_p_state=maximized&p_p_mode=view&doAsGroupId=10180&refererPlid=10183&_135_struts_action=%2Fadmin_instances%2Fedit_instance&_135_redirect=http%3A%2F%2Fliferay61.test001.communities.kluwer.nl%2Fgroup%2Fcontrol_panel%2Fmanage%3Fp_p_id%3D135%26p_p_lifecycle%3D0%26p_p_state%3Dmaximized%26p_p_mode%3Dview%26doAsGroupId%3D10180%26refererPlid%3D10183%26_135_refererPlid%3D10183%26_135_doAsGroupId%3D10180&_135_companyId=10619 generates exception: com.liferay.portal.NoSuchAccountException: No Account exists with the primary key 0
      22:00:03,394 ERROR [IncludeTag:154] com.liferay.portal.NoSuchAccountException: No Account exists with the primary key 0
      at com.liferay.portal.service.persistence.AccountPersistenceImpl.findByPrimaryKey(AccountPersistenceImpl.java:340)
      at com.liferay.portal.dao.shard.advice.ShardPersistenceAdvice.invoke(ShardPersistenceAdvice.java:102)
      at com.liferay.portal.service.impl.AccountLocalServiceImpl.getAccount(AccountLocalServiceImpl.java:37)
      at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:112)
      at com.liferay.portal.dao.shard.advice.ShardParameterAdvice.invoke(ShardParameterAdvice.java:54)
      at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:108)
      at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:71)
      at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:108)
      at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:59)
      at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:108)
      at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:59)
      at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:108)
      at com.liferay.portal.spring.aop.ServiceBeanAopProxy.invoke(ServiceBeanAopProxy.java:211)
      at com.liferay.portal.service.AccountLocalServiceUtil.getAccount(AccountLocalServiceUtil.java:263)
      at com.liferay.portal.model.impl.CompanyImpl.getAccount(CompanyImpl.java:74)
      at com.liferay.portal.model.impl.CompanyImpl.getName(CompanyImpl.java:129)
      at org.apache.jsp.html.portlet.admin.edit_005finstance_jsp._jspService(edit_005finstance_jsp.java:622)
      at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
      at com.liferay.portal.kernel.servlet.DirectRequestDispatcher.include(DirectRequestDispatcher.java:45){nomarkup}

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                1 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Days since last comment:
                  7 years, 38 weeks, 3 days ago

                  Packages

                  Version Package
                  --Sprint 11/12
                  6.2.0 CE M2