Uploaded image for project: 'Bamboo Data Center'
  1. Bamboo Data Center
  2. BAM-18610

Update MSSQL documentation

XMLWordPrintable

    • 0
    • 4

    • Our product teams collect and evaluate feedback from a number of different sources. To learn more about how we use customer feedback in the planning process, check out our new feature policy.

      Problem Definition

      If Bamboo is configured to use Integrated Security with MSSQL and no default schema is set, the schema will be set to the user's ID. For example, if I had a domain account MYDOMAIN\myuser, that value would be used when creating the Bamboo database. This is especially an issue during upgrades and was reported on upgrade from Bamboo version 6.0.3 to 6.1.0.

      Suggested Solution

      Could we please update the documentation to request that customers add the following parameter to <bamboo-home>\bamboo.cfg.xml:

      <property name="hibernate.default_schema">dbo</property>

      Workaround

      If this issue is encountered, please:

      1. Stop Bamboo
      2. Roll back the most recent upgrade attempt where these tables would have been created
      3. Check your database to be sure that no unneeded schemas exist
      4. Add the following parameter to <bamboo-home>\bamboo.cfg.xml: 
        <property name="hibernate.default_schema">dbo</property>
      5. Start Bamboo and let the upgrade run

            [BAM-18610] Update MSSQL documentation

            Martyna Wojtas (Inactive) made changes -
            Resolution New: Timed out [ 10 ]
            Status Original: Gathering Interest [ 11772 ] New: Closed [ 6 ]
            Martyna Wojtas (Inactive) made changes -
            Labels Original: doc New: bamboo-bugs-grooming doc
            Gosia Kowalska made changes -
            Remote Link New: This issue links to "Page (Confluence)" [ 451776 ]
            Katherine Yabut made changes -
            Workflow Original: JAC Suggestion Workflow [ 3014281 ] New: JAC Suggestion Workflow 3 [ 3603775 ]
            SET Analytics Bot made changes -
            Support reference count Original: 3 New: 4
            Owen made changes -
            Workflow Original: Confluence Workflow - Public Facing v4 [ 2703693 ] New: JAC Suggestion Workflow [ 3014281 ]
            Krystian Brazulewicz made changes -
            UIS New: 0
            SET Analytics Bot made changes -
            Support reference count New: 3
            Owen made changes -
            Issue Type Original: New Feature [ 2 ] New: Suggestion [ 10000 ]
            Owen made changes -
            Status Original: Not Being Considered [ 11776 ] New: Gathering Interest [ 11772 ]

              Unassigned Unassigned
              ezeidan Ellie Z (they/them)
              Votes:
              1 Vote for this issue
              Watchers:
              5 Start watching this issue

                Created:
                Updated:
                Resolved: