Staing Execption

3010808, modified 2 Years ago. Regular Member Posts: 131 Join Date: 5/4/09 Recent Posts
Hi everybody!

I tried to turn on staging and it works when I publish to live site, but when I try to publish to remote server it drops me an exception. The staging server's IP is added to portal-ext.properties so the communication looks OK, and when publishing a single site without Web Content Display portlet it seems to be working, but we have many Web Content Display portlets.

Anybody has any idea???

The eception thrown is:


12:00:26,039 ERROR [JDBCExceptionReporter] Duplicate entry '10136-0-/befektetesek' for key 'IX_BC2C4231'
12:00:26,041 ERROR [STDERR] java.lang.reflect.InvocationTargetException
12:00:26,041 ERROR [STDERR]     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
12:00:26,041 ERROR [STDERR]     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:64)
12:00:26,041 ERROR [STDERR]     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
12:00:26,041 ERROR [STDERR]     at java.lang.reflect.Method.invoke(Method.java:615)
12:00:26,041 ERROR [STDERR]     at com.liferay.portal.kernel.util.MethodInvoker.invoke(MethodInvoker.java:180)
12:00:26,041 ERROR [STDERR]     at com.liferay.portal.kernel.util.MethodInvoker.invoke(MethodInvoker.java:49)
12:00:26,041 ERROR [STDERR]     at com.liferay.portal.servlet.TunnelServlet.doPost(TunnelServlet.java:128)
12:00:26,041 ERROR [STDERR]     at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
12:00:26,041 ERROR [STDERR]     at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
12:00:26,041 ERROR [STDERR]     at com.liferay.portal.kernel.servlet.PortalClassLoaderServlet.service(PortalClassLoaderServlet.java:108)
12:00:26,041 ERROR [STDERR]     at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
12:00:26,041 ERROR [STDERR]     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
12:00:26,042 ERROR [STDERR]     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
12:00:26,042 ERROR [STDERR]     at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:154)
12:00:26,042 ERROR [STDERR]     at com.liferay.portal.servlet.filters.secure.SecureFilter.processFilter(SecureFilter.java:282)
12:00:26,042 ERROR [STDERR]     at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:91)
12:00:26,042 ERROR [STDERR]     at com.liferay.portal.kernel.servlet.PortalClassLoaderFilter.doFilter(PortalClassLoaderFilter.java:78)
12:00:26,042 ERROR [STDERR]     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
12:00:26,042 ERROR [STDERR]     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
12:00:26,042 ERROR [STDERR]     at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
12:00:26,042 ERROR [STDERR]     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
12:00:26,042 ERROR [STDERR]     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
12:00:26,042 ERROR [STDERR]     at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
12:00:26,042 ERROR [STDERR]     at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
12:00:26,042 ERROR [STDERR]     at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:182)
12:00:26,042 ERROR [STDERR]     at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
12:00:26,042 ERROR [STDERR]     at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
12:00:26,042 ERROR [STDERR]     at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
12:00:26,042 ERROR [STDERR]     at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
12:00:26,042 ERROR [STDERR]     at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
12:00:26,042 ERROR [STDERR]     at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)
12:00:26,042 ERROR [STDERR]     at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
12:00:26,042 ERROR [STDERR]     at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
12:00:26,042 ERROR [STDERR]     at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)
12:00:26,043 ERROR [STDERR]     at java.lang.Thread.run(Thread.java:799)
12:00:26,043 ERROR [STDERR] Caused by:
12:00:26,043 ERROR [STDERR] com.liferay.portal.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: Could not execute JDBC batch update
12:00:26,043 ERROR [STDERR]     at com.liferay.portal.service.persistence.impl.BasePersistenceImpl.processException(BasePersistenceImpl.java:91)
12:00:26,043 ERROR [STDERR]     at com.liferay.portal.service.persistence.LayoutPersistenceImpl.updateImpl(LayoutPersistenceImpl.java:429)
12:00:26,043 ERROR [STDERR]     at com.liferay.portal.service.persistence.LayoutPersistenceImpl.update(LayoutPersistenceImpl.java:399)
12:00:26,043 ERROR [STDERR]     at com.liferay.portal.service.persistence.LayoutUtil.update(LayoutUtil.java:86)
12:00:26,043 ERROR [STDERR]     at com.liferay.portal.lar.LayoutImporter.importLayouts(LayoutImporter.java:497)
12:00:26,043 ERROR [STDERR]     at com.liferay.portal.service.impl.LayoutLocalServiceImpl.importLayouts(LayoutLocalServiceImpl.java:625)
12:00:26,043 ERROR [STDERR]     at com.liferay.portal.service.impl.LayoutLocalServiceImpl.importLayouts(LayoutLocalServiceImpl.java:610)
12:00:26,043 ERROR [STDERR]     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
12:00:26,043 ERROR [STDERR]     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:64)
12:00:26,043 ERROR [STDERR]     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
12:00:26,043 ERROR [STDERR]     at java.lang.reflect.Method.invoke(Method.java:615)
12:00:26,043 ERROR [STDERR]     at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
12:00:26,043 ERROR [STDERR]     at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
12:00:26,043 ERROR [STDERR]     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
12:00:26,043 ERROR [STDERR]     at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
12:00:26,043 ERROR [STDERR]     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
12:00:26,043 ERROR [STDERR]     at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
12:00:26,043 ERROR [STDERR]     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
12:00:26,043 ERROR [STDERR]     at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
12:00:26,043 ERROR [STDERR]     at $Proxy76.importLayouts(Unknown Source)
12:00:26,043 ERROR [STDERR]     at com.liferay.portal.service.impl.LayoutServiceImpl.importLayouts(LayoutServiceImpl.java:222)
12:00:26,043 ERROR [STDERR]     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
12:00:26,043 ERROR [STDERR]     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:64)
12:00:26,043 ERROR [STDERR]     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
12:00:26,043 ERROR [STDERR]     at java.lang.reflect.Method.invoke(Method.java:615)
12:00:26,043 ERROR [STDERR]     at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
12:00:26,043 ERROR [STDERR]     at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
12:00:26,043 ERROR [STDERR]     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
12:00:26,043 ERROR [STDERR]     at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
12:00:26,044 ERROR [STDERR]     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
12:00:26,044 ERROR [STDERR]     at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
12:00:26,044 ERROR [STDERR]     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
12:00:26,044 ERROR [STDERR]     at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
12:00:26,061 ERROR [STDERR]     at $Proxy77.importLayouts(Unknown Source)
12:00:26,061 ERROR [STDERR]     at com.liferay.portal.service.LayoutServiceUtil.importLayouts(LayoutServiceUtil.java:167)
12:00:26,061 ERROR [STDERR]     ... 35 more
12:00:26,061 ERROR [STDERR] Caused by:
12:00:26,061 ERROR [STDERR] com.liferay.portal.kernel.dao.orm.ORMException: Could not execute JDBC batch update
12:00:26,061 ERROR [STDERR]     at com.liferay.portal.dao.orm.hibernate.ExceptionTranslator.translate(ExceptionTranslator.java:41)
12:00:26,061 ERROR [STDERR]     at com.liferay.portal.dao.orm.hibernate.SessionImpl.flush(SessionImpl.java:122)
12:00:26,061 ERROR [STDERR]     at com.liferay.portal.service.persistence.BatchSessionImpl.update(BatchSessionImpl.java:81)
12:00:26,061 ERROR [STDERR]     at com.liferay.portal.service.persistence.BatchSessionUtil.update(BatchSessionUtil.java:53)
12:00:26,061 ERROR [STDERR]     at com.liferay.portal.service.persistence.LayoutPersistenceImpl.updateImpl(LayoutPersistenceImpl.java:424)
12:00:26,061 ERROR [STDERR]     ... 68 more




thumbnail
3473762, modified 16 Years ago. Junior Member Posts: 43 Join Date: 7/2/09 Recent Posts
Check your database, you should find friendly url befektetesek already exists in your database. Try to use another friendly url to test again.
3010808, modified 2 Years ago. Regular Member Posts: 131 Join Date: 5/4/09 Recent Posts
Eric Min:
Check your database, you should find friendly url befektetesek already exists in your database. Try to use another friendly url to test again.


Hi Eric,

The two machines were identical VMWare images at the starting point. Now one of them is a test machine and the other one is a developer machine. We make changes on the developer machine and I tried to use the remote publish function from the developer machine to the test machine. Actually almost every friendly url are already exists on the test system because they are already existed at the starting point. Do you think, if I create two clean install and on the developer machine I build the site and deploy it with remote publish to the test machine will work? I mean after the first publishing, the second or third one will facing the same problem with the friendly urls?

Best regards,

George
thumbnail
3473762, modified 16 Years ago. Junior Member Posts: 43 Join Date: 7/2/09 Recent Posts
You don't need to do that. From your error infomation you just need to check whether the page with friendly url you'll add is the same as the other page's(e.g. page a with a friend url aa and you want to add a page b, so you can't give page b a friend url aa). That's what i mean.
3010808, modified 2 Years ago. Regular Member Posts: 131 Join Date: 5/4/09 Recent Posts
Eric Min:
You don't need to do that. From your error infomation you just need to check whether the page with friendly url you'll add is the same as the other page's(e.g. page a with a friend url aa and you want to add a page b, so you can't give page b a friend url aa). That's what i mean.


And how could I instruct Liferay, to igrnoe or replace the duplicates when syncing all pages?
thumbnail
3473762, modified 16 Years ago. Junior Member Posts: 43 Join Date: 7/2/09 Recent Posts
1.Unchecked staging check-box.
2.Go to your DB and find out "befektetesek" change it to another unique one.
3.Checked staging check-box test again see whether it also happens the problem.
3010808, modified 2 Years ago. Regular Member Posts: 131 Join Date: 5/4/09 Recent Posts
Hi Eric,

As we were on the very beggining of the project and the problem occured on our developer ant our test machine, I simply reinstalled liferay with clean DB on them. After it we load up our contents with staging and then published it to live then from live to remote (test server) everything worked fine. I guess the problem was that the 2nd machine was installed from the 1st machine's disk image.

Best regards,

George