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.
Article is closed for comments.