I have an Always-On architecture with two nodes and two AG. One of AG working correctly but other AG's listener only directs to the primary node. When I fail it to the secondary node, the application goes down. When I check everything looks fine.
select * from sys.dm_tcp_listener_states
select * from sys.availability_group_listeners
select * from sys.availability_group_listener_ip_addresses