Upgrading AAI Insight fails with " [exec] Cannot create PoolableConnectionFactory (Connection to 127.0.0.1:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.)"

Products

• Automic Automation Intelligence

Issue/Introduction

Attempting to upgrade AAI Insight to 1.9 failed with the message below in the upgrade log:

 

[exec] Resource name: applicationContext-virtual-data-source-query-service.xml
     [exec] Cannot create PoolableConnectionFactory (Connection to 127.0.0.1:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.)
     [exec] Cannot create PoolableConnectionFactory (Connection to 127.0.0.1:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.)
     [exec]  -- JasperServer:  ProfileAttributeCacheImpl shutdown called.  This normal shutdown operation.
     [exec] Cannot create PoolableConnectionFactory (Connection to 127.0.0.1:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.)

 

...

BUILD FAILED
d:\Temp\1.9_upgrade\terma-bi-upgrader-1.9\termaBiInstaller.xml:39: The following error occurred while executing this line:
d:\Temp\1.9_upgrade\terma-bi-upgrader-1.9\termaBiInstaller.xml:675: exec returned: -1

Total time: 29 seconds

Environment

AAI Release : 6.3.0

Insight: 1.9

Component : AUTOMIC AUTOMATION INTELLIGENCE INTEGRATION

Cause

This will occur if the insight services, specifically jasperreportsPostgreSQL service, is shutdown before running the upgrade.

The upgrade is trying to connect to Insight's PostgreSQL database and cannot because the service is down.

 

Resolution

You can follow the steps below to recover from the error above and run the upgrade again.

1. Stop the insight services.

• Linux run "/<install dir>/ctlscript.sh stop"
• Windows use the "Stop JRS Service" desktop shortcut.

2. Delete the file below:

<Install Dir>\apache-tomcat\webapps\jasperserver-pro\WEB-INF\lib\termaJasperPatch-1.9

 

3. Start up the insight services and verify both are running when looking at Windows services

jasperreportsPostgreSQL

jasperreportsPostgreSQL

 

4. Run the upgrade again.

terma-bi-upgrader.bat /f termaBi-config.bat

 

5.   It should finish with a message like below:

start-tomcat:
     [echo] Starting Tomcat server
     [exec] The jasperreportsTomcat service is starting.
     [exec] The jasperreportsTomcat service was started successfully.
     [exec]
     [echo] Done starting Tomcat server

upgrade-depends:
     [echo] Upgraded BI server to 6.4.2

BUILD SUCCESSFUL
Total time: 1 minute 48 seconds