Prerequisites

Last Updated : Oct 28, 2025 |

Before upgrading POM to release 4.1, do the following:

  • Ensure your current release is POM 4.0.2 or service packs or patches of 4.0.2.

  • See the Interoperability matrix.

  • For more information about hardware and software requirements for upgrading to release 4.1, see Implementing Proactive Outreach Manager.

  • Check the existing system customizations and take necessary inputs for changes in Java, Hibernate, and the operating system of the POM server.

  • Ensure you upgrade POM in lab systems first.

    If the POM upgrade in the lab is successful, upgrade POM in the production environment.

Oracle database - required role for database monitoring

To have SELECT access for POM users on Oracle's dynamic performance views, Database Administrator (DBA) must grant the following Oracle role to POM users:

GRANT SELECT ANY DICTIONARY TO <pom_user>;

SQL Server database – required role for database monitoring

To have SELECT access for POM users on dynamic management views and functions that provide information about database health statistics, DBA must grant following SQL Server role to POM users.

GRANT VIEW SERVER STATE TO <pom_user>;

Postgres database - required role for database monitoring

To allow POM Postgres users to read pg_stat_* views which provide information about database health statistics, DBA must grant following Postgres role to POM users.

GRANT pg_read_all_stats TO <pom_user>;

Note:

POM for Postgres database require pg_stat_statements module for tracking planning and execution statistics of all SQL statements executed by a server. This module is not available globally but can be enabled for a specific database with CREATE EXTENSION.

Contact your database administrator to install and enable the pg_stat_statements extension in POM PostgreSQL database server.