AppSync: Falha no plano do serviço SQL durante a fase de detecção do aplicativo com o erro: Unable to connect to database.
Summary:
O plano do serviço SQL falhou durante a fase de detecção do aplicativo com erro: Unable to connect to database Unable to connect to database. This can happen if either SQL
database is not in online state or ODBC driver is not properly installed. Check the AppSync host plug-in log for more details.
...
Bu makale şunlar için geçerlidir:
Bu makale şunlar için geçerli değildir:
Bu makale, belirli bir ürüne bağlı değildir.
Bu makalede tüm ürün sürümleri tanımlanmamıştır.
Symptoms
O plano do serviço falhou durante a fase de detecção do aplicativo com o erro: Unable to connect to database Unable to connect to database <Db name>. This can happen if either SQL database is not in online state or ODBC driver is not properly installed.
Check the AppSync host plug-in log for more details.
Registro de eventos do AppSync:
Logs do servidor AppSync:
Check the AppSync host plug-in log for more details.
Registro de eventos do AppSync:
Application discovery,7d2c438e-6ea7-4bb9-b515-0ce2594f9315,SQL_000141,<AppSync Server>,Unable to connect to database <Db name>. This can happen if either SQL database is not in online state or ODBC driver is not properly installed. Check the AppSync host plug-in log for more details.
Logs do servidor AppSync:
07-02-2021 06:00:05.840 INFO [Thread-28455 (HornetQ-client-global-threads-320952484)] [com.emc.archway.service.eventservice.EventServiceBean] [ASServer] [] d96dbf19-8962-4ef4-9e53-9d22e4af3e33->>> EVENT [SQL_000141]: Unable to connect to database hostname.master. This can happen if either SQL database is not in online state or ODBC driver is not properly installed. Check the AppSync host plug-in log for more details.(METADATA: TYPE-ERROR, TIME-2021-07-02 06:00:05.840-0600NATIVETIME-2021-07-02 06:00:05.643-0600, HOST-hostname.a.b.corporate. com, PHASE-Application discovery, THREAD=17152, USER-null, CATEGORY-GENERIC, SESSIONID-null)
07-02-2021 06:00:05.841 ERROR [Thread-28455 (HornetQ-client-global-threads-320952484)] [org.jboss.as.ejb3.invocation] [ASServer] [] WFLYEJB0034: EJB Invocation failed on component SqlServiceBean for method public com.emc.archway.objectmodel.host.sql.SqlServerInstances com.emc.archway.service.sqlservice.SqlServiceBean.discoverDatabases(com.emc.archway.context.ExecutionContext,com.emc.archway.objectmodel.host.AgentHost,com.emc.archway.objectmodel.host.sql.SqlServerInstances) throws java.net.UnknownHostException,com.emc.archway.service.eventservice.exceptions.HostPluginDownException: javax.ejb.EJBException: java.lang.RuntimeException
07-02-2021 06:00:06.032 ERROR [Thread-28455 (HornetQ-client-global-threads-320952484)] [com.emc.archway.application.sqlserver.SqlServerCommandListenerBean] [ASServer] [] d96dbf19-8962-4ef4-9e53-9d22e4af3e33->>> Exception Occurred: RuntimeException
07-02-2021 06:00:06.035 ERROR [Thread-28455 (HornetQ-client-global-threads-320952484)] [com.emc.archway.application.sqlserver.SqlServerCommandListenerBean] [ASServer] [] d96dbf19-8962-4ef4-9e53-9d22e4af3e33->>> Exception Occurred: EJBException, Message: java.lang.RuntimeException
07-02-2021 06:00:07.272 INFO [Thread-28456 (HornetQ-client-global-threads-320952484)] [com.emc.archway.service.eventservice.EventServiceBean] [ASServer] [] d96dbf19-8962-4ef4-9e53-9d22e4af3e33->>> EVENT [MILE_000005]: Application discovery phase for hostname:Utility completed with errors(METADATA: TYPE-ERROR, TIME-2021-07-02 06:00:07.272-0600NATIVETIME-2021-07-02 06:00:07.272-0600, HOST-ASServer, PHASE-Application discovery, THREAD=Thread-28456 (HornetQ-client-global-threads-320952484), USER-null, CATEGORY-MILESTONE, SESSIONID-null)
07-02-2021 06:00:05.841 ERROR [Thread-28455 (HornetQ-client-global-threads-320952484)] [org.jboss.as.ejb3.invocation] [ASServer] [] WFLYEJB0034: EJB Invocation failed on component SqlServiceBean for method public com.emc.archway.objectmodel.host.sql.SqlServerInstances com.emc.archway.service.sqlservice.SqlServiceBean.discoverDatabases(com.emc.archway.context.ExecutionContext,com.emc.archway.objectmodel.host.AgentHost,com.emc.archway.objectmodel.host.sql.SqlServerInstances) throws java.net.UnknownHostException,com.emc.archway.service.eventservice.exceptions.HostPluginDownException: javax.ejb.EJBException: java.lang.RuntimeException
07-02-2021 06:00:06.032 ERROR [Thread-28455 (HornetQ-client-global-threads-320952484)] [com.emc.archway.application.sqlserver.SqlServerCommandListenerBean] [ASServer] [] d96dbf19-8962-4ef4-9e53-9d22e4af3e33->>> Exception Occurred: RuntimeException
07-02-2021 06:00:06.035 ERROR [Thread-28455 (HornetQ-client-global-threads-320952484)] [com.emc.archway.application.sqlserver.SqlServerCommandListenerBean] [ASServer] [] d96dbf19-8962-4ef4-9e53-9d22e4af3e33->>> Exception Occurred: EJBException, Message: java.lang.RuntimeException
07-02-2021 06:00:07.272 INFO [Thread-28456 (HornetQ-client-global-threads-320952484)] [com.emc.archway.service.eventservice.EventServiceBean] [ASServer] [] d96dbf19-8962-4ef4-9e53-9d22e4af3e33->>> EVENT [MILE_000005]: Application discovery phase for hostname:Utility completed with errors(METADATA: TYPE-ERROR, TIME-2021-07-02 06:00:07.272-0600NATIVETIME-2021-07-02 06:00:07.272-0600, HOST-ASServer, PHASE-Application discovery, THREAD=Thread-28456 (HornetQ-client-global-threads-320952484), USER-null, CATEGORY-MILESTONE, SESSIONID-null)
Cause
A proteção do banco de dados SQL estava falhando porque o usuário fornecido ao AppSync para SQL não tinha os privilégios necessários.
Resolution
Redefinir a autenticação do Windows dos bancos de dados para o usuário apropriado resolverá o problema.
Etapas para redefinir a autenticação:
1. No console do AppSync, selecione Gerenciamento de cópia.
2. Na lista suspensa Cópias, selecione Cópias.
3. Na lista suspensa Selecionar aplicativo, selecione Microsoft SQL Server para exibir a página da instância.
4. Selecione um banco de dados e clique em Configurações de conexão.
2. Na lista suspensa Cópias, selecione Cópias.
3. Na lista suspensa Selecionar aplicativo, selecione Microsoft SQL Server para exibir a página da instância.
4. Selecione um banco de dados e clique em Configurações de conexão.
A caixa de diálogo das configurações de Conexão do SQL Server é exibida.
5. No campo Autenticação, selecione um dos seguintes requisitos por local:
● Autenticação do Windows
● Autenticação do SQL Server
● Autenticação do SQL Server
6. Especifique valores para os seguintes campos:
● Nome de usuário
● Senha
● Senha
7. Clique em OK
Etkilenen Ürünler
AppSyncÜrünler
Data Protection, Data Backup & Protection SoftwareMakale Özellikleri
Article Number: 000189823
Article Type: Solution
Son Değiştirme: 22 Eki 2024
Version: 6
Sorularınıza diğer Dell kullanıcılarından yanıtlar bulun
Destek Hizmetleri
Aygıtınızın Destek Hizmetleri kapsamında olup olmadığını kontrol edin.