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

None of the user-related options are working in case "com.liferay.social.office.upgrade.association-1.0.4.jar" is deployed

    Details

    • Fix Priority:
      4

      Description

      Reproduction steps

      Case 1

      1) Startup Liferay (DXP with the client's patch level: de-31-7010)
      2) Deploy "com.liferay.social.office.upgrade.association-1.0.4.jar"
      3) Create new Role with name and title "Social Office User"
      4) Tried to create user, received error on portal:
      Portlet is temporarily unavailable.
      (In the logs:

       Caused by: com.liferay.portal.kernel.exception.ModelListenerException: com.liferay.expando.kernel.exception.NoSuchTableException: No ExpandoTable exists with the key
      
      \{companyId=20116, classNameId=20045, name=CUSTOM_FIELDS
      

      5) As could not create new user, used the admin one 'Test Test', tried to add the role 'Social Office User' .
      The following error came on portal: Portlet is temporarily unavailable.
      (In the logs I could see:

       javax.portlet.PortletException: com.liferay.portal.kernel.exception.ModelListenerException: com.liferay.expando.kernel.exception.NoSuchTableException: No ExpandoTable exists with the key \{companyId=20116, classNameId=20045, name=CUSTOM_FIELDS}
      

      )

      Case 2

      1) Startup Liferay (DXP with your patch level: de-31-7010)
      2) Add a new user 'football_star'
      3) Restart Liferay
      4) Deploy "com.liferay.social.office.upgrade.association-1.0.4.jar"
      5) Role was already created in the previous test (Case 1) in point 3 ( after"com.liferay.social.office.upgrade.association-1.0.4.jar" was deployed )
      6) Tried to add role "Social Office User" to the account 'football_star'
      received error on portal:
       Portlet is temporarily unavailable.
      (In the logs:

       Caused by: com.liferay.portal.kernel.exception.ModelListenerException: com.liferay.expando.kernel.exception.NoSuchTableException: No ExpandoTable exists with the key
      
      \{companyId=20116, classNameId=20045, name=CUSTOM_FIELDS}
       at com.liferay.social.office.upgrade.association.internal.model.listener.GroupModelListener.onAfterUpdate(GroupModelListener.java:44)
       at com.liferay.social.office.upgrade.association.internal.model.listener.GroupModelListener.onAfterUpdate(GroupModelListener.java:35)
       at com.liferay.portal.kernel.service.persistence.impl.BasePersistenceImpl.update(BasePersistenceImpl.java:353)
       at com.liferay.portal.service.impl.UserLocalServiceImpl.updateUser(UserLocalServiceImpl.java:5371)
       7) tried to deactivate user 'football_star'
       error on portal:
       Portlet is temporarily unavailable.
       error in the logs:
       com.liferay.expando.kernel.exception.NoSuchTableException: No ExpandoTable exists with the key \{companyId=20116, classNameId=20045, name=CUSTOM_FIELDS}
      
      at com.liferay.portlet.expando.service.persistence.impl.ExpandoTablePersistenceImpl.findByC_C_N(ExpandoTablePersistenceImpl.java:683)
       at com.liferay.portlet.expando.service.impl.ExpandoTableLocalServiceImpl.getTable(ExpandoTableLocalServiceImpl.java:205)
       at com.liferay.portlet.expando.service.impl.ExpandoTableLocalServiceImpl.getTable(ExpandoTableLocalServiceImpl.java:215)
      

      8) As user could not be deactivated, cannot delete it either

      Based on the investigation up to now, it seems that none of the reported user-related options are working in case "com.liferay.social.office.upgrade.association-1.0.4.jar" is deployed. These options are:
      -user creation
      -role assignment
      -user deactivation
      -user deletion( as use deactivation fails already)

      Download jar file

      Location of the "com.liferay.social.office.upgrade.association-1.0.4.jar": https://repository.liferay.com/nexus/content/repositories/liferay-public-releases/com/liferay/com.liferay.social.office.upgrade.association/1.0.4/

      Reproduced

       DXP de-31-7010
      7.0.x  commit 21f699679e97e0472987ad88ef6fb7d9da923b78//2017-10-05
       


      Related
      https://web.liferay.com/group/customer/products/social-office-upgrade
      https://customer.liferay.com/documentation/7.0/deploy/-/official_documentation/deployment/upgrading-social-office

        Attachments

          Activity

            People

            • Assignee:
              norbert.kocsis Norbert Kocsis
              Reporter:
              amadea.fejes Amadea Fejes (Inactive)
              Participants of an Issue:
              Recent user:
              Enterprise Release HU
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:
                Days since last comment:
                2 years, 4 weeks, 1 day ago

                Packages

                Version Package