Operational Defect Database
BugZero found this defect 1308 days ago.
Data sources
All data on this page is proprietary to BugZero® or gathered from public sources
Microsoft SQL Server | 11919582
KB4090004 - Improvement: Configure SESSION_TIMEOUT value for a Distributed Availability Group replica in SQL Server 2016 and 2017 - Microsoft Support
Last update date:
7/20/2023
Affected products:
SQL Server 2016 Service Pack 1
SQL Server 2016 Enterprise - duplicate (do not use)
SQL Server 2016 Developer - duplicate (do not use)
SQL Server 2016 Standard - duplicate (do not use)
SQL Server 2016 Enterprise Core - duplicate (do not use)
SQL Server 2017 on Windows (all editions)
Affected releases:
build lower than 14.0.3026.27
Fixed releases:
14.0.3026.27
Description:
Improvement
This improvement enables you to configure SESSION_TIMEOUT value for a Distributed Availability Group (DAG) replica in Microsoft SQL Server 2016 and 2017. Before installing this update, when you try to change SESSION_TIMEOUT value, you may receive the following error message: Msg 155, Level 15, State 1, Line LineNumber 'SESSION_TIMEOUT' is not a recognized ALTER AVAILABILITY GROUP option. After applying this update, you can configure the SESSION_TIMEOUT value. For example: CREATE AVAILABILITY GROUP [distributedag] WITH (DISTRIBUTED) AVAILABILITY GROUP ON 'cag' WITH ( LISTENER_URL = 'tcp://SQLServerName:5022', AVAILABILITY_MODE = ASYNCHRONOUS_COMMIT, FAILOVER_MODE = MANUAL, SEEDING_MODE = AUTOMATIC, SESSION_TIMEOUT = 10 ), 'nag' WITH ( LISTENER_URL = 'tcp://SQLServerName:5022', AVAILABILITY_MODE = ASYNCHRONOUS_COMMIT, FAILOVER_MODE = MANUAL, SEEDING_MODE = AUTOMATIC, SESSION_TIMEOUT = 10 ); GO
Resolution
Hotfix information Hotfix for SQL Server 2016 SP1 A supported update is available. We recommend that all customers apply this update. On-demand hotfix update package for SQL Server 2016 SP1 Cumulative update for SQL Server: This issue is fixed in the following cumulative updates for SQL Server: Cumulative update 7 for SQL Server 2017 Cumulative Update 2 for SQL Server 2016 SP2 Cumulative Update 10 for SQL Server 2016 SP1
