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
All supported DX NetOps releases integrated with CABI using the native postgres database
The postgres DB was failing to start due to postgres OS user being unable to write to the /tmp directory.
Allow postgres user read/write access to the /tmp directory.