Jira Align Self-Hosted: Error Upgrading to 10.128.2 on Azure SQL PaaS
Summary
Unable to upgrade to Jira Align 10.128.2 (ro later) running on Azure SQL PaaS Database
⚠️ Where the version being upgraded from is earlier than 10.128.2
ℹ️ The Self-Hosted version of Jira Align is sometimes referred to as the 'On-Prem' or 'On-Premise' version
Environment
Jira Align Self-Hosted
Diagnosis
The following error is shown after running the C:\[YOURCOMPANYNAME]\Releases\[VERSION]Deploy-only-CUSTOMERNAME.bat:
'msdb.dbo.rds_cdc_enable_db' is not supported in this version of SQL Server.
Cause
The error is related to the SQL Server version not supporting the 'msdb.dbo.rds_cdc_enable_db' command, the CDC is being introduced in Jira Align 10.128., it wasn’t used before.
Solution
Enable the CDC on Azure SQL Jira Align CUSTOMER_DATABASE as mentioned in Microsoft's official guide
EXEC sys.sp_cdc_enable_db;
GOℹ️ It is also possible to check which databases have the CDC enabled by running:
select
name,
is_cdc_enabled
from sys.databases;Comment out the following script installation lines in 'JiraAlign-10.128.2.20\Sources\DbManagementScripts\Setup\Database\Migrations\20231026_2236Z_jarda-4123_cdc-add-sp-to-aligndb.sql':
by adjusting line 24:
-- exec msdb.dbo.rds_cdc_enable_db @dband also surround lines 684-687 to comment them out as a block
|/*
if @action = 'disable'
begin
exec msdb.dbo.rds_cdc_disable_db @db
end
*/Proceed with the installation of Jira Align Web service by running C:\[YOURCOMPANYNAME]\Releases\[VERSION]Deploy-only-CUSTOMERNAME.bat.
Start the Jira Align IIS Service
Related Content:
Upgrade self-hosted Jira Align instances
Change data capture (CDC) with Azure SQL Database - Azure SQL Database
Was this helpful?