It is important, that the database is cleaned regularly, to remove old data, particularly statistics.
The database cleaner script - see Rolle DATA - Cleaner (auf den MASTER Server, der das Backup erstellt) - should be installed for this purpose.
Note
There is no recommendation as to how to set these parameters, as this will be dependent on the space available on the system.
Particularly, the following tables can "explode" depending on the number of agents configured on the system:
- JTELStats.AcdStatisticsLogin
- JTELStats.AcdStatisticsLogin2
- JTELStats2.CompressedU15
It is recommended to install monitoring on the database server, and check the table usage regularly.
Also, when implementing shorter deletion periods for tables which are large, do not reduce the deletion period in one large step. The danger is that the daemon may not be able to complete the work in one night. Rather, reduce the time period by small increments until the desired time period is reached.
The behaviour of the cleaner, is controlled by the following parameters:
| Parameter | Affects Data in Table(s) - Records are DELETED | Affects Data in Table(s) - References are set to NULL | Comments |
|---|---|---|---|
| ConfServer.Statistics.ConfStatsPartA.MaxAgeDays | JTELWeb.ConfStatsPartA | This affects the availability of uncompressed historical data on conferences and their participants, and affects the availability of historical reports based on this data. | |
| ConfServer.Statistics.ConfStatsPartI.MaxAgeDays | JTELWeb.ConfStatsPartI | This affects the availability of uncompressed historical data on conference invitations, and affects the availability of historical reports based on this data. | |
| Portal.Routing.CounterDetailStatistics.MaxAgeDays | JTELWeb.CounterDetailStatistics | This affects the availability of detail counter statistics for IVR applications, and affects the availability of the counters shown when a routing application's counters are accessed via the web application. | |
| Portal.Statistics.AcdStatisticsChatTransactionCodes.MaxAgeDays | JTELStats.AcdStatisticsChatTransactionCodes | This affects the availability of uncompressed historical data on transaction codes for chat sessions, and affects the availability of historical reports based on this data. | |
| Portal.Statistics.AcdStatisticsLogin.MaxAgeDays | JTELStats.AcdStatisticsLogin | This affects the availability of uncompressed historical data on agent login / logout activity, and affects the availability of historical reports based on this data. | |
| Portal.Statistics.AcdStatisticsPartC.MaxAgeDays | JTELStats.AcdStatisticsPartC | This affects the availability of uncompressed historical data on chat sessions, and affects the availability of historical reports based on this data. | |
| Portal.Statistics.AcdStatisticsPartD.MaxAgeDays | JTELStats.AcdStatisticsPartD | This affects the availability of uncompressed historical data on dynamic priority group handling, and affects the availability of historical reports based on this data. | |
| Portal.Statistics.AcdStatisticsTransactionCodes.MaxAgeDays | JTELStats.AcdStatisticsTransactionCodes | This affects the availability of uncompressed historical data on transaction codes for calls, and affects the availability of historical reports based on this data. | |
| Portal.Statistics.CallHistoryPartA.MaxAgeDays | JTELLog.CallHistoryPartA | This affects the visibility of calls in the Call Log or Call Analyser Log. | |
| Portal.Statistics.StatisticsClick2DialNoPortal.MaxAgeDays | JTELStats.StatisticsClick2DialNoPortal | This affects the availability of CDRs for click to dial (no portal) requests made to the system, and affects the availability of historical reports based on this data. | |
| Portal.Statistics.StatisticsDiallerCampaigns.MaxAgeDays | JTELStats.StatisticsDiallerCampaigns | This affects the availability of compressed historical data on dialler campaigns for calls made and results, and affects the availability of historical reports based on this data. | |
| Portal.Statistics.StatisticsPartA.MaxAgeDays | JTELLog.CallHistoryPartA JTELStats.AcdStatisticsPartB JTELWeb.DiallerContactsHistory | JTELStats.AcdStatisticsTransactionCodes | Because the StatisticsPartA table is referenced for each incoming and outgoing call, deletion of records in this table causes all data, which is dependent on these records, to be deleted or NULLed at the same time. This affects the availability of uncompressed historical data regarding calls to and from the system, including all referenced records in the tables noted, and affects the availability of historical reports based on this data. |
| Portal.Statistics.StatisticsPartIVR.MaxAgeDays | JTELStats.StatisticsPartIVR | This affects the availability of uncompressed historical data on IVR statistics markers used in IVR applications, and affects the availability of historical reports based on this data. | |
| Portal.Statistics.StatisticsPartK.MaxAgeDays | JTELStats.StatisticsPartK | This affects the availability of uncompressed historical data on incoming e-mails received using a workflow connector script (ruby script, not an E-Mail connector), and affects the availability of historical reports based on this data. | |
| Portal.Statistics.StatisticsPartR.MaxAgeDays | JTELStats.StatisticsPartR1 | This affects the availability of uncompressed historical data on recording transport statistics (sending automatically as a result of saving recordings in the IVR, for example to FTP or to E-Mail), and affects the availability of historical reports based on this data. | |
| Portal.Statistics.StatisticsPartT.MaxAgeDays | JTELStats.StatisticsPartT | This affects the availability of uncompressed historical data on PBX CDRs, and affects the availability of historical reports based on this data. | |
| Portal.Statistics.StatisticsPartZ.MaxAgeDays | JTELStats.StatisticsPartZ | This affects the availability of uncompressed historical data on calls which could not be processed by any service number (and hence were rejected by the system), and affects the availability of historical reports based on this data. | |
| Portal.ACD.Statistics.JTELStats2.CompressedA15.MaxAgeDays | JTELStats.CompressedA15 JTELStats.custom_CompressedA15 | This affects the availability of compressed historical data in 15 minute time intervals regarding service numbers and calls processed, and affects the availability of historical reports based on this data. | |
| Portal.ACD.Statistics.JTELStats2.CompressedADay.MaxAgeDays | JTELStats.CompressedADay JTELStats.custom_CompressedADay | This affects the availability of compressed historical data in day intervals regarding service numbers and calls processed, and affects the availability of historical reports based on this data. | |
| Portal.ACD.Statistics.JTELStats2.CompressedU15.MaxAgeDays | JTELStats.CompressedU15 JTELStats.custom_CompressedU15 | This affects the availability of compressed historical data in 15 minute time intervals regarding user login / logout activity, and affects the availability of historical reports based on this data. | |
| Portal.ACD.Statistics.JTELStats2.CompressedUDay.MaxAgeDays | JTELStats.CompressedUDay JTELStats.custom_CompressedUDay | This affects the availability of compressed historical data in day intervals regarding user login / logout activity, and affects the availability of historical reports based on this data. | |
| Portal.ACD.Statistics.JTELStats2.CompressedUA15.MaxAgeDays | JTELStats.CompressedUA15 JTELStats.custom_CompressedUA15 | This affects the availability of compressed historical data in 15 minute time intervals regarding user call performance data, and affects the availability of historical reports based on this data. | |
| Portal.ACD.Statistics.JTELStats2.CompressedUADay.MaxAgeDays | JTELStats.CompressedUADay JTELStats.custom_CompressedUADay | This affects the availability of compressed historical data in day intervals regarding user call performance data, and affects the availability of historical reports based on this data. |