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

Cannot create virtual instance record after upgrading social office

    Details

      Description

      Description

      After upgrading Social Office from 6.2 to DXP, customer cannot create virtual instances record.

      Reproduction Steps

      1. Start up a vanilla Liferay 6.2 EE SP18 bundle
      2. Deploy Social Office EE.lpkg
      3. Create a new user and assign the user to Social Office User Role
      4. Shut down the portal and backup the database
      5. On master bundle, run the following command to do the upgrade from liferay_home/tools/portal-tools-db-upgrade-client

      java -jar com.liferay.portal.tools.db.upgrade.client.jar
      

      6 After the core upgrade completes, run social office upgrade following the documentation https://dev.liferay.com/discover/deployment/-/knowledge_base/7-0/upgrading-social-office.
      7. Copy portal-ext.properties from Liferay 6.2 and paste it to Liferay_Home in DXP
      8. Start master bundle
      9. Deploy com.liferay.social.office.upgrade.jar and com.liferay.social.office.upgrade.association.jar to deploy folder
      10. Open Gogo shell by running "telnet localhost 11311"
      11. Run "socialOffice:executeAll"
      12. After the upgrade is completed, navigate to Control Panel > Configuration > Server Administration > Reindex all search indexes and click "Execute"
      13. Navigate to Control Panel > Configuration > Virtual Instances and add a new instance
      Actual Result:

      "Portlet is temporarily unavailable" shows on UI.

      The error "No ExpandoTable exists with the key" is thrown.

      07:19:56,043 ERROR [http-nio-8080-exec-9][PortletServlet:112] javax.portlet.PortletException: com.liferay.portal.kernel.exception.ModelListenerException: com.liferay.expando.kernel.exception.NoSuchTableException: No ExpandoTable exists with the key {companyId=25668, classNameId=20001, name=CUSTOM_FIELDS}
      javax.portlet.PortletException: com.liferay.portal.kernel.exception.ModelListenerException: com.liferay.expando.kernel.exception.NoSuchTableException: No ExpandoTable exists with the key {companyId=25668, classNameId=20001, name=CUSTOM_FIELDS}
      	at com.liferay.portal.kernel.portlet.bridges.mvc.BaseMVCActionCommand.processAction(BaseMVCActionCommand.java:69)
      	at com.liferay.portal.kernel.portlet.bridges.mvc.MVCPortlet.callActionMethod(MVCPortlet.java:380)
      	at com.liferay.portal.kernel.portlet.LiferayPortlet.processAction(LiferayPortlet.java:93)
      	at com.liferay.portal.kernel.portlet.bridges.mvc.MVCPortlet.processAction(MVCPortlet.java:260)
      	at com.liferay.portlet.FilterChainImpl.doFilter(FilterChainImpl.java:71)
      	at com.liferay.portal.kernel.portlet.PortletFilterUtil.doFilter(PortletFilterUtil.java:48)
      	at com.liferay.portal.kernel.servlet.PortletServlet.service(PortletServlet.java:108)
      ......
      

      Expected Result: No error occurs and record is created successfully.

        Attachments

          Activity

            People

            Assignee:
            summer.zhang Summer Zhang
            Reporter:
            hai.yu Hai Yu
            Participants of an Issue:
            Recent user:
            Jason Pince
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

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

                Packages

                Version Package
                7.0.X EE
                7.1.X
                Master