Hi all,
I am getting problem with GVP Reporting Statistics.
All GVP Reporting Statistics in Genesys Administrator are zero. When I check the log, I don't get any errors.
Can anyone help me please.
Please find part of my Reporting Server log below:
16:02:20.939 Trace CTIPRDRHL03 Reporting_Server GCTI-153-04100 com.genesyslab.commons.log4j.LoggingManager Logging service started
16:02:20.947 Trace CTIPRDRHL03 Reporting_Server GCTI-153-20000 com.gvp.rpt.service.StandAloneReportingService Successfully obtained configuration from configuration server.
16:02:20.994 Trace CTIPRDRHL03 Reporting_Server GCTI-153-20000 com.gvp.rpt.service.StandAloneReportingService Creating HTTP connector on: 8080
16:02:20.995 Trace CTIPRDRHL03 Reporting_Server GCTI-153-20000 com.gvp.rpt.service.StandAloneReportingService JMS broker listening on: 61616
16:02:21.025 Debug CTIPRDRHL03 Reporting_Server GCTI-153-09900 com.genesyslab.commons.lca.LCAManager activate JVM shutdown hook
16:02:21.025 Debug CTIPRDRHL03 Reporting_Server GCTI-153-09900 com.genesyslab.commons.lca.LCAManager Async init of LCAManager is initiated
16:02:21.025 Trace CTIPRDRHL03 Reporting_Server GCTI-153-04500 com.genesyslab.commons.lca.LCAManager Connecting to Local Control Agent 'LCA' at host 'localhost', port 4999
16:02:21.026 Standard CTIPRDRHL03 Reporting_Server GCTI-153-05061 com.gvp.rpt.service.StandAloneReportingService Initialization completed
16:02:21.032 Standard CTIPRDRHL03 Reporting_Server GCTI-153-04503 com.genesyslab.commons.lca.LCAManager Connected to Local Control Agent 'LCA' at host 'localhost', port 4999
16:02:21.033 Trace CTIPRDRHL03 Reporting_Server GCTI-153-20001 com.genesyslab.commons.lca.LCAManager Reporting Server initializing in 'standalone' mode
16:02:21.034 Trace CTIPRDRHL03 Reporting_Server GCTI-153-20000 com.gvp.rpt.service.StandAloneReportingService PARTITIONING_ENABLED is false. Using configuration - [Ljava.lang.String;@12f9924
16:02:22.769 Trace CTIPRDRHL03 Reporting_Server GCTI-153-20000 com.gvp.rpt.dao.SessionFactoryBean Building new Hibernate SessionFactory
16:02:24.016 Debug CTIPRDRHL03 Reporting_Server GCTI-153-09900 com.gvp.rpt.dao.SessionFactoryBean Closing opened DB session.
16:02:28.489 Trace CTIPRDRHL03 Reporting_Server GCTI-153-20007 com.gvp.rpt.service.DateComponentsPopulationJob DateComponents Population job run
16:02:28.492 Trace CTIPRDRHL03 Reporting_Server GCTI-153-20000 com.gvp.rpt.service.DateComponentsPopulationJob Populating DateComponents from Tue Sep 01 00:00:00 RET 2015 until Fri Sep 01 00:00:00 RET 2017
16:02:28.683 Debug CTIPRDRHL03 Reporting_Server GCTI-153-09900 com.gvp.rpt.dao.DateComponentsDao End date is not after start date; no need to populate
16:02:28.691 Trace CTIPRDRHL03 Reporting_Server GCTI-153-20000 com.gvp.rpt.service.DateComponentsPopulationJob Populating TimeComponents
16:02:28.706 Debug CTIPRDRHL03 Reporting_Server GCTI-153-09900 com.gvp.rpt.dao.TimeComponentsDao TimeComponents already populated.
16:02:28.707 Trace CTIPRDRHL03 Reporting_Server GCTI-153-20008 com.gvp.rpt.service.DateComponentsPopulationJob DateComponents Population job complete
16:02:28.819 Debug CTIPRDRHL03 Reporting_Server GCTI-153-09900 com.gvp.rpt.summarization.dao.ArrivalSummarizationHelper Query for THIRTY_MINUTES summarization:
INSERT INTO PERIOD_RESULT_STATS_HOUR (start_of_day, minute_of_day, applicationID, tenantId, state, result, reason, CALL_COUNT, totalCallLenInSec)
SELECT start_of_day, half_hour_col * 30, applicationID, tenantId, state, result, reason, SUM(CALL_COUNT), SUM(totalCallLenInSec)
FROM PERIOD_RESULT_STATS_30MIN s
INNER JOIN TimeComponents t ON t.minute_of_day = s.minute_of_day
WHERE :lastSumID < id AND id <= :curSeqID
GROUP BY start_of_day, half_hour_col, applicationID, tenantId, state, result, reason
16:02:28.820 Debug CTIPRDRHL03 Reporting_Server GCTI-153-09900 com.gvp.rpt.summarization.dao.ArrivalSummarizationHelper Query for HOUR summarization:
INSERT INTO PERIOD_RESULT_STATS_HOUR (start_of_day, minute_of_day, applicationID, tenantId, state, result, reason, CALL_COUNT, totalCallLenInSec)
SELECT start_of_day, hour_col * 60, applicationID, tenantId, state, result, reason, SUM(CALL_COUNT), SUM(totalCallLenInSec)
FROM PERIOD_RESULT_STATS_30MIN s
INNER JOIN TimeComponents t ON t.minute_of_day = s.minute_of_day
WHERE :lastSumID < id AND id <= :curSeqID
GROUP BY start_of_day, hour_col, applicationID, tenantId, state, result, reason
16:02:28.821 Debug CTIPRDRHL03 Reporting_Server GCTI-153-09900 com.gvp.rpt.summarization.dao.ArrivalSummarizationHelper Query for DAY summarization:
INSERT INTO PERIOD_RESULT_STATS_HOUR (start_of_day, minute_of_day, applicationID, tenantId, state, result, reason, CALL_COUNT, totalCallLenInSec)
SELECT start_of_day, 0, applicationID, tenantId, state, result, reason, SUM(CALL_COUNT), SUM(totalCallLenInSec)
FROM PERIOD_RESULT_STATS_30MIN s
WHERE :lastSumID < id AND id <= :curSeqID
GROUP BY start_of_day, applicationID, tenantId, state, result, reason
16:02:28.821 Debug CTIPRDRHL03 Reporting_Server GCTI-153-09900 com.gvp.rpt.summarization.dao.ArrivalSummarizationHelper Query for WEEK summarization:
INSERT INTO PERIOD_RESULT_STATS_HOUR (start_of_day, minute_of_day, applicationID, tenantId, state, result, reason, CALL_COUNT, totalCallLenInSec)
SELECT start_of_week, 0, applicationID, tenantId, state, result, reason, SUM(CALL_COUNT), SUM(totalCallLenInSec)
FROM PERIOD_RESULT_STATS_30MIN s
INNER JOIN DateComponents d ON d.start_of_day = s.start_of_day
WHERE :lastSumID < id AND id <= :curSeqID
GROUP BY start_of_week, applicationID, tenantId, state, result, reason
16:02:28.822 Debug CTIPRDRHL03 Reporting_Server GCTI-153-09900 com.gvp.rpt.summarization.dao.ArrivalSummarizationHelper Query for MONTH summarization:
INSERT INTO PERIOD_RESULT_STATS_HOUR (start_of_day, minute_of_day, applicationID, tenantId, state, result, reason, CALL_COUNT, totalCallLenInSec)
SELECT start_of_month, 0, applicationID, tenantId, state, result, reason, SUM(CALL_COUNT), SUM(totalCallLenInSec)
FROM PERIOD_RESULT_STATS_30MIN s
INNER JOIN DateComponents d ON d.start_of_day = s.start_of_day
WHERE :lastSumID < id AND id <= :curSeqID
GROUP BY start_of_month, applicationID, tenantId, state, result, reason
16:02:28.822 Debug CTIPRDRHL03 Reporting_Server GCTI-153-09900 com.gvp.rpt.summarization.dao.ArrivalSummarizationHelper Query for THIRTY_MINUTES summarization:
INSERT INTO PERIOD_RESULT_STATS_DAY (start_of_day, minute_of_day, applicationID, tenantId, state, result, reason, CALL_COUNT, totalCallLenInSec)
SELECT start_of_day, half_hour_col * 30, applicationID, tenantId, state, result, reason, SUM(CALL_COUNT), SUM(totalCallLenInSec)
FROM PERIOD_RESULT_STATS_HOUR s
INNER JOIN TimeComponents t ON t.minute_of_day = s.minute_of_day
WHERE :lastSumID < id AND id <= :curSeqID
GROUP BY start_of_day, half_hour_col, applicationID, tenantId, state, result, reason
16:02:28.823 Debug CTIPRDRHL03 Reporting_Server GCTI-153-09900 com.gvp.rpt.summarization.dao.ArrivalSummarizationHelper Query for HOUR summarization:
INSERT INTO PERIOD_RESULT_STATS_DAY (start_of_day, minute_of_day, applicationID, tenantId, state, result, reason, CALL_COUNT, totalCallLenInSec)
SELECT start_of_day, hour_col * 60, applicationID, tenantId, state, result, reason, SUM(CALL_COUNT), SUM(totalCallLenInSec)
FROM PERIOD_RESULT_STATS_HOUR s
INNER JOIN TimeComponents t ON t.minute_of_day = s.minute_of_day
WHERE :lastSumID < id AND id <= :curSeqID
GROUP BY start_of_day, hour_col, applicationID, tenantId, state, result, reason
16:02:28.824 Debug CTIPRDRHL03 Reporting_Server GCTI-153-09900 com.gvp.rpt.summarization.dao.ArrivalSummarizationHelper Query for DAY summarization:
INSERT INTO PERIOD_RESULT_STATS_DAY (start_of_day, minute_of_day, applicationID, tenantId, state, result, reason, CALL_COUNT, totalCallLenInSec)
SELECT start_of_day, 0, applicationID, tenantId, state, result, reason, SUM(CALL_COUNT), SUM(totalCallLenInSec)
FROM PERIOD_RESULT_STATS_HOUR s
WHERE :lastSumID < id AND id <= :curSeqID
GROUP BY start_of_day, applicationID, tenantId, state, result, reason
16:02:28.824 Debug CTIPRDRHL03 Reporting_Server GCTI-153-09900 com.gvp.rpt.summarization.dao.ArrivalSummarizationHelper Query for WEEK summarization:
INSERT INTO PERIOD_RESULT_STATS_DAY (start_of_day, minute_of_day, applicationID, tenantId, state, result, reason, CALL_COUNT, totalCallLenInSec)
SELECT start_of_week, 0, applicationID, tenantId, state, result, reason, SUM(CALL_COUNT), SUM(totalCallLenInSec)
FROM PERIOD_RESULT_STATS_HOUR s
INNER JOIN DateComponents d ON d.start_of_day = s.start_of_day
WHERE :lastSumID < id AND id <= :curSeqID
GROUP BY start_of_week, applicationID, tenantId, state, result, reason
16:02:28.825 Debug CTIPRDRHL03 Reporting_Server GCTI-153-09900 com.gvp.rpt.summarization.dao.ArrivalSummarizationHelper Query for MONTH summarization:
INSERT INTO PERIOD_RESULT_STATS_DAY (start_of_day, minute_of_day, applicationID, tenantId, state, result, reason, CALL_COUNT, totalCallLenInSec)
SELECT start_of_month, 0, applicationID, tenantId, state, result, reason, SUM(CALL_COUNT), SUM(totalCallLenInSec)
FROM PERIOD_RESULT_STATS_HOUR s
INNER JOIN DateComponents d ON d.start_of_day = s.start_of_day
WHERE :lastSumID < id AND id <= :curSeqID
GROUP BY start_of_month, applicationID, tenantId, state, result, reason
16:02:28.826 Debug CTIPRDRHL03 Reporting_Server GCTI-153-09900 com.gvp.rpt.summarization.dao.ArrivalSummarizationHelper Query for THIRTY_MINUTES summarization:
INSERT INTO PERIOD_RESULT_STATS_WEEK (start_of_day, minute_of_day, applicationID, tenantId, state, result, reason, CALL_COUNT, totalCallLenInSec)
SELECT start_of_day, half_hour_col * 30, applicationID, tenantId, state, result, reason, SUM(CALL_COUNT), SUM(totalCallLenInSec)
FROM PERIOD_RESULT_STATS_DAY s
INNER JOIN TimeComponents t ON t.minute_of_day = s.minute_of_day
WHERE :lastSumID < id AND id <= :curSeqID
GROUP BY start_of_day, half_hour_col, applicationID, tenantId, state, result, reason
16:02:28.826 Debug CTIPRDRHL03 Reporting_Server GCTI-153-09900 com.gvp.rpt.summarization.dao.ArrivalSummarizationHelper Query for HOUR summarization:
INSERT INTO PERIOD_RESULT_STATS_WEEK (start_of_day, minute_of_day, applicationID, tenantId, state, result, reason, CALL_COUNT, totalCallLenInSec)
SELECT start_of_day, hour_col * 60, applicationID, tenantId, state, result, reason, SUM(CALL_COUNT), SUM(totalCallLenInSec)
FROM PERIOD_RESULT_STATS_DAY s
INNER JOIN TimeComponents t ON t.minute_of_day = s.minute_of_day
WHERE :lastSumID < id AND id <= :curSeqID
GROUP BY start_of_day, hour_col, applicationID, tenantId, state, result, reason
16:02:28.827 Debug CTIPRDRHL03 Reporting_Server GCTI-153-09900 com.gvp.rpt.summarization.dao.ArrivalSummarizationHelper Query for DAY summarization:
INSERT INTO PERIOD_RESULT_STATS_WEEK (start_of_day, minute_of_day, applicationID, tenantId, state, result, reason, CALL_COUNT, totalCallLenInSec)
SELECT start_of_day, 0, applicationID, tenantId, state, result, reason, SUM(CALL_COUNT), SUM(totalCallLenInSec)
FROM PERIOD_RESULT_STATS_DAY s
WHERE :lastSumID < id AND id <= :curSeqID
GROUP BY start_of_day, applicationID, tenantId, state, result, reason
16:02:28.828 Debug CTIPRDRHL03 Reporting_Server GCTI-153-09900 com.gvp.rpt.summarization.dao.ArrivalSummarizationHelper Query for WEEK summarization:
INSERT INTO PERIOD_RESULT_STATS_WEEK (start_of_day, minute_of_day, applicationID, tenantId, state, result, reason, CALL_COUNT, totalCallLenInSec)
SELECT start_of_week, 0, applicationID, tenantId, state, result, reason, SUM(CALL_COUNT), SUM(totalCallLenInSec)
FROM PERIOD_RESULT_STATS_DAY s
INNER JOIN DateComponents d ON d.start_of_day = s.start_of_day
WHERE :lastSumID < id AND id <= :curSeqID
GROUP BY start_of_week, applicationID, tenantId, state, result, reason
16:02:28.828 Debug CTIPRDRHL03 Reporting_Server GCTI-153-09900 com.gvp.rpt.summarization.dao.ArrivalSummarizationHelper Query for MONTH summarization:
INSERT INTO PERIOD_RESULT_STATS_WEEK (start_of_day, minute_of_day, applicationID, tenantId, state, result, reason, CALL_COUNT, totalCallLenInSec)
SELECT start_of_month, 0, applicationID, tenantId, state, result, reason, SUM(CALL_COUNT), SUM(totalCallLenInSec)
FROM PERIOD_RESULT_STATS_DAY s
INNER JOIN DateComponents d ON d.start_of_day = s.start_of_day
WHERE :lastSumID < id AND id <= :curSeqID
GROUP BY start_of_month, applicationID, tenantId, state, result, reason
16:02:28.829 Debug CTIPRDRHL03 Reporting_Server GCTI-153-09900 com.gvp.rpt.summarization.dao.ArrivalSummarizationHelper Query for THIRTY_MINUTES summarization:
INSERT INTO PERIOD_RESULT_STATS_MONTH (start_of_day, minute_of_day, applicationID, tenantId, state, result, reason, CALL_COUNT, totalCallLenInSec)
SELECT start_of_day, half_hour_col * 30, applicationID, tenantId, state, result, reason, SUM(CALL_COUNT), SUM(totalCallLenInSec)
FROM PERIOD_RESULT_STATS_DAY s
INNER JOIN TimeComponents t ON t.minute_of_day = s.minute_of_day
WHERE :lastSumID < id AND id <= :curSeqID
GROUP BY start_of_day, half_hour_col, applicationID, tenantId, state, result, reason
16:02:28.829 Debug CTIPRDRHL03 Reporting_Server GCTI-153-09900 com.gvp.rpt.summarization.dao.ArrivalSummarizationHelper Query for HOUR summarization:
INSERT INTO PERIOD_RESULT_STATS_MONTH (start_of_day, minute_of_day, applicationID, tenantId, state, result, reason, CALL_COUNT, totalCallLenInSec)
SELECT start_of_day, hour_col * 60, applicationID, tenantId, state, result, reason, SUM(CALL_COUNT), SUM(totalCallLenInSec)
FROM PERIOD_RESULT_STATS_DAY s
INNER JOIN TimeComponents t ON t.minute_of_day = s.minute_of_day
WHERE :lastSumID < id AND id <= :curSeqID
GROUP BY start_of_day, hour_col, applicationID, tenantId, state, result, reason
16:02:28.830 Debug CTIPRDRHL03 Reporting_Server GCTI-153-09900 com.gvp.rpt.summarization.dao.ArrivalSummarizationHelper Query for DAY summarization:
INSERT INTO PERIOD_RESULT_STATS_MONTH (start_of_day, minute_of_day, applicationID, tenantId, state, result, reason, CALL_COUNT, totalCallLenInSec)
SELECT start_of_day, 0, applicationID, tenantId, state, result, reason, SUM(CALL_COUNT), SUM(totalCallLenInSec)
FROM PERIOD_RESULT_STATS_DAY s
WHERE :lastSumID < id AND id <= :curSeqID
GROUP BY start_of_day, applicationID, tenantId, state, result, reason
16:02:28.831 Debug CTIPRDRHL03 Reporting_Server GCTI-153-09900 com.gvp.rpt.summarization.dao.ArrivalSummarizationHelper Query for WEEK summarization:
INSERT INTO PERIOD_RESULT_STATS_MONTH (start_of_day, minute_of_day, applicationID, tenantId, state, result, reason, CALL_COUNT, totalCallLenInSec)
SELECT start_of_week, 0, applicationID, tenantId, state, result, reason, SUM(CALL_COUNT), SUM(totalCallLenInSec)
FROM PERIOD_RESULT_STATS_DAY s
INNER JOIN DateComponents d ON d.start_of_day = s.start_of_day
WHERE :lastSumID < id AND id <= :curSeqID
GROUP BY start_of_week, applicationID, tenantId, state, result, reason
16:02:28.831 Debug CTIPRDRHL03 Reporting_Server GCTI-153-09900 com.gvp.rpt.summarization.dao.ArrivalSummarizationHelper Query for MONTH summarization:
INSERT INTO PERIOD_RESULT_STATS_MONTH (start_of_day, minute_of_day, applicationID, tenantId, state, result, reason, CALL_COUNT, totalCallLenInSec)
SELECT start_of_month, 0, applicationID, tenantId, state, result, reason, SUM(CALL_COUNT), SUM(totalCallLenInSec)
FROM PERIOD_RESULT_STATS_DAY s
INNER JOIN DateComponents d ON d.start_of_day = s.start_of_day
WHERE :lastSumID < id AND id <= :curSeqID
GROUP BY start_of_month, applicationID, tenantId, state, result, reason
16:02:28.832 Debug CTIPRDRHL03 Reporting_Server GCTI-153-09900 com.gvp.rpt.summarization.dao.ArrivalSummarizationHelper Query for THIRTY_MINUTES summarization:
INSERT INTO PERIOD_RESULT_STATS_30MIN (start_of_day, minute_of_day, applicationID, tenantId, state, result, reason, CALL_COUNT, totalCallLenInSec)
SELECT start_of_day, half_hour_col * 30, applicationID, tenantId, state, result, reason, SUM(CALL_COUNT), SUM(totalCallLenInSec)
FROM PERIOD_RESULT_STATS_5MIN s
INNER JOIN TimeComponents t ON t.minute_of_day = s.minute_of_day
WHERE :lastSumID < id AND id <= :curSeqID
GROUP BY start_of_day, half_hour_col, applicationID, tenantId, state, result, reason
16:02:28.832 Debug CTIPRDRHL03 Reporting_Server GCTI-153-09900 com.gvp.rpt.summarization.dao.ArrivalSummarizationHelper Query for HOUR summarization:
INSERT INTO PERIOD_RESULT_STATS_30MIN (start_of_day, minute_of_day, applicationID, tenantId, state, result, reason, CALL_COUNT, totalCallLenInSec)
SELECT start_of_day, hour_col * 60, applicationID, tenantId, state, result, reason, SUM(CALL_COUNT), SUM(totalCallLenInSec)
FROM PERIOD_RESULT_STATS_5MIN s
INNER JOIN TimeComponents t ON t.minute_of_day = s.minute_of_day
WHERE :lastSumID < id AND id <= :curSeqID
GROUP BY start_of_day, hour_col, applicationID, tenantId, state, result, reason
16:02:28.833 Debug CTIPRDRHL03 Reporting_Server GCTI-153-09900 com.gvp.rpt.summarization.dao.ArrivalSummarizationHelper Query for DAY summarization:
INSERT INTO PERIOD_RESULT_STATS_30MIN (start_of_day, minute_of_day, applicationID, tenantId, state, result, reason, CALL_COUNT, totalCallLenInSec)
SELECT start_of_day, 0, applicationID, tenantId, state, result, reason, SUM(CALL_COUNT), SUM(totalCallLenInSec)
FROM PERIOD_RESULT_STATS_5MIN s
WHERE :lastSumID < id AND id <= :curSeqID
GROUP BY start_of_day, applicationID, tenantId, state, result, reason
16:02:28.833 Debug CTIPRDRHL03 Reporting_Server GCTI-153-09900 com.gvp.rpt.summarization.dao.ArrivalSummarizationHelper Query for WEEK summarization:
INSERT INTO PERIOD_RESULT_STATS_30MIN (start_of_day, minute_of_day, applicationID, tenantId, state, result, reason, CALL_COUNT, totalCallLenInSec)
SELECT start_of_week, 0, applicationID, tenantId, state, result, reason, SUM(CALL_COUNT), SUM(totalCallLenInSec)
FROM PERIOD_RESULT_STATS_5MIN s
INNER JOIN DateComponents d ON d.start_of_day = s.start_of_day
WHERE :lastSumID < id AND id <= :curSeqID
GROUP BY start_of_week, applicationID, tenantId, state, result, reason
16:02:28.834 Debug CTIPRDRHL03 Reporting_Server GCTI-153-09900 com.gvp.rpt.summarization.dao.ArrivalSummarizationHelper Query for MONTH summarization:
INSERT INTO PERIOD_RESULT_STATS_30MIN (start_of_day, minute_of_day, applicationID, tenantId, state, result, reason, CALL_COUNT, totalCallLenInSec)
SELECT start_of_month, 0, applicationID, tenantId, state, result, reason, SUM(CALL_COUNT), SUM(totalCallLenInSec)
FROM PERIOD_RESULT_STATS_5MIN s
INNER JOIN DateComponents d ON d.start_of_day = s.start_of_day
WHERE :lastSumID < id AND id <= :curSeqID
GROUP BY start_of_month, applicationID, tenantId, state, result, reason
16:02:28.946 Debug CTIPRDRHL03 Reporting_Server GCTI-153-09900 com.gvp.rpt.summarization.dao.ArrivalSummarizationHelper Query for THIRTY_MINUTES summarization:
INSERT INTO PERIOD_IVR_ACTION_STATS_HOUR (start_of_day, minute_of_day, applicationID, tenantId, IVRActionID, result, reason, count, numUniqueCalls, S_usrEndCount, S_aplEndCount, S_sysErrCount, S_unknownCount, F_usrEndCount, F_aplEndCount, F_sysErrCount, F_unknownCount, U_usrEndCount, U_aplEndCount, U_sysErrCount, U_unknownCount)
SELECT start_of_day, half_hour_col * 30, applicationID, tenantId, IVRActionID, result, reason, SUM(count), SUM(numUniqueCalls), SUM(S_usrEndCount), SUM(S_aplEndCount), SUM(S_sysErrCount), SUM(S_unknownCount), SUM(F_usrEndCount), SUM(F_aplEndCount), SUM(F_sysErrCount), SUM(F_unknownCount), SUM(U_usrEndCount), SUM(U_aplEndCount), SUM(U_sysErrCount), SUM(U_unknownCount)
FROM PERIOD_IVR_ACTION_STATS_30MIN s
INNER JOIN TimeComponents t ON t.minute_of_day = s.minute_of_day
WHERE :lastSumID < id AND id <= :curSeqID
GROUP BY start_of_day, half_hour_col, applicationID, tenantId, IVRActionID, result, reason
16:02:28.947 Debug CTIPRDRHL03 Reporting_Server GCTI-153-09900 com.gvp.rpt.summarization.dao.ArrivalSummarizationHelper Query for HOUR summarization:
INSERT INTO PERIOD_IVR_ACTION_STATS_HOUR (start_of_day, minute_of_day, applicationID, tenantId, IVRActionID, result, reason, count, numUniqueCalls, S_usrEndCount, S_aplEndCount, S_sysErrCount, S_unknownCount, F_usrEndCount, F_aplEndCount, F_sysErrCount, F_unknownCount, U_usrEndCount, U_aplEndCount, U_sysErrCount, U_unknownCount)
SELECT start_of_day, hour_col * 60, applicationID, tenantId, IVRActionID, result, reason, SUM(count), SUM(numUniqueCalls), SUM(S_usrEndCount), SUM(S_aplEndCount), SUM(S_sysErrCount), SUM(S_unknownCount), SUM(F_usrEndCount), SUM(F_aplEndCount), SUM(F_sysErrCount), SUM(F_unknownCount), SUM(U_usrEndCount), SUM(U_aplEndCount), SUM(U_sysErrCount), SUM(U_unknownCount)
FROM PERIOD_IVR_ACTION_STATS_30MIN s
INNER JOIN TimeComponents t ON t.minute_of_day = s.minute_of_day
WHERE :lastSumID < id AND id <= :curSeqID
GROUP BY start_of_day, hour_col, applicationID, tenantId, IVRActionID, result, reason
16:02:28.947 Debug CTIPRDRHL03 Reporting_Server GCTI-153-09900 com.gvp.rpt.summarization.dao.ArrivalSummarizationHelper Query for DAY summarization:
INSERT INTO PERIOD_IVR_ACTION_STATS_HOUR (start_of_day, minute_of_day, applicationID, tenantId, IVRActionID, result, reason, count, numUniqueCalls, S_usrEndCount, S_aplEndCount, S_sysErrCount, S_unknownCount, F_usrEndCount, F_aplEndCount, F_sysErrCount, F_unknownCount, U_usrEndCount, U_aplEndCount, U_sysErrCount, U_unknownCount)
SELECT start_of_day, 0, applicationID, tenantId, IVRActionID, result, reason, SUM(count), SUM(numUniqueCalls), SUM(S_usrEndCount), SUM(S_aplEndCount), SUM(S_sysErrCount), SUM(S_unknownCount), SUM(F_usrEndCount), SUM(F_aplEndCount), SUM(F_sysErrCount), SUM(F_unknownCount), SUM(U_usrEndCount), SUM(U_aplEndCount), SUM(U_sysErrCount), SUM(U_unknownCount)
FROM PERIOD_IVR_ACTION_STATS_30MIN s
WHERE :lastSumID < id AND id <= :curSeqID
GROUP BY start_of_day, applicationID, tenantId, IVRActionID, result, reason
16:02:28.948 Debug CTIPRDRHL03 Reporting_Server GCTI-153-09900 com.gvp.rpt.summarization.dao.ArrivalSummarizationHelper Query for WEEK summarization:
INSERT INTO PERIOD_IVR_ACTION_STATS_HOUR (start_of_day, minute_of_day, applicationID, tenantId, IVRActionID, result, reason, count, numUniqueCalls, S_usrEndCount, S_aplEndCount, S_sysErrCount, S_unknownCount, F_usrEndCount, F_aplEndCount, F_sysErrCount, F_unknownCount, U_usrEndCount, U_aplEndCount, U_sysErrCount, U_unknownCount)
SELECT start_of_week, 0, applicationID, tenantId, IVRActionID, result, reason, SUM(count), SUM(numUniqueCalls), SUM(S_usrEndCount), SUM(S_aplEndCount), SUM(S_sysErrCount), SUM(S_unknownCount), SUM(F_usrEndCount), SUM(F_aplEndCount), SUM(F_sysErrCount), SUM(F_unknownCount), SUM(U_usrEndCount), SUM(U_aplEndCount), SUM(U_sysErrCount), SUM(U_unknownCount)
FROM PERIOD_IVR_ACTION_STATS_30MIN s
INNER JOIN DateComponents d ON d.start_of_day = s.start_of_day
WHERE :lastSumID < id AND id <= :curSeqID
GROUP BY start_of_week, applicationID, tenantId, IVRActionID, result, reason
16:02:28.948 Debug CTIPRDRHL03 Reporting_Server GCTI-153-09900 com.gvp.rpt.summarization.dao.ArrivalSummarizationHelper Query for MONTH summarization:
INSERT INTO PERIOD_IVR_ACTION_STATS_HOUR (start_of_day, minute_of_day, applicationID, tenantId, IVRActionID, result, reason, count, numUniqueCalls, S_usrEndCount, S_aplEndCount, S_sysErrCount, S_unknownCount, F_usrEndCount, F_aplEndCount, F_sysErrCount, F_unknownCount, U_usrEndCount, U_aplEndCount, U_sysErrCount, U_unknownCount)
SELECT start_of_month, 0, applicationID, tenantId, IVRActionID, result, reason, SUM(count), SUM(numUniqueCalls), SUM(S_usrEndCount), SUM(S_aplEndCount), SUM(S_sysErrCount), SUM(S_unknownCount), SUM(F_usrEndCount), SUM(F_aplEndCount), SUM(F_sysErrCount), SUM(F_unknownCount), SUM(U_usrEndCount), SUM(U_aplEndCount), SUM(U_sysErrCount), SUM(U_unknownCount)
FROM PERIOD_IVR_ACTION_STATS_30MIN s
INNER JOIN DateComponents d ON d.start_of_day = s.start_of_day
WHERE :lastSumID < id AND id <= :curSeqID
GROUP BY start_of_month, applicationID, tenantId, IVRActionID, result, reason
16:02:28.949 Debug CTIPRDRHL03 Reporting_Server GCTI-153-09900 com.gvp.rpt.summarization.dao.ArrivalSummarizationHelper Query for THIRTY_MINUTES summarization:
INSERT INTO PERIOD_IVR_ACTION_STATS_DAY (start_of_day, minute_of_day, applicationID, tenantId, IVRActionID, result, reason, count, numUniqueCalls, S_usrEndCount, S_aplEndCount, S_sysErrCount, S_unknownCount, F_usrEndCount, F_aplEndCount, F_sysErrCount, F_unknownCount, U_usrEndCount, U_aplEndCount, U_sysErrCount, U_unknownCount)
SELECT start_of_day, half_hour_col * 30, applicationID, tenantId, IVRActionID, result, reason, SUM(count), SUM(numUniqueCalls), SUM(S_usrEndCount), SUM(S_aplEndCount), SUM(S_sysErrCount), SUM(S_unknownCount), SUM(F_usrEndCount), SUM(F_aplEndCount), SUM(F_sysErrCount), SUM(F_unknownCount), SUM(U_usrEndCount), SUM(U_aplEndCount), SUM(U_sysErrCount), SUM(U_unknownCount)
FROM PERIOD_IVR_ACTION_STATS_HOUR s
INNER JOIN TimeComponents t ON t.minute_of_day = s.minute_of_day
WHERE :lastSumID < id AND id <= :curSeqID
GROUP BY start_of_day, half_hour_col, applicationID, tenantId, IVRActionID, result, reason
16:02:28.949 Debug CTIPRDRHL03 Reporting_Server GCTI-153-09900 com.gvp.rpt.summarization.dao.ArrivalSummarizationHelper Query for HOUR summarization:
INSERT INTO PERIOD_IVR_ACTION_STATS_DAY (start_of_day, minute_of_day, applicationID, tenantId, IVRActionID, result, reason, count, numUniqueCalls, S_usrEndCount, S_aplEndCount, S_sysErrCount, S_unknownCount, F_usrEndCount, F_aplEndCount, F_sysErrCount, F_unknownCount, U_usrEndCount, U_aplEndCount, U_sysErrCount, U_unknownCount)
SELECT start_of_day, hour_col * 60, applicationID, tenantId, IVRActionID, result, reason, SUM(count), SUM(numUniqueCalls), SUM(S_usrEndCount), SUM(S_aplEndCount), SUM(S_sysErrCount), SUM(S_unknownCount), SUM(F_usrEndCount), SUM(F_aplEndCount), SUM(F_sysErrCount), SUM(F_unknownCount), SUM(U_usrEndCount), SUM(U_aplEndCount), SUM(U_sysErrCount), SUM(U_unknownCount)
FROM PERIOD_IVR_ACTION_STATS_HOUR s
INNER JOIN TimeComponents t ON t.minute_of_day = s.minute_of_day
WHERE :lastSumID < id AND id <= :curSeqID
GROUP BY start_of_day, hour_col, applicationID, tenantId, IVRActionID, result, reason
16:02:28.949 Debug CTIPRDRHL03 Reporting_Server GCTI-153-09900 com.gvp.rpt.summarization.dao.ArrivalSummarizationHelper Query for DAY summarization:
INSERT INTO PERIOD_IVR_ACTION_STATS_DAY (start_of_day, minute_of_day, applicationID, tenantId, IVRActionID, result, reason, count, numUniqueCalls, S_usrEndCount, S_aplEndCount, S_sysErrCount, S_unknownCount, F_usrEndCount, F_aplEndCount, F_sysErrCount, F_unknownCount, U_usrEndCount, U_aplEndCount, U_sysErrCount, U_unknownCount)
SELECT start_of_day, 0, applicationID, tenantId, IVRActionID, result, reason, SUM(count), SUM(numUniqueCalls), SUM(S_usrEndCount), SUM(S_aplEndCount), SUM(S_sysErrCount), SUM(S_unknownCount), SUM(F_usrEndCount), SUM(F_aplEndCount), SUM(F_sysErrCount), SUM(F_unknownCount), SUM(U_usrEndCount), SUM(U_aplEndCount), SUM(U_sysErrCount), SUM(U_unknownCount)
FROM PERIOD_IVR_ACTION_STATS_HOUR s
WHERE :lastSumID < id AND id <= :curSeqID
GROUP BY start_of_day, applicationID, tenantId, IVRActionID, result, reason
16:02:28.950 Debug CTIPRDRHL03 Reporting_Server GCTI-153-09900 com.gvp.rpt.summarization.dao.ArrivalSummarizationHelper Query for WEEK summarization:
INSERT INTO PERIOD_IVR_ACTION_STATS_DAY (start_of_day, minute_of_day, applicationID, tenantId, IVRActionID, result, reason, count, numUniqueCalls, S_usrEndCount, S_aplEndCount, S_sysErrCount, S_unknownCount, F_usrEndCount, F_aplEndCount, F_sysErrCount, F_unknownCount, U_usrEndCount, U_aplEndCount, U_sysErrCount, U_unknownCount)
SELECT start_of_week, 0, applicationID, tenantId, IVRActionID, result, reason, SUM(count), SUM(numUniqueCalls), SUM(S_usrEndCount), SUM(S_aplEndCount), SUM(S_sysErrCount), SUM(S_unknownCount), SUM(F_usrEndCount), SUM(F_aplEndCount), SUM(F_sysErrCount), SUM(F_unknownCount), SUM(U_usrEndCount), SUM(U_aplEndCount), SUM(U_sysErrCount), SUM(U_unknownCount)
FROM PERIOD_IVR_ACTION_STATS_HOUR s
INNER JOIN DateComponents d ON d.start_of_day = s.start_of_day
WHERE :lastSumID < id AND id <= :curSeqID
GROUP BY start_of_week, applicationID, tenantId, IVRActionID, result, reason
16:02:28.950 Debug CTIPRDRHL03 Reporting_Server GCTI-153-09900 com.gvp.rpt.summarization.dao.ArrivalSummarizationHelper Query for MONTH summarization:
INSERT INTO PERIOD_IVR_ACTION_STATS_DAY (start_of_day, minute_of_day, applicationID, tenantId, IVRActionID, result, reason, count, numUniqueCalls, S_usrEndCount, S_aplEndCount, S_sysErrCount, S_unknownCount, F_usrEndCount, F_aplEndCount, F_sysErrCount, F_unknownCount, U_usrEndCount, U_aplEndCount, U_sysErrCount, U_unknownCount)
SELECT start_of_month, 0, applicationID, tenantId, IVRActionID, result, reason, SUM(count), SUM(numUniqueCalls), SUM(S_usrEndCount), SUM(S_aplEndCount), SUM(S_sysErrCount), SUM(S_unknownCount), SUM(F_usrEndCount), SUM(F_aplEndCount), SUM(F_sysErrCount), SUM(F_unknownCount), SUM(U_usrEndCount), SUM(U_aplEndCount), SUM(U_sysErrCount), SUM(U_unknownCount)
FROM PERIOD_IVR_ACTION_STATS_HOUR s
INNER JOIN DateComponents d ON d.start_of_day = s.start_of_day
WHERE :lastSumID < id AND id <= :curSeqID
GROUP BY start_of_month, applicationID, tenantId, IVRActionID, result, reason
16:02:28.951 Debug CTIPRDRHL03 Reporting_Server GCTI-153-09900 com.gvp.rpt.summarization.dao.ArrivalSummarizationHelper Query for THIRTY_MINUTES summarization:
INSERT INTO PERIOD_IVR_ACTION_STATS_WEEK (start_of_day, minute_of_day, applicationID, tenantId, IVRActionID, result, reason, count, numUniqueCalls, S_usrEndCount, S_aplEndCount, S_sysErrCount, S_unknownCount, F_usrEndCount, F_aplEndCount, F_sysErrCount, F_unknownCount, U_usrEndCount, U_aplEndCount, U_sysErrCount, U_unknownCount)
SELECT start_of_day, half_hour_col * 30, applicationID, tenantId, IVRActionID, result, reason, SUM(count), SUM(numUniqueCalls), SUM(S_usrEndCount), SUM(S_aplEndCount), SUM(S_sysErrCount), SUM(S_unknownCount), SUM(F_usrEndCount), SUM(F_aplEndCount), SUM(F_sysErrCount), SUM(F_unknownCount), SUM(U_usrEndCount), SUM(U_aplEndCount), SUM(U_sysErrCount), SUM(U_unknownCount)
FROM PERIOD_IVR_ACTION_STATS_DAY s
INNER JOIN TimeComponents t ON t.minute_of_day = s.minute_of_day
WHERE :lastSumID < id AND id <= :curSeqID
GROUP BY start_of_day, half_hour_col, applicationID, tenantId, IVRActionID, result, reason
16:02:28.951 Debug CTIPRDRHL03 Reporting_Server GCTI-153-09900 com.gvp.rpt.summarization.dao.ArrivalSummarizationHelper Query for HOUR summarization:
INSERT INTO PERIOD_IVR_ACTION_STATS_WEEK (start_of_day, minute_of_day, applicationID, tenantId, IVRActionID, result, reason, count, numUniqueCalls, S_usrEndCount, S_aplEndCount, S_sysErrCount, S_unknownCount, F_usrEndCount, F_aplEndCount, F_sysErrCount, F_unknownCount, U_usrEndCount, U_aplEndCount, U_sysErrCount, U_unknownCount)
SELECT start_of_day, hour_col * 60, applicationID, tenantId, IVRActionID, result, reason, SUM(count), SUM(numUniqueCalls), SUM(S_usrEndCount), SUM(S_aplEndCount), SUM(S_sysErrCount), SUM(S_unknownCount), SUM(F_usrEndCount), SUM(F_aplEndCount), SUM(F_sysErrCount), SUM(F_unknownCount), SUM(U_usrEndCount), SUM(U_aplEndCount), SUM(U_sysErrCount), SUM(U_unknownCount)
FROM PERIOD_IVR_ACTION_STATS_DAY s
INNER JOIN TimeComponents t ON t.minute_of_day = s.minute_of_day
WHERE :lastSumID < id AND id <= :curSeqID
GROUP BY start_of_day, hour_col, applicationID, tenantId, IVRActionID, result, reason
16:02:28.951 Debug CTIPRDRHL03 Reporting_Server GCTI-153-09900 com.gvp.rpt.summarization.dao.ArrivalSummarizationHelper Query for DAY summarization:
INSERT INTO PERIOD_IVR_ACTION_STATS_WEEK (start_of_day, minute_of_day, applicationID, tenantId, IVRActionID, result, reason, count, numUniqueCalls, S_usrEndCount, S_aplEndCount, S_sysErrCount, S_unknownCount, F_usrEndCount, F_aplEndCount, F_sysErrCount, F_unknownCount, U_usrEndCount, U_aplEndCount, U_sysErrCount, U_unknownCount)
SELECT start_of_day, 0, applicationID, tenantId, IVRActionID, result, reason, SUM(count), SUM(numUniqueCalls), SUM(S_usrEndCount), SUM(S_aplEndCount), SUM(S_sysErrCount), SUM(S_unknownCount), SUM(F_usrEndCount), SUM(F_aplEndCount), SUM(F_sysErrCount), SUM(F_unknownCount), SUM(U_usrEndCount), SUM(U_aplEndCount), SUM(U_sysErrCount), SUM(U_unknownCount)
FROM PERIOD_IVR_ACTION_STATS_DAY s
WHERE :lastSumID < id AND id <= :curSeqID
GROUP BY start_of_day, applicationID, tenantId, IVRActionID, result, reason
16:02:28.952 Debug CTIPRDRHL03 Reporting_Server GCTI-153-09900 com.gvp.rpt.summarization.dao.ArrivalSummarizationHelper Query for WEEK summarization:
INSERT INTO PERIOD_IVR_ACTION_STATS_WEEK (start_of_day, minute_of_day, applicationID, tenantId, IVRActionID, result, reason, count, numUniqueCalls, S_usrEndCount, S_aplEndCount, S_sysErrCount, S_unknownCount, F_usrEndCount, F_aplEndCount, F_sysErrCount, F_unknownCount, U_usrEndCount, U_aplEndCount, U_sysErrCount, U_unknownCount)
SELECT start_of_week, 0, applicationID, tenantId, IVRActionID, result, reason, SUM(count), SUM(numUniqueCalls), SUM(S_usrEndCount), SUM(S_aplEndCount), SUM(S_sysErrCount), SUM(S_unknownCount), SUM(F_usrEndCount), SUM(F_aplEndCount), SUM(F_sysErrCount), SUM(F_unknownCount), SUM(U_usrEndCount), SUM(U_aplEndCount), SUM(U_sysErrCount), SUM(U_unknownCount)
FROM PERIOD_IVR_ACTION_STATS_DAY s
INNER JOIN DateComponents d ON d.start_of_day = s.start_of_day
WHERE :lastSumID < id AND id <= :curSeqID
GROUP BY start_of_week, applicationID, tenantId, IVRActionID, result, reason
16:02:28.952 Debug CTIPRDRHL03 Reporting_Server GCTI-153-09900 com.gvp.rpt.summarization.dao.ArrivalSummarizationHelper Query for MONTH summarization:
INSERT INTO PERIOD_IVR_ACTION_STATS_WEEK (start_of_day, minute_of_day, applicationID, tenantId, IVRActionID, result, reason, count, numUniqueCalls, S_usrEndCount, S_aplEndCount, S_sysErrCount, S_unknownCount, F_usrEndCount, F_aplEndCount, F_sysErrCount, F_unknownCount, U_usrEndCount, U_aplEndCount, U_sysErrCount, U_unknownCount)
SELECT start_of_month, 0, applicationID, tenantId, IVRActionID, result, reason, SUM(count), SUM(numUniqueCalls), SUM(S_usrEndCount), SUM(S_aplEndCount), SUM(S_sysErrCount), SUM(S_unknownCount), SUM(F_usrEndCount), SUM(F_aplEndCount), SUM(F_sysErrCount), SUM(F_unknownCount), SUM(U_usrEndCount), SUM(U_aplEndCount), SUM(U_sysErrCount), SUM(U_unknownCount)
FROM PERIOD_IVR_ACTION_STATS_DAY s
INNER JOIN DateComponents d ON d.start_of_day = s.start_of_day
WHERE :lastSumID < id AND id <= :curSeqID
GROUP BY start_of_month, applicationID, tenantId, IVRActionID, result, reason
16:02:28.953 Debug CTIPRDRHL03 Reporting_Server GCTI-153-09900 com.gvp.rpt.summarization.dao.ArrivalSummarizationHelper Query for THIRTY_MINUTES summarization:
INSERT INTO PERIOD_IVR_ACTION_STATS_MONTH (start_of_day, minute_of_day, applicationID, tenantId, IVRActionID, result, reason, count, numUniqueCalls, S_usrEndCount, S_aplEndCount, S_sysErrCount, S_unknownCount, F_usrEndCount, F_aplEndCount, F_sysErrCount, F_unknownCount, U_usrEndCount, U_aplEndCount, U_sysErrCount, U_unknownCount)
SELECT start_of_day, half_hour_col * 30, applicationID, tenantId, IVRActionID, result, reason, SUM(count), SUM(numUniqueCalls), SUM(S_usrEndCount), SUM(S_aplEndCount), SUM(S_sysErrCount), SUM(S_unknownCount), SUM(F_usrEndCount), SUM(F_aplEndCount), SUM(F_sysErrCount), SUM(F_unknownCount), SUM(U_usrEndCount), SUM(U_aplEndCount), SUM(U_sysErrCount), SUM(U_unknownCount)
FROM PERIOD_IVR_ACTION_STATS_DAY s
INNER JOIN TimeComponents t ON t.minute_of_day = s.minute_of_day
WHERE :lastSumID < id AND id <= :curSeqID
GROUP BY start_of_day, half_hour_col, applicationID, tenantId, IVRActionID, result, reason
16:02:28.953 Debug CTIPRDRHL03 Reporting_Server GCTI-153-09900 com.gvp.rpt.summarization.dao.ArrivalSummarizationHelper Query for HOUR summarization:
INSERT INTO PERIOD_IVR_ACTION_STATS_MONTH (start_of_day, minute_of_day, applicationID, tenantId, IVRActionID, result, reason, count, numUniqueCalls, S_usrEndCount, S_aplEndCount, S_sysErrCount, S_unknownCount, F_usrEndCount, F_aplEndCount, F_sysErrCount, F_unknownCount, U_usrEndCount, U_aplEndCount, U_sysErrCount, U_unknownCount)
SELECT start_of_day, hour_col * 60, applicationID, tenantId, IVRActionID, result, reason, SUM(count), SUM(numUniqueCalls), SUM(S_usrEndCount), SUM(S_aplEndCount), SUM(S_sysErrCount), SUM(S_unknownCount), SUM(F_usrEndCount), SUM(F_aplEndCount), SUM(F_sysErrCount), SUM(F_unknownCount), SUM(U_usrEndCount), SUM(U_aplEndCount), SUM(U_sysErrCount), SUM(U_unknownCount)
FROM PERIOD_IVR_ACTION_STATS_DAY s
INNER JOIN TimeComponents t ON t.minute_of_day = s.minute_of_day
WHERE :lastSumID < id AND id <= :curSeqID
GROUP BY start_of_day, hour_col, applicationID, tenantId, IVRActionID, result, reason
16:02:28.953 Debug CTIPRDRHL03 Reporting_Server GCTI-153-09900 com.gvp.rpt.summarization.dao.ArrivalSummarizationHelper Query for DAY summarization:
INSERT INTO PERIOD_IVR_ACTION_STATS_MONTH (start_of_day, minute_of_day, applicationID, tenantId, IVRActionID, result, reason, count, numUniqueCalls, S_usrEndCount, S_aplEndCount, S_sysErrCount, S_unknownCount, F_usrEndCount, F_aplEndCount, F_sysErrCount, F_unknownCount, U_usrEndCount, U_aplEndCount, U_sysErrCount, U_unknownCount)
SELECT start_of_day, 0, applicationID, tenantId, IVRActionID, result, reason, SUM(count), SUM(numUniqueCalls), SUM(S_usrEndCount), SUM(S_aplEndCount), SUM(S_sysErrCount), SUM(S_unknownCount), SUM(F_usrEndCount), SUM(F_aplEndCount), SUM(F_sysErrCount), SUM(F_unknownCount), SUM(U_usrEndCount), SUM(U_aplEndCount), SUM(U_sysErrCount), SUM(U_unknownCount)
FROM PERIOD_IVR_ACTION_STATS_DAY s
WHERE :lastSumID < id AND id <= :curSeqID
GROUP BY start_of_day, applicationID, tenantId, IVRActionID, result, reason
16:02:28.954 Debug CTIPRDRHL03 Reporting_Server GCTI-153-09900 com.gvp.rpt.summarization.dao.ArrivalSummarizationHelper Query for WEEK summarization:
INSERT INTO PERIOD_IVR_ACTION_STATS_MONTH (start_of_day, minute_of_day, applicationID, tenantId, IVRActionID, result, reason, count, numUniqueCalls, S_usrEndCount, S_aplEndCount, S_sysErrCount, S_unknownCount, F_usrEndCount, F_aplEndCount, F_sysErrCount, F_unknownCount, U_usrEndCount, U_aplEndCount, U_sysErrCount, U_unknownCount)
SELECT start_of_week, 0, applicationID, tenantId, IVRActionID, result, reason, SUM(count), SUM(numUniqueCalls), SUM(S_usrEndCount), SUM(S_aplEndCount), SUM(S_sysErrCount), SUM(S_unknownCount), SUM(F_usrEndCount), SUM(F_aplEndCount), SUM(F_sysErrCount), SUM(F_unknownCount), SUM(U_usrEndCount), SUM(U_aplEndCount), SUM(U_sysErrCount), SUM(U_unknownCount)
FROM PERIOD_IVR_ACTION_STATS_DAY s
INNER JOIN DateComponents d ON d.start_of_day = s.start_of_day
WHERE :lastSumID < id AND id <= :curSeqID
GROUP BY start_of_week, applicationID, tenantId, IVRActionID, result, reason
16:02:28.954 Debug CTIPRDRHL03 Reporting_Server GCTI-153-09900 com.gvp.rpt.summarization.dao.ArrivalSummarizationHelper Query for MONTH summarization:
INSERT INTO PERIOD_IVR_ACTION_STATS_MONTH (start_of_day, minute_of_day, applicationID, tenantId, IVRActionID, result, reason, count, numUniqueCalls, S_usrEndCount, S_aplEndCount, S_sysErrCount, S_unknownCount, F_usrEndCount, F_aplEndCount, F_sysErrCount, F_unknownCount, U_usrEndCount, U_aplEndCount, U_sysErrCount, U_unknownCount)
SELECT start_of_month, 0, applicationID, tenantId, IVRActionID, result, reason, SUM(count), SUM(numUniqueCalls), SUM(S_usrEndCount), SUM(S_aplEndCount), SUM(S_sysErrCount), SUM(S_unknownCount), SUM(F_usrEndCount), SUM(F_aplEndCount), SUM(F_sysErrCount), SUM(F_unknownCount), SUM(U_usrEndCount), SUM(U_aplEndCount), SUM(U_sysErrCount), SUM(U_unknownCount)
FROM PERIOD_IVR_ACTION_STATS_DAY s
INNER JOIN DateComponents d ON d.start_of_day = s.start_of_day
WHERE :lastSumID < id AND id <= :curSeqID
GROUP BY start_of_month, applicationID, tenantId, IVRActionID, result, reason
16:02:28.955 Debug CTIPRDRHL03 Reporting_Server GCTI-153-09900 com.gvp.rpt.summarization.dao.ArrivalSummarizationHelper Query for THIRTY_MINUTES summarization:
INSERT INTO PERIOD_IVR_ACTION_STATS_30MIN (start_of_day, minute_of_day, applicationID, tenantId, IVRActionID, result, reason, count, numUniqueCalls, S_usrEndCount, S_aplEndCount, S_sysErrCount, S_unknownCount, F_usrEndCount, F_aplEndCount, F_sysErrCount, F_unknownCount, U_usrEndCount, U_aplEndCount, U_sysErrCount, U_unknownCount)
SELECT start_of_day, half_hour_col * 30, applicationID, tenantId, IVRActionID, result, reason, SUM(count), SUM(numUniqueCalls), SUM(S_usrEndCount), SUM(S_aplEndCount), SUM(S_sysErrCount), SUM(S_unknownCount), SUM(F_usrEndCount), SUM(F_aplEndCount), SUM(F_sysErrCount), SUM(F_unknownCount), SUM(U_usrEndCount), SUM(U_aplEndCount), SUM(U_sysErrCount), SUM(U_unknownCount)
FROM PERIOD_IVR_ACTION_STATS_5MIN s
INNER JOIN TimeComponents t ON t.minute_of_day = s.minute_of_day
WHERE :lastSumID < id AND id <= :curSeqID
GROUP BY start_of_day, half_hour_col, applicationID, tenantId, IVRActionID, result, reason
16:02:28.955 Debug CTIPRDRHL03 Reporting_Server GCTI-153-09900 com.gvp.rpt.summarization.dao.ArrivalSummarizationHelper Query for HOUR summarization:
INSERT INTO PERIOD_IVR_ACTION_STATS_30MIN (start_of_day, minute_of_day, applicationID, tenantId, IVRActionID, result, reason, count, numUniqueCalls, S_usrEndCount, S_aplEndCount, S_sysErrCount, S_unknownCount, F_usrEndCount, F_aplEndCount, F_sysErrCount, F_unknownCount, U_usrEndCount, U_aplEndCount, U_sysErrCount, U_unknownCount)
SELECT start_of_day, hour_col * 60, applicationID, tenantId, IVRActionID, result, reason, SUM(count), SUM(numUniqueCalls), SUM(S_usrEndCount), SUM(S_aplEndCount), SUM(S_sysErrCount), SUM(S_unknownCount), SUM(F_usrEndCount), SUM(F_aplEndCount), SUM(F_sysErrCount), SUM(F_unknownCount), SUM(U_usrEndCount), SUM(U_aplEndCount), SUM(U_sysErrCount), SUM(U_unknownCount)
FROM PERIOD_IVR_ACTION_STATS_5MIN s
INNER JOIN TimeComponents t ON t.minute_of_day = s.minute_of_day
WHERE :lastSumID < id AND id <= :curSeqID
GROUP BY start_of_day, hour_col, applicationID, tenantId, IVRActionID, result, reason
16:02:28.955 Debug CTIPRDRHL03 Reporting_Server GCTI-153-09900 com.gvp.rpt.summarization.dao.ArrivalSummarizationHelper Query for DAY summarization:
INSERT INTO PERIOD_IVR_ACTION_STATS_30MIN (start_of_day, minute_of_day, applicationID, tenantId, IVRActionID, result, reason, count, numUniqueCalls, S_usrEndCount, S_aplEndCount, S_sysErrCount, S_unknownCount, F_usrEndCount, F_aplEndCount, F_sysErrCount, F_unknownCount, U_usrEndCount, U_aplEndCount, U_sysErrCount, U_unknownCount)
SELECT start_of_day, 0, applicationID, tenantId, IVRActionID, result, reason, SUM(count), SUM(numUniqueCalls), SUM(S_usrEndCount), SUM(S_aplEndCount), SUM(S_sysErrCount), SUM(S_unknownCount), SUM(F_usrEndCount), SUM(F_aplEndCount), SUM(F_sysErrCount), SUM(F_unknownCount), SUM(U_usrEndCount), SUM(U_aplEndCount), SUM(U_sysErrCount), SUM(U_unknownCount)
FROM PERIOD_IVR_ACTION_STATS_5MIN s
WHERE :lastSumID < id AND id <= :curSeqID
GROUP BY start_of_day, applicationID, tenantId, IVRActionID, result, reason
16:02:28.956 Debug CTIPRDRHL03 Reporting_Server GCTI-153-09900 com.gvp.rpt.summarization.dao.ArrivalSummarizationHelper Query for WEEK summarization:
INSERT INTO PERIOD_IVR_ACTION_STATS_30MIN (start_of_day, minute_of_day, applicationID, tenantId, IVRActionID, result, reason, count, numUniqueCalls, S_usrEndCount, S_aplEndCount, S_sysErrCount, S_unknownCount, F_usrEndCount, F_aplEndCount, F_sysErrCount, F_unknownCount, U_usrEndCount, U_aplEndCount, U_sysErrCount, U_unknownCount)
SELECT start_of_week, 0, applicationID, tenantId, IVRActionID, result, reason, SUM(count), SUM(numUniqueCalls), SUM(S_usrEndCount), SUM(S_aplEndCount), SUM(S_sysErrCount), SUM(S_unknownCount), SUM(F_usrEndCount), SUM(F_aplEndCount), SUM(F_sysErrCount), SUM(F_unknownCount), SUM(U_usrEndCount), SUM(U_aplEndCount), SUM(U_sysErrCount), SUM(U_unknownCount)
FROM PERIOD_IVR_ACTION_STATS_5MIN s
INNER JOIN DateComponents d ON d.start_of_day = s.start_of_day
WHERE :lastSumID < id AND id <= :curSeqID
GROUP BY start_of_week, applicationID, tenantId, IVRActionID, result, reason
16:02:28.956 Debug CTIPRDRHL03 Reporting_Server GCTI-153-09900 com.gvp.rpt.summarization.dao.ArrivalSummarizationHelper Query for MONTH summarization:
INSERT INTO PERIOD_IVR_ACTION_STATS_30MIN (start_of_day, minute_of_day, applicationID, tenantId, IVRActionID, result, reason, count, numUniqueCalls, S_usrEndCount, S_aplEndCount, S_sysErrCount, S_unknownCount, F_usrEndCount, F_aplEndCount, F_sysErrCount, F_unknownCount, U_usrEndCount, U_aplEndCount, U_sysErrCount, U_unknownCount)
SELECT start_of_month, 0, applicationID, tenantId, IVRActionID, result, reason, SUM(count), SUM(numUniqueCalls), SUM(S_usrEndCount), SUM(S_aplEndCount), SUM(S_sysErrCount), SUM(S_unknownCount), SUM(F_usrEndCount), SUM(F_aplEndCount), SUM(F_sysErrCount), SUM(F_unknownCount), SUM(U_usrEndCount), SUM(U_aplEndCount), SUM(U_sysErrCount), SUM(U_unknownCount)
FROM PERIOD_IVR_ACTION_STATS_5MIN s
INNER JOIN DateComponents d ON d.start_of_day = s.start_of_day
WHERE :lastSumID < id AND id <= :curSeqID
GROUP BY start_of_month, applicationID, tenantId, IVRActionID, result, reason
16:02:28.992 Debug CTIPRDRHL03 Reporting_Server GCTI-153-09900 com.gvp.rpt.summarization.dao.ArrivalSummarizationHelper Query for THIRTY_MINUTES summarization:
INSERT INTO MCP_ARRIVALS_HOUR (start_of_day, minute_of_day, COMPONENT_ID, APPLICATION_ID, INBOUND, OUTBOUND, BRIDGED)
SELECT start_of_day, half_hour_col * 30, COMPONENT_ID, APPLICATION_ID, SUM(INBOUND), SUM(OUTBOUND), SUM(BRIDGED)
FROM MCP_ARRIVALS_30MIN s
INNER JOIN TimeComponents t ON t.minute_of_day = s.minute_of_day
WHERE :lastSumID < id AND id <= :curSeqID
GROUP BY start_of_day, half_hour_col, COMPONENT_ID, APPLICATION_ID
16:02:28.992 Debug CTIPRDRHL03 Reporting_Server GCTI-153-09900 com.gvp.rpt.summarization.dao.ArrivalSummarizationHelper Query for HOUR summarization:
INSERT INTO MCP_ARRIVALS_HOUR (start_of_day, minute_of_day, COMPONENT_ID, APPLICATION_ID, INBOUND, OUTBOUND, BRIDGED)
SELECT start_of_day, hour_col * 60, COMPONENT_ID, APPLICATION_ID, SUM(INBOUND), SUM(OUTBOUND), SUM(BRIDGED)
FROM MCP_ARRIVALS_30MIN s
INNER JOIN TimeComponents t ON t.minute_of_day = s.minute_of_day
WHERE :lastSumID < id AND id <= :curSeqID
GROUP BY start_of_day, hour_col, COMPONENT_ID, APPLICATION_ID
16:02:28.993 Debug CTIPRDRHL03 Reporting_Server GCTI-153-09900 com.gvp.rpt.summarization.dao.ArrivalSummarizationHelper Query for DAY summarization:
INSERT INTO MCP_ARRIVALS_HOUR (start_of_day, minute_of_day, COMPONENT_ID, APPLICATION_ID, INBOUND, OUTBOUND, BRIDGED)
SELECT start_of_day, 0, COMPONENT_ID, APPLICATION_ID, SUM(INBOUND), SUM(OUTBOUND), SUM(BRIDGED)
FROM MCP_ARRIVALS_30MIN s
WHERE :lastSumID < id AND id <= :curSeqID
GROUP BY start_of_day, COMPONENT_ID, APPLICATION_ID
16:02:28.993 Debug CTIPRDRHL03 Reporting_Server GCTI-153-09900 com.gvp.rpt.summarization.dao.ArrivalSummarizationHelper Query for WEEK summarization:
INSERT INTO MCP_ARRIVALS_HOUR (start_of_day, minute_of_day, COMPONENT_ID, APPLICATION_ID, INBOUND, OUTBOUND, BRIDGED)
SELECT start_of_week, 0, COMPONENT_ID, APPLICATION_ID, SUM(INBOUND), SUM(OUTBOUND), SUM(BRIDGED)
FROM MCP_ARRIVALS_30MIN s
INNER JOIN DateComponents d ON d.start_of_day = s.start_of_day
WHERE :lastSumID < id AND id <= :curSeqID
GROUP BY start_of_week, COMPONENT_ID, APPLICATION_ID
16:02:28.993 Debug CTIPRDRHL03 Reporting_Server GCTI-153-09900 com.gvp.rpt.summarization.dao.ArrivalSummarizationHelper Query for MONTH summarization:
INSERT INTO MCP_ARRIVALS_HOUR (start_of_day, minute_of_day, COMPONENT_ID, APPLICATION_ID, INBOUND, OUTBOUND, BRIDGED)
SELECT start_of_month, 0, COMPONENT_ID, APPLICATION_ID, SUM(INBOUND), SUM(OUTBOUND), SUM(BRIDGED)
FROM MCP_ARRIVALS_30MIN s
INNER JOIN DateComponents d ON d.start_of_day = s.start_of_day
WHERE :lastSumID < id AND id <= :curSeqID
GROUP BY start_of_month, COMPONENT_ID, APPLICATION_ID
16:02:28.993 Debug CTIPRDRHL03 Reporting_Server GCTI-153-09900 com.gvp.rpt.summarization.dao.ArrivalSummarizationHelper Query for THIRTY_MINUTES summarization:
INSERT INTO MCP_ARRIVALS_DAY (start_of_day, minute_of_day, COMPONENT_ID, APPLICATION_ID, INBOUND, OUTBOUND, BRIDGED)
SELECT start_of_day, half_hour_col * 30, COMPONENT_ID, APPLICATION_ID, SUM(INBOUND), SUM(OUTBOUND), SUM(BRIDGED)
FROM MCP_ARRIVALS_HOUR s
INNER JOIN TimeComponents t ON t.minute_of_day = s.minute_of_day
WHERE :lastSumID < id AND id <= :curSeqID
GROUP BY start_of_day, half_hour_col, COMPONENT_ID, APPLICATION_ID
16:02:28.994 Debug CTIPRDRHL03 Reporting_Server GCTI-153-09900 com.gvp.rpt.summarization.dao.ArrivalSummarizationHelper Query for HOUR summarization:
INSERT INTO MCP_ARRIVALS_DAY (start_of_day, minute_of_day, COMPONENT_ID, APPLICATION_ID, INBOUND, OUTBOUND, BRIDGED)
SELECT start_of_day, hour_col * 60, COMPONENT_ID, APPLICATION_ID, SUM(INBOUND), SUM(OUTBOUND), SUM(BRIDGED)
FROM MCP_ARRIVALS_HOUR s
INNER JOIN TimeComponents t ON t.minute_of_day = s.minute_of_day
WHERE :lastSumID < id AND id <= :curSeqID
GROUP BY start_of_day, hour_col, COMPONENT_ID, APPLICATION_ID
16:02:28.994 Debug CTIPRDRHL03 Reporting_Server GCTI-153-09900 com.gvp.rpt.summarization.dao.ArrivalSummarizationHelper Query for DAY summarization:
INSERT INTO MCP_ARRIVALS_DAY (start_of_day, minute_of_day, COMPONENT_ID, APPLICATION_ID, INBOUND, OUTBOUND, BRIDGED)
SELECT start_of_day, 0, COMPONENT_ID, APPLICATION_ID, SUM(INBOUND), SUM(OUTBOUND), SUM(BRIDGED)
FROM MCP_ARRIVALS_HOUR s
WHERE :lastSumID < id AND id <= :curSeqID
GROUP BY start_of_day, COMPONENT_ID, APPLICATION_ID
16:02:28.994 Debug CTIPRDRHL03 Reporting_Server GCTI-153-09900 com.gvp.rpt.summarization.dao.ArrivalSummarizationHelper Query for WEEK summarization:
INSERT INTO MCP_ARRIVALS_DAY (start_of_day, minute_of_day, COMPONENT_ID, APPLICATION_ID, INBOUND, OUTBOUND, BRIDGED)
SELECT start_of_week, 0, COMPONENT_ID, APPLICATION_ID, SUM(INBOUND), SUM(OUTBOUND), SUM(BRIDGED)
FROM MCP_ARRIVALS_HOUR s
INNER JOIN DateComponents d ON d.start_of_day = s.start_of_day
WHERE :lastSumID < id AND id <= :curSeqID
GROUP BY start_of_week, COMPONENT_ID, APPLICATION_ID
16:02:28.994 Debug CTIPRDRHL03 Reporting_Server GCTI-153-09900 com.gvp.rpt.summarization.dao.ArrivalSummarizationHelper Query for MONTH summarization:
INSERT INTO MCP_ARRIVALS_DAY (start_of_day, minute_of_day, COMPONENT_ID, APPLICATION_ID, INBOUND, OUTBOUND, BRIDGED)
SELECT start_of_month, 0, COMPONENT_ID, APPLICATION_ID, SUM(INBOUND), SUM(OUTBOUND), SUM(BRIDGED)
FROM MCP_ARRIVALS_HOUR s
INNER JOIN DateComponents d ON d.start_of_day = s.start_of_day
WHERE :lastSumID < id AND id <= :curSeqID
GROUP BY start_of_month, COMPONENT_ID, APPLICATION_ID
16:02:28.995 Debug CTIPRDRHL03 Reporting_Server GCTI-153-09900 com.gvp.rpt.summarization.dao.ArrivalSummarizationHelper Query for THIRTY_MINUTES summarization:
INSERT INTO MCP_ARRIVALS_WEEK (start_of_day, minute_of_day, COMPONENT_ID, APPLICATION_ID, INBOUND, OUTBOUND, BRIDGED)
SELECT start_of_day, half_hour_col * 30, COMPONENT_ID, APPLICATION_ID, SUM(INBOUND), SUM(OUTBOUND), SUM(BRIDGED)
FROM MCP_ARRIVALS_DAY s
INNER JOIN TimeComponents t ON t.minute_of_day = s.minute_of_day
WHERE :lastSumID < id AND id <= :curSeqID
GROUP BY start_of_day, half_hour_col, COMPONENT_ID, APPLICATION_ID
16:02:28.995 Debug CTIPRDRHL03 Reporting_Server GCTI-153-09900 com.gvp.rpt.summarization.dao.ArrivalSummarizationHelper Query for HOUR summarization:
INSERT INTO MCP_ARRIVALS_WEEK (start_of_day, minute_of_day, COMPONENT_ID, APPLICATION_ID, INBOUND, OUTBOUND, BRIDGED)
SELECT start_of_day, hour_col * 60, COMPONENT_ID, APPLICATION_ID, SUM(INBOUND), SUM(OUTBOUND), SUM(BRIDGED)
FROM MCP_ARRIVALS_DAY s
INNER JOIN TimeComponents t ON t.minute_of_day = s.minute_of_day
WHERE :lastSumID < id AND id <= :curSeqID
GROUP BY start_of_day, hour_col, COMPONENT_ID, APPLICATION_ID
16:02:28.995 Debug CTIPRDRHL03 Reporting_Server GCTI-153-09900 com.gvp.rpt.summarization.dao.ArrivalSummarizationHelper Query for DAY summarization:
INSERT INTO MCP_ARRIVALS_WEEK (start_of_day, minute_of_day, COMPONENT_ID, APPLICATION_ID, INBOUND, OUTBOUND, BRIDGED)
SELECT start_of_day, 0, COMPONENT_ID, APPLICATION_ID, SUM(INBOUND), SUM(OUTBOUND), SUM(BRIDGED)
FROM MCP_ARRIVALS_DAY s
WHERE :lastSumID < id AND id <= :curSeqID
GROUP BY start_of_day, COMPONENT_ID, APPLICATION_ID
16:02:28.995 Debug CTIPRDRHL03 Reporting_Server GCTI-153-09900 com.gvp.rpt.summarization.dao.ArrivalSummarizationHelper Query for WEEK summarization:
INSERT INTO MCP_ARRIVALS_WEEK (start_of_day, minute_of_day, COMPONENT_ID, APPLICATION_ID, INBOUND, OUTBOUND, BRIDGED)
SELECT start_of_week, 0, COMPONENT_ID, APPLICATION_ID, SUM(INBOUND), SUM(OUTBOUND), SUM(BRIDGED)
FROM MCP_ARRIVALS_DAY s
INNER JOIN DateComponents d ON d.start_of_day = s.start_of_day
WHERE :lastSumID < id AND id <= :curSeqID
GROUP BY start_of_week, COMPONENT_ID, APPLICATION_ID
16:02:28.996 Debug CTIPRDRHL03 Reporting_Server GCTI-153-09900 com.gvp.rpt.summarization.dao.ArrivalSummarizationHelper Query for MONTH summarization:
INSERT INTO MCP_ARRIVALS_WEEK (start_of_day, minute_of_day, COMPONENT_ID, APPLICATION_ID, INBOUND, OUTBOUND, BRIDGED)
SELECT start_of_month, 0, COMPONENT_ID, APPLICATION_ID, SUM(INBOUND), SUM(OUTBOUND), SUM(BRIDGED)
FROM MCP_ARRIVALS_DAY s
INNER JOIN DateComponents d ON d.start_of_day = s.start_of_day
WHERE :lastSumID < id AND id <= :curSeqID
GROUP BY start_of_month, COMPONENT_ID, APPLICATION_ID
16:02:28.996 Debug CTIPRDRHL03 Reporting_Server GCTI-153-09900 com.gvp.rpt.summarization.dao.ArrivalSummarizationHelper Query for THIRTY_MINUTES summarization:
INSERT INTO MCP_ARRIVALS_MONTH (start_of_day, minute_of_day, COMPONENT_ID, APPLICATION_ID, INBOUND, OUTBOUND, BRIDGED)
SELECT start_of_day, half_hour_col * 30, COMPONENT_ID, APPLICATION_ID, SUM(INBOUND), SUM(OUTBOUND), SUM(BRIDGED)
FROM MCP_ARRIVALS_DAY s
INNER JOIN TimeComponents t ON t.minute_of_day = s.minute_of_day
WHERE :lastSumID < id AND id <= :curSeqID
GROUP BY start_of_day, half_hour_col, COMPONENT_ID, APPLICATION_ID
16:02:28.996 Debug CTIPRDRHL03 Reporting_Server GCTI-153-09900 com.gvp.rpt.summarization.dao.ArrivalSummarizationHelper Query for HOUR summarization:
INSERT INTO MCP_ARRIVALS_MONTH (start_of_day, minute_of_day, COMPONENT_ID, APPLICATION_ID, INBOUND, OUTBOUND, BRIDGED)
SELECT start_of_day, hour_col * 60, COMPONENT_ID, APPLICATION_ID, SUM(INBOUND), SUM(OUTBOUND), SUM(BRIDGED)
FROM MCP_ARRIVALS_DAY s
INNER JOIN TimeComponents t ON t.minute_of_day = s.minute_of_day
WHERE :lastSumID < id AND id <= :curSeqID
GROUP BY start_of_day, hour_col, COMPONENT_ID, APPLICATION_ID
16:02:28.996 Debug CTIPRDRHL03 Reporting_Server GCTI-153-09900 com.gvp.rpt.summarization.dao.ArrivalSummarizationHelper Query for DAY summarization:
INSERT INTO MCP_ARRIVALS_MONTH (start_of_day, minute_of_day, COMPONENT_ID, APPLICATION_ID, INBOUND, OUTBOUND, BRIDGED)
SELECT start_of_day, 0, COMPONENT_ID, APPLICATION_ID, SUM(INBOUND), SUM(OUTBOUND), SUM(BRIDGED)
FROM MCP_ARRIVALS_DAY s
WHERE :lastSumID < id AND id <= :curSeqID
GROUP BY start_of_day, COMPONENT_ID, APPLICATION_ID
16:02:28.997 Debug CTIPRDRHL03 Reporting_Server GCTI-153-09900 com.gvp.rpt.summarization.dao.ArrivalSummarizationHelper Query for WEEK summarization:
INSERT INTO MCP_ARRIVALS_MONTH (start_of_day, minute_of_day, COMPONENT_ID, APPLICATION_ID, INBOUND, OUTBOUND, BRIDGED)
SELECT start_of_week, 0, COMPONENT_ID, APPLICATION_ID, SUM(INBOUND), SUM(OUTBOUND), SUM(BRIDGED)
FROM MCP_ARRIVALS_DAY s
