Portfolio Recomputation: ORA-01795: maximum number of expressions in a list is 1000

SonarQube Server / Community Build
, ,
1

We are using SonarQube Server Enterprise Edition v2025.2 (105476) and have some large Portfolios.
We are using Oracle as the database and now we receive the following error in the recomputations of this portfolios:

org.apache.ibatis.exceptions.PersistenceException:
### Error querying database. Cause: java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in a list is 1000

ORA-01795 - Database Error Messages
### The error may exist in org.sonar.db.project.ProjectMapper
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: select p.uuid as uuid, p.kee as kee, p.qualifier as qualifier, p.name as name, p.description as description, p.tags as tagsString, p.private as isPrivate, p.creation_method as creationMethod, p.contains_ai_code as containsAiCode, p.detected_ai_code as detectedAiCode, p.ai_code_fix_enabled as aiCodeFixEnabled, p.created_at as createdAt, p.updated_at as updatedAt from projects p where p.qualifier=‘TRK’ and p.kee in ( ? , ? , […]

2

Hey there.

Thanks for the report. This is a known issue tracked at SONAR-24712.

It will be fixed in 2025.3, which should be released at the end of this month.