Migrating Confluence on SQL Server with collection setting results blank list of spaces during migration plan

XMLWordPrintable

    • 1

      Confluence migration tool blank list of spaces

      Steps to Reproduce

      1. Create a Confluence Server/DC instance with SQL Server having a collation setting that enforces case sensitive table names for DDL identifiers
      2. Create a migration plan
      3. In the Space panel, filter by any migration status

      Expected Results

      List all spaces in your DC.

      Actual Results

      Empty list of spaces with a pop error will display.

      The below exception is thrown in the atlassian-confluence.log file:

      Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'EXECUTIONSTATUS'.	at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:270)	at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1735)	at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:675)	at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:594)	at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7745)	at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:4391)	at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:276)	at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:246)	at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:509)	at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)	at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java)	at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:722)	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:648)	... 450 more

      Workaround

      Do not filter your items by status. Instead, filter by project name, or use "Select with CSV file" or use MAPI to create your plan https://community.atlassian.com/forums/Community-Announcements-articles/Migrations-API-MAPI-is-now-in-General-Availability/ba-p/2710605

            Assignee:
            Rafael Buzzi
            Reporter:
            Alan Prado
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated: