Hi all - have come across something interesting. I have noticed an intermittent problem where on completion of load,aggregate and maintain GIM, data for agent login/logout only shows up until a certain point for the previous day (as an example, up to 1pm). However, when the following night's load, aggregate and maintain runs, the data for the previous day is fully complete (ie. beyond 1pm). I thought this might be something to do with 'limit-extract-data' being set to 'TRUE' but then again, I have seen release notes indicating improved Extract ICON performance in 7.6 releases. When I see the problem, ETL jobs are not failing so am wondering if anyone has any ideas? I don't have a recent example with logs etc so hopefully it's probably just a configuration issue.
This is what the config file looks like for GIM ETL:
[enterprise-fiscal-periods]
first-day-of-week=MONDAY
last-day-identifies-year=TRUE
last-day-of-last-month=31
last-month-of-year=DECEMBER
week-pattern-in-quarter=544
[gim-aggregates-tenant]
maximum-aggregation-level=MONTH
populate-agent-state-aggregates=TRUE
populate-skill-combination-aggregates=TRUE
populate-skill-demand-aggregates=TRUE
[gim-agg-skill-abandon-tenant]
abandon-duration-range-1-thold=15
abandon-duration-range-2-thold=30
abandon-duration-range-3-thold=60
[gim-agg-skill-inb-ixn-tenant]
init-resp-duration-range-1-thold=15
init-resp-duration-range-2-thold=30
init-resp-duration-range-3-thold=60
[gim-etl]
days-to-keep-deleted-tenant-facts=760
days-to-keep-stg-ha-ir-ids=3
extract-data-time-range-limit=1
extract-data-time-range-units=DAYS
ir-merge-interval=0
limit-extract-data=TRUE
max-camp-group-session-duration-in-hours=168
max-camp-group-state-duration-in-hours=168
max-session-duration-in-hours=24
max-wrap-delay=5
memory-threshold=0
populate-chat-ixns=FALSE
populate-chat-resource-activity=FALSE
populate-email-ixns=FALSE
populate-email-resource-activity=FALSE
populate-ocs-ixns=FALSE
purge-action-is-delete=TRUE
q-answer-threshold-voice=30
q-short-abandoned-threshold-voice=30
short-abandon-threshold=10
std-enterprise-time-zone=AET
[gim-etl-tenant]
days-to-keep-gim-facts=760
std-tenant-time-zone=AET
[gim-transformation]
show-abandoned-detail=FALSE
show-conference-detail=TRUE
transformation-buffer-size=3
voice-init-resp-duration=TIME_TO_FIRST_AGENT
[ixn-user-data-facts]
user-data-1=LAST
user-data-10=LAST
user-data-11=LAST
user-data-12=LAST
user-data-13=LAST
user-data-14=LAST
user-data-15=LAST
user-data-16=LAST
user-data-17=LAST
user-data-18=LAST
user-data-19=LAST
user-data-2=LAST
user-data-20=LAST
user-data-3=LAST
user-data-4=LAST
user-data-5=LAST
user-data-6=LAST
user-data-7=LAST
user-data-8=LAST
user-data-9=LAST
[log]
all=e:\Logs\gim\gimetl.log
expire=50
segment=10000
standard=stdout
verbose=all
[log4j]
log-file-name=gim_etl.log
logging-level=info
max-backup-index=10
max-log-file-size=5MB
[optional-tables]
populate-gvp-var-facts=FALSE
populate-place-group-facts=TRUE
populate-resource-group-facts=TRUE
populate-resource-session-facts=TRUE
populate-resource-skill-facts=TRUE
populate-resource-state-facts=TRUE
populate-resource-state-reason-facts=TRUE
populate-virtual-queue-facts=TRUE
[schedule]
aggregate-start-time=01:00
etl-end-time=22:00
etl-frequency=60
etl-start-time=06:00
load-recent-start-time=22:15
load-start-time=23:15
maintain-start-time=03:00
max-concurrent-extract-jobs=10
populate-intraday-aggregates=TRUE
run-aggregates=TRUE
run-load-recent-with-extract-and-transform=TRUE
run-maintain=TRUE
run-scheduler=true
[tenant-fiscal-periods]
first-day-of-week=MONDAY
last-day-identifies-year=TRUE
last-day-of-last-month=31
last-month-of-year=DECEMBER
week-pattern-in-quarter=544
