{ Community }
  • Academy
  • Docs
  • Developers
  • Resources
    • Community Articles
    • Apigee on GitHub
    • Code Samples
    • Videos & eBooks
    • Accelerator Methodology
  • Support
  • Ask a Question
  • Spaces
    • Product Announcements
    • General
    • Edge/API Management
    • Developer Portal (Drupal-based)
    • Developer Portal (Integrated)
    • API Design
    • APIM on Istio
    • Extensions
    • Business of APIs
    • Academy/Certification
    • Adapter for Envoy
    • Analytics
    • Events
    • Hybrid
    • Integration (AWS, PCF, Etc.)
    • Microgateway
    • Monetization
    • Private Cloud Deployment
    • 日本語コミュニティ
    • Insights
    • IoT Apigee Link
    • BaaS/Usergrid
    • BaaS Transition/Migration
    • Apigee-127
    • New Customers
    • Topics
    • Questions
    • Articles
    • Ideas
    • Leaderboard
    • Badges
  • Log in
  • Sign up

Get answers, ideas, and support from the Apigee Community

  • Home /
  • Analytics /
avatar image
0
Question by Dmitriy Bannikov · Jun 02, 2017 at 11:05 PM · 2.2k Views analyticspostgresenvironmentsprovisioning

Postgres error - relation does not exist

I've added a new environment prod using apigee-adminapi script. After that I ran apigee-provision enable-ax.

When I switch to the prod environment in Apigee UI, I see "Error fetching analytics data Data Access Error.".

In Postgres logs I see this error (<ORG_NAME> - my org name):

SELECT developer,developer_app,sum(message_count) AS mtrc0,sum(error_count) AS mtrc1,date_trunc('month', timestamp at time zone '-0:0:0')::timestamp without time zone AS time_unit FROM analytics."<ORG_NAME>.prod.agg_app" WHERE timestamp >= '2017-5-26 22:0:0' AND timestamp < '2017-6-2 22:0:0' AND ((developer_app != 'na' ) and (developer_app != '(not set)' )) AND developer_app IN ( SELECT developer_app FROM ( SELECT developer_app FROM analytics."<ORG_NAME>.prod.agg_app" WHERE timestamp >= '2017-5-26 22:0:0' AND timestamp < '2017-6-2 22:0:0' AND ((developer_app != 'na' ) and (developer_app != '(not set)' )) GROUP BY developer,developer_app ORDER BY sum(message_count) DESC,sum(error_count) DESC LIMIT 5 OFFSET 0 ) AS subquery ) GROUP BY developer,developer_app,time_unit ORDER BY sum(message_count) DESC,sum(error_count) DESC LIMIT 14400 OFFSET 0 2017-06-02 22:56:43 UTC [10011]: [61-1] user=<USERNAME> db=apigee host=10.227.14.26 ERROR: relation "analytics.<ORG_NAME>.prod.agg_app" does not exist at character 146

Comment
Add comment Show 1
10 |5000 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by Apigeeks only
  • Viewable by the original poster
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users
avatar image Dhavalkumar Dangaria · Sep 26, 2019 at 07:13 PM 0
Link

How did you solve this issue? I am getting the same error.

Close

1 Answer

  • Sort: 
avatar image
0

Answer by Ian MacLeish · Jan 20 at 05:18 PM

Hi!
This error can be caused if you created a new environment, but did not enable analytics for that env. The command you need to run will look something like this:

/opt/apigee/apigee-service/bin/apigee-service apigee-provision enable-ax -f configFile


You can follow the steps outlined below to do this. You may also need to restart your env once you run this command.

[1] https://docs.apigee.com/private-cloud/v4.50.00/creating-organization-environment-and-virtual-host#createanenvironment-createanenvironmentbyusingapicalls

Comment
Add comment · Link
10 |5000 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by Apigeeks only
  • Viewable by the original poster
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Follow this Question

Answers Answers and Comments

40 People are following this question.

avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image

Related Questions

Error while fetching Stat: Invalid API Call 3 Answers

postgres status recovering 2 Answers

Analytic Data not appearing in UI 5 Answers

Working with the Analytics Group API 2 Answers

‘ERROR: out of shared memory’ on Postgres server 1 Answer

  • Products
    • Edge - APIs
    • Insights - Big Data
    • Plans
  • Developers
    • Overview
    • Documentation
  • Resources
    • Overview
    • Blog
    • Apigee Institute
    • Academy
    • Documentation
  • Company
    • Overview
    • Press
    • Customers
    • Partners
    • Team
    • Events
    • Careers
    • Contact Us
  • Support
    • Support Overview
    • Documentation
    • Status
    • Edge Support Portal
    • Privacy Policy
    • Terms & Conditions
© 2021 Apigee Corp. All rights reserved. - Apigee Community Terms of Use - Powered by AnswerHub
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Create an article
  • Post an idea
  • Spaces
  • Product Announcements
  • General
  • Edge/API Management
  • Developer Portal (Drupal-based)
  • Developer Portal (Integrated)
  • API Design
  • APIM on Istio
  • Extensions
  • Business of APIs
  • Academy/Certification
  • Adapter for Envoy
  • Analytics
  • Events
  • Hybrid
  • Integration (AWS, PCF, Etc.)
  • Microgateway
  • Monetization
  • Private Cloud Deployment
  • 日本語コミュニティ
  • Insights
  • IoT Apigee Link
  • BaaS/Usergrid
  • BaaS Transition/Migration
  • Apigee-127
  • New Customers
  • Explore
  • Topics
  • Questions
  • Articles
  • Ideas
  • Badges