Uploaded image for project: 'Bitbucket Data Center'
  1. Bitbucket Data Center
  2. BSERV-3990

Mismatches in SQL Server database names cause inscrutable migration errors

    XMLWordPrintable

Details

    Description

      If the database's name is "stash" (lowercase "s") and "Stash" (uppercase "S") is entered in the database name during migration (or setup), the following error will be produced:

      The database name component of the object qualifier must be the name of the current database.
      com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)
      com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515)
      

      Due to an error handling regression in 2.7.0 from changes made to support backup and restore, the exception details are hidden and the UI simply shows "A database error has occurred."

      NOTE: Don't trust third party connection parameters as they mask the problem. Connect directly using SQL Server Management Studio and confirm the name or connect from the command line and run

      EXEC sp_databases

      . Confirm connectivity by using brackets in SQL calls, e.g.:

      select * from [Stashdb].[dbo].[DATABASECHANGELOG]

      Attachments

        Activity

          People

            Unassigned Unassigned
            bturner Bryan Turner (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: