CDRFileAudit SQLException Exhausted Resultset

Issue:

The “Exhausted Resultset” error message appears in the NexOSS-CDR-Collection.log file(s).

Log message:

CDRFileAudit|ERROR|SQLException:Exhausted Resultset

Troubleshoot:

The clocks on NexOSS and OSPrey(s) are not synchronized.

Clocks aren’t synchronized

Solution:

Install and start the NTP daemon on NexOSS and each OSPrey system as user root.

[ospadmin@callsim-139 ~]$ su
Password:
[root@osp ospadmin]#
[root@osp ospadmin]# yum install ntpd
Loaded plugins: fastestmirror, refresh-packagekit, security
Determining fastest mirrors
 * base: mirror.dattobackup.com
 * extras: mirror.wiredtree.com
 * updates: mirror.cs.uwp.edu
base
| 3.7 kB     00:00     base/primary_db
| 4.6 MB     00:08     debug
| 2.5 kB     00:00     debug/primary_db
| 1.2 MB     00:01     extras
| 3.4 kB     00:00     extras/primary_db
|  30 kB     00:00     updates
| 3.4 kB     00:00     updates/primary_db
| 1.5 MB     00:01
Setting up Install Process
[root@osp ospadmin]#
[root@osp ospadmin]# ps -ef|grep ntpd
root      4986  4293  0 10:24 pts/0    00:00:00 grep ntpd
[root@osp ospadmin]#
[root@osp ospadmin]# /etc/init.d/ntpd start
Starting ntpd:                                             [  OK  ]
[root@osp ospadmin]#
[root@osp ospadmin]# ps -ef|grep ntpd
ntp  5015     1  0 10:25 ?      00:00:00 ntpd -u ntp:ntp -p /var/run/ntpd.pid -g
root 5018  4293  0 10:25 pts/0  00:00:00 grep ntpd