Vibe error - Packet for query is too large

  • 7017666
  • 03-Jun-2016
  • 06-Jun-2016

Environment

Novell Vibe OnPrem

Situation

Whilst executing a workflow the following error is seen:
An error occurred during this operation


Message in the appserver.log:
2016-05-23 08:21:02,397 WARN  [http-bio-443-exec-1] [org.hibernate.util.JDBCExceptionReporter] - SQL Error: 0, SQLState: S1000
2016-05-23 08:21:02,397 ERROR [http-bio-443-exec-1] [org.hibernate.util.JDBCExceptionReporter] - Packet for query is too large (1048615 > 1048576). You can change this value on the server by setting the max_allowed_packet' variable.
2016-05-23 08:21:02,600 ERROR [http-bio-443-exec-1] [org.kablink.teaming.module.binder.impl.EntryDataErrors] - Entry data error (type=0)
org.springframework.dao.TransientDataAccessResourceException: Hibernate flushing: could not update: [org.kablink.teaming.domain.CustomAttribute#8a338efc45f48847014619c9fb5824f1]; SQL [update SS_CustomAttributes set serializedValue=? where id=?]; Packet for query is too large (1048615 > 1048576). You can change this value on the server by setting the max_allowed_packet' variable.; nested exception is com.mysql.jdbc.PacketTooBigException: Packet for query is too large (1048615 > 1048576). You can change this value on the server by setting the max_allowed_packet' variable.

Resolution

Edit the following file:
Linux: /etc/my.cnf
Windows: c:\Program Files\MySQL\MySQL Server version\my.ini

Find the [mysqld] section
Add this entry: max_allowed_packet = 1024M
Restart the MySQL server