Error when connecting to SQL Server
Problem
When configuring Bamboo to connect to SQL Server, the following appears in the atlassian-bamboo.log
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:
SELECT @@versionCause
Bamboo is connected with unsupported SQL Server version 2005 but the data type date does not exist in SQL Server 2005.
Resolution
Upgrade SQL Server to the supported version as shown in Supported platforms
Last modified on Sep 2, 2016
Powered by Confluence and Scroll Viewport.