{ 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 /
  • Private Cloud Deployment /
avatar image
3
Question by Chris Covney · Dec 17, 2015 at 08:50 PM · 798 Views edgePrivate Cloudanalyticserrorpostgres

add-env.sh did not successfully enable analytics

Hi everyone,

I have a few environments (dev, test, prod) running in my Apigee Private Cloud v4.15.04.03, all with analytics data working perfectly fine.

I went to create an additional environment today by ssh-ing into the management server VM and running the add-env.sh script. I entered all the prompted info correctly and it claims to have received an HTTP 201 from the API to enable analytics for the env.

At the very end of the add-env.sh script, it says that one can check the overall analytics status with two commands. When I run both commands, they each suggest that analytics has failed to be enabled.

\d analytics."fooBarOrg.fooBarEnv.fact"

Did not find any relation named "analytics."fooBarOrg.fooBarEnv.fact"".

^ i.e. the postgres tables were never created. Why?

<mgmt-svr>/v1/o/fooBarOrg/environments/fooBarEnv/provisioning/axstatus


{
  "environments": [
    {
      "components": [
        {
          "hosts": "[localhost, localhost]",
          "message": "success",
          "name": "qs",
          "status": "SUCCESS",
          "uuid": "[ea0c145b-fd45-4003-90ef-7c479a826634, c7ab40bb-d430-4987-b9d2-e38fdf1dea4b]"
        },
        {
          "hosts": "[localhost:localhost]",
          "message": "",
          "name": "pg",
          "status": "UNKNOWN",
          "uuid": "[ab38e06e-09b6-44a4-9b44-bbbfc282ceec:3d46f771-86c1-4449-959a-c4ad44a41ebb]"
        }
      ],
      "message": "",
      "name": "fooBarEnv"
    }
  ],
  "organization": "fooBarOrg",
  "status": "FAILURE"
}

^ i.e. the postgres server is in an UNKNOWN status and the analytics overall status is FAILURE. Why?

In the Management Server UI, I see this error in red when I browse to any of the pages while the fooBarEnv is selected in the top-right drop-down:

Error fetching analytics data Invalid API Call

I have followed the shell script prompts correctly. I even removed the env and re-tried it 3 times, just for good measure, and the same failure result occurs every time. I see errors in the postgres logs, but they seem to complain about the tables missing, which we already know from the postgres command above.

Does anyone have any idea how this could be happening? Thanks!

Best,

Chris

Comment
Add comment Show 3
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 Bryant Olson · Feb 10, 2016 at 07:58 PM 0
Link

Hi @Chris,

Did you ever find a resolution to this? I'm having the exact same problem. It looks like it was caused by having a bad reference to a postgres server uUID in the system. Removing that reference allowed the enable-ax.sh script to complete, but I'm getting the same response as you in my environment. Wondering if you ever found a solution.

Thanks,

Braynt

avatar image Pravin · Jun 08, 2016 at 03:58 AM 0
Link

Same error in my on-primse edge-

api request - executing on demand load of a/c cfg from ZK for scope fis.dev 2016-06-07 22:54:04,850 org:fis env:dev qtp393060055-212

ERROR QueryService - QueryServiceImpl.loadDSOnDemand() : Could not find group for scope fis.dev 2016-06-07 22:54:04,852 org:fis env:dev qtp393060055-212 ERROR KERNEL - ErrorMessages.getFormattedMessage() : getFormattedMessage() : Unable to locate a resource bundle for error code Could not resolve scope fis.dev 2016-06-07 22:54:04,854 org:fis env:dev qtp393060055-212 ERROR c.a.a.d.d.i.StatsDAOImpl - StatsDAOImpl.getStats() : Exception while getting stats Could not resolve scope fis.dev com.apigee.rest.framework.ResourceNotFoundException: Could not resolve scope fis.dev at com.apigee.analytics.queryservice.impl.QueryServiceImpl.query(QueryServiceIm.......'

On Edge - UI.

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

How do i create new environment, with proper analytics configuration ??

avatar image Mudit Purwar · Aug 17, 2016 at 04:40 PM 0
Link

@Chris Covney Hey Chris, were you able to resolve this issue?

If yes, can you please share the solution here.

Thanks

Mudit

@Carlos Frias @Maruti Chand

Exact same in on the QA planet.

Close

2 Answers

  • Sort: 
avatar image
0

Answer by Pravin · Aug 17, 2016 at 05:21 PM

Hi @Mudit.Purwar

Solution by @cocoandjan documented here...it worked for me. thank you.

https://community.apigee.com/questions/26038/onpremise-edge-41601-analytics-for-new-environment.html

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
avatar image
0

Answer by William.Deurwaarder · Sep 29, 2016 at 04:48 PM

Hi, we had a similar issue where 'apigee-service apigee-provision add-env' gave the same error. Our axgroup was correct so the previous answer did not help us. We do not know how this situation is created, or what the cause of this situation is. The issue did not automatically resolve and that blocked us to create environments.

We were able to unblock this by restarting all services on both postgres-master and postgres-slave. We did this in two steps first stopping master and slave and than starting slave and master via 'apigee-all stop' and 'apigee-all start'.

After this restart 'apigee-service apigee-provision add-env' run with success.

Comment
Add comment Show 1 · 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
avatar image Michael Veit · 4 days ago 0
Link

Restarting components is not an option for us, as we create org/env and enable analytics on-the-fly via management server API REST calls. Is there any other workaround for this bug?

Follow this Question

Answers Answers and Comments

32 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

Related Questions

Edge Private Cloud 4.19.01 - Unable to install PostGres Slave node for 5 node topology 1 Answer

How to fix dropdb error during restore-postgres ? 1 Answer

4.15.04.03 patch no analytics data 2 Answers

Error during update postgres to apigee 4.16.09 10 Answers

16.09 private cloud installation problematic anomaly 2 Answers

  • 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