Why do we see data that uses session_summary table in reports older than 1 day?

Environment:

All Oracle B2C Service versions

Resolution:

If you see that the report "Questions Avoided" or any other report using the session_summary database table is showing data that is older than 1 day you might follow the below steps:

1. Please check the Run Time of the agedatabase utility using Site Tools > Utility Stats after logging into the below link:

https://cx.rightnow.com/ > Site Tools > Utility Stats > agedatabase > Run Time

2. If you see that the utility runs before midnight compared to your timezone, please create a service request with Oracle B2C Service Technical Support

Cause:

Oracle B2C Service Technical Support can change the run time of the agedatabase utility in order to run later in the evening and prevent data from being displayed in reports for more than 1 day.