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.
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
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