Could not find column '<column_name>' in previously parsed query!
Platform notice: Server and Data Center only. This article only applies to Atlassian products on the Server and Data Center platforms.
Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Problem
When navigating to a branch of a repository in Bitbucket Server a Server Error is displayed, or when trying to clone a repository the following error is returned on the console:
remote: Repository hook com.atlassian.bitbucket.server.bitbucket-ref-restriction:restrictionEnforcerHook failed
remote: bundle [com.atlassian.bitbucket.server.bitbucket-ref-restriction]
The following appears in the atlassian-bitbucket.log
:
Caused by: java.lang.IllegalStateException: Could not find column '<column_name>' in previously parsed query!
Diagnosis
Bitbucket Server is using Oracle as its backend database.
Cause
The Oracle user that Bitbucket Server is configured to connect to the database with has too many permissions.
Resolution
To resolve this problem, revoke extraneous permissions from the Oracle user that Bitbucket Server uses to connect to the database by running the following queries:
REVOKE SELECT ANY TABLE FROM <db_user>;
REVOKE DBA FROM <db_user>;
REVOKE EXP_FULL_DATABASE FROM <db_user>;
where <db_user>
is the Oracle username that Bitbucket Server uses to connect to the database.