org.hibernate.exception.GenericJDBCException: could not update: [com.pentaho.repository.dbbased.solution.RepositoryFile#c6107913-ca68-11dc-98dc-5d7c50ee1b1e]

Pentaho BI Platform Tracking | gunter rombauts | 9 years ago
  1. 0

    When you publish the metadata.xmi file to the server, it is sent in 1 chunk to the database. This works in MySQL as long as the wmi file is smaller then the max_allowed_packet variable. As you cannot make this value too high, you will end up with the following error message in some cases (If the size of metadata.xmi is big enough). In mu case metadata.xmi=3810136 while max_allowed_packet=1048576 2008-02-07 10:53:15,578 INFO [STDOUT] 10:53:15,578 DEBUG [JDBCTransaction] commit 2008-02-07 10:53:15,890 WARN [JDBCExceptionReporter] SQL Error: 0, SQLState: S1000 2008-02-07 10:53:15,890 ERROR [JDBCExceptionReporter] Packet for query is too large (3810136 > 1048576). You can change this value on the server by setting the max_allowed_packet' variabl 2008-02-07 10:53:15,890 ERROR [AbstractFlushingEventListener] Could not synchronize database state with session org.hibernate.exception.GenericJDBCException: could not update: [com.pentaho.repository.dbbased.solution.RepositoryFile#c6107913-ca68-11dc-98dc-5d7c50ee1b1e] at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103) at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2425) at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:2307) at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2607) at org.hibernate.action.EntityUpdateAction.execute(EntityUpdateAction.java:92) at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:234) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:142) at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298) at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27) at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000) at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338) at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106) at org.pentaho.repository.HibernateUtil.commitTransaction(Unknown Source) at com.pentaho.repository.dbbased.solution.SolutionRepository.addSolutionFile(Unknown Source) at org.pentaho.ui.servlet.RepositoryFilePublisher.doGet(Unknown Source) at org.pentaho.ui.servlet.RepositoryFilePublisher.doPost(Unknown Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)

    Pentaho BI Platform Tracking | 9 years ago | gunter rombauts
    org.hibernate.exception.GenericJDBCException: could not update: [com.pentaho.repository.dbbased.solution.RepositoryFile#c6107913-ca68-11dc-98dc-5d7c50ee1b1e]
  2. 0

    When you publish the metadata.xmi file to the server, it is sent in 1 chunk to the database. This works in MySQL as long as the wmi file is smaller then the max_allowed_packet variable. As you cannot make this value too high, you will end up with the following error message in some cases (If the size of metadata.xmi is big enough). In mu case metadata.xmi=3810136 while max_allowed_packet=1048576 2008-02-07 10:53:15,578 INFO [STDOUT] 10:53:15,578 DEBUG [JDBCTransaction] commit 2008-02-07 10:53:15,890 WARN [JDBCExceptionReporter] SQL Error: 0, SQLState: S1000 2008-02-07 10:53:15,890 ERROR [JDBCExceptionReporter] Packet for query is too large (3810136 > 1048576). You can change this value on the server by setting the max_allowed_packet' variabl 2008-02-07 10:53:15,890 ERROR [AbstractFlushingEventListener] Could not synchronize database state with session org.hibernate.exception.GenericJDBCException: could not update: [com.pentaho.repository.dbbased.solution.RepositoryFile#c6107913-ca68-11dc-98dc-5d7c50ee1b1e] at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103) at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2425) at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:2307) at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2607) at org.hibernate.action.EntityUpdateAction.execute(EntityUpdateAction.java:92) at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:234) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:142) at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298) at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27) at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000) at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338) at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106) at org.pentaho.repository.HibernateUtil.commitTransaction(Unknown Source) at com.pentaho.repository.dbbased.solution.SolutionRepository.addSolutionFile(Unknown Source) at org.pentaho.ui.servlet.RepositoryFilePublisher.doGet(Unknown Source) at org.pentaho.ui.servlet.RepositoryFilePublisher.doPost(Unknown Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)

    Pentaho BI Platform Tracking | 9 years ago | gunter rombauts
    org.hibernate.exception.GenericJDBCException: could not update: [com.pentaho.repository.dbbased.solution.RepositoryFile#c6107913-ca68-11dc-98dc-5d7c50ee1b1e]
  3. 0

    insert/update timeout

    Google Groups | 9 years ago | hhale21
    org.hibernate.exception.GenericJDBCException: could not update: [ca.digitalrapids.licenseServer.constraints.model.AccessGrant#2]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Hibernate Community • View topic - java.sql.SQLException: could not reset reader -- Blobs in Hi

    hibernate.org | 6 months ago
    org.hibernate.exception.GenericJDBCException: could not update: [net.bioclipse.lis.pojos.DrugOrigin#116]
  6. 0

    Error Endeca baseline_update.sh

    Oracle Community | 11 months ago | 3145960
    org.hibernate.exception.GenericJDBCException: could not update: [com.endeca.esf.shared.status.ServerStatus#COMPONENT/VTRTOL/AuthoringDgraph]

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. org.hibernate.exception.GenericJDBCException

      could not update: [com.pentaho.repository.dbbased.solution.RepositoryFile#c6107913-ca68-11dc-98dc-5d7c50ee1b1e]

      at org.hibernate.exception.SQLStateConverter.handledNonSpecificException()
    2. Hibernate
      AbstractEntityPersister.update
      1. org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
      2. org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
      3. org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
      4. org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2425)
      5. org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:2307)
      6. org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2607)
      6 frames
    3. Hibernate
      EntityUpdateAction.execute
      1. org.hibernate.action.EntityUpdateAction.execute(EntityUpdateAction.java:92)
      1 frame
    4. Hibernate
      ActionQueue.executeActions
      1. org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250)
      2. org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:234)
      3. org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:142)
      3 frames
    5. Hibernate
      SessionImpl.managedFlush
      1. org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
      2. org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
      3. org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
      4. org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
      4 frames
    6. Hibernate
      JDBCTransaction.commit
      1. org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
      1 frame
    7. org.pentaho.repository
      HibernateUtil.commitTransaction
      1. org.pentaho.repository.HibernateUtil.commitTransaction(Unknown Source)
      1 frame
    8. com.pentaho.repository
      SolutionRepository.addSolutionFile
      1. com.pentaho.repository.dbbased.solution.SolutionRepository.addSolutionFile(Unknown Source)
      1 frame
    9. org.pentaho.ui
      RepositoryFilePublisher.doPost
      1. org.pentaho.ui.servlet.RepositoryFilePublisher.doGet(Unknown Source)
      2. org.pentaho.ui.servlet.RepositoryFilePublisher.doPost(Unknown Source)
      2 frames
    10. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
      1 frame