Jira Backup Fail

[AnatoliyG]

Hello,

Trying to migrate on new Jira instance.

• v6.4.12#64027-sha1:e3691cc)
• Oracle DB

When I perfom backup from JIRA (from Backup System)

I always get the error:

An exception occurred backing up: org.ofbiz.core.util.GeneralRuntimeException: Error creating GenericValue (SQL Exception while getting value: (Invalid column type: getBLOB not implemented for class oracle.jdbc.driver.T4CLongRawAccessor))

 Found the same error here: https://confluence.atlassian.com/jirakb/invalid-column-type-getblob-not-implemented-for-class-oracle-jdbc-driver-t4clongrawaccessor-during-backup-process-854131615.html

Made this:

desc propertydata
Name          Null     Type       
------------- -------- ---------- 
ID            NOT NULL NUMBER(18) 
PROPERTYVALUE          BLOB       

But this doesn't help, still get the error. 

Cant find another way to migrate.

Any ideas? 

Caused by: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while getting value:  (Invalid column type: getBLOB not implemented for class oracle.jdbc.driver.T4CLongRawAccessor)
	at org.ofbiz.core.entity.jdbc.SqlJdbcUtil.getValue(SqlJdbcUtil.java:728)
	at org.ofbiz.core.entity.EntityListIterator.currentGenericValue(EntityListIterator.java:169)
	at org.ofbiz.core.entity.EntityListIterator.next(EntityListIterator.java:246)
	... 199 more
Caused by: java.sql.SQLException: Invalid column type: getBLOB not implemented for class oracle.jdbc.driver.T4CLongRawAccessor
	at oracle.jdbc.driver.Accessor.getBLOB(Accessor.java:1270)
	at oracle.jdbc.driver.OracleResultSetImpl.getBLOB(OracleResultSetImpl.java:1623)
	at oracle.jdbc.driver.OracleResultSetImpl.getBlob(OracleResultSetImpl.java:585)
	at org.apache.commons.dbcp.DelegatingResultSet.getBlob(DelegatingResultSet.java:550)
	at org.apache.commons.dbcp.DelegatingResultSet.getBlob(DelegatingResultSet.java:550)
	at org.ofbiz.core.entity.jdbc.SqlJdbcUtil.getValue(SqlJdbcUtil.java:647)
	... 201 more

[somethingblue · Accepted solution]

Hi Artem,

If you are still running into this issue please run the database integrity checker for JIRA.  If it finds any issues let it fix the problems per step 4 of the Using the database integrity checker knowledge base article.

In addition, it appears you may be running into the bug documented in JRASERVER-47267.  Please review that bug ticket and follow the work around if you agree that applies to your situation.

Cheers,

Branden

[AnatoliyG]

You're right. It was JRASERVER-47267. 

And I was resolve the situation in few hours with atlassian support team.

Thank you!

[nishant · Accepted solution]

I am getting this erroe while taking the backup. can you help me in this. i need to switch my jira server o jira cloud.

I want to move it to jira cloud with all my attachments and backup. Please help me in doing that.