Showing No Users in control Panel

[Manish Yadav, modificado hace 11 años.]

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

[David H Nebinger, modificado hace 11 años.]

You need to reindex all search indices and it will work.

[Vijayakumar L, modificado hace 10 años.]

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, modificado hace 10 años.]

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. create temp folder in mysql home
2. Copy attached my.ini file into your mysql home directory. Don't forget to change below values according to your environment.


#Path to installation directory. All paths are usually resolved relative to this.
basedir="D:/MYSQL/mysql-noinstall-5.0.51a-win32/mysql-5.0.51a-win32"

#Path to the database root
datadir="D:/MYSQL/mysql-noinstall-5.0.51a-win32/mysql-5.0.51a-win32/data/"

tmpdir = "D:/MYSQL/mysql-noinstall-5.0.51a-win32/mysql-5.0.51a-win32/temp"


restart tomcat(direct kill from window task manager and  restart mysql and liferay)

Thanks & Regards
Manish Banwari lal Yadav
Email:- [e-mail]
Contact No:- [phone]

[Vijayakumar L, modificado hace 10 años.]

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, modificado hace 10 años.]

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:- [e-mail]

[Vijayakumar L, modificado hace 10 años.]

Hi Manish,

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

Thanks

[Manish Yadav, modificado hace 10 años.]

Please share fresh catlina.log file

Thanks & Regards
Manish Banwari lal Yadav
Email:- [e-mail]