Controller (SaaS, On Premise)

cancel
Showing results for 
Search instead for 
Did you mean: 

Unable to connect DB agent with on premise controller

Adventurer

Unable to connect DB agent with on premise controller

Hi Team,

We have install on premise controller and DB agent for DB monitoring.

It is absolutely working fine for 2 months and suddenly data is not reporting in controller as DB agent is unable to connect to controller.

I have tried to troubleshhot the same by uninstalling controller and agent and install the same again.

Still whi;e Connecting the Agent to the AppDynamics Controller showing me waiting for connection.

Please find below agent log-

[main] 12 Mar 2019 14:11:18,547 INFO DBAgent - ####################################################################################
[main] 12 Mar 2019 14:11:18,563 INFO DBAgent - Agent Install Directory [C:\AQM\RCA\dbagent-4.3.8.8]
[main] 12 Mar 2019 14:11:18,563 INFO DBAgent - Using Agent Version [Database Agent v4.3.8.8 GA Build Date 2018-04-13]
[main] 12 Mar 2019 14:11:18,579 INFO DBAgent - JVM Runtime:
java.home=C:\Program Files\Java\jre1.8.0_121
java.vm.vendor=Oracle Corporation
java.vm.name=Java HotSpot(TM) 64-Bit Server VM
java.runtime.version=1.8.0_121-b13
java.io.tmpdir=C:\Users\ADMINI~1\AppData\Local\Temp\
user.language=en
user.country=IN
user.variant=
Default locale=en_IN
[main] 12 Mar 2019 14:11:18,579 INFO DBAgent - OS Runtime:
os.name=Windows Server 2012 R2
os.arch=amd64
os.version=6.3
user.name=Abibl-Admin
user.home=C:\Users\Administrator
user.dir=C:\Windows\system32
[main] 12 Mar 2019 14:11:18,579 INFO DBAgent - JVM Args :
[main] 12 Mar 2019 14:11:18,610 INFO DBAgent - JVM Runtime Name: 7736@ABIBLTCLRTLCUA
[main] 12 Mar 2019 14:11:18,610 INFO DBAgent - JVM PID: 7736
[main] 12 Mar 2019 14:11:18,610 INFO DBAgent - Default Database Agent is resolving bootstrap info....
[main] 12 Mar 2019 14:11:18,672 INFO DBAgent - Default Host Identifier Resolver using host name for unique host identifier [ABIBLTCLRTLCUA]
[main] 12 Mar 2019 14:11:18,735 INFO DBAgent - Default IP Address Resolver found IP addresses [[fe80:0:0:0:0:5efe:a01:e18c%net4, 10.1.225.140, fe80:0:0:0:69b6:7c5e:2c18:e8c7%eth5]]
[main] 12 Mar 2019 14:11:18,735 INFO DBAgent - Full Agent Registration Info Resolver found system property [appdynamics.agent.applicationName] for application name [Database Monitoring]
[main] 12 Mar 2019 14:11:18,735 INFO DBAgent - Full Agent Registration Info Resolver found system property [appdynamics.agent.tierName] for tier name [Database Monitoring]
[main] 12 Mar 2019 14:11:18,751 INFO DBAgent - Full Agent Registration Info Resolver found system property [appdynamics.agent.nodeName] for node name [Database Monitoring]
[main] 12 Mar 2019 14:11:18,751 INFO DBAgent - Full Agent Registration Info Resolver using selfService [false]
[main] 12 Mar 2019 14:11:18,751 INFO DBAgent - Full Agent Registration Info Resolver using application name [Database Monitoring]
[main] 12 Mar 2019 14:11:18,766 INFO DBAgent - Full Agent Registration Info Resolver using tier name [Database Monitoring]
[main] 12 Mar 2019 14:11:18,766 INFO DBAgent - Full Agent Registration Info Resolver using node name [Database Monitoring]
[main] 12 Mar 2019 14:11:18,782 INFO DBAgent - XML Controller Info Resolver found controller host [abibltclebua]
[main] 12 Mar 2019 14:11:18,782 INFO DBAgent - XML Controller Info Resolver found controller port [8090]
[main] 12 Mar 2019 14:11:18,797 INFO DBAgent - XML Agent Account Info Resolver using account name [customer1]
[main] 12 Mar 2019 14:11:18,797 INFO DBAgent - XML Agent Account Info Resolver using account access key [dadccc6a-a8ac-4cc8-b4a1-6fe4fda7a4b0]
[main] 12 Mar 2019 14:11:18,797 INFO DBAgent - Keystore file C:\AQM\RCA\dbagent-4.3.8.8\conf\cacerts.jks was not found
[main] 12 Mar 2019 14:11:19,172 INFO DBAgent - Default Database Agent resolved bootstrap info!
[main] 12 Mar 2019 14:11:19,204 INFO DBAgent - Started [Default Database Agent] Schedulers
[main] 12 Mar 2019 14:11:19,204 INFO DBAgent - Scheduling Default Database Agent Registration ....
[main] 12 Mar 2019 14:11:19,219 INFO DBAgent - Reregistration Check is : [enabled].
[<Default Database Agent>-Scheduler-1] 12 Mar 2019 14:11:19,219 INFO DBAgent - using controller host [abibltclebua]; controller port [8090]
[<Default Database Agent>-Scheduler-1] 12 Mar 2019 14:11:19,251 INFO DBAgent - setting unique host information Host Name [ABIBLTCLRTLCUA]
[<Default Database Agent>-Scheduler-1] 12 Mar 2019 14:11:19,266 INFO DBAgent - setting agent version [Database Agent v4.3.8.8 GA Build Date 2018-04-13]
[<Default Database Agent>-Scheduler-1] 12 Mar 2019 14:11:19,266 INFO DBAgent - setting agent properties [{dbagent-name=Default Database Agent, dbagent-launch-id=bdb40563-648f-42d2-8b8c-f4682b893af7}]
[<Default Database Agent>-Scheduler-1] 12 Mar 2019 14:11:19,266 INFO DBAgent - setting agent install dir [C:\AQM\RCA\dbagent-4.3.8.8]
[<Default Database Agent>-Scheduler-1] 12 Mar 2019 14:11:19,266 INFO DBAgent - setting agent type [DB_AGENT]
[<Default Database Agent>-Scheduler-1] 12 Mar 2019 14:11:19,266 INFO DBAgent - setting agent application [Database Monitoring]
[<Default Database Agent>-Scheduler-1] 12 Mar 2019 14:11:19,266 INFO DBAgent - setting agent tier name [Database Monitoring]
[<Default Database Agent>-Scheduler-1] 12 Mar 2019 14:11:19,266 INFO DBAgent - setting agent node name [Database Monitoring]
[<Default Database Agent>-Scheduler-1] 12 Mar 2019 14:11:19,266 INFO DBAgent - Sending Registration request
[<Default Database Agent>-Scheduler-1] 12 Mar 2019 14:11:20,032 INFO DBAgent - Auto agent registration attempted: Application Name [Database Monitoring] Component Name [Database Monitoring] Node Name [Database Monitoring]
[<Default Database Agent>-Scheduler-1] 12 Mar 2019 14:11:20,032 INFO DBAgent - Auto agent registration SUCCEEDED!
[<Default Database Agent>-Scheduler-1] 12 Mar 2019 14:11:20,032 INFO DBAgent - Registered database agent with agent ID [2]
[<Default Database Agent>-Scheduler-1] 12 Mar 2019 14:11:20,032 INFO DBAgent - Starting Default Database Agent....
[<Default Database Agent>-Scheduler-1] 12 Mar 2019 14:11:20,032 INFO ControllerTimeSkewHandler - Skew Handler is : [enabled].
[<Default Database Agent>-Scheduler-1] 12 Mar 2019 14:11:20,141 INFO ManagedMonitorDelegate - Started Agent Metric Generation Service
[<Default Database Agent>-Scheduler-1] 12 Mar 2019 14:11:20,157 INFO ManagedMonitorDelegate - Event Service is : [enabled].
[<Default Database Agent>-Scheduler-1] 12 Mar 2019 14:11:20,266 INFO ManagedMonitorDelegate - Metric Service is : [enabled].
[<Default Database Agent>-Scheduler-1] 12 Mar 2019 14:11:20,329 INFO ManagedMonitorDelegate - Started Agent Env Properties Service
[<Default Database Agent>-Scheduler-1] 12 Mar 2019 14:11:20,329 INFO ManagedMonitorDelegate - Scheduled Continuous Task Monitor with frequency [30000]ms
[<Default Database Agent>-Scheduler-1] 12 Mar 2019 14:11:20,344 INFO MonitorConfigReader - Reading monitor config file:C:\AQM\RCA\dbagent-4.3.8.8\monitors\DatabaseMonitor\monitor.xml
[<Default Database Agent>-Scheduler-1] 12 Mar 2019 14:11:20,360 INFO MonitorConfigReader - os name [windows server 2012 r2] version [6.3]
[<Default Database Agent>-Scheduler-1] 12 Mar 2019 14:11:20,376 INFO NodeMonitorManager - Initializing managed monitor [DatabaseMonitor]
[<Default Database Agent>-Scheduler-1] 12 Mar 2019 14:11:20,376 INFO ManagedMonitorDelegate - Initializing managed monitor [DBMonitor]
[<Default Database Agent>-Scheduler-1] 12 Mar 2019 14:11:20,376 INFO ManagedMonitorDelegate - Executing managed monitor [DBMonitor], task name [null]
[<Default Database Agent>-Scheduler-1] 12 Mar 2019 14:11:20,391 INFO ManagedMonitorDelegate - Task [null] for monitor [DBMonitor] is SCHEDULED
[<Default Database Agent>-Scheduler-1] 12 Mar 2019 14:11:20,391 INFO JavaTaskCreator - Task classpath not specified,System classpath will be used.
[<Default Database Agent>-Scheduler-1] 12 Mar 2019 14:11:20,407 INFO NodeMonitorManager - Directory [C:\AQM\RCA\dbagent-4.3.8.8\monitors\unmanaged] not found, continuing.
[<Default Database Agent>-Scheduler-1] 12 Mar 2019 14:11:20,407 INFO AgentMonitorManager - Initialized System Monitor Manager with directory [C:\AQM\RCA\dbagent-4.3.8.8\monitors]
[<Default Database Agent>-Scheduler-1] 12 Mar 2019 14:11:20,407 INFO DBAgent - Set up agent monitor manager
[<Default Database Agent>-Scheduler-1] 12 Mar 2019 14:11:20,407 INFO DBAgent - Orchestration is disabled - disabling one-way agent transport. The agent will not be able to execute workflow tasks.
[<Default Database Agent>-Scheduler-1] 12 Mar 2019 14:11:20,407 INFO DBAgent - Set up agent re-registration task
[<Default Database Agent>-Scheduler-1] 12 Mar 2019 14:11:20,422 INFO DBAgentConfigManager - Scheduling configuration refresh at an interval of 10 seconds
[<Default Database Agent>-Scheduler-1] 12 Mar 2019 14:11:20,422 INFO DBAgentConfigManager - Configuration refresh task interval is 10 seconds
[<Default Database Agent>-Scheduler-1] 12 Mar 2019 14:11:20,422 INFO DBAgent - Configuration manager successfully configured
[<Default Database Agent>-Scheduler-1] 12 Mar 2019 14:11:20,438 INFO DBAgent - Keystore file C:\AQM\RCA\dbagent-4.3.8.8\conf\cacerts.jks was not found
[<Default Database Agent>-Scheduler-1] 12 Mar 2019 14:11:20,454 INFO DBAgent - Started Default Database Agent successfully
[<Default Database Agent>-Monitor-Scheduler-1] 12 Mar 2019 14:11:30,468 INFO DBEntityManager - System property [dbagent.waitTimeLoadMultiplier] = 1
[<Default Database Agent>-Monitor-Scheduler-1] 12 Mar 2019 14:11:30,468 INFO DBEntityManager - System property [dbagent.queryStatLoadMultiplier] = 1
[<Default Database Agent>-Monitor-Scheduler-1] 12 Mar 2019 14:11:30,468 INFO DBEntityManager - System property [dbagent.blockStateLoadMultiplier] = 1
[main] 12 Mar 2019 15:02:09,927 INFO DBAgent - ####################################################################################
[main] 12 Mar 2019 15:02:09,927 INFO DBAgent - Agent Install Directory [C:\AQM\RCA\dbagent-4.3.8.8]
[main] 12 Mar 2019 15:02:09,927 INFO DBAgent - Using Agent Version [Database Agent v4.3.8.8 GA Build Date 2018-04-13]
[main] 12 Mar 2019 15:02:09,943 INFO DBAgent - JVM Runtime:
java.home=C:\Program Files\Java\jre1.8.0_121
java.vm.vendor=Oracle Corporation
java.vm.name=Java HotSpot(TM) 64-Bit Server VM
java.runtime.version=1.8.0_121-b13
java.io.tmpdir=C:\Users\bi045523\AppData\Local\Temp\
user.language=en
user.country=IN
user.variant=
Default locale=en_IN
[main] 12 Mar 2019 15:02:09,943 INFO DBAgent - OS Runtime:
os.name=Windows Server 2012 R2
os.arch=amd64
os.version=6.3
user.name=bi045523
user.home=C:\Users\bi045523
user.dir=C:\Windows\system32
[main] 12 Mar 2019 15:02:09,943 INFO DBAgent - JVM Args :
[main] 12 Mar 2019 15:02:09,974 INFO DBAgent - JVM Runtime Name: 5608@ABIBLTCLRTLCUA
[main] 12 Mar 2019 15:02:09,974 INFO DBAgent - JVM PID: 5608
[main] 12 Mar 2019 15:02:09,974 INFO DBAgent - Default Database Agent is resolving bootstrap info....
[main] 12 Mar 2019 15:02:10,005 INFO DBAgent - Default Host Identifier Resolver using host name for unique host identifier [ABIBLTCLRTLCUA]
[main] 12 Mar 2019 15:02:10,068 INFO DBAgent - Default IP Address Resolver found IP addresses [[fe80:0:0:0:0:5efe:a01:e18c%net4, 10.1.225.140, fe80:0:0:0:69b6:7c5e:2c18:e8c7%eth5]]
[main] 12 Mar 2019 15:02:10,068 INFO DBAgent - Full Agent Registration Info Resolver found system property [appdynamics.agent.applicationName] for application name [Database Monitoring]
[main] 12 Mar 2019 15:02:10,068 INFO DBAgent - Full Agent Registration Info Resolver found system property [appdynamics.agent.tierName] for tier name [Database Monitoring]
[main] 12 Mar 2019 15:02:10,068 INFO DBAgent - Full Agent Registration Info Resolver found system property [appdynamics.agent.nodeName] for node name [Database Monitoring]
[main] 12 Mar 2019 15:02:10,083 INFO DBAgent - Full Agent Registration Info Resolver using selfService [false]
[main] 12 Mar 2019 15:02:10,083 INFO DBAgent - Full Agent Registration Info Resolver using application name [Database Monitoring]
[main] 12 Mar 2019 15:02:10,083 INFO DBAgent - Full Agent Registration Info Resolver using tier name [Database Monitoring]
[main] 12 Mar 2019 15:02:10,083 INFO DBAgent - Full Agent Registration Info Resolver using node name [Database Monitoring]
[main] 12 Mar 2019 15:02:10,099 INFO DBAgent - XML Controller Info Resolver found controller host [abibltclebua]
[main] 12 Mar 2019 15:02:10,099 INFO DBAgent - XML Controller Info Resolver found controller port [8090]
[main] 12 Mar 2019 15:02:10,115 INFO DBAgent - XML Agent Account Info Resolver using account name [customer1]
[main] 12 Mar 2019 15:02:10,115 INFO DBAgent - XML Agent Account Info Resolver using account access key [dadccc6a-a8ac-4cc8-b4a1-6fe4fda7a4b0]
[main] 12 Mar 2019 15:02:10,115 INFO DBAgent - Keystore file C:\AQM\RCA\dbagent-4.3.8.8\conf\cacerts.jks was not found
[main] 12 Mar 2019 15:02:10,427 INFO DBAgent - Default Database Agent resolved bootstrap info!
[main] 12 Mar 2019 15:02:10,458 INFO DBAgent - Started [Default Database Agent] Schedulers
[main] 12 Mar 2019 15:02:10,458 INFO DBAgent - Scheduling Default Database Agent Registration ....
[main] 12 Mar 2019 15:02:10,458 INFO DBAgent - Reregistration Check is : [enabled].
[<Default Database Agent>-Scheduler-1] 12 Mar 2019 15:02:10,474 INFO DBAgent - using controller host [abibltclebua]; controller port [8090]
[<Default Database Agent>-Scheduler-1] 12 Mar 2019 15:02:10,489 INFO DBAgent - setting unique host information Host Name [ABIBLTCLRTLCUA]
[<Default Database Agent>-Scheduler-1] 12 Mar 2019 15:02:10,505 INFO DBAgent - setting agent version [Database Agent v4.3.8.8 GA Build Date 2018-04-13]
[<Default Database Agent>-Scheduler-1] 12 Mar 2019 15:02:10,505 INFO DBAgent - setting agent properties [{dbagent-name=Default Database Agent, dbagent-launch-id=9d94fb54-9bd9-4c00-806e-5e38c78e7f07}]
[<Default Database Agent>-Scheduler-1] 12 Mar 2019 15:02:10,505 INFO DBAgent - setting agent install dir [C:\AQM\RCA\dbagent-4.3.8.8]
[<Default Database Agent>-Scheduler-1] 12 Mar 2019 15:02:10,505 INFO DBAgent - setting agent type [DB_AGENT]
[<Default Database Agent>-Scheduler-1] 12 Mar 2019 15:02:10,505 INFO DBAgent - setting agent application [Database Monitoring]
[<Default Database Agent>-Scheduler-1] 12 Mar 2019 15:02:10,505 INFO DBAgent - setting agent tier name [Database Monitoring]
[<Default Database Agent>-Scheduler-1] 12 Mar 2019 15:02:10,505 INFO DBAgent - setting agent node name [Database Monitoring]
[<Default Database Agent>-Scheduler-1] 12 Mar 2019 15:02:10,505 INFO DBAgent - Sending Registration request
[<Default Database Agent>-Scheduler-1] 12 Mar 2019 15:02:10,755 INFO DBAgent - Auto agent registration attempted: Application Name [Database Monitoring] Component Name [Database Monitoring] Node Name [Database Monitoring]
[<Default Database Agent>-Scheduler-1] 12 Mar 2019 15:02:10,755 INFO DBAgent - Auto agent registration SUCCEEDED!
[<Default Database Agent>-Scheduler-1] 12 Mar 2019 15:02:10,755 INFO DBAgent - Registered database agent with agent ID [4]
[<Default Database Agent>-Scheduler-1] 12 Mar 2019 15:02:10,755 INFO DBAgent - Starting Default Database Agent....
[<Default Database Agent>-Scheduler-1] 12 Mar 2019 15:02:10,771 INFO ControllerTimeSkewHandler - Skew Handler is : [enabled].
[<Default Database Agent>-Scheduler-1] 12 Mar 2019 15:02:10,849 INFO ManagedMonitorDelegate - Started Agent Metric Generation Service
[<Default Database Agent>-Scheduler-1] 12 Mar 2019 15:02:10,864 INFO ManagedMonitorDelegate - Event Service is : [enabled].
[<Default Database Agent>-Scheduler-1] 12 Mar 2019 15:02:10,958 INFO ManagedMonitorDelegate - Metric Service is : [enabled].
[<Default Database Agent>-Scheduler-1] 12 Mar 2019 15:02:11,021 INFO ManagedMonitorDelegate - Started Agent Env Properties Service
[<Default Database Agent>-Scheduler-1] 12 Mar 2019 15:02:11,036 INFO ManagedMonitorDelegate - Scheduled Continuous Task Monitor with frequency [30000]ms
[<Default Database Agent>-Scheduler-1] 12 Mar 2019 15:02:11,036 INFO MonitorConfigReader - Reading monitor config file:C:\AQM\RCA\dbagent-4.3.8.8\monitors\DatabaseMonitor\monitor.xml
[<Default Database Agent>-Scheduler-1] 12 Mar 2019 15:02:11,052 INFO MonitorConfigReader - os name [windows server 2012 r2] version [6.3]
[<Default Database Agent>-Scheduler-1] 12 Mar 2019 15:02:11,068 INFO NodeMonitorManager - Initializing managed monitor [DatabaseMonitor]
[<Default Database Agent>-Scheduler-1] 12 Mar 2019 15:02:11,083 INFO ManagedMonitorDelegate - Initializing managed monitor [DBMonitor]
[<Default Database Agent>-Scheduler-1] 12 Mar 2019 15:02:11,083 INFO ManagedMonitorDelegate - Executing managed monitor [DBMonitor], task name [null]
[<Default Database Agent>-Scheduler-1] 12 Mar 2019 15:02:11,083 INFO ManagedMonitorDelegate - Task [null] for monitor [DBMonitor] is SCHEDULED
[<Default Database Agent>-Scheduler-1] 12 Mar 2019 15:02:11,083 INFO JavaTaskCreator - Task classpath not specified,System classpath will be used.
[<Default Database Agent>-Scheduler-1] 12 Mar 2019 15:02:11,099 INFO NodeMonitorManager - Directory [C:\AQM\RCA\dbagent-4.3.8.8\monitors\unmanaged] not found, continuing.
[<Default Database Agent>-Scheduler-1] 12 Mar 2019 15:02:11,099 INFO AgentMonitorManager - Initialized System Monitor Manager with directory [C:\AQM\RCA\dbagent-4.3.8.8\monitors]
[<Default Database Agent>-Scheduler-1] 12 Mar 2019 15:02:11,099 INFO DBAgent - Set up agent monitor manager
[<Default Database Agent>-Scheduler-1] 12 Mar 2019 15:02:11,099 INFO DBAgent - Orchestration is disabled - disabling one-way agent transport. The agent will not be able to execute workflow tasks.
[<Default Database Agent>-Scheduler-1] 12 Mar 2019 15:02:11,114 INFO DBAgent - Set up agent re-registration task
[<Default Database Agent>-Scheduler-1] 12 Mar 2019 15:02:11,114 INFO DBAgentConfigManager - Scheduling configuration refresh at an interval of 10 seconds
[<Default Database Agent>-Scheduler-1] 12 Mar 2019 15:02:11,130 INFO DBAgentConfigManager - Configuration refresh task interval is 10 seconds
[<Default Database Agent>-Scheduler-1] 12 Mar 2019 15:02:11,130 INFO DBAgent - Configuration manager successfully configured
[<Default Database Agent>-Scheduler-1] 12 Mar 2019 15:02:11,130 INFO DBAgent - Keystore file C:\AQM\RCA\dbagent-4.3.8.8\conf\cacerts.jks was not found
[<Default Database Agent>-Scheduler-1] 12 Mar 2019 15:02:11,146 INFO DBAgent - Started Default Database Agent successfully
[<Default Database Agent>-Monitor-Scheduler-2] 12 Mar 2019 15:02:21,146 INFO DBEntityManager - System property [dbagent.waitTimeLoadMultiplier] = 1
[<Default Database Agent>-Monitor-Scheduler-2] 12 Mar 2019 15:02:21,161 INFO DBEntityManager - System property [dbagent.queryStatLoadMultiplier] = 1
[<Default Database Agent>-Monitor-Scheduler-2] 12 Mar 2019 15:02:21,161 INFO DBEntityManager - System property [dbagent.blockStateLoadMultiplier] = 1

 

Awaiting for your valuable guidance as we are unable to proceed further.

 

 

Unable to connect DB agent with on premise controller