Forums

Home » Liferay Sync

Combination View Flat View Tree View
Threads [ Previous | Next ]
toggle
Manish Yadav
Showing No Users in control Panel
April 18, 2013 7:39 AM
Answer

Manish Yadav

Rank: Expert

Posts: 385

Join Date: May 26, 2012

Recent Posts

Hi All ,

I just took the DB backup of my production Box and executed DB script to my local DB.I am facing problem that all users ,roles everything comes.I am able to login with each userid also but problem is when i'm trying to check User in control pannel>user and organization> it showing no user found.
Any body faced this issue while importing db script from different machine
Anonymous
RE: Showing No Users in control Panel
April 18, 2013 7:55 AM
Answer

Anonymous

This forum is specifically for Sync. So you will probably get a better answer in a different forum.
David H Nebinger
RE: Showing No Users in control Panel
April 18, 2013 8:58 AM
Answer

David H Nebinger

Community Moderator

Rank: Liferay Legend

Posts: 8426

Join Date: September 1, 2006

Recent Posts

You need to reindex all search indices and it will work.
Vijayakumar L
RE: Showing No Users in control Panel
May 27, 2013 3:51 AM
Answer

Vijayakumar L

Rank: New Member

Posts: 13

Join Date: April 29, 2013

Recent Posts

Hi,

I am facing the same problem.
I have execute reindex all search indices, but i get error in log as following :-

10:40:25,546 ERROR [JDBCExceptionReporter:101] Can't create/write to file 'C:\WI
NDOWS\TEMP\#sql_254_0.MYI' (Errcode: 13)
10:40:25,562 ERROR [LuceneIndexer:146] Error encountered while reindexing
com.liferay.portal.kernel.search.SearchException: com.liferay.portal.kernel.exce
ption.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hiber
nate.exception.GenericJDBCException: could not execute query
at com.liferay.portal.kernel.search.BaseIndexer.getDocument(BaseIndexer.
java:61)
at com.liferay.portlet.enterpriseadmin.util.UserIndexer.reindexUsers(Use
rIndexer.java:455)
at com.liferay.portlet.enterpriseadmin.util.UserIndexer.reindexUsers(Use
rIndexer.java:434)
at com.liferay.portlet.enterpriseadmin.util.UserIndexer.doReindex(UserIn
dexer.java:273)
at com.liferay.portal.kernel.search.BaseIndexer.reindex(BaseIndexer.java
:108)
at com.liferay.portal.search.lucene.LuceneIndexer.doReIndex(LuceneIndexe
r.java:130)
at com.liferay.portal.search.lucene.LuceneIndexer.reindex(LuceneIndexer.
java:61)
at com.liferay.portal.search.lucene.LuceneIndexer.reindex(LuceneIndexer.
java:54)
at com.liferay.portlet.admin.action.EditServerAction.reindex(EditServerA
ction.java:267)
at com.liferay.portlet.admin.action.EditServerAction.processAction(EditS
erverAction.java:131)
at com.liferay.portal.struts.PortletRequestProcessor.process(PortletRequ
estProcessor.java:169)
at com.liferay.portlet.StrutsPortlet.processAction(StrutsPortlet.java:18
6)
at com.liferay.portlet.FilterChainImpl.doFilter(FilterChainImpl.java:70)

at com.liferay.portal.kernel.portlet.PortletFilterUtil.doFilter(PortletF
ilterUtil.java:48)
at com.liferay.portlet.InvokerPortletImpl.invoke(InvokerPortletImpl.java
:652)
at com.liferay.portlet.InvokerPortletImpl.invokeAction(InvokerPortletImp
l.java:687)
at com.liferay.portlet.InvokerPortletImpl.processAction(InvokerPortletIm
pl.java:360)
at com.liferay.portal.action.LayoutAction.processPortletRequest(LayoutAc
tion.java:784)
at com.liferay.portal.action.LayoutAction.processLayout(LayoutAction.jav
a:582)
at com.liferay.portal.action.LayoutAction.execute(LayoutAction.java:232)

at org.apache.struts.action.RequestProcessor.processActionPerform(Reques
tProcessor.java:431)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.ja
va:236)
at com.liferay.portal.struts.PortalRequestProcessor.process(PortalReques
tProcessor.java:153)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:119
6)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at com.liferay.portal.servlet.MainServlet.callParentService(MainServlet.
java:508)
at com.liferay.portal.servlet.MainServlet.service(MainServlet.java:485)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter
.java:196)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java
:126)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter
.java:196)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java
:126)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter
.java:196)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java
:126)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter
.java:196)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java
:126)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter
.java:196)
at com.liferay.portal.servlet.filters.gzip.GZipFilter.processFilter(GZip
Filter.java:121)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java
:123)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter
.java:196)
at com.liferay.portal.servlet.filters.secure.SecureFilter.processFilter(
SecureFilter.java:182)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java
:123)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter
.java:196)
at com.liferay.portal.servlet.filters.autologin.AutoLoginFilter.processF
ilter(AutoLoginFilter.java:254)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java
:123)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDisp
atcher.java:646)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(Applica
tionDispatcher.java:436)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationD
ispatcher.java:374)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDis
patcher.java:302)
at com.liferay.portal.servlet.FriendlyURLServlet.service(FriendlyURLServ
let.java:134)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter
.java:196)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java
:126)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter
.java:196)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java
:126)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter
.java:196)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java
:126)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewrit
eFilter.java:738)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter
.java:196)
at com.liferay.portal.servlet.filters.threadlocal.ThreadLocalFilter.proc
essFilter(ThreadLocalFilter.java:35)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java
:123)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:191)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentica
torBase.java:470)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
:857)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce
ss(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:48
9)
at java.lang.Thread.run(Thread.java:619)
Caused by: com.liferay.portal.kernel.exception.SystemException: com.liferay.port
al.kernel.dao.orm.ORMException: org.hibernate.exception.GenericJDBCException: co
uld not execute query
at com.liferay.portal.service.persistence.impl.BasePersistenceImpl.proce
ssException(BasePersistenceImpl.java:195)
at com.liferay.portal.service.persistence.UserPersistenceImpl.getOrganiz
ations(UserPersistenceImpl.java:4967)
at com.liferay.portal.service.persistence.UserPersistenceImpl.getOrganiz
ations(UserPersistenceImpl.java:4902)
at com.liferay.portal.service.impl.OrganizationLocalServiceImpl.getUserO
rganizations(OrganizationLocalServiceImpl.java:445)
at com.liferay.portal.service.impl.OrganizationLocalServiceImpl.getUserO
rganizations(OrganizationLocalServiceImpl.java:421)
at com.liferay.portal.service.impl.OrganizationLocalServiceImpl.getUserO
rganizations(OrganizationLocalServiceImpl.java:414)
at sun.reflect.GeneratedMethodAccessor971.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti
on(AopUtils.java:309)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo
inpoint(ReflectiveMethodInvocation.java:183)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:150)
at org.springframework.transaction.interceptor.TransactionInterceptor.in
voke(TransactionInterceptor.java:110)
at com.liferay.portal.dao.jdbc.aop.DynamicDataSourceTransactionIntercept
or.invoke(DynamicDataSourceTransactionInterceptor.java:44)
at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableM
ethodAdvice.java:58)
at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableM
ethodAdvice.java:58)
at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableM
ethodAdvice.java:58)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:172)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invok
e(ExposeInvocationInterceptor.java:89)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami
cAopProxy.java:202)
at $Proxy41.getUserOrganizations(Unknown Source)
at com.liferay.portal.service.OrganizationLocalServiceUtil.getUserOrgani
zations(OrganizationLocalServiceUtil.java:317)
at com.liferay.portal.model.impl.UserImpl.getOrganizations(UserImpl.java
:320)
at com.liferay.portal.model.impl.UserImpl.getOrganizationIds(UserImpl.ja
va:304)
at com.liferay.portlet.enterpriseadmin.util.UserIndexer.doGetDocument(Us
erIndexer.java:150)
at com.liferay.portal.kernel.search.BaseIndexer.getDocument(BaseIndexer.
java:55)
... 161 more
Caused by: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.excepti
on.GenericJDBCException: could not execute query
at com.liferay.portal.dao.orm.hibernate.ExceptionTranslator.translate(Ex
ceptionTranslator.java:30)
at com.liferay.portal.dao.orm.hibernate.SQLQueryImpl.list(SQLQueryImpl.j
ava:96)
at com.liferay.portal.kernel.dao.orm.QueryUtil.list(QueryUtil.java:60)
at com.liferay.portal.kernel.dao.orm.QueryUtil.list(QueryUtil.java:52)
at com.liferay.portal.service.persistence.UserPersistenceImpl.getOrganiz
ations(UserPersistenceImpl.java:4963)
... 186 more
Caused by: org.hibernate.exception.GenericJDBCException: could not execute query

at org.hibernate.exception.SQLStateConverter.handledNonSpecificException
(SQLStateConverter.java:140)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.j
ava:128)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp
er.java:66)
at org.hibernate.loader.Loader.doList(Loader.java:2297)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2172)
at org.hibernate.loader.Loader.list(Loader.java:2167)
at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:316)
at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1832)

at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:
165)
at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:179)
at com.liferay.portal.dao.orm.hibernate.SQLQueryImpl.list(SQLQueryImpl.j
ava:86)
... 189 more
Caused by: java.sql.SQLException: Can't create/write to file 'C:\WINDOWS\TEMP\#s
ql_254_0.MYI' (Errcode: 13)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3256)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja
va:1313)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:
1448)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewPr
oxyPreparedStatement.java:76)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:
208)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1849)
at org.hibernate.loader.Loader.doQuery(Loader.java:718)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Lo
ader.java:270)
at org.hibernate.loader.Loader.doList(Loader.java:2294)
... 196 more


Please help me.
Thanks
Manish Yadav
RE: Showing No Users in control Panel
May 27, 2013 4:13 AM
Answer

Manish Yadav

Rank: Expert

Posts: 385

Join Date: May 26, 2012

Recent Posts

This problem happened because of your user account don't have permission to write file in C:\WINDOWS\TEMP\#sql_254_0.MYI
Steps to resolve Issue
 1
 21. create temp folder in mysql home
 32. Copy attached my.ini file into your mysql home directory. Don't forget to change below values according to your environment.
 4
 5
 6#Path to installation directory. All paths are usually resolved relative to this.
 7basedir="D:/MYSQL/mysql-noinstall-5.0.51a-win32/mysql-5.0.51a-win32"
 8
 9#Path to the database root
10datadir="D:/MYSQL/mysql-noinstall-5.0.51a-win32/mysql-5.0.51a-win32/data/"
11
12tmpdir = "D:/MYSQL/mysql-noinstall-5.0.51a-win32/mysql-5.0.51a-win32/temp"
13
14
15restart tomcat(direct kill from window task manager and  restart mysql and liferay)



Thanks & Regards
Manish Banwari lal Yadav
Email:- manishyadav1103@gmail.com
Contact No:- +91-8452899010
Attachments: my.ini (9.2k)
Vijayakumar L
RE: Showing No Users in control Panel
May 29, 2013 2:20 AM
Answer

Vijayakumar L

Rank: New Member

Posts: 13

Join Date: April 29, 2013

Recent Posts

Hi Manish,

I have go through your steps. But still I am facing the same problem.
Will i need to do anything else?

Thanks
Manish Yadav
RE: Showing No Users in control Panel
May 29, 2013 2:51 AM
Answer

Manish Yadav

Rank: Expert

Posts: 385

Join Date: May 26, 2012

Recent Posts

Hi Vijay,

Check temp folder in mysql home if folder is empty its means wrong path you mentioned in my.ini or you haven't restarted mysql...


Thanks & Regards
Manish Banwari lal Yadav
Email:- manishyadav1103@gmail.com
Vijayakumar L
RE: Showing No Users in control Panel
May 29, 2013 3:03 AM
Answer

Vijayakumar L

Rank: New Member

Posts: 13

Join Date: April 29, 2013

Recent Posts

Hi Manish,

I have given correct path and checked temp folder, it contains some files with extensions ".tmp".

Thanks
Manish Yadav
RE: Showing No Users in control Panel
May 29, 2013 3:09 AM
Answer

Manish Yadav

Rank: Expert

Posts: 385

Join Date: May 26, 2012

Recent Posts

Please share fresh catlina.log file

Thanks & Regards
Manish Banwari lal Yadav
Email:- manishyadav1103@gmail.com