Unable to view Question tab
The following appears in the
caused by: com.atlassian.confluence.plugins.questions.api.exception.InfrastructureException: Error getting recent question ids at com.atlassian.confluence.plugins.questions.contenttype.repository.ContentTypeQuestionRepository.getRecentQuestionsIds(ContentTypeQuestionRepository.java:646) caused by: net.sf.hibernate.exception.GenericJDBCException: Could not execute query at net.sf.hibernate.exception.ErrorCodeConverter.handledNonSpecificException(ErrorCodeConverter.java:90) caused by: java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in a list is 1000
The following appears in the page:
User using Oracle and installed Confluence Questions
When user is in a group which consist of 16000 user they will face this error.
There is 2 workaround for this issue:
- Use different database such as MySql and PostgreSQL.
- Reduce the number of the user in a group to 1500 and below.