Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Problem before upgrade to 8.22.6

David González
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
December 26, 2023

We have an error, and we are unable to access issues, it seems a problema with migration DDBB schema

Exception during health check invocation com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT pkey, issuenum, PROJECT, REPORTER, ASSIGNEE, CREATOR, issuetype, SUMMARY, DESCRIPTION, ENVIRONMENT, PRIORITY, RESOLUTION, issuestatus, CREATED, UPDATED, DUEDATE, RESOLUTIONDATE, VOTES, WATCHES, TIMEORIGINALESTIMATE, TIMEESTIMATE, TIMESPENT, WORKFLOW_ID, SECURITY, FIXFOR, COMPONENT, ARCHIVED, ARCHIVEDBY, ARCHIVEDDATE FROM jiraissue WHERE ID=? (Unknown column 'ARCHIVED' in 'field list')

 

2 answers

1 vote
Dan Breyen
Community Champion
December 26, 2023

Hi David, I'm no expert on Jira Server issue, but I found this when I googled your error: 

/unknown-column-error-when-upgrading 

That's for Confluence, but it might be related.

Hope that helps.

0 votes
Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 26, 2023

Welcome to the Atlassian Community!

That suggests your upgrade failed - the database has not been altered to match the new schema for the new version.

How did you do the upgrade?

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
SERVER
TAGS
AUG Leaders

Atlassian Community Events