JMS Event hangs on large number of queued messages

Issue: Transactional JMS Event gets hanged for large number of en-queued messages on JMS Server when Adeptia Suite is installed with HSQLDB backend. Also, Kernel log displays "Couldn't update job data: data exception: string data, right truncation" exception frequently.

Resolution: To resolve this, Follow the below steps:

1)Stop Adeptia Server.
2)Go to "AdeptiaServer\ServerKernel\embeddedDb\db" location and open "abpmquartz.script" file.
3)Replace all the VARBINARY(16000) with the required size e.g. VARBINARY(32000).
4)Save the changes.
5)Start Adeptia Server.