getting a " Oops - an error has occurred "

[Hyunmin Kim]

I try to login via SSH tunnel on company server.

I got the below error.

How can I solve this problem?

Technical details

Log's referral number: 3ad8718d-09d7-44db-bbdd-3c4e7119bfd4

Cause

Referer URL: http://localhost:8080/login.jsp?os_destination=%2Fsecure%2FDashboard.jspa

com.atlassian.cache.CacheException: com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT DISTINCT lower_parent_name FROM public.cwd_membership WHERE (directory_id =  ? ) AND (lower_child_name =  ? ) AND (membership_type =  ? ) ORDER BY lower_parent_name (ERROR: column "lower_parent_name" does not exist
  Position: 17)

com.atlassian.cache.CacheException: com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT DISTINCT lower_parent_name FROM public.cwd_membership WHERE (directory_id =  ? ) AND (lower_child_name =  ? ) AND (membership_type =  ? ) ORDER BY lower_parent_name (ERROR: column "lower_parent_name" does not exist
      Position: 17)
...

[Alexey Matveev]

Hello,

There is something wrong with the database. Can you execute this query directly in the database and have a look at the error. If you have the same error, it means that somehow Jira's table structure was modified. You need to restore Jira from a backup.

[Hyunmin Kim]

First, I backuped from Jira Cloud.

and I try to restore the data to Jira Server. (postgresql)

How can I handle this problem? 

[Alexey Matveev]

Kindly make sure that you followed this guide while migrating from Cloud to Server:

https://confluence.atlassian.com/adminjiraserver/migrating-from-jira-cloud-to-server-applications-938846963.html

[Hyunmin Kim]

I already tried to migrate by followed your link.

I don't know why the difference column exists between server and cloud version of jira.