BLOB datatype

[Nikolay Galushko]

Appears Great Gadgets store some data in Jira database in a BLOB datatype.

This causes failure or system backup ( may be smth. else).

Please refer to the link below:

https://confluence.atlassian.com/jirakb/jira-xml-backup-fails-throws-java-lang-noclassdeffounderror-javax-xml-bind-datatypeconverter-895910465.html

And the screenshots.

Please check and fix.

Thank you

[Danut M [StonikByte]]

Hi @Nikolay Galushko

We fixed this issue in version 1.5.1 by introducing a new database table named “ao_?????_sbcache_results“, which does not use the BLOB type. Unfortunately the active objects framework used by Jira does not seem to remove the old table automatically. So please manually drop the old table “ao_?????_sbcache_result“ from the Jira database because it is no longer used. After this, the backup error should no longer occur.

Let me know if this solved the issue.

Thank you,

Danut Manda