Cisco AppDynamics Community

Pascal.Anowi · ‎07-18-2023

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

Mario.Morelli · ‎07-18-2023

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.

Pascal.Anowi · ‎07-18-2023

Thanks i would try it

Pascal.Anowi · ‎07-18-2023

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

Mario.Morelli · ‎07-18-2023

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.

Pascal.Anowi · ‎07-18-2023

Tried this but still got the same error

even after increasing the timeout and restarting DB collector services

Mario.Morelli · ‎07-18-2023

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.

Pascal.Anowi · ‎07-18-2023

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

MONITORING DATABASE