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.
2. Execute ./controller.sh login-db.
3. Run the following query to determine the reason for the failure.
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
