Uploaded image for project: 'Migration Platform'
  1. Migration Platform
  2. MIG-590

Migration assistant doesn't launch due to ORA-01795

    XMLWordPrintable

Details

    • 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

      1. Create an instance with more than 1000 spaces
      2. 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

          Activity

            People

              d64d1edffe88 Oleg Timoshenko
              btom1 Brian
              Votes:
              1 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

                Created:
                Updated: