FATAL: database "pomopdb" does not exist

Last Updated : Jun 03, 2026 |

Condition

While running a campaign, the CmpDirService.out file displays the following error:

Feb 23, 2022 8:29:10 PM [com.avaya.pim.trace.Tracer LogAndPrintStackTrace] WARNING Exception Occurred:FATAL: database "pomopdb101" does not exist
org.postgresql.util.PSQLException: FATAL: database "pomopdb" does not exist
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2553)
        at org.postgresql.core.v3.QueryExecutorImpl.readStartupMessages(QueryExecutorImpl.java:2665)
        at org.postgresql.core.v3.QueryExecutorImpl.<init>(QueryExecutorImpl.java:147)
        at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:273)
        at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:51)
        at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:225)
        at org.postgresql.Driver.makeConnection(Driver.java:465)
        at org.postgresql.Driver.connect(Driver.java:264)
        at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138)
        at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:353)
        at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:201)
        at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:473)
        at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:562)
        at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:115)
        at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112)
        at com.avaya.pim.jdbc.opdb.DBConnectionManager.getConnection(DBConnectionManager.java:264)
        at com.avaya.pim.jdbc.opdb.PGDBAdvListMgmtHelper.dropJobTable(PGDBAdvListMgmtHelper.java:1185)
        at com.avaya.pim.localstore.db.PimJobContactDAO.dropJobTable(PimJobContactDAO.java:449)
        at com.avaya.pim.workers.HistoryManagerThread.PerformFinalHistoryCreation(HistoryManagerThread.java:1673)
        at com.avaya.pim.workers.HistoryManagerThread.run(HistoryManagerThread.java:1780)

Cause

The connection of the POM system to the operational POM database breaks.

Solution

Connect the POM system to the operational POM database.

Procedure