Knowledge Base

cancel
Showing results for 
Search instead for 
Did you mean: 

How to troubleshoot failed analytics metrics

The analytics metrics show a failed status (or shows a "last run failed" message) in the Controller UI.

 

Screen Shot 2017-07-19 at 9.16.57 PM.png

 

 

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

 

 

Version history
Revision #:
2 of 2
Last update:
‎07-19-2017 02:45 PM
Updated by:
 
Labels (2)
0 Kudos