Analytics problems

You're viewing Apigee Edge documentation.
Go to the Apigee X documentation. info

These topics explain how to troubleshoot issues with Analytics such as data not showing up in the Analytics dashboard, issues with custom reports, Postgres disk running out of space, and so on.

Playbooks

This section provides information and guidance on some specific procedures that can be followed for troubleshooting and resolving the common Analytics problems.

Problem Error message or description Playbook

Analytics Reports timing out

The report timed out: Try again with a smaller 
date range or a larger aggregation interval.

Analytics reports timing out

or:

Report timed out

Data not showing up in Analytics dashboards No traffic in the selected date range Data not showing up on analytics dashboards

Custom variable not visible in Custom Reports

None

Custom variable not visible to analytics custom reports

Custom Dimensions not appearing when multiple axgroups have been configured

Diagnostic information

If you need assistance from Apigee Support on the Analytics problems, then gather the following diagnostic information and share it in the support case:

Diagnostic information	Where can I gather this information?	How do I gather this information?
Analytics Group and Status Output	Management Server	curl -u sysadminEmail:password http://`MGMT_SERVER_HOST`:8080/v1/analytics/groups/ax curl -u sysadminEmail:sysadminPwd http://`MGMT_SERVER_HOST`:8080/v1/organizations/`ORGNAME`/environments/`ENVNAME`/provisioning/axstatus
Qpidd queue stats	Qpid Server	qpid-stat -q 2>&1 \| tee /tmp/qpid_stat_q_$(hostname)-$(date +%Y.%m.%d_%H.%M.%S).txt
Qpidd and Qpid Server logs	Qpid Server	tar cvzf /tmp/qpid_logs_$(hostname)_$(date +%Y.%m.%d_%H.%M.%S).tar.gz /opt/apigee/var/log/apigee-qpidd/apigee-qpidd* /opt/apigee/var/log/edge-qpid-server/logs/system.log
Data in Postgres DB	Postgres Server	Login to Postgres SQL, get the latest timestamp and size of data: psql -h /opt/apigee/var/run/apigee-postgresql -U apigee apigee SELECT min(client_received_start_timestamp), max(client_received_start_timestamp) FROM analytics."`ORGNAME`.`ENVNAME`.fact"; SELECT relname as "Table",pg_size_pretty(pg_total_relation_size(relid)) As "Size", pg_size_pretty(pg_total_relation_size(relid) - pg_relation_size(relid)) as "External Size" FROM pg_catalog.pg_statio_user_tables ORDER BY pg_total_relation_size(relid) DESC; SELECT column_name, data_type, character_maximum_length FROM INFORMATION_SCHEMA_COLUMNS analytics."`ORGNAME`.`ENVNAME`.fact"; Note: Replace `ORGNAME` and `ENVNAME` with the actual `org` and `env` names before running the above SQL queries.
Postgresql and Postgres Server logs	Postgres Server	tar cvzf /tmp/postgres_logs_$(hostname)_$(date +%Y.%m.%d_%H.%M.%S).tar.gz /opt/apigee/var/log/apigee-postgresql/apigee-postgresql* /opt/apigee/var/log/edge-postgres-server/logs/system*
ZooKeeper Tree Output	ZooKeeper	sudo /opt/apigee/apigee-zookeeper/contrib/zk-tree.sh > zktree-output.txt

Postgres disk space issue

This section provides information and guidance on some specific procedures that can be followed for troubleshooting and resolving Postgres running out of disk space.

Playbooks

Problem	Error message or description	Playbook
Postgres server running out of disk space	None	Postgres server running out of disk space

Diagnostic information

If you need assistance from Apigee Edge Support on this issue, then gather the following diagnostic information and share it in the support case:

Diagnostic information	Where can I gather this information?	How do I gather this information?
Disk Space	Postgres server	df -h 2>&1 \| tee /tmp/postgres_df_$(hostname)-$(date +%Y.%m.%d_%H.%M.%S).txt free -h 2>&1 \| tee /tmp/postgres_mem_$(hostname)-$(date +%Y.%m.%d_%H.%M.%S).txt
Data in Postgres DB	Postgres server	Login to Postgres SQL, get the latest timestamp and size of data psql -h /opt/apigee/var/run/apigee-postgresql -U apigee apigee SELECT min(client_received_start_timestamp), max(client_received_start_timestamp) FROM analytics."`ORGNAME`.`ENVNAME`.fact"; SELECT relname as "Table",pg_size_pretty(pg_total_relation_size(relid)) As "Size", pg_size_pretty(pg_total_relation_size(relid) - pg_relation_size(relid)) as "External Size" FROM pg_catalog.pg_statio_user_tables ORDER BY pg_total_relation_size(relid) DESC;

Diagnostic information

Where can I gather this information?

How do I gather this information?

Disk Space

Postgres server

df -h 2>&1 | tee /tmp/postgres_df_$(hostname)-$(date +%Y.%m.%d_%H.%M.%S).txt

free -h 2>&1 | tee /tmp/postgres_mem_$(hostname)-$(date +%Y.%m.%d_%H.%M.%S).txt

Data in Postgres DB

Postgres server

psql -h /opt/apigee/var/run/apigee-postgresql -U apigee apigee

SELECT min(client_received_start_timestamp), max(client_received_start_timestamp) FROM analytics."ORGNAME.ENVNAME.fact";

SELECT relname as "Table",pg_size_pretty(pg_total_relation_size(relid)) As "Size", pg_size_pretty(pg_total_relation_size(relid) - pg_relation_size(relid)) as "External Size" FROM pg_catalog.pg_statio_user_tables ORDER BY pg_total_relation_size(relid) DESC;