Error when connecting to SQL Server
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Summary
Problem
When configuring Bamboo to connect to SQL Server, the following appears in the atlassian-bamboo.log
1
2
3
4
2016-08-31 16:20:54,666 ERROR [performSetupDatabaseConnectionBackgroundThread] [SchemaExport] HHH000389: Unsuccessful: create table AUTH_ATTEMPT_INFO (ID bigint not null, USER_NAME nvarchar(255) not null, AUTH_COUNT int, LAST_AUTH_TIMESTAMP date not null, primary key (ID))
2016-08-31 16:20:54,666 ERROR [performSetupDatabaseConnectionBackgroundThread] [SchemaExport] Column, parameter, or variable #4: Cannot find data type date.
2016-08-31 16:20:54,666 ERROR [performSetupDatabaseConnectionBackgroundThread] [SchemaExport] HHH000389: Unsuccessful: create table BRANCH_COMMIT_INFO (BRANCH_COMMIT_INFO_ID bigint not null, BRANCH_ID bigint not null, CREATING_AUTHOR_ID bigint, CREATING_COMMIT_DATE datetime2, CREATING_CHANGE_SET_ID nvarchar(4000), LATEST_COMMIT_AUTHOR_ID bigint, LATEST_COMMIT_DATE datetime2, LATEST_COMMIT_CHANGE_SET_ID nvarchar(4000), primary key (BRANCH_COMMIT_INFO_ID))
2016-08-31 16:20:54,666 ERROR [performSetupDatabaseConnectionBackgroundThread] [SchemaExport] Column, parameter, or variable #4: Cannot find data type datetime2.Diagnosis
Run the following SQL query to confirm SQL Server version:
1
SELECT @@versionCause
Bamboo is connected with unsupported SQL Server version 2005 but the data type date does not exist in SQL Server 2005.
Solution
Resolution
Upgrade SQL Server to the supported version as shown in Supported platforms
Was this helpful?