Home Dashboard Directory Help
Search

Denali - HADRON: 'READ_ONLY_ROUTING_URL' is not yet implemented. by Karola_Shanker


Status: 

Closed
 as By Design Help for as By Design


1
1
Sign in
to vote
Type: Bug
ID: 682581
Opened: 8/1/2011 1:16:27 PM
Access Restriction: Public
0
Workaround(s)
view
0
User(s) can reproduce this bug

Description

Error when executing following error -

Alter availability group [xxxxx] MODIFY REPLICA ON N'yyyyy'
WITH (SECONDARY_ROLE(READ_ONLY_ROUTING_URL=N'TCP://yyyyy:1433'))

Error description:
'READ_ONLY_ROUTING_URL' is not yet implemented.

Scripts got executed successfully after doing failover. Is Read_ONLY_Routing_URL expecting to do thefailover first?
Details
Sign in to post a comment.
Posted by Microsoft on 8/1/2011 at 5:50 PM
Note -T9532 is only needed for CTP3 bits, subsequent SQL releases should not require this trace flag for ALTER AVAILABILITY GROUP to function.
Posted by Microsoft on 8/1/2011 at 5:49 PM
The issue here was due to not enabling trace flag -T 9532. This trace flag is required for the ALTER AVAILABILITY GROUP MODIFY transact-SQL to function properly. When you configure the service startup with -T 9532, you also need to restart the SQL Server service for the trace flag to take effect.
Posted by Microsoft on 8/1/2011 at 1:37 PM
Thanks for reporting this, some functions of Alter Availability group is under trace flag T9532, can you confirm if you've enabled this traceflag.
Sign in to post a workaround.