Google is committed to advancing racial equity for Black communities. See how.

Analytics problems

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

or

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";
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 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;