Visualização combinada Visão plana Exibição em árvore
Tópicos [ Anterior | Próximo ]
toggle
William Fleming
Migrating Database
17 de Fevereiro de 2011 01:53
Resposta

William Fleming

Ranking: Regular Member

Mensagens: 180

Data de entrada: 15 de Setembro de 2010

Mensagens recentes

I have moved from a mysql 5.5 server on CentOS to openBSD server with mysql 5.1 and when we migrated we had a few errors appear in the catalina.out log.




09:23:14,111 ERROR [Organization:180]
com.liferay.portal.NoSuchGroupException: No Group exists with the key {companyId=10131, classNameId=10024, classPK=12926}
at com.liferay.portal.service.persistence.GroupPersistenceImpl.findByC_C_C(GroupPersistenceImpl.java:1948)
at com.liferay.portal.service.impl.GroupLocalServiceImpl.getOrganizationGroup(GroupLocalServiceImpl.java:595)
at sun.reflect.GeneratedMethodAccessor405.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:617)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
at com.liferay.portal.dao.jdbc.aop.DynamicDataSourceTransactionInterceptor.invoke(DynamicDataSourceTransactionInterce$
at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:58)
at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:58)
at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:58)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
at $Proxy24.getOrganizationGroup(Unknown Source)
at com.liferay.portal.service.GroupLocalServiceUtil.getOrganizationGroup(GroupLocalServiceUtil.java:351)
at com.liferay.portal.model.impl.OrganizationImpl.getGroup(OrganizationImpl.java:176)
at org.apache.jsp.html.portlet.control_005fpanel_005fmenu.view_jsp._jspService(Unknown Source)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:551)
at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:488)
at com.liferay.taglib.util.IncludeTag.include(IncludeTag.java:175)
at com.liferay.taglib.util.IncludeTag._doInclude(IncludeTag.java:223)
at com.liferay.taglib.util.IncludeTag.doEndTag(IncludeTag.java:58)
at org.apache.jsp.html.common.themes.portlet_jsp._jspService(Unknown Source)


All of them very similar to each other saying that groups etc were missing but after login in it seems everything is in order. Will this cause errors in the future further down the line? Dont want to continue on and find out that we will have have serious problems later.

Any guidance would be good thanks
William
William Fleming
RE: Migrating Database
17 de Fevereiro de 2011 02:35
Resposta

William Fleming

Ranking: Regular Member

Mensagens: 180

Data de entrada: 15 de Setembro de 2010

Mensagens recentes

Just noticed that one of the screen names and first names where the same. Liferay seems to automatically puts a capital letter on the first name but for some reason this one had not and its was throwing an exception in the logs of Catalina.out

just thought I would let you know in case anybody had the same errors. I am now getting a clean launch every time.

William
A. E.
RE: Migrating Database
3 de Maio de 2011 00:36
Resposta

A. E.

Ranking: New Member

Mensagens: 5

Data de entrada: 26 de Julho de 2010

Mensagens recentes

William Fleming:
Just noticed that one of the screen names and first names where the same. Liferay seems to automatically puts a capital letter on the first name but for some reason this one had not and its was throwing an exception in the logs of Catalina.out

just thought I would let you know in case anybody had the same errors. I am now getting a clean launch every time.

William



Hi,

same Problem here. But I actually did not understand how I can solve it...
Could you please describe what you mean with "screen name"?

Thx
lanix
William Fleming
RE: Migrating Database
6 de Julho de 2011 01:25
Resposta

William Fleming

Ranking: Regular Member

Mensagens: 180

Data de entrada: 15 de Setembro de 2010

Mensagens recentes

The issue was to do with mySQL being case sensitive. I moved from a case sensitive database to another machine that didn't accept higher case letters. The machine threw lots of errors and then a created another set of tables in the schema. Rather than using the set that I had migrated over.

Thanks
William