Can not start CA Business Inteligence

Products

• CA Performance Management - Usage and Administration
• DX NetOps

Issue/Introduction

I am not able to start the Jasperreports for CA Business Intelligence.  Please see attached pic for the error :

When shutting all CABI services down, it was necessary to use "kill -9 <PID>" on the tomcat service as it was hung and failed to properly shut down. Thus was due to no postgres DB running.

Trying to start postgres on it's own with the following command, run as the root user calling the postgres OS user, revealed the issue.

su postgres -c '"/opt/CA/SharedComponents/CA Business Intelligence/postgresql/bin/pg_ctl" start -D "/opt/CA/SharedComponents/CA Business Intelligence/postgresql/data" -l "/opt/CA/SharedComponents/CA Business Intelligence/postgresql/logs/logfile1"'

After that fails to start a postgres services (use "ps -ef | grep postgres" to validate) examining logfile1 we see this error.

[[email protected]_HOST logs]# more logfile1 
FATAL:  could not create lock file "/tmp/.s.PGSQL.5432.lock": Permission denied

Cause

The postgres DB was failing to start due to postgres OS user being unable to write to the /tmp directory.

Environment

All supported DX NetOps releases integrated with CABI using the native postgres database

Resolution

Allow postgres user read/write access to the /tmp directory.