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