{ 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
0
Question by apigee geek · Feb 06, 2015 at 11:19 PM · 775 Views analytics

Error while fetching object while opening API Proxies page

On opening the API Proxy page, I am seeing "Error while fetching object org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Conneciton; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP Connections.)

What should I do to resolve the issue?

Comment
Add comment
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

Close

1 Answer

  • Sort: 
avatar image
3
Best Answer

Answer by corinna fu · Feb 06, 2015 at 11:22 PM

Apigee uses the Postgres database for storing analytics data. On opening the API proxies page in the management UI, the Apigee management UI would load the API proxy performance data from the Postgres database for the Performance section following the API proxy list. The error indicates that the Apigee management server is not able to contact the Postgres server to retrieve the data.

If the connection is down between the management server and the postgres server, please fix the network issue between the two nodes. If there is no network connection problem, please do 'nc -z <IP of the Postgres server> 5432' from the management server to see if the port is open for access. If the port is not open for access, please go to the Postgres server and check if the postmaster process is running, e.g, ps -elf | grep postmaster and you should see something similar to /usr/pgsql-9.3/bin/postmaster -p 5432 -D /ebs/pgdata. If the postmaster process does not exist, you could try running the <apigee-bin>/all-stop.sh script then the <apigee-bin>all-start.sh script on the Postgres server and see if the postmaster process would start and the error in the management UI would disappear.

There are more links regarding Postgres server setup and could help further diagnose the problem, for example, http://www.postgresql.org/docs/9.0/static/server-start.html and http://stackoverflow.com/questions/20825734/postgresql-connection-refused-check-that-the-hostname-and-port-are-correct-an.

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

6 People are following this question.

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

Related Questions

Why does Apigee Edge show no data in Analytics? 1 Answer

Custom Dimension not appearing 1 Answer

How to Start, Stop, and Restart Apigee Edge in a private cloud deployment? 1 Answer

How can we change the Analytics Custom report duration on Private Cloud? 1 Answer

Are stand-by PostgreSQL used for analytics queries? 0 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