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.
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