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

error publish stage to live when web content contains reference to resource file

    Details

    • Type: Bug
    • Status: Closed
    • Resolution: Fixed
    • Affects Version/s: 6.0.6 GA
    • Fix Version/s: None
    • Component/s: Staging
    • Labels:
      None
    • Branch Version/s:
      6.0.x

      Description

      1. in the community guest
      2. Create a page in this community.
      3. Set up staging environment to the community.
      4. Go to Control Panel / Web Content.
      5. Create a structure with document library type Row and create a template.
      6. Create a web content with structure and template. When create a web content, select a document, then save.
      7. Back to the community (staging), publish to live.
      8. Go to Control Panel / Web Content, edit the web content name, then save.
      9. Back to the community (staging), publish to live again.

      I get an error
      Caused by: com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.ConstraintViolationExc
      d not execute JDBC batch update
      ....
      Caused by: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
      at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:96)
      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)
      ... 265 more
      Caused by: java.sql.BatchUpdateException: Duplicate entry '10157-' for key 'IX_88DF994A'
      at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1257)
      --------------------

      where key 'IX_88DF994A' is for table journalarticleresource

      it is like LPS-12089 ? but not fixed 6.0.6

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Days since last comment:
                  8 years, 12 weeks, 4 days ago

                  Packages

                  Version Package