Recently we have encountered an issue for the ICM HDS data replication. When we tried to view some historical reports such as skill group half hour, trunki group half hour (for current date) on the webview, nothing was shown, there was only 1 line of record showing some "0" values.. However, some other reports such as Call Type Half Hour, Agent Task Summary Half Hour are working fine and they are able to show the stats for the current date..
When I looked at the rpl process window on the HDS, the log space used was 25% and it didn't seem to decrease.
I also noticed that, under Space Used Summary for the HDS database by using icmdba, the "Max DateTime" under those tables which store the historical data for the mentioned report, showed the date of 3 days ago, which is not up-to-date. however, the "Max DateTime" for the rest of the tables has got the current date..
Appreciate it if any expert can enlighten me with some clue or solution.. it this caused by the over utilization of the transaction logs for the HDS, as shown in the rpl process window? We tried to do a dump tran with no_log query and rebooted the HDS server, but it didn't help at all. the log space used still stays at 25%..
I have also checked and confirmed there is up-to-date historical data in the Logger database. We are using ICM 6.0 SR2..
Thanks & Regards,