Avaya POM Postgres DB Connect Command

[email protected] 08:04 PM /opt/Avaya/avpom/POManager/logs # su – postgres

-bash-3.2$ psql
Welcome to psql 8.3.10, the PostgreSQL interactive terminal.

Type: \\copyright for distribution terms
\\h for help with SQL commands
\\? for help with psql commands
\\g or terminate with semicolon to execute query
\\q to quit

postgres=# \\c VoicePortal
You are now connected to database “VoicePortal”.

pom=# select * from pim_job where job_id=’1150′;
job_id | campaign_id | schedule_id | status | start_time | end_time | last_allocated_id | f inish_reason | next_archival_time | abort_time | total_calls | total_emails | total_sms | total_contacts | successful_calls | nuisance_calls | customer_hangups
1150 | 1 | | 16 | 2011-03-02 12:41:42.188-07 | | -1 | | | | 0 | 0 | 0 | 0 | 0 | 0 | 0
(1 row)

pom=# delete from pim_job where job_id=’1150′;

Src: How to stop POM Campaign manually


[email protected] ~]# service POM restart
Stopping POM at Mon Oct 17 10:12:07 CEST 2011
Stopping individual components:
Stopping Campaign Manager…
Stopping Campaign Manager:
Warning: No CM process is running! Please restart CM [ OK ]
… successful
Stopping Campaign Director…
Stopping Campaign Director:
Warning: No CD process is running! Please restart CD [ OK ]
… successful

POM Shutdown Status: [ OK ]

Solution: From the Voice Portal (VP) web Administration page, remove and create back the POM server.

From the Voice Portal Web Administration page, access menu POM Configuration / POM servers

  1.  Check the box in front of the POM server name and click the Delete button.
  2. Click the Add button to create back the POM server and fill the POM Server Name and POM Server IP Address fields.


 Proactive Outreach Manager POM: Got only one ring on POM dialed contact

When running the campaign, the called contacts ring only once. In the POM report, the calls are identified as transferred however the calls have not been answered. The strategy has been developed to use the AvayaPOMAgent application which proceed with a Blind transfer.

On CM, access the administration and run:

change system-parameters special-applications.

Set to yes SA8874 as shown below:

(SA8874) – Call Status Messages for 7434ND IP Softphone? y

[[email protected] ~]# service POM status