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

Update MSSQL documentation

    XMLWordPrintable

    Details

    • UIS:
      0
    • Support reference count:
      4
    • Feedback Policy:

      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.

      Description

      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

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              ezeidan Elias Zeidan
              Votes:
              1 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: