Details
-
Bug
-
Resolution: Fixed
-
Low
-
None
-
None
-
None
-
2
-
Severity 2 - Major
Description
Issue Summary
Launching the migration assistant results in an error: "We can't communicate with your server. We're having trouble communicating with your server instance. Please try again. If this doesn't fix the issue. contact support for help"
Environment
Server instance with 1000+ spaces
Steps to Reproduce
- Create an instance with more than 1000 spaces
- Launch the migration assistant
Expected Results
The assistant loads and returns data on the spaces
Actual Results
An exception like the one below is thrown in the atlassian-confluence.log file:
2021-04-30 00:42:19,813 WARN [SiteSummaryCalculator:thread-1] [hibernate.query.internal.QueryParameterBindingsImpl] doLogf HHH000443: Dialect [com.atlassian.migration.agent.store.jpa.impl.OracleDialect] limits the number of elements in an IN predicate to 1000 entries. However, the given parameter list [keys] contained 3457 entries, which will likely cause failures to execute the query in the database 2021-04-30 00:42:19,965 ERROR [SiteSummaryCalculator:thread-1] [engine.jdbc.spi.SqlExceptionHelper] doLog ORA-01795: maximum number of expressions in a list is 1000 2021-04-30 00:42:19,967 ERROR [http-nio2-8011-exec-6] [common.error.jersey.ThrowableExceptionMapper] toResponse Uncaught exception thrown by REST service: Failed to load server statistics -- referer: https://confluence.base.url/admin/migration.action | url: /rest/migration/latest/stats/server | traceId: 8c1944ae44e26d55 | userName: admin com.atlassian.migration.agent.service.FailedToLoadStatsException: Failed to load server statistics ... Caused by: java.util.concurrent.ExecutionException: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not extract ResultSet ... Caused by: java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in a list is 1000
Workaround
Currently there is no known workaround for this behavior. A workaround will be added here when available
Attachments
Issue Links
- blocks
-
MOVE-22863 Loading...
- causes
-
PSR-627 Loading...