Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-14474

Mail portlet not synchronizing all the mails

    Details

    • Type: Bug
    • Status: Closed
    • Resolution: Fixed
    • Affects Version/s: 6.0.5 GA
    • Fix Version/s: --Sprint 12/11, 6.1.0 CE RC1
    • Component/s: Mail
    • Labels:
      None
    • Environment:
      Liferay 6.0.5, Ubuntu
    • Liferay Contributor's Agreement:
      Accept

      Description

      we are using Mail portlet in Liferay 6.0.5. It is working fine But it is not synchronizing all the mails properly. when we navigate all the mails through pagination, it stopped showing mails in some level and throws error in console like this:

      Stacktrace:
      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.engine.ActionQueue.executeActions(ActionQueue.java:262)
      at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:178)
      at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
      at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:51)
      at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1206)
      at com.liferay.portal.dao.orm.hibernate.SessionImpl.flush(SessionImpl.java:115)
      ... 54 more
      Caused by: java.sql.BatchUpdateException: Incorrect string value: '\xEF\x83\xA0 Ma...' for column 'subject' at row 1
      at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1257)
      at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:943)
      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)

      Caused by: java.sql.BatchUpdateException: Incorrect string value: '\xE0\xAE\xB5\xE0\xAF\x87...' for column 'sender' at row 1
      at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1257)
      at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:943)
      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)
      ... 280 more

        Attachments

          Activity

            People

            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:
                Days since last comment:
                7 years, 46 weeks ago

                Packages

                Version Package
                --Sprint 12/11
                6.1.0 CE RC1