'Exception in thread PersonalInformationRepair' Reported after Upgrading to Version 2.9.2 or Higher

Still need help?

The Atlassian Community is here for you.

Ask the community


After upgrading to Confluence 2.9.2 or higher, an error like the following is reported:

Exception in thread "PersonalInformationRepair" org.springframework.dao.DataAccessResourceFailureException: PreparedStatementCallback; SQL [select distinct(c.CREATOR) from CONTENT c LEFT OUTER JOIN CONTENT pi on c.CREATOR = pi.USERNAME where pi.USERNAME IS NULL AND c.CREATOR IS NOT NULL\]; No operations allowed after statement closed.; 


The migration required to enable the contributor search added in Confluence 2.9 was not successfully completed.


Manually complete the migration by following the instructions at Enabling Contributor Filtering for Search.

Last modified on Mar 30, 2016

Was this helpful?

Provide feedback about this article
Powered by Confluence and Scroll Viewport.