cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

MONITORING DATABASE

Pascal.Anowi
Creator

Hello everyone,

Please we are trying to monitor a database but everytime we run the querry we get the error

an error occured while fetching data the agent did not respond after 70 seconds

Has anyone had this issue before and how did you solve it

7 REPLIES 7

Mario.Morelli
Architect

Hi, add an additional startup parameter to the DB Agent

-Ddbagent.custommetric.query.timeout.seconds=120

Increase timeout to what is required for your complex queries 

Ciao



Found something helpful? Click the Accept as Solution button to help others find answers faster.
Liked something? Click the Thumbs Up button.

Learn more about me in the Community Member Spotlight Q & A

Thanks i would try it

After increasing it do we need to restart a service or anything

Mario.Morelli
Architect
That is correct, changes will only be activated upon restart of DB collector service


Found something helpful? Click the Accept as Solution button to help others find answers faster.
Liked something? Click the Thumbs Up button.

Learn more about me in the Community Member Spotlight Q & A

Tried this but still got the same error

even after increasing the timeout and restarting DB collector services

PascalAnowi_1-1689691829367.png

 

 

Mario.Morelli
Architect

Can you share your full startup parameters for the service including the additional settings you just added? Just hide any sensitive info



Found something helpful? Click the Accept as Solution button to help others find answers faster.
Liked something? Click the Thumbs Up button.

Learn more about me in the Community Member Spotlight Q & A

nohup java -Dappdynamics.agent.maxMetrics=300000 -Ddbagent.custommetric.query.timeout.seconds=600 -Ddbagent.name=DB-Agent-23.2 -jar db-agent.jar &