APM ASM Integration Agent is missing data and gives a warning containing "Cloud Monitor query returned the following error: Empty result for cursor <id>. database error".

Products

• CA Application Performance Management Agent (APM / Wily / Introscope)
• INTROSCOPE

Issue/Introduction

     The APM ASM Integration Agent is missing data after performing the rule_Log API call. The agent logs display the following warning:

     "Problem while getting Cloud Monitor data: com.wily.apm.cloudmonitor.cmconnector.rest.RestConnectionProblem: Cloud Monitor query returned the following error: Empty result for cursor <id>. database error".

Environment

This error can occur for any supported release of the APM ASM Integration Agent.

Cause

     The cursor mentioned in the warning message is a relative value used in the rule_Log API call (https://api.asm.ca.com/1.6/rule_log?doc) to retrieve large sets of sequential monitor results. The cursor value allows these results to be retrieved in chunks. For example, 200 logs result can be returned in sets of 50, if the same rule_Log API call is made using the cursor value return in the previous invocation.

The warning message occurs when this cursor value becomes invalidated. The APM agent then fails to retrieve ASM data on subsequent rule_logs and only partial sets of ASM data are returned.

Resolution

     To correct this issue, Restart the agent which resets the cursor value used by the agent.  If this does not resolve the issue, the open a case with ASM support.

Additional Information

     For more information on the APM Integration with ASM, please see:https://docops.ca.com/ca-apm/10-5/en/integrating/integrate-ca-app-synthetic-monitor-in-your-apm-deployment.  As always, please contact CA Support if you have further questions.