Combination View Flat View Tree View
Threads [ Previous | Next ]
toggle
Abid Mehmood
liferay remote staging
September 21, 2011 6:25 AM
Answer

Abid Mehmood

Rank: Junior Member

Posts: 45

Join Date: September 8, 2011

Recent Posts

Hi All,
I am doing remote staging but i am facing this problem. Some portlets do work fine and they got transfered from staging to production system but in some this problem appears. I have only one system so i am running two instances of tomcat, one is running on port 8080(staging) and one on 8081(production). When i transfer my portalet then on staging side i got the following exception.
 1
 2..
 3...
 4.......
 5Hibernate: select portletpre0_.portletPreferencesId as portletP1_32_, portletpre0_.ownerId as ownerId32_, portletpre0_.ownerType as ownerType32_, portletpre0_.plid as plid32_, portletpre0_.portletId as portletId32_, portletpre0_.preferences as preferen6_32_ from PortletPreferences portletpre0_ where (portletpre0_.ownerId=? )AND(portletpre0_.ownerType=? )AND(portletpre0_.plid=? )AND(portletpre0_.portletId=? )
 6Hibernate: update LayoutSet set groupId=?, companyId=?, privateLayout=?, logo=?, logoId=?, themeId=?, colorSchemeId=?, wapThemeId=?, wapColorSchemeId=?, css=?, pageCount=?, virtualHost=?, settings_=?, layoutSetPrototypeId=? where layoutSetId=?
 7Hibernate: SELECT top ? User_.userId AS userId, Contact_.firstName AS firstName, Contact_.middleName AS middleName, Contact_.lastName AS lastName, User_.portraitId AS portraitId, Chat_Status.awake AS awake FROM Chat_Status INNER JOIN User_ ON (User_.userId = Chat_Status.userId) INNER JOIN Contact_ ON (Contact_.contactId = User_.contactId) WHERE (User_.companyId = ?) AND (User_.userId != ?) AND (Chat_Status.modifiedDate > ?) AND (Chat_Status.online_ = true) ORDER BY Chat_Status.awake ASC, Contact_.firstName ASC, Contact_.middleName ASC, Contact_.lastName ASC
 8Hibernate: SELECT top ? Chat_Entry.entryId as entryId266_0_, Chat_Entry.createDate as createDate266_0_, Chat_Entry.fromUserId as fromUserId266_0_, Chat_Entry.toUserId as toUserId266_0_, Chat_Entry.content as content266_0_ FROM Chat_Entry WHERE ( (fromUserId = ?) OR (toUserId = ?) ) AND (createDate > ?) ORDER BY createDate DESC
 913:00:52,888 ERROR [LayoutServiceHttp:525] com.liferay.portal.kernel.exception.SystemException
10com.liferay.portal.kernel.exception.SystemException
11    at com.liferay.portal.servlet.TunnelServlet.doPost(TunnelServlet.java:146)
12    at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
13    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
14    at com.liferay.portal.kernel.servlet.PortalClassLoaderServlet.service(PortalClassLoaderServlet.java:95)
15    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
16    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
17    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
18    at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:196)
19    at com.liferay.portal.servlet.filters.secure.SecureFilter.processFilter(SecureFilter.java:182)
20    at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:123)
21    at com.liferay.portal.kernel.servlet.PortalClassLoaderFilter.doFilter(PortalClassLoaderFilter.java:53)
22    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
23    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
24    at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:196)
25    at com.liferay.portal.servlet.filters.threadlocal.ThreadLocalFilter.processFilter(ThreadLocalFilter.java:35)
26    at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:123)
27    at com.liferay.portal.kernel.servlet.PortalClassLoaderFilter.doFilter(PortalClassLoaderFilter.java:53)
28    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
29    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
30    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
31    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
32    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
33    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
34    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
35    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
36    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
37    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
38    at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
39    at java.lang.Thread.run(Thread.java:619)
40.... continue


while on the production side i got a number of exception so here are some.
  1
  2Hibernate: update Counter set currentId=? where name=?
  3Hibernate: select userimpl0_.userId as userId45_, userimpl0_.uuid_ as uuid2_45_, userimpl0_.companyId as companyId45_, userimpl0_.createDate as createDate45_, userimpl0_.modifiedDate as modified5_45_, userimpl0_.defaultUser as defaultU6_45_, userimpl0_.contactId as contactId45_, userimpl0_.password_ as password8_45_, userimpl0_.passwordEncrypted as password9_45_, userimpl0_.passwordReset as passwor10_45_, userimpl0_.passwordModifiedDate as passwor11_45_, userimpl0_.digest as digest45_, userimpl0_.reminderQueryQuestion as reminde13_45_, userimpl0_.reminderQueryAnswer as reminde14_45_, userimpl0_.graceLoginCount as graceLo15_45_, userimpl0_.screenName as screenName45_, userimpl0_.emailAddress as emailAd17_45_, userimpl0_.facebookId as facebookId45_, userimpl0_.openId as openId45_, userimpl0_.portraitId as portraitId45_, userimpl0_.languageId as languageId45_, userimpl0_.timeZoneId as timeZoneId45_, userimpl0_.greeting as greeting45_, userimpl0_.comments as comments45_, userimpl0_.firstName as firstName45_, userimpl0_.middleName as middleName45_, userimpl0_.lastName as lastName45_, userimpl0_.jobTitle as jobTitle45_, userimpl0_.loginDate as loginDate45_, userimpl0_.loginIP as loginIP45_, userimpl0_.lastLoginDate as lastLog31_45_, userimpl0_.lastLoginIP as lastLog32_45_, userimpl0_.lastFailedLoginDate as lastFai33_45_, userimpl0_.failedLoginAttempts as failedL34_45_, userimpl0_.lockout as lockout45_, userimpl0_.lockoutDate as lockout36_45_, userimpl0_.agreedToTermsOfUse as agreedT37_45_, userimpl0_.active_ as active38_45_ from User_ userimpl0_ where (userimpl0_.uuid_=? )
  4Hibernate: select journalstr0_.id_ as id1_88_, journalstr0_.uuid_ as uuid2_88_, journalstr0_.groupId as groupId88_, journalstr0_.companyId as companyId88_, journalstr0_.userId as userId88_, journalstr0_.userName as userName88_, journalstr0_.createDate as createDate88_, journalstr0_.modifiedDate as modified8_88_, journalstr0_.structureId as structur9_88_, journalstr0_.parentStructureId as parentS10_88_, journalstr0_.name as name88_, journalstr0_.description as descrip12_88_, journalstr0_.xsd as xsd88_ from JournalStructure journalstr0_ where (journalstr0_.groupId=? )AND(journalstr0_.structureId=? ) order by  journalstr0_.structureId ASC
  5Hibernate: select journaltem0_.id_ as id1_89_, journaltem0_.uuid_ as uuid2_89_, journaltem0_.groupId as groupId89_, journaltem0_.companyId as companyId89_, journaltem0_.userId as userId89_, journaltem0_.userName as userName89_, journaltem0_.createDate as createDate89_, journaltem0_.modifiedDate as modified8_89_, journaltem0_.templateId as templateId89_, journaltem0_.structureId as structu10_89_, journaltem0_.name as name89_, journaltem0_.description as descrip12_89_, journaltem0_.xsl as xsl89_, journaltem0_.langType as langType89_, journaltem0_.cacheable as cacheable89_, journaltem0_.smallImage as smallImage89_, journaltem0_.smallImageId as smallIm17_89_, journaltem0_.smallImageURL as smallIm18_89_ from JournalTemplate journaltem0_ where (journaltem0_.groupId=? )AND(journaltem0_.templateId=? ) order by  journaltem0_.templateId ASC
  6Hibernate: select imageimpl0_.imageId as imageId12_0_, imageimpl0_.modifiedDate as modified2_12_0_, imageimpl0_.text_ as text3_12_0_, imageimpl0_.type_ as type4_12_0_, imageimpl0_.height as height12_0_, imageimpl0_.width as width12_0_, imageimpl0_.size_ as size7_12_0_ from Image imageimpl0_ where imageimpl0_.imageId=?
  7Hibernate: select imageimpl0_.imageId as imageId12_0_, imageimpl0_.modifiedDate as modified2_12_0_, imageimpl0_.text_ as text3_12_0_, imageimpl0_.type_ as type4_12_0_, imageimpl0_.height as height12_0_, imageimpl0_.width as width12_0_, imageimpl0_.size_ as size7_12_0_ from Image imageimpl0_ where imageimpl0_.imageId=?
  8Hibernate: select journalart0_.resourcePrimKey as resource1_85_, journalart0_.uuid_ as uuid2_85_, journalart0_.groupId as groupId85_, journalart0_.articleId as articleId85_ from JournalArticleResource journalart0_ where (journalart0_.uuid_=? )AND(journalart0_.groupId=? )
  9Hibernate: select journalart0_.resourcePrimKey as resource1_85_, journalart0_.uuid_ as uuid2_85_, journalart0_.groupId as groupId85_, journalart0_.articleId as articleId85_ from JournalArticleResource journalart0_ where (journalart0_.groupId=? )AND(journalart0_.articleId IS NULL )
 10Hibernate: select top ? journalart0_.id_ as id1_83_, journalart0_.uuid_ as uuid2_83_, journalart0_.resourcePrimKey as resource3_83_, journalart0_.groupId as groupId83_, journalart0_.companyId as companyId83_, journalart0_.userId as userId83_, journalart0_.userName as userName83_, journalart0_.createDate as createDate83_, journalart0_.modifiedDate as modified9_83_, journalart0_.articleId as articleId83_, journalart0_.version as version83_, journalart0_.title as title83_, journalart0_.urlTitle as urlTitle83_, journalart0_.description as descrip14_83_, journalart0_.content as content83_, journalart0_.type_ as type16_83_, journalart0_.structureId as structu17_83_, journalart0_.templateId as templateId83_, journalart0_.displayDate as display19_83_, journalart0_.expirationDate as expirat20_83_, journalart0_.reviewDate as reviewDate83_, journalart0_.indexable as indexable83_, journalart0_.smallImage as smallImage83_, journalart0_.smallImageId as smallIm24_83_, journalart0_.smallImageURL as smallIm25_83_, journalart0_.status as status83_, journalart0_.statusByUserId as statusB27_83_, journalart0_.statusByUserName as statusB28_83_, journalart0_.statusDate as statusDate83_ from JournalArticle journalart0_ where (journalart0_.resourcePrimKey=? )AND(journalart0_.status=? ) order by  journalart0_.version DESC
 11Hibernate: select top ? journalart0_.id_ as id1_83_, journalart0_.uuid_ as uuid2_83_, journalart0_.resourcePrimKey as resource3_83_, journalart0_.groupId as groupId83_, journalart0_.companyId as companyId83_, journalart0_.userId as userId83_, journalart0_.userName as userName83_, journalart0_.createDate as createDate83_, journalart0_.modifiedDate as modified9_83_, journalart0_.articleId as articleId83_, journalart0_.version as version83_, journalart0_.title as title83_, journalart0_.urlTitle as urlTitle83_, journalart0_.description as descrip14_83_, journalart0_.content as content83_, journalart0_.type_ as type16_83_, journalart0_.structureId as structu17_83_, journalart0_.templateId as templateId83_, journalart0_.displayDate as display19_83_, journalart0_.expirationDate as expirat20_83_, journalart0_.reviewDate as reviewDate83_, journalart0_.indexable as indexable83_, journalart0_.smallImage as smallImage83_, journalart0_.smallImageId as smallIm24_83_, journalart0_.smallImageURL as smallIm25_83_, journalart0_.status as status83_, journalart0_.statusByUserId as statusB27_83_, journalart0_.statusByUserName as statusB28_83_, journalart0_.statusDate as statusDate83_ from JournalArticle journalart0_ where (journalart0_.resourcePrimKey=? ) order by  journalart0_.version DESC
 12Hibernate: select journalart0_.id_ as id1_83_, journalart0_.uuid_ as uuid2_83_, journalart0_.resourcePrimKey as resource3_83_, journalart0_.groupId as groupId83_, journalart0_.companyId as companyId83_, journalart0_.userId as userId83_, journalart0_.userName as userName83_, journalart0_.createDate as createDate83_, journalart0_.modifiedDate as modified9_83_, journalart0_.articleId as articleId83_, journalart0_.version as version83_, journalart0_.title as title83_, journalart0_.urlTitle as urlTitle83_, journalart0_.description as descrip14_83_, journalart0_.content as content83_, journalart0_.type_ as type16_83_, journalart0_.structureId as structu17_83_, journalart0_.templateId as templateId83_, journalart0_.displayDate as display19_83_, journalart0_.expirationDate as expirat20_83_, journalart0_.reviewDate as reviewDate83_, journalart0_.indexable as indexable83_, journalart0_.smallImage as smallImage83_, journalart0_.smallImageId as smallIm24_83_, journalart0_.smallImageURL as smallIm25_83_, journalart0_.status as status83_, journalart0_.statusByUserId as statusB27_83_, journalart0_.statusByUserName as statusB28_83_, journalart0_.statusDate as statusDate83_ from JournalArticle journalart0_ where (journalart0_.groupId=? )AND(journalart0_.articleId IS NULL )AND(journalart0_.version=? ) order by  journalart0_.articleId ASC , journalart0_.version DESC
 13Hibernate: select top ? journalart0_.id_ as id1_83_, journalart0_.uuid_ as uuid2_83_, journalart0_.resourcePrimKey as resource3_83_, journalart0_.groupId as groupId83_, journalart0_.companyId as companyId83_, journalart0_.userId as userId83_, journalart0_.userName as userName83_, journalart0_.createDate as createDate83_, journalart0_.modifiedDate as modified9_83_, journalart0_.articleId as articleId83_, journalart0_.version as version83_, journalart0_.title as title83_, journalart0_.urlTitle as urlTitle83_, journalart0_.description as descrip14_83_, journalart0_.content as content83_, journalart0_.type_ as type16_83_, journalart0_.structureId as structu17_83_, journalart0_.templateId as templateId83_, journalart0_.displayDate as display19_83_, journalart0_.expirationDate as expirat20_83_, journalart0_.reviewDate as reviewDate83_, journalart0_.indexable as indexable83_, journalart0_.smallImage as smallImage83_, journalart0_.smallImageId as smallIm24_83_, journalart0_.smallImageURL as smallIm25_83_, journalart0_.status as status83_, journalart0_.statusByUserId as statusB27_83_, journalart0_.statusByUserName as statusB28_83_, journalart0_.statusDate as statusDate83_ from JournalArticle journalart0_ where (journalart0_.groupId=? )AND(journalart0_.urlTitle=? )AND(journalart0_.status=? ) order by  journalart0_.version DESC
 14Hibernate: select top ? journalart0_.id_ as id1_83_, journalart0_.uuid_ as uuid2_83_, journalart0_.resourcePrimKey as resource3_83_, journalart0_.groupId as groupId83_, journalart0_.companyId as companyId83_, journalart0_.userId as userId83_, journalart0_.userName as userName83_, journalart0_.createDate as createDate83_, journalart0_.modifiedDate as modified9_83_, journalart0_.articleId as articleId83_, journalart0_.version as version83_, journalart0_.title as title83_, journalart0_.urlTitle as urlTitle83_, journalart0_.description as descrip14_83_, journalart0_.content as content83_, journalart0_.type_ as type16_83_, journalart0_.structureId as structu17_83_, journalart0_.templateId as templateId83_, journalart0_.displayDate as display19_83_, journalart0_.expirationDate as expirat20_83_, journalart0_.reviewDate as reviewDate83_, journalart0_.indexable as indexable83_, journalart0_.smallImage as smallImage83_, journalart0_.smallImageId as smallIm24_83_, journalart0_.smallImageURL as smallIm25_83_, journalart0_.status as status83_, journalart0_.statusByUserId as statusB27_83_, journalart0_.statusByUserName as statusB28_83_, journalart0_.statusDate as statusDate83_ from JournalArticle journalart0_ where (journalart0_.groupId=? )AND(journalart0_.urlTitle=? )AND(journalart0_.status=? ) order by  journalart0_.version DESC
 15Hibernate: select resourcepe0_.resourcePermissionId as resource1_38_, resourcepe0_.companyId as companyId38_, resourcepe0_.name as name38_, resourcepe0_.scope as scope38_, resourcepe0_.primKey as primKey38_, resourcepe0_.roleId as roleId38_, resourcepe0_.actionIds as actionIds38_ from ResourcePermission resourcepe0_ where (resourcepe0_.companyId=? )AND(resourcepe0_.name=? )AND(resourcepe0_.scope=? )AND(resourcepe0_.primKey=? )AND(resourcepe0_.roleId=? )
 16Hibernate: select counterimp0_.name as name130_0_, counterimp0_.currentId as currentId130_0_ from Counter counterimp0_ where counterimp0_.name=?
 17Hibernate: update Counter set currentId=? where name=?
 18Hibernate: insert into PortletPreferences (ownerId, ownerType, plid, portletId, preferences, portletPreferencesId) values (?, ?, ?, ?, ?, ?)
 19Hibernate: insert into JournalArticleResource (uuid_, groupId, articleId, resourcePrimKey) values (?, ?, ?, ?)
 2013:00:52,067 ERROR [JDBCExceptionReporter:101] failed batch
 2113:00:52,071 ERROR [SearchPermissionCheckerImpl:139] com.liferay.portal.kernel.search.SearchException: com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
 22com.liferay.portal.kernel.search.SearchException: com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
 23    at com.liferay.portal.kernel.search.BaseIndexer.reindex(BaseIndexer.java:98)
 24    at com.liferay.portal.search.SearchPermissionCheckerImpl.doUpdatePermissionFields_6(SearchPermissionCheckerImpl.java:488)
 25    at com.liferay.portal.search.SearchPermissionCheckerImpl.updatePermissionFields(SearchPermissionCheckerImpl.java:135)
 26    at com.liferay.portal.kernel.search.SearchEngineUtil.updatePermissionFields(SearchEngineUtil.java:238)
 27    at com.liferay.portal.service.impl.ResourcePermissionLocalServiceImpl.doUpdateResourcePermission(ResourcePermissionLocalServiceImpl.java:404)
 28    at com.liferay.portal.service.impl.ResourcePermissionLocalServiceImpl.updateResourcePermission(ResourcePermissionLocalServiceImpl.java:441)
 29    at com.liferay.portal.service.impl.ResourcePermissionLocalServiceImpl.setResourcePermissions(ResourcePermissionLocalServiceImpl.java:329)
 30    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 31    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
 32    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 33    at java.lang.reflect.Method.invoke(Method.java:597)
 34    at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
 35    at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
 36    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
 37    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
 38    at com.liferay.portal.dao.jdbc.aop.DynamicDataSourceTransactionInterceptor.invoke(DynamicDataSourceTransactionInterceptor.java:44)
 39    at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:58)
 40    at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:58)
 41    at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:58)
 42    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
 43    at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
 44    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
 45    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
 46    at $Proxy69.setResourcePermissions(Unknown Source)
 47    at com.liferay.portal.service.impl.ResourceLocalServiceImpl.addResources_6(ResourceLocalServiceImpl.java:781)
 48    at com.liferay.portal.service.impl.ResourceLocalServiceImpl.addResources(ResourceLocalServiceImpl.java:192)
 49    at com.liferay.portal.service.impl.ResourceLocalServiceImpl.addResources(ResourceLocalServiceImpl.java:151)
 50    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 51    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
 52    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 53    at java.lang.reflect.Method.invoke(Method.java:597)
 54    at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
 55    at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
 56    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
 57    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
 58    at com.liferay.portal.dao.jdbc.aop.DynamicDataSourceTransactionInterceptor.invoke(DynamicDataSourceTransactionInterceptor.java:44)
 59    at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:58)
 60    at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:58)
 61    at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:58)
 62    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
 63    at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
 64    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
 65    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
 66    at $Proxy65.addResources(Unknown Source)
 67    at com.liferay.portlet.journal.service.impl.JournalArticleLocalServiceImpl.addArticleResources(JournalArticleLocalServiceImpl.java:298)
 68    at com.liferay.portlet.journal.service.impl.JournalArticleLocalServiceImpl.addArticle(JournalArticleLocalServiceImpl.java:235)
 69    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 70    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
 71    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 72    at java.lang.reflect.Method.invoke(Method.java:597)
 73    at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
 74    at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
 75    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
 76    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
 77    at com.liferay.portal.dao.jdbc.aop.DynamicDataSourceTransactionInterceptor.invoke(DynamicDataSourceTransactionInterceptor.java:44)
 78    at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:58)
 79    at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:58)
 80    at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:58)
 81    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
 82    at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
 83    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
 84    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
 85    at $Proxy169.addArticle(Unknown Source)
 86    at com.liferay.portlet.journal.service.JournalArticleLocalServiceUtil.addArticle(JournalArticleLocalServiceUtil.java:263)
 87    at com.liferay.portlet.journal.lar.JournalPortletDataHandlerImpl.importArticle(JournalPortletDataHandlerImpl.java:1305)
 88    at com.liferay.portlet.journal.lar.JournalContentPortletDataHandlerImpl.doImportData(JournalContentPortletDataHandlerImpl.java:321)
 89    at com.liferay.portal.kernel.lar.BasePortletDataHandler.importData(BasePortletDataHandler.java:64)
 90    at com.liferay.portal.lar.PortletImporter.importPortletData(PortletImporter.java:643)
 91    at com.liferay.portal.lar.PortletImporter.importPortletData(PortletImporter.java:545)
 92    at com.liferay.portal.lar.LayoutImporter.importLayouts(LayoutImporter.java:407)
 93    at com.liferay.portal.service.impl.LayoutLocalServiceImpl.importLayouts(LayoutLocalServiceImpl.java:680)
 94    at com.liferay.portal.service.impl.LayoutLocalServiceImpl.importLayouts(LayoutLocalServiceImpl.java:707)
 95    at com.liferay.portal.service.impl.LayoutLocalServiceImpl.importLayouts(LayoutLocalServiceImpl.java:665)
 96    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 97    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
 98    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 99    at java.lang.reflect.Method.invoke(Method.java:597)
100    at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
101    at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
102    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
103    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
104    at com.liferay.portal.dao.jdbc.aop.DynamicDataSourceTransactionInterceptor.invoke(DynamicDataSourceTransactionInterceptor.java:44)
105    at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:58)
106    at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:58)
107    at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:58)
108    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
109    at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
110    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
111    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
112    at $Proxy28.importLayouts(Unknown Source)
113    at com.liferay.portal.service.impl.LayoutServiceImpl.importLayouts(LayoutServiceImpl.java:204)
114    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
115    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
116    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
117    at java.lang.reflect.Method.invoke(Method.java:597)
118    at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
119    at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
120    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
121    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
122    at com.liferay.portal.dao.jdbc.aop.DynamicDataSourceTransactionInterceptor.invoke(DynamicDataSourceTransactionInterceptor.java:44)
123    at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:58)
124    at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:58)
125    at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:58)
126    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
127    at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
128    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
129    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
130    at $Proxy29.importLayouts(Unknown Source)
131    at com.liferay.portal.service.LayoutServiceUtil.importLayouts(LayoutServiceUtil.java:153)
132    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
133    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
134    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
135    at java.lang.reflect.Method.invoke(Method.java:597)
136    at com.liferay.portal.kernel.util.MethodHandler.invoke(MethodHandler.java:81)
137    at com.liferay.portal.kernel.util.MethodHandler.invoke(MethodHandler.java:75)
138    at com.liferay.portal.servlet.TunnelServlet.doPost(TunnelServlet.java:133)
139    at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
140    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
141    at com.liferay.portal.kernel.servlet.PortalClassLoaderServlet.service(PortalClassLoaderServlet.java:95)
142    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
143    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
144    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
145    at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:196)
146    at com.liferay.portal.servlet.filters.secure.SecureFilter.processFilter(SecureFilter.java:182)
147    at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:123)
148    at com.liferay.portal.kernel.servlet.PortalClassLoaderFilter.doFilter(PortalClassLoaderFilter.java:53)
149    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
150    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
151    at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:196)
152    at com.liferay.portal.servlet.filters.threadlocal.ThreadLocalFilter.processFilter(ThreadLocalFilter.java:35)
153    at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:123)
154    at com.liferay.portal.kernel.servlet.PortalClassLoaderFilter.doFilter(PortalClassLoaderFilter.java:53)
155    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
156    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
157    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
158    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
159    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
160    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
161    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
162    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
163    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
164    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
165    at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
166    at java.lang.Thread.run(Thread.java:619)
167Caused by: com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
168    at com.liferay.portal.service.persistence.impl.BasePersistenceImpl.processException(BasePersistenceImpl.java:195)
169    at com.liferay.portlet.journal.service.persistence.JournalArticlePersistenceImpl.findByR_ST(JournalArticlePersistenceImpl.java:2833)
170    at com.liferay.portlet.journal.service.impl.JournalArticleLocalServiceImpl.getLatestArticle(JournalArticleLocalServiceImpl.java:1213)
171    at com.liferay.portlet.journal.service.impl.JournalArticleLocalServiceImpl.getLatestArticle(JournalArticleLocalServiceImpl.java:1189)
172    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
173    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
174    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
175    at java.lang.reflect.Method.invoke(Method.java:597)
176    at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
177    at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
178    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
179    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
180    at com.liferay.portal.dao.jdbc.aop.DynamicDataSourceTransactionInterceptor.invoke(DynamicDataSourceTransactionInterceptor.java:44)
181    at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:58)
182    at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:58)
183    at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:58)
184    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
185    at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
186    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
187    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
188    at $Proxy169.getLatestArticle(Unknown Source)
189    at com.liferay.portlet.journal.service.JournalArticleLocalServiceUtil.getLatestArticle(JournalArticleLocalServiceUtil.java:630)
190    at com.liferay.portlet.journal.util.JournalIndexer.doReindex(JournalIndexer.java:170)
191    at com.liferay.portal.kernel.search.BaseIndexer.reindex(BaseIndexer.java:87)
192    ... 143 more
193Caused by: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
194    at com.liferay.portal.dao.orm.hibernate.ExceptionTranslator.translate(ExceptionTranslator.java:30)
195    at com.liferay.portal.dao.orm.hibernate.QueryImpl.list(QueryImpl.java:78)
196    at com.liferay.portal.kernel.dao.orm.QueryUtil.list(QueryUtil.java:67)
197    at com.liferay.portal.kernel.dao.orm.QueryUtil.list(QueryUtil.java:52)
198    at com.liferay.portlet.journal.service.persistence.JournalArticlePersistenceImpl.findByR_ST(JournalArticlePersistenceImpl.java:2829)
199    ... 165 more
200Caused by: org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
201    at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140)
202    at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128)
203    at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
204    at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275)
205    at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:114)
206    at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:109)
207    at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:244)
208    at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2395)
209    at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2858)
210    at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:79)
211    at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:268)
212    at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:260)
213    at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:179)
214    at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
215    at org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:64)
216    at org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:1175)
217    at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1251)
218    at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
219    at com.liferay.portal.dao.orm.hibernate.QueryImpl.list(QueryImpl.java:68)
220    ... 168 more
221Caused by: java.sql.BatchUpdateException: failed batch
222    at org.hsqldb.jdbc.jdbcStatement.executeBatch(Unknown Source)
223    at org.hsqldb.jdbc.jdbcPreparedStatement.executeBatch(Unknown Source)
224    at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723)
225    at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
226    at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
227    ... 183 more
228Hibernate: insert into PortletPreferences (ownerId, ownerType, plid, portletId, preferences, portletPreferencesId) values (?, ?, ?, ?, ?, ?)
22913:00:52,113 ERROR [JDBCExceptionReporter:101] failed batch
23013:00:52,115 ERROR [PortletImporter:647] com.liferay.portal.kernel.lar.PortletDataException: com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
231com.liferay.portal.kernel.lar.PortletDataException: com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
232    at com.liferay.portal.kernel.lar.BasePortletDataHandler.importData(BasePortletDataHandler.java:67)



Any help?
David H Nebinger
RE: liferay remote staging
September 21, 2011 6:59 AM
Answer

David H Nebinger

Community Moderator

Rank: Liferay Legend

Posts: 8428

Join Date: September 1, 2006

Recent Posts

If I had to venture a guess, I'd say that someone has been making changes directly in production...

When you do the staging, all work should be done there. If you mix making changes in staging and in production, you run the risk of having primary key collisions...

Basically, when you add something in production (i.e. a journal article), this will be assigned a primary key value. When you add different things in staging, those are also assigned primary key values. When the promotion from staging to production occurs, the primary key from the staging record collides with the primary key in production and these collisions are hard to programmatically resolve.

Long story short, if you're using staging then all work should be done there and promoted, and no work should be done directly in production (no journal content changes, etc.)
Abid Mehmood
RE: liferay remote staging
September 21, 2011 7:11 AM
Answer

Abid Mehmood

Rank: Junior Member

Posts: 45

Join Date: September 8, 2011

Recent Posts

Hi David,

Thanks a lot for your reply and it was really a great tip. I will keep that in mind in future. But here, i am not doing any changes directly into production system. My production is a fresh copy and i haven't made any change there but through staging.
lou cat
RE: liferay remote staging
February 6, 2013 2:27 AM
Answer

lou cat

Rank: Regular Member

Posts: 196

Join Date: January 26, 2012

Recent Posts

I think I have a similar issue and it happens from the beginning, the remote community is brand new, so no one is mixing stage and live.
Did you ever find a solution for this?

This is my thread

In fact my problem is that in the future I would need to mix stage and live editing (or better, some articles should come directly from another community, not from the staged one)