"Could not get clob value for"

Question

Hi

When I try to make a XML backup file in JIRA It show me an error:

image2016-1-19 8:54:35.png

I see atlassian-jira.log and it show me the following error.

com.atlassian.activeobjects.spi.ActiveObjectsImportExportException: There was an error during import/export with plugin Jitter Notify - In-App Notifications for JIRA(com.jitterplugin.jira.jitter-notify) #0.4 (table AO_0BE43A_NOTIFICATION_BODY):Could not get clob value for col #1

Did you have any experience like this and are there any resolution for that?

image2016-1-19 8:54:35.png

crf · Answer

(Just in case the linked text was too subtle... the knowledge base article I'm talking about is here: https://confluence.atlassian.com/pages/viewpage.action?pageId=780863295 )

Vasiliy Zverev · Answer

* Ask for support here:https://jitter.uservoice.com/
* It seem some trouble with database. Try to check values into this table via SQL.

Select 
	AO_0BE43A_NOTIFICATION_BODY.*
from
	AO_0BE43A_NOTIFICATION_BODY

It has to be column with clobe valus, perhaps some values are corrupted.

crf · Answer

This knowledge base article is for Confluence, but the AO code would work more or less the same in both products, and it says that this is due to a bug in the OJDBC 7 Oracle Driver version 12.1.0.1.0.

The remediation steps listed there sound like they would work just as well for JIRA.