Liferay remote staging

[zainu Mehmood]

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.

..
...
.......
Hibernate: 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=? )
Hibernate: update LayoutSet set groupId=?, companyId=?, privateLayout=?, logo=?, logoId=?, themeId=?, colorSchemeId=?, wapThemeId=?, wapColorSchemeId=?, css=?, pageCount=?, virtualHost=?, settings_=?, layoutSetPrototypeId=? where layoutSetId=?
Hibernate: 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
Hibernate: 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
13:00:52,888 ERROR [LayoutServiceHttp:525] com.liferay.portal.kernel.exception.SystemException
com.liferay.portal.kernel.exception.SystemException
	at com.liferay.portal.servlet.TunnelServlet.doPost(TunnelServlet.java:146)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	at com.liferay.portal.kernel.servlet.PortalClassLoaderServlet.service(PortalClassLoaderServlet.java:95)
	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 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 com.liferay.portal.kernel.servlet.PortalClassLoaderFilter.doFilter(PortalClassLoaderFilter.java:53)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:196)
	at com.liferay.portal.servlet.filters.threadlocal.ThreadLocalFilter.processFilter(ThreadLocalFilter.java:35)
	at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:123)
	at com.liferay.portal.kernel.servlet.PortalClassLoaderFilter.doFilter(PortalClassLoaderFilter.java:53)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
	at java.lang.Thread.run(Thread.java:619)
.... continue

while on the production side i got a number of exception so here are some.

Hibernate: update Counter set currentId=? where name=?
Hibernate: 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_=? )
Hibernate: 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
Hibernate: 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
Hibernate: 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=?
Hibernate: 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=?
Hibernate: 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=? )
Hibernate: 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 )
Hibernate: 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
Hibernate: 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
Hibernate: 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
Hibernate: 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
Hibernate: 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
Hibernate: 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=? )
Hibernate: select counterimp0_.name as name130_0_, counterimp0_.currentId as currentId130_0_ from Counter counterimp0_ where counterimp0_.name=?
Hibernate: update Counter set currentId=? where name=?
Hibernate: insert into PortletPreferences (ownerId, ownerType, plid, portletId, preferences, portletPreferencesId) values (?, ?, ?, ?, ?, ?)
Hibernate: insert into JournalArticleResource (uuid_, groupId, articleId, resourcePrimKey) values (?, ?, ?, ?)
13:00:52,067 ERROR [JDBCExceptionReporter:101] failed batch
13: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
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
	at com.liferay.portal.kernel.search.BaseIndexer.reindex(BaseIndexer.java:98)
	at com.liferay.portal.search.SearchPermissionCheckerImpl.doUpdatePermissionFields_6(SearchPermissionCheckerImpl.java:488)
	at com.liferay.portal.search.SearchPermissionCheckerImpl.updatePermissionFields(SearchPermissionCheckerImpl.java:135)
	at com.liferay.portal.kernel.search.SearchEngineUtil.updatePermissionFields(SearchEngineUtil.java:238)
	at com.liferay.portal.service.impl.ResourcePermissionLocalServiceImpl.doUpdateResourcePermission(ResourcePermissionLocalServiceImpl.java:404)
	at com.liferay.portal.service.impl.ResourcePermissionLocalServiceImpl.updateResourcePermission(ResourcePermissionLocalServiceImpl.java:441)
	at com.liferay.portal.service.impl.ResourcePermissionLocalServiceImpl.setResourcePermissions(ResourcePermissionLocalServiceImpl.java:329)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	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(DynamicDataSourceTransactionInterceptor.java:44)
	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 $Proxy69.setResourcePermissions(Unknown Source)
	at com.liferay.portal.service.impl.ResourceLocalServiceImpl.addResources_6(ResourceLocalServiceImpl.java:781)
	at com.liferay.portal.service.impl.ResourceLocalServiceImpl.addResources(ResourceLocalServiceImpl.java:192)
	at com.liferay.portal.service.impl.ResourceLocalServiceImpl.addResources(ResourceLocalServiceImpl.java:151)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	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(DynamicDataSourceTransactionInterceptor.java:44)
	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 $Proxy65.addResources(Unknown Source)
	at com.liferay.portlet.journal.service.impl.JournalArticleLocalServiceImpl.addArticleResources(JournalArticleLocalServiceImpl.java:298)
	at com.liferay.portlet.journal.service.impl.JournalArticleLocalServiceImpl.addArticle(JournalArticleLocalServiceImpl.java:235)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	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(DynamicDataSourceTransactionInterceptor.java:44)
	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 $Proxy169.addArticle(Unknown Source)
	at com.liferay.portlet.journal.service.JournalArticleLocalServiceUtil.addArticle(JournalArticleLocalServiceUtil.java:263)
	at com.liferay.portlet.journal.lar.JournalPortletDataHandlerImpl.importArticle(JournalPortletDataHandlerImpl.java:1305)
	at com.liferay.portlet.journal.lar.JournalContentPortletDataHandlerImpl.doImportData(JournalContentPortletDataHandlerImpl.java:321)
	at com.liferay.portal.kernel.lar.BasePortletDataHandler.importData(BasePortletDataHandler.java:64)
	at com.liferay.portal.lar.PortletImporter.importPortletData(PortletImporter.java:643)
	at com.liferay.portal.lar.PortletImporter.importPortletData(PortletImporter.java:545)
	at com.liferay.portal.lar.LayoutImporter.importLayouts(LayoutImporter.java:407)
	at com.liferay.portal.service.impl.LayoutLocalServiceImpl.importLayouts(LayoutLocalServiceImpl.java:680)
	at com.liferay.portal.service.impl.LayoutLocalServiceImpl.importLayouts(LayoutLocalServiceImpl.java:707)
	at com.liferay.portal.service.impl.LayoutLocalServiceImpl.importLayouts(LayoutLocalServiceImpl.java:665)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	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(DynamicDataSourceTransactionInterceptor.java:44)
	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 $Proxy28.importLayouts(Unknown Source)
	at com.liferay.portal.service.impl.LayoutServiceImpl.importLayouts(LayoutServiceImpl.java:204)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	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(DynamicDataSourceTransactionInterceptor.java:44)
	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 $Proxy29.importLayouts(Unknown Source)
	at com.liferay.portal.service.LayoutServiceUtil.importLayouts(LayoutServiceUtil.java:153)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at com.liferay.portal.kernel.util.MethodHandler.invoke(MethodHandler.java:81)
	at com.liferay.portal.kernel.util.MethodHandler.invoke(MethodHandler.java:75)
	at com.liferay.portal.servlet.TunnelServlet.doPost(TunnelServlet.java:133)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	at com.liferay.portal.kernel.servlet.PortalClassLoaderServlet.service(PortalClassLoaderServlet.java:95)
	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 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 com.liferay.portal.kernel.servlet.PortalClassLoaderFilter.doFilter(PortalClassLoaderFilter.java:53)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:196)
	at com.liferay.portal.servlet.filters.threadlocal.ThreadLocalFilter.processFilter(ThreadLocalFilter.java:35)
	at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:123)
	at com.liferay.portal.kernel.servlet.PortalClassLoaderFilter.doFilter(PortalClassLoaderFilter.java:53)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
	at java.lang.Thread.run(Thread.java:619)
Caused by: com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
	at com.liferay.portal.service.persistence.impl.BasePersistenceImpl.processException(BasePersistenceImpl.java:195)
	at com.liferay.portlet.journal.service.persistence.JournalArticlePersistenceImpl.findByR_ST(JournalArticlePersistenceImpl.java:2833)
	at com.liferay.portlet.journal.service.impl.JournalArticleLocalServiceImpl.getLatestArticle(JournalArticleLocalServiceImpl.java:1213)
	at com.liferay.portlet.journal.service.impl.JournalArticleLocalServiceImpl.getLatestArticle(JournalArticleLocalServiceImpl.java:1189)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	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(DynamicDataSourceTransactionInterceptor.java:44)
	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 $Proxy169.getLatestArticle(Unknown Source)
	at com.liferay.portlet.journal.service.JournalArticleLocalServiceUtil.getLatestArticle(JournalArticleLocalServiceUtil.java:630)
	at com.liferay.portlet.journal.util.JournalIndexer.doReindex(JournalIndexer.java:170)
	at com.liferay.portal.kernel.search.BaseIndexer.reindex(BaseIndexer.java:87)
	... 143 more
Caused by: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
	at com.liferay.portal.dao.orm.hibernate.ExceptionTranslator.translate(ExceptionTranslator.java:30)
	at com.liferay.portal.dao.orm.hibernate.QueryImpl.list(QueryImpl.java:78)
	at com.liferay.portal.kernel.dao.orm.QueryUtil.list(QueryUtil.java:67)
	at com.liferay.portal.kernel.dao.orm.QueryUtil.list(QueryUtil.java:52)
	at com.liferay.portlet.journal.service.persistence.JournalArticlePersistenceImpl.findByR_ST(JournalArticlePersistenceImpl.java:2829)
	... 165 more
Caused by: org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
	at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140)
	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128)
	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
	at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275)
	at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:114)
	at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:109)
	at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:244)
	at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2395)
	at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2858)
	at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:79)
	at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:268)
	at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:260)
	at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:179)
	at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
	at org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:64)
	at org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:1175)
	at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1251)
	at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
	at com.liferay.portal.dao.orm.hibernate.QueryImpl.list(QueryImpl.java:68)
	... 168 more
Caused by: java.sql.BatchUpdateException: failed batch
	at org.hsqldb.jdbc.jdbcStatement.executeBatch(Unknown Source)
	at org.hsqldb.jdbc.jdbcPreparedStatement.executeBatch(Unknown Source)
	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723)
	at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
	at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
	... 183 more
Hibernate: insert into PortletPreferences (ownerId, ownerType, plid, portletId, preferences, portletPreferencesId) values (?, ?, ?, ?, ?, ?)
13:00:52,113 ERROR [JDBCExceptionReporter:101] failed batch
13: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
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
	at com.liferay.portal.kernel.lar.BasePortletDataHandler.importData(BasePortletDataHandler.java:67)

Any help?