Discussion Feed

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     ... View more

How does a user determine the number of business transaction (BT) events that are published to the Analytics or Events Service Server by each application?   Some users may see the following message in the Analytic Agent logs and need to determine the total number of events being published. For action [EVENT_UPSERT], you have reached the events limit of [22500000] for account [XYZXYZXYZXYZXYZ] and event type group [biz_txn_v.*|custom_.*]     One business transaction can traverse many tiers. In each tier, one business transaction can traverse one node. One node produces one event for each BT when the transaction is synchronous. For async transactions, multiple events may be generated by a node for a single request.   To calculate how many events a BT generates, use the following formula to estimate the number of tiers/nodes that are sending data to the Analytics Agent.   number of events for one business transaction = calls per minute multiplied by number of tiers     Use the following ADQL query for each application, and add the results to find the total number of BT events published across the applications to the Events Service or Analytics Server.   SELECT transactionName, distinctcount(segments.tier) AS 'Tiers', count(*) as 'Transactions', distinctcount(segments.tier) * count(*) AS 'Events' FROM transactions WHERE application = "ECommerce" LIMIT 100   4.3.x     Note: On the above query,  there is a limit of 100 results as its an aggregate function. Users with many BTs may hit the limit.    As an alternative, use the following query for the BT Transaction Analytics License consumption:   SELECT count(segments.node) FROM transactions SELECT count(*) FROM transactions            Related Links: Calculating Analytics Event Volume   ... View more