Vue combinée Vue Plate Arborescence
Sujets [ Précédent | Suivant ]
toggle
Ankur Jaswal
Existing users not listed in the control panel user tab in 6.2
25 août 2014 16:59
Réponse

Ankur Jaswal

Rang: Junior Member

Publications: 42

Date d'inscription: 12 août 2010

Publications Récentes

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
RE: Existing users not listed in the control panel user tab in 6.2
25 août 2014 21:27
Réponse

David H Nebinger

Community Moderator

Rang: Liferay Legend

Publications: 11100

Date d'inscription: 1 septembre 2006

Publications Récentes

This is indicative of a problem that occurred during your upgrade. Were there errors in the logs during the upgrade?
Nagendra Kumar Busam
RE: Existing users not listed in the control panel user tab in 6.2
25 août 2014 21:31
Réponse

Nagendra Kumar Busam

Rang: Liferay Master

Publications: 653

Date d'inscription: 7 juillet 2009

Publications Récentes

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

1SELECT c.*
2FROM Contact_ AS c
3LEFT JOIN User_ AS u ON u.userId= c.userId
4WHERE
5u.userId IS NULL;
Wouter Vernaillen
RE: Existing users not listed in the control panel user tab in 6.2
1 octobre 2014 01:51
Réponse

Wouter Vernaillen

Rang: Junior Member

Publications: 60

Date d'inscription: 6 juin 2009

Publications Récentes

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:

1SELECT 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
RE: Existing users not listed in the control panel user tab in 6.2
1 octobre 2014 06:07
Réponse

Wouter Vernaillen

Rang: Junior Member

Publications: 60

Date d'inscription: 6 juin 2009

Publications Récentes

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
RE: Existing users not listed in the control panel user tab in 6.2
1 octobre 2014 05:49
Réponse

David H Nebinger

Community Moderator

Rang: Liferay Legend

Publications: 11100

Date d'inscription: 1 septembre 2006

Publications Récentes

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
RE: Existing users not listed in the control panel user tab in 6.2
1 octobre 2014 06:23
Réponse

Wouter Vernaillen

Rang: Junior Member

Publications: 60

Date d'inscription: 6 juin 2009

Publications Récentes

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
RE: Existing users not listed in the control panel user tab in 6.2
1 octobre 2014 06:30
Réponse

David H Nebinger

Community Moderator

Rang: Liferay Legend

Publications: 11100

Date d'inscription: 1 septembre 2006

Publications Récentes

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... emoticon
michele guarnaccia
RE: Existing users not listed in the control panel user tab in 6.2
28 janvier 2016 00:05
Réponse

michele guarnaccia

Rang: New Member

Publications: 2

Date d'inscription: 23 juillet 2014

Publications Récentes

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
RE: Existing users not listed in the control panel user tab in 6.2
12 juillet 2016 07:32
Réponse

srini vasulu

Rang: Junior Member

Publications: 30

Date d'inscription: 21 février 2011

Publications Récentes

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?.