SQL Server Lock Dashboard displays error message - The target database, 'xxxx', is participating in an availability group and is currently not accessible for queries. (4341647)

Chatee ahora con Soporte

Obtener ayuda en vivo
Completar registro

Iniciar sesión

Solicitar precios

Comuníquese con Ventas

SQL Server Lock Dashboard displays error message - The target database, 'xxxx', is participating in an availability group and is currently not accessible for queries. (4341647)

Regresar

Comentarios enviados

¿Este artículo solucionó su problema?

Seleccionar calificación

Título

SQL Server Lock Dashboard displays error message - The target database, 'xxxx', is participating in an availability group and is currently not accessible for queries.
Descripción

The following error appears on database dashboard "Overview | SQL Activity | Locks":
"An error occurred while trying to retrieve data to this screen."
The following message captured in the agent log:
---
2019-10-14 15:05:56.988 ERROR [RMI TCP Connection(47)-10.242.95.107] com.quest.qsi.fason.core.collection.RMISubmissionCollection - An exception occurred during the execution of a processor from com.quest.qsi.fason.sqlserver.collection.processor.DBSSRMICallbacklGeneralProcessor class. The processor belongs to LOCKS_LIST collection.
java.lang.RuntimeException: java.lang.RuntimeException: Failed to execute collection [LOCKS_LIST], reason=[Foglight][SQLServer JDBC Driver][SQLServer]The target database, 'xxxxxx', is participating in an availability group and is currently not accessible for queries.
---
Causa

Read access must give to all databases under the same availability group
Resolución

Issue resolved after granting read access to all the databases under the same availability group

Comentarios enviados

¿Este artículo solucionó su problema?

Seleccionar calificación

Solicitar un artículo KB

Contenido recomendado

Producto(s):: Foglight
6.1.0, 6.0.0, 5.9.8, 5.9.7, 5.9.5, 5.9.4, 5.9.3, 5.9.2; Foglight for Databases
6.1.0, 6.0.0, 5.9.7, 5.9.5, 5.9.4, 5.9.3, 5.9.2

Tema(s):: Troubleshooting

Historial del artículo:: Creado el: 10/17/2019
Última actualización: 5/7/2023

Buscar todos los artículos

Seleccione su producto:

Con el fin de ofrecerle un mejor servicio, complete el campo Motivo del chat:

Soluciones recomendadas para su problema

SQL Server Lock Dashboard displays error message - The target database, 'xxxx', is participating in an availability group and is currently not accessible for queries. (4341647)

Título

Descripción

Causa

Resolución

Leave a Comment