Existing users not listed in the control panel user tab in 6.2

[Ankur Jaswal, modifié il y a 9 années.]

We are not able to see any existing users in the control panel user tab after migrating from 6.0 to 6.2 EE. We tried to run re-indexing through
Control Panel >> Server Administration >> Reindex all search indexes, but got the below exception.

16:19:08,526 ERROR [http-bio-12030-exec-52][LuceneIndexer:145] Error encountered while reindexing
com.liferay.portal.kernel.search.SearchException: com.liferay.portal.NoSuchUserException: No User exists with the key {contactId=77954}
at com.liferay.portal.kernel.search.BaseIndexer.getDocument(BaseIndexer.java:177)
at com.liferay.portlet.usersadmin.util.ContactIndexer$1.performAction(ContactIndexer.java:203)
at com.liferay.portal.kernel.dao.orm.BaseActionableDynamicQuery.performActionsInSingleInterval(BaseActionableDynamicQuery.java:317)
at com.liferay.portal.kernel.dao.orm.BaseActionableDynamicQuery.performActions(BaseActionableDynamicQuery.java:46)
at com.liferay.portlet.usersadmin.util.ContactIndexer.reindexContacts(ContactIndexer.java:215)
at com.liferay.portlet.usersadmin.util.ContactIndexer.doReindex(ContactIndexer.java:185)
at com.liferay.portal.kernel.search.BaseIndexer.reindex(BaseIndexer.java:455)
at com.liferay.portal.search.lucene.LuceneIndexer.reindex(LuceneIndexer.java:168)
at com.liferay.portal.search.lucene.LuceneIndexer.doReIndex(LuceneIndexer.java:134)
at com.liferay.portal.search.lucene.LuceneIndexer.reindex(LuceneIndexer.java:64)
at com.liferay.portal.search.lucene.LuceneIndexer.reindex(LuceneIndexer.java:57)
at com.liferay.portlet.admin.action.EditServerAction.reindex(EditServerAction.java:384)
at com.liferay.portlet.admin.action.EditServerAction.processAction(EditServerAction.java:199)
at com.liferay.portal.struts.PortletRequestProcessor.process(PortletRequestProcessor.java:166)
at com.liferay.portlet.StrutsPortlet.processAction(StrutsPortlet.java:216)
at com.liferay.portlet.FilterChainImpl.doFilter(FilterChainImpl.java:71)
at com.liferay.portal.kernel.portlet.PortletFilterUtil.doFilter(PortletFilterUtil.java:48)
at com.liferay.portlet.InvokerPortletImpl.invoke(InvokerPortletImpl.java:618)
at com.liferay.portlet.InvokerPortletImpl.invokeAction(InvokerPortletImpl.java:649)
at com.liferay.portlet.InvokerPortletImpl.processAction(InvokerPortletImpl.java:312)
at com.liferay.portlet.PortletContainerImpl._doProcessAction(PortletContainerImpl.java:402)
at com.liferay.portlet.PortletContainerImpl.processAction(PortletContainerImpl.java:110)
at com.liferay.portlet.SecurityPortletContainerWrapper.processAction(SecurityPortletContainerWrapper.java:109)
at com.liferay.portlet.RestrictPortletContainerWrapper.processAction(RestrictPortletContainerWrapper.java:75)
at com.liferay.portal.kernel.portlet.PortletContainerUtil.processAction(PortletContainerUtil.java:115)
at com.liferay.portal.action.LayoutAction.processLayout(LayoutAction.java:381)
at com.liferay.portal.action.LayoutAction.doExecute(LayoutAction.java:203)
at com.liferay.portal.action.LayoutAction.execute(LayoutAction.java:95)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
at com.liferay.portal.struts.PortalRequestProcessor.process(PortalRequestProcessor.java:178)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
at com.liferay.portal.servlet.MainServlet.callParentService(MainServlet.java:549)
at com.liferay.portal.servlet.MainServlet.service(MainServlet.java:526)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:116)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:169)
at com.liferay.portal.servlet.filters.secure.SecureFilter.processFilter(SecureFilter.java:293)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:59)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:204)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:109)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:169)
at com.liferay.portal.servlet.filters.jsoncontenttype.JSONContentTypeFilter.processFilter(JSONContentTypeFilter.java:42)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:59)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:204)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:109)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilter.doFilter(InvokerFilter.java:96)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:749)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:487)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:412)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:339)
at com.liferay.portal.servlet.FriendlyURLServlet.service(FriendlyURLServlet.java:162)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:116)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:169)
at com.liferay.portal.servlet.filters.strip.StripFilter.processFilter(StripFilter.java:359)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:59)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:204)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:109)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:169)
at com.liferay.portal.servlet.filters.gzip.GZipFilter.processFilter(GZipFilter.java:123)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:59)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:204)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:109)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:169)
at com.liferay.portal.servlet.filters.secure.SecureFilter.processFilter(SecureFilter.java:293)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:59)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:204)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:109)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:169)
at com.liferay.portal.servlet.filters.i18n.I18nFilter.processFilter(I18nFilter.java:243)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:59)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:204)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:109)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:169)
at com.liferay.portal.servlet.filters.etag.ETagFilter.processFilter(ETagFilter.java:86)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:59)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:204)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:109)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:169)
at com.liferay.portal.servlet.filters.jsoncontenttype.JSONContentTypeFilter.processFilter(JSONContentTypeFilter.java:42)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:59)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:204)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:109)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:169)
at com.liferay.portal.servlet.filters.autologin.AutoLoginFilter.processFilter(AutoLoginFilter.java:267)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:59)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:204)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:109)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:169)
at com.liferay.portal.servlet.filters.sso.ntlm.NtlmPostFilter.processFilter(NtlmPostFilter.java:83)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:59)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:204)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:109)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:169)
at com.liferay.portal.sharepoint.SharepointFilter.processFilter(SharepointFilter.java:88)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:59)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:204)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:109)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:169)
at com.liferay.portal.servlet.filters.virtualhost.VirtualHostFilter.processFilter(VirtualHostFilter.java:226)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:59)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:204)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:109)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDirectCallFilter(InvokerFilterChain.java:185)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:96)
at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:738)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:204)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:109)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDirectCallFilter(InvokerFilterChain.java:165)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:96)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDirectCallFilter(InvokerFilterChain.java:165)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:96)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDirectCallFilter(InvokerFilterChain.java:185)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:96)
at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilter.doFilter(InvokerFilter.java:96)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
Caused by: com.liferay.portal.NoSuchUserException: No User exists with the key {contactId=77954}
at com.liferay.portal.service.persistence.UserPersistenceImpl.findByContactId(UserPersistenceImpl.java:1711)
at com.liferay.portal.service.impl.UserLocalServiceImpl.getUserByContactId(UserLocalServiceImpl.java:2628)
at sun.reflect.GeneratedMethodAccessor1386.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:115)
at com.liferay.portal.spring.transaction.DefaultTransactionExecutor.execute(DefaultTransactionExecutor.java:62)
at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:51)
at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:111)
at com.liferay.portal.spring.aop.ServiceBeanAopProxy.invoke(ServiceBeanAopProxy.java:175)
at com.sun.proxy.$Proxy106.getUserByContactId(Unknown Source)
at com.liferay.portal.service.UserLocalServiceUtil.getUserByContactId(UserLocalServiceUtil.java:2093)
at com.liferay.portlet.usersadmin.util.ContactIndexer.doGetDocument(ContactIndexer.java:108)
at com.liferay.portal.kernel.search.BaseIndexer.getDocument(BaseIndexer.java:149)
... 139 more

[David H Nebinger, modifié il y a 9 années.]

This is indicative of a problem that occurred during your upgrade. Were there errors in the logs during the upgrade?

[Nagendra Kumar Busam, modifié il y a 9 années.]

Trying running below query, it seems some records become stale during your upgrade process (might be some errors during upgrade process as David pointed)

SELECT c.*
FROM Contact_ AS c
LEFT JOIN User_ AS u ON u.userId= c.userId
WHERE
u.userId IS NULL;

[Wouter Vernaillen, modifié il y a 9 années.]

We ran into the same issue after upgrading from Liferay 6.0.6 to Liferay 6.2.1.

In the contact table we have more then 13000 records that are not linked to a user:

SELECT c.* FROM Contact_ AS c LEFT JOIN User_ AS u ON u.contactId= c.contactId WHERE u.userId IS NULL

These unlinked contact records were already there in the Liferay 6.0.6 database, but it's only after the upgrade that it is causing a problem when running the indexer.

For all these unlinked contact records there is always a correct record as well that is correctly linked to a user. The created date of the unlinked contact records is always within minutes to an hour before the created date of the user.

Any idea on why these contact records were created (in Liferay 6.0.6) even before the user record was inserted?

Would it be safe to just delete all the unlinked contact records?

[Wouter Vernaillen, modifié il y a 9 années.]

After some investigation we guess that the situation was caused by this bug in Liferay 6.0.6: https://issues.liferay.com/browse/LPS-13444

We were actually using that method UserLocalServiceUtil.deleteUser(User) in out code.

I guess it's safe to asusme that we can delete the unlinked Contact, Phone and Address records from the database?

[David H Nebinger, modifié il y a 9 années.]

Wouter Vernaillen:

I guess it's safe to asusme that we can delete the unlinked Contact, Phone and Address records from the database?

When it comes to the Liferay database, I assume nothing and actually try to avoid doing anything to it for fear of breaking the environment.

I would say as long as you have a good backup (database and data dir), you can give it a try. At least that way you'll be able to get back to a known good point should something go awry...

[Wouter Vernaillen, modifié il y a 9 années.]

Thanks for your reply, David.

In fact our environment is broken already because the bug in Liferay 6.0.6 caused a lot of ghost data and this makes the user indexing fail after upgrading to Liferay 6.2.1.

We made a copy of our production db to our test environment and are now in process of cleaning up ghost data in 5 tables (Group_, Contact, Phone, Address and AnnouncementsDelivery).
After that we'll test the functionality thoroughly.

[David H Nebinger, modifié il y a 9 années.]

If at all possible, I'd recommend stepping up to EE. EE gets regular patches and bug fixes, so while that bug remained in 6.0.6 CE it was fixed in EE and may have simplified your upgrade process.

People don't always know it, but CE is not always the best choice for a Liferay production environment. Sure it is "free", but it ends up costing you a lot in your self-support needs...

[michele guarnaccia, modifié il y a 8 années.]

Hi, it's a bit late but i'm facing the same issue on 6.2-ga2 CE.
No solutions till now, but i've noticed that when a user edits his account data, then is shown again in the user-list.

Hope this helps.

[srini vasulu, modifié il y a 7 années.]

michele guarnaccia:

Hi, it's a bit late but i'm facing the same issue on 6.2-ga2 CE.
No solutions till now, but i've noticed that when a user edits his account data, then is shown again in the user-list.

Hope this helps.

Hi Michele,
I am also facing same issue. first users are not showing in user tab. After saving the my account then i am able to see.
but when i run the reindex all getting the issue :: com.liferay.portal.NoSuchUserException: No User exists with the key {contactId=825999} and it's stopping the reindex , verified the data base and found the one user id is showing to multiple contactid's and looks like user_ table and contact_ table upgrade is not happening properly.

is there any solutions for this issues?.

[m g, modifié il y a 7 années.]

m g:

Hi, it's a bit late but i'm facing the same issue on 6.2-ga2 CE.
No solutions till now, but i've noticed that when a user edits his account data, then is shown again in the user-list.

Hope this helps.

It's again a bit late, but my problem was that i wasn't updating my users data properly. The solution was adding the following line to my code:
UserLocalServiceUtil.updateUser(currentUser);

[Prashant Sharma, modifié il y a 6 années.]

Hi David,

I am working on Migration from Liferay 6.1 ce to Liferay 6.2 ce and facing a major issue of User list. I have around 250 users in my database out of which only 2 are appearing under Control Panel --> Users. However I am able to see all 250 users under siteadmin --> Sitemembers --> users list.
There is no error on my console logs. Below are the steps i have tiered :

1. I have reindexed all search indexes and restarted the server.
2. Checked users status all are in active stage from status column of user_ table

On R&D and as work around solution i found is that :
1. Create an Organization and assign users to org from available user list.
2. On adding you would see the list of users under Organization users list .
3. Delete the users from organization list and check you users on control panel again.
4. Users get visible on all Users tab.

Unable to find any specific and fix solution.
Need help, please do suggest something

Regards
Prashant Sharma

[Alberto Chaparro, modifié il y a 6 années.]

Hi Prashant,

Are you sure that your users don't belong to an organization? As far as I remember the default view shows the organizations and their users so maybe you don't see them because you have to go inside the organizations.

I hope it helps.

Regards.