The analytics metrics show a failed status (or shows a "last run failed" message) in the Controller UI.
To troubleshoot this issue, log into the Controller database and run the following query.
1. Navigate to the Controller/bin directory../controller.sh login-db
.select *, FROM_UNIXTIME(floor(schedule_time/1000)) as scheduled_time_readable from analytics_query_execution_detail WHERE status="FAILED" \G;
Output example:
mysql> select *, FROM_UNIXTIME(floor(schedule_time/1000)) as scheduled_time_readable from analytics_query_execution_detail WHERE status="FAILED" \G; *************************** 1. row *************************** scheduled_query_id: 17 bucket: 0 account_name: <Your Account Name> query_name: <Your Query Name> schedule_time: 1496303580917 actual_start_time: 1496303643991 actual_end_time: 1496303645772 error: Status code: [401], Message: The supplied auth information is incorrect or not authorized.RestException(statusCode=401, code=Auth.Unauthorized, errorMessage=The supplied auth information is incorrect or not authorized., developerMessage=) at com.appdynamics.analytics.shared.rest.exceptions.RestExceptionFactory.makeException(RestExceptionFactory.java:41) at com.appdynamics.analytics.shared.rest.client.utils.RestClientUtils.consumeResponseAs(RestClientUtils.java:161) status: FAILED
*************************** 2. row *************************** scheduled_query_id: 17 bucket: 0 account_name: <Your Account Name> query_name: <Your Query Name> schedule_time: 1496303580917 actual_start_time: 1496303643991 actual_end_time: 1496303645772 error: com.fasterxml.jackson.core.JsonParseException: Unexpected character (':' (code 58)): was expecting double-quote to start field status: FAILED