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=/secure/Dashboard.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.