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

Users cannot be assigned to sites when users.search.with.index=false

    Details

    • Type: Regression Bug
    • Status: Verified
    • Resolution: Unresolved
    • Affects Version/s: 7.2.X, Master
    • Fix Version/s: None
    • Component/s: User Management
    • Labels:
      None
    • Fix Priority:
      3
    • Last Working Version:
    • Sprint:
      U&SM| S03 Sprint 30 | 8.18-31

      Description

      Steps to reproduce:

      1. Configure users.search.with.index=false
      2. Start up the application server
      3. Login as Administrator
      4. Go to Liferay > People > Site Memberships and click in the Plus button

      Expected result:

      • Users are shown to be selected

      Actual result:

      • An error message appears in the modal: "Site Memberships Portlets is temporarily unavailable"
      • An error message appears in the server logs:
        2020-06-26 08:57:57.668 ERROR [http-nio-17280-exec-3][render_portlet_jsp:131] null
        java.lang.IllegalArgumentException: Positional parameter does not exist: 13 in query: SELECT COUNT(userId) AS COUNT_VALUE FROM ((  SELECT DISTINCT User_.userId AS userId FROM User_  WHERE  (User_.companyId = ?) AND (User_.defaultUser = ?) AND ((LOWER(User_.firstName) LIKE ? OR ? IS NULL) AND (LOWER(User_.middleName) LIKE ? OR ? IS NULL) AND (LOWER(User_.lastName) LIKE ? OR ? IS NULL) AND (LOWER(User_.screenName) LIKE ? OR ? IS NULL) AND (LOWER(User_.emailAddress) LIKE ? OR ? IS NULL)) AND (User_.status = ?)   )) userId
        	at org.hibernate.impl.AbstractQueryImpl.setParameter(AbstractQueryImpl.java:382)
        	at org.hibernate.impl.AbstractQueryImpl.setInteger(AbstractQueryImpl.java:531)
        	at com.liferay.portal.dao.orm.hibernate.SQLQueryImpl.setInteger(SQLQueryImpl.java:304)
        	at com.liferay.portal.kernel.dao.orm.QueryPos.add(QueryPos.java:179)
        	at com.liferay.portal.service.persistence.impl.UserFinderImpl.countByC_FN_MN_LN_SN_EA_S(UserFinderImpl.java:596)
        	at com.liferay.portal.service.persistence.impl.UserFinderImpl.countByKeywords(UserFinderImpl.java:319)
        	at com.liferay.portal.service.impl.UserLocalServiceImpl.searchCount(UserLocalServiceImpl.java:3357)
        	at com.liferay.portal.kernel.bean.ClassLoaderBeanHandler.invoke(ClassLoaderBeanHandler.java:66)
        	at com.liferay.portal.kernel.service.UserLocalServiceWrapper.searchCount(UserLocalServiceWrapper.java:2507)
        	at com.liferay.portal.kernel.bean.ClassLoaderBeanHandler.invoke(ClassLoaderBeanHandler.java:66)
        	at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:50)
        	at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:69)
        	at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:57)
        	at com.liferay.portal.spring.aop.AopInvocationHandler.invoke(AopInvocationHandler.java:49)
        	at com.liferay.portal.kernel.service.UserLocalServiceUtil.searchCount(UserLocalServiceUtil.java:2330)
        	at com.liferay.site.memberships.web.internal.display.context.SelectUsersDisplayContext.getUserSearchContainer(SelectUsersDisplayContext.java:188)
        	at com.liferay.site.memberships.web.internal.display.context.SelectUsersManagementToolbarDisplayContext.<init>(SelectUsersManagementToolbarDisplayContext.java:40)
        	at org.apache.jsp.select_005fusers_jsp._jspService(select_005fusers_jsp.java:345)
        	at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:111)
        	at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
        
        

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Days since last comment:
                  13 hours, 8 minutes ago

                  Packages

                  Version Package