Release Notes

Release Notes

 
Customer Science releases regular updates to our Genesys Adapter and associated CXiaaS offerings.

Please review to understand our current releases:
September 2026

September 2026

Version v3.62.1 - September 15, 2026

2026-09-15

New Features

  • Maintain interaction legs as a table rebuilt per day: introduces a daily-maintained interaction legs table and build process to avoid expensive single-statement refreshes, improving installation reliability and reducing service disruption. (PR #1264)

Improvements

  • Add Genesys data model lookup recipes: provides documented lookup recipes to verify payload shapes, field names, and enum values against primary sources to simplify troubleshooting and model validation. (PR #1374)

Bug Fixes

  • Normalize queue state start timestamps as UTC: fixes queue wait time reporting when external timestamps lacked timezone information so wait times are accurate across timezones. (PR #1278)
  • Queue voice analysis fallback at retry limit: allow fallback processing when realtime voice analysis exhausts retries to avoid permanent failures and improve resilience. (PR #1548)
  • Keep license assignment history as intervals and mark removals: record license assignments as intervals and mark removals so licensing views reflect current state and avoid overcounting. (PR #1529)
  • Parse contact list exports correctly and stop deleting on partial exports: improve import accuracy by handling quoted fields, embedded line breaks, and partial exports to prevent unintended deletions. (PR #1512)

Schema Changes

Table NameChangesAddedUpdatedRemoved
interactionlegdata+ new table - 44 columns - primary key (interactionid, conversationstartdate) *conversationstartdate was changed: monthly partitioning on PostgreSQL to support per-day rebuilds and reduce full-refresh impact.
subuserlicensedata+ new column licenseremovaldate - removed username - removed email - removed divisionid *First seen was changed: assignments are now stored as intervals and removals recorded with licenseremovaldate so history is preserved and overcounting is avoided.
mvwInteractionLegData- removed materialized view *existing_object was changed: removed to prevent expensive full-instance refreshes during installs and replaced by the maintained table approach.

Customer Summary

This release improves data reliability and accuracy across the system: interaction leg data is now rebuilt daily to avoid heavy full-refresh operations, licensing records now track assignment intervals and removals so counts are correct, real-time queue timings and voice analysis behavior have been fixed to report accurate wait times and avoid permanent failures, and contact list imports plus documentation have been enhanced to reduce parsing errors and ease troubleshooting.

August 2026

August 2026

Version v3.62.0 - August 25, 2026

2026-08-25

New Features

    Improvements

      Bug Fixes

      • Ensures database installation steps and fallback checks run in sequence to prevent concurrency issues and improve setup reliability. (PR 1252)

      Schema Changes

      Table NameChangesAddedUpdatedRemoved

      Customer Summary

      This release fixes a setup issue that could affect database installation by ensuring setup steps and fallback checks run in order, making installations more reliable and reducing the chance of setup failures.

      Version v3.61.3 - August 24, 2026

      2026-08-21

      New Features

      • Added realtime monitor health scoring and restart control to calculate service health percentages and coordinate automatic restarts for services below thresholds, with separate scoring for media types, business-hours suppression, operator-facing restart controls, and dashboard views for monitoring. (PR 1066)

      Improvements

        Bug Fixes

        • Fixed evaluation discovery and mapping synchronization so evaluations are retrieved by multiple identifiers, missing payloads are handled gracefully, and mapping lookups are performed more efficiently to improve sync reliability. (PR 1067)
        • Fixed presence synchronization and install behavior to avoid blocking installations, recover from detailed row errors, and reset sync after schema drift to improve stability and install reliability. (PR 1103)

        Schema Changes

        Table NameChangesAddedUpdatedRemoved
        PresenceDetailavoid blocking Postgres installs on presence data; fail on detailed presence row errors; reset PresenceDetail sync after schema drift.

        Customer Summary

        This release introduces real-time health monitoring with automatic restart controls and new dashboards to help operators monitor and recover unhealthy services, improves evaluation synchronization reliability, and fixes presence synchronization issues that could block installations or cause sync problems.

        Version v3.61.2 - August 8, 2026

        2026-08-08

        New Features

        • Uplifted ParticipantAttributes rate limiting and published guidance on service limits so attribute syncs can run at higher throughput while avoiding spurious throttling (PR 890).
        • Added AWS Secrets Manager support to source client and database credentials with strict validation so deployments can centrally manage secrets and fail fast on misconfiguration (PR 937).
        • Added Azure Key Vault credential sourcing with an AWS-to-Azure federation option so deployments can use either cloud secret stores with clear authentication modes and safe startup validation (PR 974).
        • Added per-leg interaction metrics and a performance-optimized interaction-leg view to provide finer-grained timing and routing data with a faster, validated implementation (PR 972).
        • Added new detail fields across user, presence, queue, management-unit, division, and business-unit tables and views so more contextual data is available in reports and dashboards (PR 950).
        • Added participant summary subject capture and related protections to make participant-level context available for downstream reporting (PR 998).

        Improvements

        • Improved job and query parallelism and introduced safer limited schema migration so ingestion is faster, more resilient to timeouts, and recovers more cleanly from transient failures (PR 858).
        • Prevented silent participant attribute data loss and simplified polling/dedup logic so interaction syncs preserve richer attributes and run more efficiently (PR 798).
        • Unified the WFM schedule watermark with the standard job pattern and added diagnostics to make schedule backfills and troubleshooting more reliable (PR 797).
        • Improved data sanitization and realtime presence synchronization to reduce lost updates, preserve in-memory row state during bulk saves, and lower exception noise (PR 859).
        • Migrated console logging to structured ILogger and added progress telemetry so long-running jobs produce reliable, searchable logs and clearer progress indicators (PR 866).
        • Uplifted the database interaction layer to improve bulk-write behavior, schema cache handling, and interaction-diff correctness, reducing false-positive diffs and improving write reliability (PR 887).

        Bug Fixes

        • Fixed missing agents in After Call Work (ACW) by preserving ACW state, deferring cleanup, and adding targeted forensic logs so agent ACW status now persists correctly (PR 908).
        • Resolved primary key and dynamic-column creation errors by adding existence checks, retrying schema-sensitive writes, and improving bulk-write retries to prevent install- and runtime failures (PR 954).
        • Hardened MSSQL retry behavior to avoid returning partial results on failure and increased the install SQL timeout so large installs and migrations complete reliably (PR 891).
        • Fixed adherence lookups across daylight saving transitions so queries no longer reprocess or skip data at DST boundaries, reducing duplicate or missed adherence records (PR 812).
        • Distinguished division-permission errors from general API permission gaps so scoped syncs fail with clearer causes and avoid masking permission problems (PR 992).
        • Corrected queue-time calculation to compute wait time at the interaction-leg level with sensible fallbacks so reported queue times are accurate when interactions revisit queues (PR 999).

        Schema Changes

        Table NameChangesAddedUpdatedRemoved
        userinteractionpresencedetaileddata+ organizationpresenceid - datatype
        userpresencedetaileddata+ organizationpresenceid - datatype
        vwInteractionLegData+ ani, dnis, alert_time, handle_time, wrapupcode, wrapupname, disconnectiontype, per-leg timing metrics, consult_count, transfer_count, queueid, userid, divisionid, remotedisplayable, externaltag, recordingexists - datatype
        vwInteractionLegDataV2+ same 43 columns plus conversationstartdate - datatype (new performance-optimized view)
        userDetails+ acd_auto_answer_flag - datatype
        queueDetails+ member_count_fields - datatype
        muDetails+ division_fields - datatype
        divisionDetails+ division_description - datatype
        buDetails+ business_unit_division - datatype
        participantattributesdynamic*dynamic columns were changed: source now adds dynamic columns only when observed to prevent DBNull overwrites and schema cache invalidation triggers when columns are added

        Customer Summary

        This release improves reliability and performance across data ingestion, realtime updates and reporting. It increases throughput for high-volume attribute syncs while adding safer secret-management options, adds richer per-interaction fields for reports, and fixes issues that could lose or misreport data. Operational logging and diagnostics have been strengthened so incidents are easier to investigate. Customers should see more accurate reporting and more stable syncs without configuration changes.

        July 2026

        July 2026

        Version v3.61.1 - July 30, 2026

        2026-07-28

        New Features

          Improvements

            Bug Fixes

            • Fixed division permission error handling to distinguish division-specific permission errors from general API permission gaps, so users receive clearer and more actionable error messages (PR #992).

            Schema Changes

            Table NameChangesAddedUpdatedRemoved

            Customer Summary

            This release improves error reporting when access to division data is restricted. Users will see clearer messages that indicate whether a permission issue is specific to a division or affects broader access, reducing confusion and support time.

            Version v3.61.0 - July 23, 2026

            2026-07-23

            New Features

              Improvements

              • Eval Performance Uplift: Improved evaluation sync retrieval and persistence to make data syncing faster and more reliable. (PR #990)

              Bug Fixes

              • Eval Performance Uplift: Fixed evaluation changed-date persistence to ensure safe prefiltering and more accurate incremental updates. (PR #990)
              • Merge division permissions pass: Prevented scoped synchronizations from failing when division-level permissions block all data, improving sync resilience. (PR #989)
              • Merge division permissions pass: Corrected the catch-up agent's read filter to ensure evaluation data is properly retrieved during backfill. (PR #989)

              Schema Changes

              Table NameChangesAddedUpdatedRemoved

              Customer Summary

              This release improves the speed and reliability of evaluation data syncing, reduces the chance of failed synchronizations caused by permission settings, and fixes catch-up filtering so historical data backfills complete correctly. Users should see faster, more reliable syncs and fewer missed updates.

              Version v3.60.9 - July 14, 2026

              2026-07-14

              New Features

              • Per-leg interaction metrics: Adds detailed per-leg metric columns (ANI/DNIS, alert and handle times, wrap-up codes and names, disconnection type, queue and agent identifiers, recording flag, consult/transfer counts, and a set of per-leg timing metrics) to enable more granular leg-level analysis and reporting. (PR #972)
              • vwInteractionLegDataV2: Introduces a performance-optimized, compatible sibling view that preserves the original output contract while adding a UTC conversation start timestamp to improve query performance and partition pruning. (PR #972)
              • vwUserRoutingStatusDetailedData: Adds a dedicated routing status view that separates routing status periods from presence data to make routing-state reporting clearer and easier to consume. (PR #972)

              Improvements

              • Performance optimization: Reworked the interaction-leg data implementation to scan detailed interaction records once, resolve names once per leg, and push predicates into partitions so common queries run faster and use fewer resources. (PR #972)
              • Materialized snapshot and index handling: Rebuilt the materialized interaction-leg snapshot on install and introduced a unique interaction identifier index to improve refresh reliability and concurrency. (PR #972)
              • Verification and robustness: Completed dialect and equivalence reviews and improved handling of malformed leg data so queries are more robust and produce consistent results. (PR #972)

              Bug Fixes

              • Callback guard: Ensures callback legs are isolated so nested dial-out sessions are not double counted and talk time is reported accurately. (PR #972)

              Schema Changes

              Table NameChangesAddedUpdatedRemoved
              vwInteractionLegDataAdded numerous per-leg metric columns to support finer-grained leg-level reporting.
              vwInteractionLegDataV2Appended a UTC conversation start timestamp to the V2 output to enable partition-friendly predicates and maintain compatibility with existing consumers.
              mvwInteractionLegDataRebuilt materialized snapshot on install and added a unique interactionid index to improve refresh behavior and concurrency.

              Version v3.60.8 - July 7, 2026

              New Features

                Improvements

                  Bug Fixes

                  • Added an organization presence identifier to the interaction presence schema to ensure interactions are correctly associated with their organization and to improve data consistency during upgrades. (PR #964)

                  Schema Changes

                  Table NameChangesAddedUpdatedRemoved
                  userinteractionpresencedetaileddataAdded organizationpresenceid column (datatype unknown)

                  Customer Summary

                  This release adds an organization identifier to interaction presence records so interactions are correctly linked to their organizations, improving data accuracy and reliability during upgrades.

                  June 2026

                  June 2026

                  Version v3.60.7 - June 28, 2026

                  2026-06-26

                  New Features

                  • Source credentials from AWS Secrets Manager: allow a single flat secret to supply the Genesys client secret and database password with strict validation to simplify secure, auditable credential management and reduce startup surprises (PR 937).
                  • VCC view field updates: added multiple new fields to several detail tables and their corresponding views so more relevant contact center data is available consistently across database platforms (PR 950).

                  Improvements

                    Bug Fixes

                    • Bug fix patch: resolved primary key constraint violations and invalid SQL column naming, added checks to prevent duplicate dynamic column creation, fixed schema visibility issues, and implemented retry strategies to make bulk schema updates more reliable (PR 954).

                    Schema Changes

                    Table NameChangesAddedUpdatedRemoved
                    userDetailsACD auto-answer flag added
                    userPresenceDetailedDataorganization presence id added
                    queueDetailsmember count fields added
                    muDetailsdivision fields added
                    divisionDetailsdivision description added
                    buDetailsbusiness unit division added

                    Customer Summary

                    This release adds support for sourcing sensitive credentials from AWS Secrets Manager to simplify secure configuration, updates multiple data views so more contact center details are available consistently across databases, and fixes reliability issues that could cause schema or column errors during updates. These changes make configuration safer and reduce the chance of update-related failures; most customers will see improved stability and more usable data in reports. If you enable Secrets Manager, follow the provided runbook steps to migrate safely.

                    Version v3.60.6 - June 10, 2026

                    2026-06-10

                    New Features

                      Improvements

                      • Encapsulate dynamic attribute diff helper to reduce exposure and improve code organization, preserving existing behavior while making future maintenance easier (PR #934)

                      Bug Fixes

                      • Harden MSSQL query retry handling to prevent incomplete results from being returned and increase installation SQL timeout to reduce failures on large installs (PR #891)

                      Schema Changes

                      Table NameChangesAddedUpdatedRemoved

                      Customer Summary

                      This release fixes an issue that could cause incomplete database results to be used and increases the timeout for database installs to improve reliability on large deployments. It also reorganizes internal attribute-diffing code to improve maintainability without changing behavior. These updates reduce the chance of incorrect data and make future fixes easier.

                      May 2026

                      May 2026

                      Version v3.60.5 - May 27, 2026

                      2026-05-27

                      New Features

                      • Increase throughput for high-volume participant attribute processing to reduce rate-limit-related interruptions and improve interaction data reliability; includes documentation on Genesys Cloud rate limits to guide correct retry and token handling. (PR #890)

                      Improvements

                      • Remove an unreachable duplicate-detection routine and simplify interaction sync to reduce complexity and improve maintainability. (PR #890)
                      • Add documentation describing rate-limit semantics and diagnostics to help operators troubleshoot and configure retry behavior. (PR #890)

                      Bug Fixes

                      • ACW missing agents investigation and fixes: preserve After Call Work (ACW) status when external systems report unknown states to prevent spurious clearing of agents' ACW. (PR #908)
                      • ACW missing agents investigation and fixes: defer removal of disconnected rows and protect active ACW rows from cross-service cleanup so multi-agent conversations no longer lose agents' ACW status. (PR #908)
                      • ACW missing agents investigation and fixes: add forensic instrumentation and reduce log noise to make it easier to detect and prevent state loss. (PR #908)

                      Schema Changes

                      Table NameChangesAddedUpdatedRemoved

                      Customer Summary

                      This release increases throughput for high-volume participant data processing and adds clear documentation on rate limits to reduce interruptions. It fixes situations where agents could unexpectedly lose After Call Work (ACW) status, including multi-agent scenarios, and adds better diagnostic logging to help detect and prevent state loss. The update also removes unreachable legacy detection code to simplify and stabilize interaction processing.

                      April 2026

                      April 2026

                      Version v3.60.2 - April 23, 2026

                      New Features

                      • None.

                      Improvements

                      • Logging during adherence processing is clearer, making it easier to understand what happened.
                      • Start and end dates are normalized and timezone offsets are applied safely to avoid incorrect date ranges.
                      • The system uses the actual processed query end as the new synchronization watermark when processing ends early, improving data accuracy.
                      • The sync watermark will not move backwards, reducing repeated or missing data processing.

                      Bug Fixes

                      • Fixed handling of daylight saving time transitions so adherence lookups are not duplicated or missed.
                      • Detects previously processed daylight saving boundaries and clamps the query start to avoid reprocessing across a DST change.

                      Schema Changes

                      None.

                      Version v3.60.1 - April 17, 2026

                      New Features

                      • None in this release.

                      Improvements

                      • Interaction job performance improved by always diffing before write and reducing unnecessary merges.
                      • Polling and dedup logic simplified for more reliable and efficient processing.
                      • WFM schedule ingestion now uses a standard query window and includes better diagnostics for missing results.
                      • Adherence processing is faster and more correct by using DataTable primary-key lookups and helper methods.
                      • Channel unsubscription no longer leaks network resources and now uses structured logging.
                      • Install timeout increased to support large schema migrations.

                      Bug Fixes

                      • Prevented participant attribute values from being overwritten by incomplete interaction job reruns, preserving existing attributes when new data omits them.
                      • Fixed WFM schedule backfill iteration so it no longer generates a final zero-length request.
                      • Updated MSSQL grant script to resolve procedure schema dynamically to avoid permission or resolution errors.

                      Schema Changes

                      No schema column changes in this release.

                      Version v3.60.0 - April 2, 2026

                      New Features

                      • Added realtime voice processing infrastructure and a dedicated voice-analysis worker to support reliable, scalable live voice analytics.
                      • Added KnowledgeQuest receiver functionality with secure SSL/TLS support for ingesting knowledge payloads.
                      • Introduced Copilot V2 analytics, knowledge aggregates, per-user license tracking, and multiple new data tables to capture Copilot and knowledge usage.
                      • Added Archive job handling to better manage and offload historical data syncs.
                      • Added detailed OAuth usage collection and a new detailed OAuth usage table for richer API usage reporting.
                      • Enabled installer support for parameterized cron job installation to simplify shared-cron deployment.

                      Improvements

                      • Improved queue observability and added a memory-backed queue repository to reduce processing delays and make troubleshooting easier.
                      • Reduced logging noise and streamlined messages for clearer observability while preserving important diagnostics.
                      • Improved resilience for queue member retrieval with retries, token refresh, and progress reporting to reduce transient failures.
                      • Improved database and install robustness: explicit DB timeouts for cleanup operations, better permission error handling, and fixes to MSSQL/Postgres/Snowflake migrations.
                      • Improved performance by adding targeted indexes and enhancing database indexing for dashboards and common queries.
                      • Enhanced realtime health checks and conversation handling to detect partial disconnections and avoid stuck conversations.
                      • Made interaction data more flexible by removing MaxLength truncation for participant attributes and making query overlap configurable.
                      • Fixed adaptive polling for OAuth usage and replaced it with a fixed 30s polling interval to reliably wait for report generation.

                      Bug Fixes

                      • Fixed token-refresh conflicts and rate-limit handling to prevent intermittent failures in realtime and API calls.
                      • Resolved cold-start locking issues so startup operations no longer hold locks during external API calls and persist cold-start data immediately.
                      • Fixed multiple SQL and migration errors across dialects, including DATEDIFF conversion issues on Postgres and improved handling for large migrations.
                      • Fixed typos and backward compatibility for the eval details column (renamed 'quesiontype' to 'questiontype' and added compatibility aliases).
                      • Prevented duplicate key violations in voice analytics by improving primary-key checks and deduplication logic.
                      • Restored accidentally removed code paths (GetOauthUsageDetailed) and fixed unreachable backoff delays so retries now wait as expected.

                      Schema Changes

                      TableColumnCustomer Benefit
                      subscriptionkeyidIncreased key length so longer external identifiers are stored reliably for customers.
                      suboverviewkeyidIncreased key length so longer external identifiers are stored reliably for customers.
                      evaldetailsquestiontypeCorrected misspelling and added backward-compatible alias so existing queries continue to work and data is consistent.
                      evaldetailsmanuallycheckedAdded a manual-checked flag so customers can track human review status.
                      intentslotvalue(column size)Expanded column size so larger bot slot values are preserved without truncation.
                      participantAttributesDynamicattribute_valueChanged to unlimited text so participant attribute values are no longer truncated.
                      detailedInteractionDatanConversationsProvides counts of conversations per record for richer reporting.
                      participantSummaryDatanConversationsProvides counts of conversations per participant for richer reporting.
                      planninggroupdetailsbusinessunitidAdded businessUnitId and widened the planning group key so identifiers tied to business units store fully and avoid truncation.
                      evalnameWidened name columns to avoid failures for long evaluation and group names.
                      oauthusagedetaileddata(new table)Added detailed OAuth usage data so customers get per-endpoint/method usage reporting for auditing and cost control.
                      agentcopilotaggregatesdata(new table)Captures agent Copilot analytics for usage and performance insights.
                      knowledgeaggregatesdata(new table)Records knowledge-base analytics for content and usage insights.
                      knowledgedocumentfeedbackdata(new table)Tracks document feedback so customers can improve knowledge document quality.
                      subuserlicensedata(new table)Enables per-user license tracking so license usage can be analyzed at the individual level.
                      convvoicesummarydata(new table)Provides summarized voice analytics for conversations so customers get quick conversation-level insights.
                      knowledgebasedocumentvariation(new table)Tracks document variations to help manage versions and usage of knowledge documents.
                      summaryrating(type change)Changed from integer to text so rating labels and varied formats are preserved.
                      March 2026

                      March 2026

                      Version v3.59.0 - March 19, 2026

                      New Features

                      • Adds detailed OAuth usage collection and storage so we can report endpoint and method-level API usage.

                      Improvements

                      • Improved documentation comments for views to make data explanations clearer.
                      • Made copilot schema migrations safer and made views more defensive to reduce deployment failures.
                      • Extended OAuth usage collection to cover from the offset month through today so recent usage is included.
                      • Improved realtime conversation health-check strategy to reduce stuck conversations and control API load.
                      • Added exponential backoff and warning logs to 5xx retry logic so transient server errors are retried with delays.

                      Bug Fixes

                      • Disabled a broken CI pipeline endpoint so the CI runs successfully.
                      • Restored the GetOauthUsageDetailed method that was accidentally removed so builds succeed and detailed data is collected.
                      • Increased planning group key length and fixed related views to prevent key truncation and broken joins; made exception logging null-safe.
                      • Fixed Snowflake date formatting that caused installs to fail.

                      Schema Changes

                      • planninggroupdetails | businessUnitId: Adds a business unit identifier so planning group records are correctly associated with the customer's business unit and prevent mis-association.
                      • planninggroupdetails | planningGroupCompositeKey: Increased the composite key length to 255 characters to prevent key truncation when the key includes businessUnitId, planningGroupId, queueId and mediaType.
                      • oauthusagedetaileddata | composite_key: Added a composite key column for the new oauthusagedetaileddata table so detailed OAuth usage can be stored and queried efficiently.
                      • dimension_date | iso_week: Reworked ISO week string generation so date values fit the column width and installs succeed on Snowflake.

                      Customer Summary

                      This release improves reporting and reliability: you will get more detailed OAuth usage metrics, fewer transient failures due to smarter retries, and more reliable deployments and installs thanks to schema fixes and safer migrations.

                      Detailed Customer Summary

                      • Added detailed OAuth usage collection so you can see API usage broken down by client, endpoint and method.
                      • Extended the OAuth usage date range to include data up to today so recent activity is not missed.
                      • Restored the detailed OAuth method that was accidentally removed so detailed reporting works and builds succeed.
                      • Added exponential backoff and retry warnings so transient server errors are handled more reliably and jobs recover instead of failing.
                      • Disabled a broken CI endpoint so continuous integration runs reliably again.
                      • Fixed Snowflake ISO week formatting so database installs no longer fail due to unexpected string lengths.
                      • Added businessUnitId to planning group details so records are properly scoped by business unit.
                      • Widened the planning group composite key to prevent truncation and ensure joins work correctly.
                      • Improved the realtime conversation health-check so stuck conversations are detected and cleared more effectively while keeping API usage under control.
                      • Improved view comments and made copilot migrations safer to reduce deployment surprises and make schema changes more robust.
                      • Made exception logging null-safe to avoid runtime errors during error reporting.
                      February 2026

                      February 2026

                      Version v3.58.2 - February 23, 2026

                      New Features

                      • Processing windows now follow the configured aggregation interval and new TimeGranularity helpers were added to make time-based processing more consistent.

                      Improvements

                      • GetBotReportingTurnsAsync now includes the DIGITALBOT flow type so bot interactions are more fully captured.
                      • Real-time user jobs were improved so agent conversation data is reflected correctly in real time.
                      • Schedule processing was improved and now includes scheduleid in time-off data and a new view combining schedule and time-off information to present a complete agent schedule.
                      • Added dependency and transcription checks and capped voice sync to improve stability of voice data ingestion.
                      • Added retry/backoff and failed-flow tracking for bot reporting to improve reliability.
                      • Sync log messages now show full timestamps so log entries reflect the actual sync windows.

                      Bug Fixes

                      • Fixed the datediff function to ensure it returns correct values.
                      • Clamped the aggregation sync watermark to the database maximum when no rows are written to avoid skipping sub-hour intervals.
                      • Preserved multiple bot reporting turns by diffing on per-turn ids to avoid losing multi-turn bot interactions.
                      • Switched to Microsoft.Data.SqlClient to avoid InvalidCastException when creating commands.
                      • Fixed issues to prevent duplicate key constraint violations in voice analytics and improved primary key handling and deduplication.
                      • Improved permission error handling for outbound data retrieval methods.
                      • Enhanced job execution logic to handle aliases and prevent duplicate runs.

                      Schema Changes

                      • EvalDetails | quesiontype: Added a backward-compatible computed alias so older reports and integrations that use the previous column name continue to work without changes.
                      • TimeOffData | scheduleid: Added scheduleid to time-off records so schedules and time-off entries can be linked, giving a complete view of agent schedules.

                      Customer Summary

                      This release improves data accuracy and reliability across reporting and real-time views, makes deployments easier with a Portainer Docker Compose template, and provides better schedule and voice data stability. You will see fewer missed records, clearer logs for troubleshooting, and continued compatibility with older reports.

                      Detailed Customer Summary

                      • Processing windows and TimeGranularity helpers: Aggregated time-based reports are now aligned to configured intervals so counts and metrics are more consistent and predictable.
                      • Portainer Docker Compose template: Easier deployment and local management of services reduces setup time and operational friction.
                      • Dependency and transcription checks; capped voice sync: Voice data ingestion is more robust and protected from overload, reducing missing or partial voice records.
                      • Bot reporting retry/backoff and failed-flow tracking: Bot interaction reporting is more reliable and will recover better from transient failures.
                      • Preserve multiple bot reporting turns: Multi-turn bot conversations are retained in reports so you no longer lose parts of a conversation.
                      • Include DIGITALBOT in bot queries: More bot interactions are captured so reporting is more complete.
                      • Fixed datediff: Date calculations are correct so time-based metrics and windows are accurate.
                      • Clamped aggregation watermark: Short or empty intervals won't be skipped, giving more continuous and accurate aggregation.
                      • Real-time user uplift: Agent conversations display accurately in real time so dashboards and monitoring reflect true activity.
                      • Schedule improvements: Time-off records now include schedule links and a combined schedule view gives a complete picture of agent availability.
                      • Clearer sync timestamps in logs: Troubleshooting and audit of sync windows is now easier with exact timestamps.
                      • Database and job reliability fixes: Underlying fixes reduce runtime errors, duplicate-key failures, and permission issues, improving overall system stability.

                      Version v3.58.1 - February 11, 2026

                      New Features

                      • No new features in this release.

                      Improvements

                      • Bot reporting now includes DIGITALBOT flow type so automated bot interactions are counted in reports.
                      • Schedule data capture has been improved and now combines schedule and time-off records so agent schedules are more complete and easier to reconcile.

                      Bug Fixes

                      • Fixed the datediff function so it returns the correct result and now accepts text input where appropriate.
                      • Real-time user jobs fixed so agents' conversation data appears correctly in real time dashboards.
                      • Multiple post-release fixes to improve database command handling, SQL compatibility, deduplication and primary key handling for voice analysis, topic import stability, permission error handling, and job execution reliability.
                      • Applied additional February bug fixes to improve overall stability.

                      Schema Changes

                      • timeoffdata | scheduleid: time-off records now include schedule IDs so agent time-off can be linked to schedules more reliably.
                      • evalDetails | quesiontype: added a compatibility column so older references to the misspelled 'quesiontype' continue to work and reports remain stable.

                      Customer Summary

                      This release improves the accuracy and completeness of reporting and scheduling, fixes multiple data- and database-related errors, and adds compatibility for older evaluation fields so your reports and dashboards are more reliable.

                      Detailed Customer Summary

                      • Fixed calculation errors in date difference functions so time-based reports are accurate and text inputs are supported.
                      • Bot reporting now includes DIGITALBOT interactions so automated conversations are included in reports.
                      • Real-time jobs now include agents' conversation data so live dashboards reflect current activity.
                      • Schedule and time-off data are combined and schedule IDs are captured so agent schedules are complete and easier to reconcile.
                      • Database command handling updated to avoid command creation errors, reducing failures when running database operations.
                      • SQL syntax updated for boolean columns so queries run consistently on Microsoft SQL servers.
                      • Voice analysis deduplication improved to prevent duplicate entries and ensure reliable analytics.
                      • Topic-import logic now checks for existing keys to avoid duplicate-key errors.
                      • Permission error handling improved so data retrieval failures are clearer and more recoverable.
                      • Background job logic improved to avoid duplicate task runs and handle aliases correctly.
                      • Eval data now includes a compatibility alias for older 'quesiontype' references to prevent breaking reports.
                      • Additional February bug fixes applied to improve overall stability and correctness.

                      Version v3.58.0 - February 10, 2026

                      New Features

                      • Added Genesys Cloud Copilot V2 analytics support, including agent copilot aggregates, knowledge aggregates, document feedback tracking, and per-user license tracking.
                      • Added KnowledgeQuest Receiver with SSL/TLS support and more flexible payload parsing.
                      • Added Archive job processing to capture and manage historical data during archive runs.

                      Improvements

                      • Improved real-time user jobs and realtime delivery to correctly include conversation data and more reliably reflect user presence.
                      • Updated bot reporting to include the DIGITALBOT flow type in queries.
                      • Enhanced schedule and time-off handling by adding scheduleid to timeoff data and providing a combined schedule/time-off view for a complete schedule picture.
                      • Refactored Copilot usage jobs for reactive chunking, dynamic granularity, centralized date configuration, and better error handling.
                      • Added NRT summary support for voice analysis with STT fallback and other post-release robustness and compatibility fixes.
                      • Various stability and compatibility improvements including switching to Microsoft.Data.SqlClient to avoid InvalidCastException and better permission error handling.

                      Bug Fixes

                      • Fixed the datediff function to ensure correct return behavior and added an overload for text input.
                      • Fixed missing conversation data for some agents in real-time processing so user realtime data is accurate.
                      • Fixed UTC timezone conversion issues in date parsing and resolved keyid collisions in Copilot usage data.
                      • Prevented duplicate key constraint violations in voice analytics and improved deduplication and primary key handling.
                      • Multiple post-release fixes to prevent duplicate job runs and add backward compatibility aliases where needed.

                      Schema Changes

                      Table / ViewColumnBenefit to Customer
                      agentcopilotaggregatesdatatable_createdAdds a new table to store detailed per-agent Copilot analytics so customers can analyze Copilot interactions at the agent level.
                      knowledgeaggregatesdatatable_createdAdds a new table to collect combined knowledge analytics so customers can measure knowledge performance across content.
                      knowledgedocumentfeedbackdatatable_createdAdds a new table to track document feedback so customers can see how knowledge documents are rated.
                      subuserlicensedatatable_createdAdds a new table for per-user license tracking so customers can monitor individual license usage.
                      convvoicesummarydatatable_createdAdds a new table for voice summaries so customers get faster summarized voice analytics.
                      knowledgebasedocumentvariationtable_createdAdds a new table to capture document variations so customers can compare different document versions.
                      vwCopilotLicensedUsersview_createdAdds a view to report licensed Copilot users for easier license reporting.
                      vwKnowledgeAggregatesDataview_createdAdds a view to simplify access to knowledge aggregate metrics.
                      vwKnowledgeBaseview_createdAdds a view to present knowledge base metadata for reporting.
                      vwKnowledgeCategoryview_createdAdds a view to present knowledge categories for easier browsing and reporting.
                      vwKnowledgeDocumentview_createdAdds a view to present knowledge documents for reporting and analysis.
                      vwKnowledgeDocumentFeedbackview_createdAdds a view to present document feedback for review.
                      vwLicenseCountsByTypeview_createdAdds a view to summarize license counts by type for reporting.
                      vwSubUserLicenseDataview_createdAdds a view to present per-user license details for analysis.
                      agentcopilotaggregatesdatasummaryratingChanged rating field from numeric to text so rating labels and special values are preserved and displayed correctly.
                      agentcopilotaggregatesdatawrapupcoderatingChanged wrap-up code rating from numeric to text so rating labels and special values are preserved and displayed correctly.
                      timeoffdatascheduleidAdded scheduleid to associate time-off records with schedules for clearer schedule reconciliation.
                      evalDetailsquesiontypeAdded a backward-compatible computed alias column to preserve older integrations that expect the alternate spelling.
                      January 2026

                      January 2026

                      Version v3.57.3 - January 21, 2026

                      New Features

                      • Teams webhook notifications were added for license validation failures so your admins can be alerted in Microsoft Teams when a license issue occurs.
                      • A helper method was added to remove computed columns from DataTable before bulk database operations to make bulk uploads more reliable on MSSQL.
                      • Cron job installation was made configurable so cron jobs can be installed with the correct schema and database settings for each customer.

                      Improvements

                      • Bot reporting now includes the DIGITALBOT flow type so reports include those bot conversations.
                      • Real-time user processing and schedule handling were improved to present more complete and accurate user and schedule data.
                      • CI/publish settings were updated (including win-x64 and linux-musl-x64 runtimes) to make builds and releases more consistent across platforms.
                      • Connection health checks now require all connections to be healthy before reporting services as healthy, improving recovery behavior and diagnostics.
                      • Database indexing for dashboards was enhanced to speed up common dashboard queries and improve performance.
                      • Installer index creation was simplified to use regular CREATE INDEX for broader compatibility and more robust installation checks.

                      Bug Fixes

                      • The datediff function was fixed and a text overload was added to ensure correct results and prevent errors in date calculations.
                      • Real-time user data issues were fixed so agents' conversation data is captured correctly in real time.
                      • Various post-release fixes were applied to database utilities, voice analysis handling, permission error handling, job execution, and backward compatibility aliases.
                      • String sanitization was added to remove unpaired Unicode surrogates and prevent database operation errors from malformed text.
                      • Multiple installer and MSSQL job errors were resolved to prevent failures during schema migrations and column additions.
                      • Evaluation and question-group name handling was improved to prevent data-length constraint failures and to provide better diagnostic logging.

                      Schema Changes

                      • timeoffdata | scheduleid: Adds a schedule identifier to timeoffdata so time-off records can be linked to schedules and reported more accurately.
                      • evaluation | name: Increases the maximum length for evaluation name columns so long evaluation names no longer cause insert or update errors.
                      • question_group | name: Increases the maximum length for question-group name columns so long group names no longer cause insert or update errors.
                      • systemcallusagedata | new_tables: Adds a new schema and tables to capture system call usage so call usage can be tracked and reported more fully.
                      December 2025

                      December 2025

                      Version v3.57.2 - December 15, 2025

                      New Features

                      • Added comprehensive automated testing for all adapter jobs in the CI pipeline to ensure reliability before deployment.
                      • Added support for Flow Milestone metrics to track customer journey progress through interaction flows.
                      • Added indexes optimized for Grafana dashboards to improve reporting query performance.

                      Improvements

                      • Enhanced error messages to provide clear, actionable guidance when database connection issues occur.
                      • Improved permission error handling to display cleaner error messages when access is denied.
                      • Optimized PostgreSQL queries to handle special characters in column names and exclude system-generated columns.
                      • Enhanced database schema handling to properly respect configured schema names in PostgreSQL.
                      • Improved WebSocket channel management for more reliable real-time data collection.
                      • Streamlined error logging to reduce duplicate messages and improve troubleshooting clarity.

                      Bug Fixes

                      • Fixed PostgreSQL compatibility issue with DATEDIFF function by using native date arithmetic.
                      • Fixed database connection errors that occurred when using special characters in column names.
                      • Fixed issue where generated columns in PostgreSQL caused write errors.
                      • Fixed database partition errors to provide clearer guidance on date range adjustments.
                      • Fixed evaluation details table column name typo from 'quesiontype' to 'questiontype' with backward compatibility.
                      • Fixed SQL query errors when selecting user data by using correct column identifiers.
                      • Fixed bot reporting to include DIGITALBOT flow type in queries.
                      • Fixed real-time user conversation data that was missing for active agents.
                      • Fixed cold start problem in user call details service by releasing locks before API calls.
                      • Fixed unauthorized access errors in copilot data processing with better error handling.

                      Version v3.57.1 - December 12, 2025

                      Improvements

                      • Bot reporting now includes the DIGITALBOT flow type so bot activity is reported more completely.
                      • Schedule and time-off data capture has been improved and a combined view was added to present agent schedules more completely.
                      • PostgreSQL compatibility was improved by excluding generated columns in some queries and replacing SQL Server-specific date functions with native PostgreSQL date arithmetic.
                      • Database client code now uses Microsoft.Data.SqlClient to avoid certain command creation errors.
                      • Primary key handling and deduplication for voice analysis were enhanced to reduce duplicate records and failures.
                      • DROP TABLE statements for legacy objects now include CASCADE to improve backward compatibility.

                      Bug Fixes

                      • Fixed the datediff function to ensure correct return values and added an overload for text input to avoid errors.
                      • Resolved missing conversation data in real-time user jobs so live user metrics reflect agent interactions accurately.
                      • Corrected SQL queries to select the proper id fields and clarified variable names to prevent data selection errors.
                      • Improved permission error handling for outbound data retrieval methods.
                      • Fixed MSSQL boolean syntax usage to prevent SQL errors for isactive and assistantenabled columns.
                      • Prevented duplicate key constraint violations in voice analytics by checking for existing keys before adding topics.

                      Schema Changes

                      • timeoffdata | scheduleid: Customers will get complete schedule data including a schedule identifier so time-off records can be linked to schedules.
                      • evalDetails | quesiontype: Adds a backward-compatible alias so older queries that expect the misspelled column continue to work.

                      Detailed Customer Summary

                      • Including DIGITALBOT flow type means bot activity is included in reports so you have a fuller view of automated interactions.
                      • Fixing missing conversation data in real-time jobs ensures live user metrics reflect actual agent conversations.
                      • The combined schedule/time-off view and added schedule identifier make agent schedules and related time-off easier to understand and reconcile.
                      • Replacing SQL Server-specific date functions with native PostgreSQL arithmetic reduces database errors when running on PostgreSQL.
                      • Switching to Microsoft.Data.SqlClient reduces certain command creation errors for more reliable database operations.
                      • Improved primary key handling and deduplication in voice analysis reduces duplicate records and improves the accuracy of voice analytics.
                      • Adding a backward-compatible alias for the misspelled quesiontype column keeps older reports and scripts working.

                      December 5, 2025 — Version 3.57.0

                      New Features

                      • Added a text-type overload for the datediff function so it can work with text inputs.

                      Improvements

                      • GetBotReportingTurnsAsync now includes DIGITALBOT flow types so bot reporting covers digital bots.
                      • Real time user jobs were improved to better reflect live user conversation data.
                      • Schedule processing was improved to capture more schedule data and include schedule IDs for time-off records.
                      • Multiple post-release improvements were made to database and job handling to increase reliability and compatibility.

                      Bug Fixes

                      • Fixed datediff so it returns correct results consistently.
                      • Corrected missing conversation data for some agents in real-time user processing.
                      • Fixed SQL client usage to avoid InvalidCastException when creating commands.
                      • Updated SQL syntax to use MSSQL-compatible boolean expressions for isactive and assistantenabled columns.
                      • Improved primary key handling and deduplication logic for voice analysis to prevent duplicate data.
                      • Prevented duplicate key constraint violations when adding voice analytics topics.
                      • Improved permission error handling for outbound data retrieval methods.
                      • Enhanced job execution logic to handle aliases and avoid duplicate job runs.
                      • Added a backward-compatible computed/generated alias 'quesiontype' to evalDetails.

                      Schema Changes

                      • timeoffdata | scheduleid: Adding a schedule identifier lets time-off records link directly to schedules so agent schedules are complete and accurate.
                      • vw_agent_schedules | combined_schedule_timeoff: A new view combines schedule and time-off data to present a single, complete view of agent schedules.
                      • evalDetails | quesiontype: Added a backward-compatible computed/generated alias so older reports and queries that use the misspelled name continue to work.

                      Customer Summary

                      This release improves data accuracy and reporting reliability: bot reporting now includes digital bots, real-time user data and schedules are more complete, datediff behaves correctly (and supports text inputs), and a series of backend fixes reduce errors and duplicate data. Overall, these changes make reports and real-time views more trustworthy and reduce interruptions from backend errors.

                      Detailed Customer Summary

                      • Datediff fix and text overload: Datediff now returns correct results and can accept text inputs, so date calculations in reports will be accurate even when dates come as text.
                      • GetBotReportingTurnsAsync (DIGITALBOT): Bot reporting now includes DIGITALBOT flows so digital bot interactions appear in bot reports.
                      • Real time user uplift: Real-time user data now includes conversations for all agents, giving a more complete live view of agent interactions.
                      • Schedule capture and scheduleid: Schedule processing now captures more schedule data and links time-off entries to schedules so agent schedules are complete and easier to interpret.
                      • New schedule/time-off view: A new combined view presents schedules and time-off together, simplifying schedule-related reporting.
                      • SQL client and syntax fixes: Using a compatible SQL client and MSSQL boolean syntax reduces errors when running database commands and improves reliability.
                      • Voice analysis deduplication and primary key handling: Voice analysis imports now avoid duplicate records, improving accuracy of voice analytics.
                      • Voice analytics duplicate key prevention: Adding topics now checks for existing keys to prevent ingestion errors and failed updates.
                      • Permission error handling for outbound data: Improved error handling reduces failures when retrieving outbound data, making data flows more robust.
                      • Job execution improvements (aliases & duplicate runs): Job logic was improved to handle aliases correctly and avoid running the same job twice, reducing duplicate work and inconsistent results.
                      • EvalDetails backward-compatible alias: A computed alias 'quesiontype' was added so legacy queries and reports that use the old name continue to work.

                      November 2025

                      November 2025

                      Version v3.56.3 - November 24, 2025

                      New Features

                      • Real-time transcripts and voice analysis ingestion so conversation text and voice insights are available as they happen.
                      • Automatic population of active conversations on startup so the system resumes ongoing work after restarts.

                      Improvements

                      • Streamlined logging to make operational messages clearer and reduce noise.

                      • Improved token refresh and pause logic for more stable real-time connections and fewer interruptions.

                      • Improved queue observability and adjusted voice-analysis timing for more reliable processing.

                      Bug Fixes

                      • Fixed an issue where a preload routine ran before a required map was set, preventing a startup ordering problem.

                      • Prevented long-running cleanup operations from hanging by setting a predictable timeout.

                      • Stabilised voice analysis batching and summary counters to reduce missed or duplicated analysis results.

                      • Avoided unnecessary snapshot writes for truncated queues to improve reliability.

                      Schema Changes

                      • detailedinteractiondata: Provides richer conversation records so you get more complete interaction history.

                      • usergroupmappings: Keeps user group associations accurate so reports and access work more reliably.

                      • userrealtimedata: Improves live user status reliability and adds a way to mark items that were manually reviewed.

                      • userrealtimeconvdata: Improves tracking of active conversations so real-time views are faster and more accurate.

                      • subscriptiondata: Allows longer identifiers so subscriptions won’t be truncated and data ingestion won’t fail.

                      • suboverviewdata: Allows longer identifiers so overview records won’t be truncated and installations succeed more smoothly.

                      Summary

                      This release improves real-time insight and reliability: customers will get transcripts and voice insights sooner, see active conversations restored after restarts, experience fewer interruptions from long-running operations, and benefit from clearer logs and smoother installs.

                      Detailed Summary

                      • Real-time transcripts and voice analysis ingestion: You will see conversation text and voice-based insights immediately, helping faster decision-making.

                      • Populate active conversations on startup: After a restart, the system will repopulate ongoing conversations so agents and supervisors pick up where they left off.

                      • Token refresh and pause logic improvements: Connections will be more stable, reducing interruptions to real-time data updates.

                      • Streamlined logging: Logs are clearer and less noisy, making it easier to spot real issues.

                      • Voice analysis batching and counters stabilised: Analysis results will be more accurate and less likely to be missed or duplicated.

                      • Adjusted voice-analysis timing and better queue observability: Voice processing happens at the right time and is easier to monitor.

                      • Preload ordering fix: Prevents a startup error that could stop some services from initialising correctly.

                      • Cleanup timeout added: Long cleanup tasks will fail predictably instead of hanging the system.

                      • Skip snapshot for truncated queues: Reduces unnecessary writes and improves queue reliability.

                      • Longer identifier support for subscriptions and overviews: Prevents errors and data loss when identifiers are longer than before.

                      • Schema install fix for subscription/overview scripts: Installations and upgrades are less likely to fail due to schema change issue.

                      Version v3.56.2 - November 7, 2025

                      Improvements

                      1. Real-Time Start Date Logic
                        Restored proper start date logic in real-time services to ensure accurate conversation timing and status tracking.
                        (Merged PR #567)

                      Version v3.56.1 - November 6, 2025

                      Improvements

                      1. String-Based FactData Job Configuration
                        Enhanced FactData job configuration with string-based job selection and exclusion support, providing more flexible control over which fact data sources to process.
                        (Merged PR #571)
                      1. Real-Time Start Date Logic
                        Restored proper start date logic in real-time services to ensure accurate conversation timing and status tracking.
                        (Merged PR #567)

                      Bug Fixes

                      1. User Detail View Team Member Filter
                        Fixed bug in vwuserdetail view that was incorrectly filtering team member data, ensuring proper user visibility in reports and dashboards.
                        (Merged PR #570)

                      Version v3.56.0 - November 5, 2025

                      Features

                      1. Fact Data Job Exclusion Rules
                        Added support for exclusion rules in specific fact jobs, allowing administrators to configure which data sources to skip during fact data synchronisation for improved flexibility and performance optimisation.
                        (Merged PR #546)
                      1. Survey Job Modernisation
                        Modernised Survey job implementation with async/await patterns for improved performance, better error handling, and enhanced scalability when processing survey data from Genesys Cloud.
                        (Merged PR #528)

                      Improvements

                      1. Real-Time Queue Service Cleanup
                        Enhanced real-time conversation tracking with automatic cleanup of terminated conversations in queue services, improving system performance and reducing memory usage.
                        (Merged PR #549)
                      1. User Detail View Performance
                        Improved vwuserdetail view performance by filtering results to only include active team members, reducing query overhead and improving dashboard response times.
                        (Merged PR #527)

                      Bug Fixes

                      1. FactData Installation Errors
                        Resolved installation errors in FactData job that were preventing proper database schema updates and job initialisation.
                        (Merged PR #556)

                      October 2025

                      October 2025

                      Version v3.55.1 - October 31, 2025

                      Improvements

                      1. Real-Time View
                        Improved real-time conversation processing by excluding terminated conversations from active tracking, reducing unnecessary data processing and improving system performance.
                        (Merged PR #544)

                      Version v3.55.0 - October 31, 2025

                      Features

                      1. Snowflake Key Pair Authentication Support
                        Added support for Snowflake key pair authentication as a secure alternative to username/password authentication, including comprehensive configuration validation, error handling for invalid key configurations, and enhanced connection security with RSA private key support.
                        (Merged PR #462)

                      Bug Fixes

                      1. Real-Time Engine
                        Enhanced WebSocket channel management with improved heartbeat handling, centralised HTTP response handling, and thread-safety improvements for real-time services. Added in-memory conversation caching, improved rate limit detection and handling, and enhanced database connection pooling for better performance and stability.
                        (Merged PR #543)

                      Version v3.54.0 - October 28, 2025

                      Features

                      1. Complete Real-Time Engine Modernisation
                        Introduced redesigned real-time data collection system with new service architecture, enhanced WebSocket management, and improved database concurrency handling for enterprise-scale deployments.
                        (Merged PR #526)
                      1. Copilot Usage Analytics
                        Introduced comprehensive copilot feature usage analytics collection from Genesys Cloud through analytics aggregates, with new database table storage and summary statistics logging for evaluation and analysis.
                        (Merged PR #521)
                      1. Voice Summary Data Collection
                        Added voice summary data collection capabilities with new schema tables (convvoicesummarydata) and enhanced voice analysis processing to capture AI-generated conversation summaries and insights.
                        (Merged PR #521)
                      1. Assistant Details Integration
                        Integrated assistant configuration data collection for queues, including AI assistant enabled views and copilot feature columns in assistantdetails schema to support advanced AI functionality.
                        (Merged PR #521)

                      Improvements

                      1. Voice Analysis Modernisation
                        Refactored voice analysis logic into modular GCUpdateVoiceAnalytics class with conversation-to-queue map caching, improved batch processing, and enhanced deduplication logic for better performance and data consistency.
                        (Merged PR #521)
                      1. Knowledge Quest Integration
                        Added Knowledge Quest functionality with improved logging, AI-enabled queue handling, and integration into main voice analysis batch flow for enhanced knowledge management capabilities.
                        (Merged PR #521)
                      1. Database Schema Enhancements
                        Updated schema across MSSQL, PostgreSQL, and Snowflake to support copilot usage data, voice summary storage, and assistant configuration with proper table definitions and permissions.
                        (Merged PR #521)

                      Version v3.53.3 - October 24, 2025

                      Improvements

                      1. Enhanced Voice Analysis Stability
                        Implemented comprehensive rate limiting solution with intelligent retry mechanisms and exponential backoff to resolve processing bottlenecks and ensure reliable voice data synchronisation.
                        (Merged PR #522)
                      1. Strengthened Security Framework
                        Addressed identified security vulnerabilities with targeted fixes to enhance system protection and maintain compliance with security best practices.
                        (Merged PR #523)
                      1. Improved Error Recovery
                        Enhanced fault tolerance in voice processing workflows with sophisticated rate limiting controls to maintain consistent operation during high-volume processing periods.
                        (Merged PR #522)


                      Version v3.53.2 - October 14, 2025

                      Features

                      1. Messaging Campaign Support
                        Introduced comprehensive outbound messaging campaign data retrieval with new odmessagingcampaigndetails table across all database platforms, consolidating voice and messaging campaigns for enhanced reporting capabilities.
                        (Merged PR #513)
                      1. Flow Reporting Analytics
                        Added new FlowReportingTurns job for detailed bot conversation turn tracking and analysis with dedicated flowreportingturns table and enhanced flow outcome reporting.
                        (Merged PR #508)
                      1. Knowledge Quest Integration
                        Implemented complete Knowledge Quest analytics schema with new tables (kq_analysis, kq_analysis_question, kq_analysis_taxonomy) for advanced knowledge management and analysis capabilities.
                        (Merged PR #377)
                      1. Flow Details Synchronisation
                        Introduced new flowdetails table for comprehensive flow configuration data synchronisation, supporting enhanced flow outcome and reporting features.
                        (Merged PR #508)
                      1. Materialised Views Migration
                        Converted all materialised views to regular views for improved maintainability, removing legacy materialised view tables and associated cron job procedures while maintaining data accessibility.
                        (Merged PR #419)

                      Improvements

                      1. Enhanced Voice Analysis Reliability
                        Implemented comprehensive rate limiting with exponential backoff, batch-level retry logic, and error-specific retry behavior for 429, 401, timeout, and 404 responses with detailed conversation ID tracking.
                        (Merged PR #522)
                      1. Centralised Key Generation System
                        Deployed system-wide composite key generation using SHA256 hashing to ensure data integrity and prevent key duplication across all data processing components.
                        (Merged PR #481)
                      1. Team Details Pagination
                        Resolved team retrieval limitations by implementing pagination support, enabling complete team data synchronisation for customers with more than 25 teams.
                        (Merged PR #516)
                      1. Optimised Realtime Performance
                        Enhanced WebSocket connection stability and queue observation processing with improved handling for large customer environments exceeding 1000 queues or users.
                        (Merged PR #461)
                      1. Expanded Permission Support
                        Added new permissions for messaging campaigns (outbound:messagingCampaign:view, outbound:emailCampaign:view, outbound:whatsAppCampaign:view) and bot flow analytics (analytics:botFlowDivisionAwareReportingTurn:view).
                      September 2025

                      September 2025

                      Version v3.53.1 - September 24, 2025

                      Improvements

                      1. Enhanced Voice Analysis Reliability
                        Strengthened error handling and retry logic for Voice Analysis operations to improve processing stability and data recovery capabilities.
                        (Merged PR #495)
                      1. Streamlined Migration Process
                        Temporarily disabled keyid format migration logic to prevent potential conflicts during system updates and ensure smoother deployment processes.
                        (Merged PR #495)
                      1. Improved Error Recovery
                        Enhanced fault tolerance mechanisms in voice processing workflows to maintain consistent operation during temporary service disruptions.
                        (Merged PR #495)

                      Version v3.53.0 - September 15, 2025

                      Features

                      • Centralised Composite Key Generation
                        Implemented a unified system for generating composite keys across all data processing operations, improving consistency and maintainability.
                        (Merged PR #481)

                      Improvements

                      1. Enhanced Database Compatibility
                        Resolved PostgreSQL partman compatibility issues to ensure seamless operation with partition management extensions.
                        (Merged PR #478)
                      1. Optimised SQL Schema Structure
                        Applied targeted schema refinements to improve database performance and maintain consistency across supported database platforms.
                        (Merged PR #473)
                      1. Voice Analysis Stability
                        Fixed ArgumentNullException errors in Voice Analysis job processing to ensure reliable execution and data processing continuity.(Merged PR #482)
                      1. Improved Data Processing Reliability
                        Strengthened error handling and key generation mechanisms to provide more robust data synchronisation workflows.
                        (Merged PR #481, #482)

                      August 2025

                      August 2025

                      Version v3.52.3 - August 19, 2025

                      Improvements

                      • Enhanced Data Integrity
                        Expanded duplicate cleanup operations to cover the full synchronisation date range, ensuring comprehensive data deduplication across all processed records.
                        (Merged PR #471)

                      • Optimised Contact List Processing
                        Enhanced logging capabilities and improved performance for contact list operations with streamlined processing workflows.
                        (Merged PR #474)

                      • Comprehensive Duplicate Management
                        Strengthened data quality controls by extending cleanup logic to maintain consistent and accurate datasets throughout the entire sync period.
                        (Merged PR #471)

                      • Performance and Monitoring Enhancements
                        Improved operational visibility and processing efficiency for contact list management with enhanced logging and optimized execution paths.
                        (Merged PR #474)
                      Version v3.52.2 - August 13, 2025

                      Improvements

                      1. Enhanced Snowflake Performance Optimisation
                        Implemented fast COPY INTO operations with optimised batch sizes and improved CSV integrity handling for Snowflake bulk data loading operations.
                        (Merged PR #472)
                      2. Database Migration and Legacy Cleanup
                        Migrated date fields to native datetime/timestamp types and removed legacy materialised view procedures for improved database consistency across all platforms.
                        (Merged PR #472)
                      3. Enhanced Data Processing and Validation
                        Improved CSV validation with enforced quoted output, enhanced duplicate detection with UTC handling, and refined punctuation filtering logic.
                        (Merged PR #472)
                      4. Performance and Query Optimisation
                        Enhanced batch query performance using keyset pagination and optimised schedule processing for improved headcount forecast efficiency.
                        (Merged PR #472)
                      5. Standardised Logging and Error Handling
                        Streamlined logging throughout the codebase and enhanced Snowflake error handling with improved COPY INTO result verification.
                        (Merged PR #472)

                      Version v3.52.1 - August 08, 2025

                      Improvements

                      • Extended Date Field Updates
                        Expanded date field update logic to cover version 3.52.1 for consistency across releases.
                        (Merged PR #469)

                      • Precise Duplicate Cleanup
                        Implemented targeted duplicate row removal after data synchronisation to maintain clean and accurate datasets.
                        (Merged PR #469)

                      • Preserve Original Order
                        Removed post-sync sorting to retain the native Genesys Cloud order of records.
                        (Merged PR #469)

                      Version v3.52.0 - August 07, 2025

                      Features

                      • SQL Schema Support for KQ Tables
                        Introduced database schema definitions for KQ-related tables to standardize structure and enable streamlined deployment.
                        (Merged PR #377)

                      • Optimised Realtime Job Performance
                        Improved performance of realtime processing jobs and added detailed documentation to aid maintainability.
                        (Merged PR #461)

                      • Replaced mvweval* Materialised Views with Regular Views
                        Replaced materialised views with equivalent standard views to reduce resource locking and improve view refresh behavior.
                        (Merged PR #419)

                      Improvements

                      • Enhanced Last Update Handling
                        Refined logic for tracking last update timestamps to prevent job stalling and improve system responsiveness.
                        (Merged PR #460)

                      Version v3.51.2 - August 04, 2025

                      Improvements

                      • Sort Participants Chronologically by Session Start
                        Ensures consistent PartCode ordering by sorting participants based on their earliest session start time.
                        (Merged PR #457)



                      July 2025

                      July 2025

                      Version v3.51.1 - July 30, 2025

                      Improvements

                      • Performance Improvements for Interaction Processing
                        Optimised interaction-related data operations to enhance performance and reduce latency.
                        (Merged PR #454)

                      Version v3.51.0 - July 29, 2025

                      Features
                      • Learning Module Uplift
                        Enhanced learning data processing for improved performance, stability, and consistency across module ingestion and reporting workflows.
                        (Merged PR #399)

                      Bug Fixes
                      • Fix Voice Analysis Batch Failures
                        Resolved issues with batch processing in the voice analysis job caused by duplicate key constraint violations, ensuring smooth and complete data loads.
                        (Merged PR #451)

                      • Fix Duplicate Key Constraint Violations in InteractionPresence Job
                        Addressed duplicate entry issues in the InteractionPresence job by refining data insertion logic to prevent constraint violations.
                        (Merged PR #452)

                      Version v3.50.1 - July 26, 2025

                      Improvements
                      • Refactor Data Access and Cleanup Logic
                        Refactored data access layers to use DataView with sorting for improved performance and clarity.
                        Added conversation and segment cleanup routines to preserve data integrity and eliminate duplicates.
                        Removed unnecessary UTC conversions for legacy data and refined interval logic by dropping redundant lookback spans.
                        (Merged PR #449)

                      Version v3.50.0 - July 25, 2025

                      Features
                      • Add Detailed Interaction Metrics to Data Views
                        Extended data visibility by introducing new detailed interaction metrics into reporting views for improved analysis and insights.
                        (Merged PR #443)

                      Improvements
                      • Update ODContactList Duplicate Removal Logic
                        Refined logic to remove duplicates, ensuring accurate data cleanup without impacting unrelated versions.
                        (Merged PR #439)

                      Bug Fixes
                      • Remove Problematic GRANT Statement from Snowflake Procedure
                        Eliminated a faulty GRANT statement from a Snowflake stored procedure to resolve permission errors during deployment.
                        (Merged PR #442)

                      • Restore Interaction Logic to Resolve Missing Data
                        Reinstated reliable interaction processing logic to address data loss issues.
                        (Merged PR #445)

                      • Fix Voice Analysis Schema and Exit Code Handling
                        Corrected schema mismatches and ensured accurate exit code reporting in the voice analysis job.
                        (Merged PR #446)

                      Version v3.49.0 - July 17, 2025

                      Features
                      • Resolve Interaction Duplicates
                        Switched to conversation-level concurrency and implemented safeguards to prevent duplicate keyid and ODContactListData rows. Also improved segment data validation and removed participant name from summaries to streamline imports.
                        (Merged PR #433)

                      Improvements
                      • Fix Realtime Thread Monitoring and API Efficiency
                        Fixed issues in realtime thread state tracking and significantly reduced excessive polling of the Observations API to improve system responsiveness.
                        (Merged PR #435)

                      Version v3.48.6.0 - July 10, 2025

                      Data Consistency Improvements

                      • Enhanced contact list processing with isolated processing to prevent data cross-contamination
                      • Fixed duplicate conversation segments by implementing consistent sorting of participants, sessions, and segments
                      • Improved queue ID assignment logic with proper null handling

                      Technical Enhancements

                      • Enhanced asynchronous processing for contact list operations
                      • Added robust null safety checks throughout conversation data processing

                      Database Updates

                      • Simplified database sync scripts for conversation summary data across all database types

                      Affected Components

                      • Outbound Dialing Data processing
                      • Conversation Segment Data processing
                      • Database synchronisation functions

                      June 2025

                      June 2025

                      June 27, 2025 — Version 3.48.5

                      Improvements

                      • Optimise Job Concurrency and Performance
                        Updated maximum concurrent tasks to align with available CPU cores, improving resource efficiency during large-scale processing.
                        (Merged PR #417)

                      • Improve Flow Outcome Processing Performance and Logging
                        Enhanced performance of flow outcome handling and added more granular logging to support observability and diagnostics.

                        (Merged PR #417)

                      • Refine Logging and Debugging Capabilities
                        Added debug logging for comparing flow outcome results between job and query modes, and removed unused metrics and legacy debug statements to reduce noise.
                        (Merged PR #417)

                      Bug Fixes

                      • Restore Sync Logic and Thread Safety for Interaction Job
                        Reinstated critical thread safety locks, sync date updates, and progress logging to maintain reliability and avoid race conditions in concurrent executions.
                        (Merged PR #417)

                      • Fix Flow Outcome and Participant Attribute Validation
                        Corrected logic to support nullable flow outcome end dates and re-enabled essential validation checks from earlier versions.
                        (Merged PR #417)

                      • Honor Sync Type Parameters and Flattening Flags
                        Fixed an issue where the SyncType parameter was not respected in GetDetailInteractionDataFromGC, and ensured flattenMultivaluedDimensions is consistently applied in both job and query modes.
                        (Merged PR #417)

                      June 26, 2025 — Version 3.48.4

                      Improvements

                      • Enhance Logging and Validation for Outbound Contact Processing
                        Improved logging for outbound contact list handling and added robust conversation tracking and data validation.
                        (Merged PR #414)

                      • Improve Configuration Handling and Secure Sensitive Data
                        Streamlined configuration logic and ensured secure handling of sensitive fields.
                        (Merged PR #414)

                      • Add Configurable Rate Limiting Support
                        Introduced configurable rate limiting options and expanded logging to support observability.
                        (Merged PR #414)

                      Bug Fixes

                      • Fix Token Refresh Behavior During Rate Limiting
                        Updated the API key correctly after token refresh events triggered by rate limits.
                        (Merged PR #414)

                      • Filter Invalid Conversations and Improve Error Messaging
                        Filtered out rows with missing conversation start dates and corrected typos in logs and processing logic.
                        (Merged PR #414)

                      June 25, 2025 — Version 3.48.3

                      Features

                      • Interaction Performance and Stability Uplift
                        Significantly enhanced interaction data performance by introducing concurrent processing, batch size optimisation, and improved Snowflake operations. Added configurable rate limiting, centralised rate limit handling, and improved synchronisation reliability.
                        (Merged PR #412)

                      • Enhance Logging and Error Observability
                        Replaced console outputs with structured logging, improved fallback sync date visibility, and added detailed context (e.g., conversation IDs) to log messages for traceability.
                        (Merged PR #412)

                      • Improve Thread Safety and Data Validation
                        Refactored internal threading logic, added duplicate conversation detection and deduplication safeguards, and improved overall data validation across segment and participant processing.
                        (Merged PR #412)

                      • Streamline Data Processing Logic and Schema Enhancements
                        Replaced SQL ORDER BY with in-memory sorting for better efficiency. Updated detailedInteractionData schema with additional fields and indexes to support richer analytics.
                        (Merged PR #411)

                      • Expand Version Checks for Compatibility
                        Broadened compatibility validation to include all 3.48.x minor releases across deployment logic.
                        (Merged PR #411)

                      June 17, 2025 — Version 3.48.0

                      Features

                      1. Enhance Data Structures with Additional Properties
                        Introduced new session, flow, and participant fields to enrich data structure definitions.
                        (Merged PR #403)
                      1. Add oMessageTurn to Interaction and Participant Tables
                        Added oMessageTurn fields to enable better tracking of messaging turn-taking in both interaction and participant records.
                        (Merged PR #403)

                      Improvements

                      • Enhance Token Refresh Logic for Broader Rate Limits
                        Enhanced token refresh logic to accommodate broader rate limiting scenarios.
                        (Merged PR #403)

                      • Optimise Diffing and Centralise Flow Processing
                        Optimised diffing logic, centralised flow processing, and expanded logging coverage for improved maintainability.
                        (Merged PR #403)

                      • Simplify Flow Outcome Status Logging
                        Simplified flow outcome status logging to reduce noise and improve clarity in logs.
                        (Merged PR #403)

                      • Replace Console Outputs with Structured Logging
                        Replaced console outputs with structured logging for better observability and integration with log monitoring systems.
                        (Merged PR #403)

                      • Synchronise Interaction Table Dates Across Databases
                        Ensured consistent date synchronisation across different instances of the interaction table.
                        (Merged PR #403)

                      • Log Flow Outcome Processing Summaries
                        Implemented summary logs for flow outcome processing to improve visibility and auditability.
                        (Merged PR #403)

                      • Implement Per-Table Sync Tracking
                        Added table-level synchronisation tracking and initialised sync logic with the earliest available date.
                        (Merged PR #403)

                      Bug Fixes

                      1. Refactor API Error Logging and Improve Contact List Logging
                        Refactored API error logging and improved contact list logging for better traceability and debugging.
                        (Merged PR #403)
                      1. Remove Redundant UTC Conversions and Clean Up Date Handling
                        Removed redundant UTC conversions and cleaned up inconsistent date handling throughout the codebase.
                        (Merged PR #403)

                      June 13, 2025 — Version 3.47.3

                      Improvements

                      • Improve Code Efficiencies for Contact List Processing
                        Improved Contact List processing efficiency  by skipping download preparation of empty lists and removing the filtering on the modification date
                        (Merged PR #400)

                      June 12, 2025 — Version 3.47.2

                      Improvements

                      • ODContactLists Job Enhancement
                        Improved stability and data coverage in the ODContactLists job by refining polling logic and extending timeout parameters.
                        (Merged PR #386)

                      • Fix Survey Empty Response Handling and Improve Rate Limiting
                        Added defensive logic to handle empty responses from survey endpoints and strengthened rate limit retry behavior.
                        (Merged PR #390)

                      • Add Indexes to Enhance Query Performance
                        Introduced indexes on several key columns across multiple tables to significantly improve query performance and reduce load on the database.
                        (Merged PR #392)

                      June 4, 2025 — Version 3.47.1

                      Features

                      1. Optimise Learning Module Assignment Retrieval
                        Enhanced the retrieval logic for learning module assignments by implementing a comprehensive user-module mapping for efficiency.
                        (Merged PR #371)

                      1. Async Initialisation and Token Caching for Authentication
                        Implemented asynchronous initialisation and token caching to prevent redundant concurrent requests and improve API performance.
                        (Merged PR #360)
                      2. Support Schedule Details Synchronisation
                        Introduced support for synchronising schedule details data from the Genesys API.
                        (Merged PR #373)

                      Improvements

                      1. Comprehensive Enhancements to Error Handling, Logging, and API Job Management
                        Refactored the GenesysJobManager to support adaptive polling, ISO-8601 granularity, and better retry logic. Added asynchronous job handling, structured logging, and robust HTTP error recovery.
                        (Merged PR #369)
                      2. Eliminate Data Skipping with Retry Logic
                        Addressed issues with skipped data by implementing robust retry logic to enhance reliability.
                        (Merged PR #370)
                      3. Enhanced Rate Limit Handling and Logging for Async APIs
                        Converted synchronous methods to async, improved timeout and logging mechanisms, and applied temporary fixes to avoid file locking issues.
                        (Merged PR #370)
                      4. Improve API Interaction and Logging Granularity
                        Refined windowed data retrieval, added detailed user presence logging, and enforced strict ISO-8601 time granularity.
                        (Merged PR #369)
                      5. Optimise Voice Analysis and Queue Observation Handling
                        Standardised participant metrics, avoided sync date updates on batch failure, and resolved DataTable mismatches. Enhanced user filtering and default search configurations.
                        (Merged PR #360)

                      1. Improve Survey Data Handling and Logging
                        Improved logging and error handling mechanisms for survey data ingestion.
                        (Merged PR #373)

                      2. Enhance Logging and JSON Parsing for API Pagination
                        Enhanced JSON parsing, pagination logic, and logging around API interactions.
                        (Merged PR #373)

                      3. Update Database Schemas and Add Column Checks
                        Added column existence checks before updates.
                        Expanded support for dynamic schema updates.
                        (Merged PR #373)

                      4. Improve JSON Status Code Handling
                        Enhanced robustness of API responses by better parsing and handling of HTTP status codes.
                        (Merged PR #387)

                      5. Make Date Handling Culture-Invariant
                        Ensured all date conversions use invariant culture to prevent region-based parsing errors.

                        (Merged PR #387)

                      Bug Fixes

                      1. Fix Voice Analysis Field Handling
                        Resolved issues with column mismatch and sync date behavior in the voice analysis pipeline.
                        (Merged PR #360)
                      2. Prevent Duplicate Transcript Processing
                        Ensured transcripts are not processed more than once and improved associated logging.
                        (Merged PR #360)
                      3. Fix for Empty Predicate API Errors
                        Handled empty predicates gracefully to prevent API call failures.
                        (Merged PR #360)

                      1. Restore Backward Compatibility for SQL Data Access
                        Fixed compatibility issues in GetSQLTableData to support legacy use cases.
                        (Merged PR #360)
                      2. Fix for Participants Collection Null References
                        Added null checks for the participants collection to prevent unhandled exceptions during interaction processing.
                        (Merged PR #373)

                      3. Database Write Failure Logging
                        Added robust logging for database write failures to support easier diagnosis of transient errors.
                        (Merged PR #373)

                      4. Improve API Error Handling and Rate Limit Management
                        Improved management of API rate limits.
                        Added fallback handling to reduce job disruption.
                        (Merged PR #373)

                      5. Improve WFM Audit Error handling and Parsing Data Structure
                        Improved the error handling around the WFM Audit job.
                        Aligned the data structure to match API responses for parsing outputs.
                        (Merged PR #373)

                      6. Resolve Date Incrementing Issue for UserInteractionData
                        Fixed an issue where dates were incrementing incorrectly due to local culture settings.
                        (Merged PR #387)

                      7. Uplift Shrinkage Job Error Handling
                        Improved error handling in the shrinkage processing job to better manage unexpected failures.
                        (Merged PR #387)



                      May 2025

                      May 2025

                      May 21, 2025 — Version 3.46.1

                      Bugs

                      • Learning Module Null Error Handling:
                        Implemented null handling on nullable columns in the Learning Module, Assignments and Results.
                        (Merged PR #358)

                      • User Data Null Error Handling:
                        Implemented null handling on nullable columns in the User Interaction and User Presence data.
                        (Merged PR #358)

                      Improvements

                      • Learning Module Logging:
                        Improved logging on the learning module.
                        (Merged PR #358)

                      May 1, 2025 — Version 3.46.0

                      Features

                      • Realtime Observations Management:
                        Implemented manager into Real Time Job for querying observations and handling limits more effectively.
                        (Merged PR #346)

                      • Update Permissions:
                        Updated and streamlined permission logic to support recent platform changes.
                        (Merged PR #327, #344)
                      • Backfill uplift:
                        Implemented backfill functionality across multiple jobs to enable separate jobs for re-syncing historical data.
                        (Merged PR #342)
                      • CSI Licensing Uplift:
                        Implemented licensing module to control access to the Genesys Adapter.
                        (Merged PR #326)

                      Bugs

                      • Offered Forecast Timeout:
                        Increased timeout on SQL queries whilst implementing additional logging and better error handling
                        (Merged PR #339)

                      Improvements

                      • CI Pipeline Uplift:
                        Included end-to-end testing across all CI jobs to strengthen build integrity.
                        (Merged PR #318)

                      • Updated Azure Pipelines Configuration:
                        Refined the azure-pipelines.yml file to enhance CI/CD performance.
                        (Merged PR #318)

                      • Deployment Trigger and Documentation Enhancements:
                        Adjusted deployment triggers to respond to pull requests and improved related documentation.
                        (Merged PR #322)

                      • Reduced API Batch Size and Logging Enhancements:
                        Lowered batch size for real-time modules and introduced more detailed logs.
                        (Merged PRs #338)

                      • Optimised Batch Processing in Real-Time Modules:
                        Refactored batch handling to improve throughput and performance.
                        (Merged PRs #336)

                      • Dynamic API URL:
                        Replaced static references to APIs for login and streaming URLs with dynamic derivation
                        (Merged PRs #342)

                      • Eval Details Column Descriptions:
                        Improved the descriptions of the columns in the Eval Details table to avoid confusion with the evaluationid column.
                        (Merged PRs #341)


                      February 2025

                      February 2025

                      February 25, 2025 — Version 3.43.0

                      Features

                      • Logging and Error Handling Enhancement for AdminData: Improved logging and error handling in adminData with structured logging for better maintainability.
                        (Merged PR #316)
                      • Added vwuserqueuemappings: Introduced the vwuserqueuemappings feature to enhance data organization and access for MSSQL.
                        (Merged PR #319)

                      Bug Fixes

                      • Null Handling for Flow Outcomes End Timestamp: Added null handling for the flowoutcomes end timestamp to prevent errors.
                        (Merged PR #314)
                      • Query End Date Handling for Future Dates: Fixed issue by setting query end date to utcnow if it's in the future.
                        (Merged PR #315)
                      • No Processing of Future Data: Resolved issue where future data was not processed correctly.
                        (Merged PR #320)

                      Improvements

                      • CI Pipeline Uplift: Enhanced CI pipeline to include end-to-end testing for all jobs, improving testing coverage and overall QA process.
                        (Merged PR #317, #318)

                      February 11, 2025 — Version 3.41.0

                      Features

                      • Logging and Code Uplift for SQL Batches in Interaction Job: Improved logging and optimised SQL batch processing for the Interaction Job.
                        (Merged PR #307)
                      • Schema Uplift for Persona Dashboards: Updated schema definitions to enhance Persona Dashboard functionality.
                        (Merged PR #309)
                      • Survey Job Uplift: Enhanced survey job processing for better reliability and performance.
                        (Merged PR #308)

                      Bug Fixes

                      • Additional check for stuck Real Time Conversations: Added an additional validation step for conversations exceeding an hour in the Real Time Job.
                        (Merged PR #312)
                      • Fix Sync Type to Lowercase: Standardised sync type values to lowercase for consistency.
                        (Merged PR #310)

                      Improvements

                      • Version Increment: Internal versioning update for tracking release changes.
                        (Merged PR #303)
                      January 2025

                      January 2025

                      January 30, 2025 — Version 3.40.1

                      Bug Fixes

                      • Fix Output for Missing Permissions Message on Error: Ensured that missing permissions messages are properly displayed when errors occur.
                        (Merged PR #301)
                      • Remove Duplicate Schema Logic in DetailedInteractionData: Addressed an issue where duplicate entries were being stored in the DetailedInteractionData schema file.
                        (Merged PR #301)
                      • Fix Error Handling on Async Interaction Job: Improved error handling for asynchronous interaction jobs to prevent failures.
                        (Merged PR #301)
                      • Add Duplicate Constraint Checks for Flow Outcomes: Implemented additional checks to prevent duplicate flow outcome entries.
                        (Merged PR #301)
                      • Update Handling for csg_artefacts Schema: Adjusted logic in the csg_artefacts schema file to improve data consistency.
                        (Merged PR #301)

                      January 28, 2024 — Version 3.40.0

                      Features

                      • Implement Flow Outcomes: Introduced flow outcomes functionality for improved tracking and analysis.
                        (Merged PR #294)
                      • Forbidden Handling: Added forbidden handling logic for the API responses to enhance error management.
                        (Merged PR #295)

                      Bug Fixes

                      • EvalData Lookback Paging Uplift: Enhanced the paging mechanism for EvalData lookback functionality.
                        (Merged PR #296)
                      • Uplift MSSQL Schemas: Improved MSSQL schemas for better compatibility and performance.
                        (Merged PR #297)
                      • Uplift Realtime Schema: Updated and optimised the realtime schema to align with current standards.
                        (Merged PR #298)

                      Improvements

                      • Extract Missing Users from Group Membership: Enhanced group membership logic to identify and extract missing users.
                        (Merged PR #299)
                      December 2024

                      December 2024

                      December 18, 2024 — Version 3.39.4

                      Features

                      • Sanitising Participant Attributes:
                        Improved extraction of participant attributes dynamically, ensuring columns names conform to database standards (e.g. whitespace)
                        (Merged PR #292)

                      December 16, 2024 — Version 3.39.0

                      Features

                      • Enhanced Asynchronous Processing for Interaction Jobs:
                        Improved asynchronous processing for interaction jobs to ensure reliable and efficient performance.
                        (Merged PR #284)
                      • Enhanced Forecast Job Stability:
                        Improved error handling in the Forecast Job to ensure reliable performance.
                        (Merged PR #282)
                      • Historical Data Synchronization:
                        Enabled synchronization of historical schedules and offered forecasts for comprehensive data tracking.
                        (Merged PR #269)

                      Improvements

                      • Enhanced User Interaction Data Processing:
                        Updated the process for retrieving user interaction data to improve efficiency and accuracy.
                        (Merged PR #280)
                      • Refined User Interaction Data Handling:
                        Further improvements to the user interaction data retrieval process, ensuring better performance.
                        (Merged PR #279)
                      • Advanced Logging for SQL Table Data:
                        Implemented enhanced logging for SQL table data operations to facilitate easier troubleshooting and monitoring.
                        (Merged PR #273)
                      • Increase Evaluation Sync Limits:
                        Updated default settings for Evaluation Syncs to ensure conversations are not missed during regular synchronization.
                        (Merged PR #276)
                      • Extended Evaluation Lookback:
                        Updated the evaluation lookback period for more accurate data analysis.
                        (Merged PR #276)
                      • Improved Table Definitions Management:
                        Implemented logic to automatically check and remove incorrect table definition entries.
                        (Merged PR #275)
                      • Voice Overview Dependency Integration:
                        Added dependencies to ensure voice interactions are synchronized with the last interaction sync.
                        (Merged PR #274)
                      • Automated Cleanup of Old Suboverview Data:
                        Introduced a procedure to delete outdated suboverview rows, maintaining data integrity.
                        (Merged PR #270)

                      Bug Fixes

                      • Prevent Missed Abandoned Interactions:
                        Addressed issues where abandoned interactions (less than one second) were being missed from data collection.
                        (Merged PR #284)
                      • Improved Data Validation for Real-time Interactions:
                        Introduced enhanced validation mechanisms for real-time interactions to increase reliability and data integrity.
                        Added additional checks to improve the accuracy and reliability of realtime conversations.
                        (Merged PR #278 and #268)
                      • Enhanced Error Logging in Data Sync Processes:
                        Updated error logs for better debugging during data synchronization.
                        (Merged PR #281)
                      • Enhanced Forecast Job Error Handling:
                        Fixed missing semicolons and corrected error handling to enhance overall code stability.
                        (Merged PR #282)
                      • Manual Check Date Handling:
                        Resolved issues with null start dates in manual checks to prevent data inconsistencies.
                        (Merged PR #281)
                      • Code Formatting Enhancements:
                        Corrected curly brace positioning and improved code escaping for better readability and maintenance.
                        (Merged PR #279)
                      • MSSQL Timespan Handling Fix:
                        Adjusted MSSQL timespan processing to ensure accurate data conversions.
                        (Merged PR #278)
                      • Data Conversion Safety:
                        Implemented safer data conversion methods to prevent errors during data processing.
                        (Merged PR #272)
                      • Duplicate Entry Prevention:
                        Added primary key checks to avoid duplication of records, ensuring data integrity.
                        (Merged PR #269)
                      • Partition Management Improvements:
                        Patched the partition management process to handle new partitions, redistribute data effectively, and enhance analysis functions.
                        (Merged PR #271)

                      December 05, 2024 — Version 3.38.1

                      Bug Fixes

                      • Real Time Null Start Date in Conversations:
                        Fixed an issue with handling null start dates in manual checks.
                        (Merged PR 281)
                      • Offered Forecast Null Object Handling:
                        Fixed an issue with handling null forecast data objects.
                        (Merged PR 282)

                      December 04, 2024 — Version 3.38.0

                      Features

                      • Historical Forecast Adjustments:
                        Enabled adjustments to historical forecasts for more accurate reporting.
                        (Merged PR 279)

                      Improvements

                      • Improved Data Validation for Real-time Interactions:
                        Introduced enhanced validation mechanisms for real-time interactions to increase reliability and data integrity.
                        (Merged PR 278)
                      • Enhanced Error Logging in Data Sync Processes:
                        Updated error logs for better debugging during data synchronization.
                        (Merged PR 281)
                      • Default: Increase Evaluation Sync Limits
                        Updated default for Evaluation Syncs to ensure conversations are not missed when syncing regularly.
                        (Merged PR 276)

                      Bug Fixes

                      • Fixed Incorrect Sync Timestamps for Historical Data:
                        Addressed an issue where historical data sync timestamps were misaligned, ensuring accurate records.
                        (Merged PR 282)
                      • Resolved Null Value Errors in Forecast Analysis:
                        Fixed a bug causing null value errors in forecast analysis calculations.
                        (Merged PR 283)

                      November 2024

                      November 2024

                      November 21, 2024 — Version 3.37.0

                      Bug Fixes

                      • Isolate OfferedForecast from Schedule:
                        Isolated the OfferedForecast logic from the Schedule to improve clarity and structure.
                        (Merged PR 264)
                      • Rename Learning Tables in Table Definitions:
                        Renamed learning tables in table definitions to avoid conflicts.
                        (Merged PR 265)
                      • Fix Incorrect Start Dates from DST Offsets:
                        Fixed issues related to incorrect start dates caused by Daylight Saving Time offsets.
                        (Merged PR 266)
                      • Resolve Keyid Deletion Logic Removing Too Many Rows:
                        Resolved an issue where the keyid deletion logic removed more rows than intended.
                        (Merged PR 262)
                      • Update Deletion Logic for Keyid:
                        Updated the deletion logic to ensure the correct number of rows are deleted, merging fixes from PR 262.
                        (Merged PR 263)

                      November 2, 2024 — Version 3.36.0

                      Bug Fixes

                      • Handle Data Errors During DST Crossover:
                        Resolved data handling errors occurring during Daylight Saving Time (DST) crossover. The adherence data aggregation now correctly adjusts for UTC-based start dates, stopping the job and initiating a new entry to accommodate DST transitions.
                        (Merged PR 261)

                      November 1, 2024 — Version 3.35.1

                      Bug Fixes

                      • Delete Team Member Data Before Write:
                        Added functionality to delete existing team member data prior to new data write operations.
                        (Merged PR 259)
                      • Update Correct Date Syntax for MSSQL in userPresenceData:
                        Adjusted date syntax in userPresenceData to comply with MSSQL formatting.
                        (Merged PR 258)
                      • Update LastSync Based on Request Date:
                        Fixed the last sync timestamp to align with the provided request date.
                        (Merged PR 258)
                      • Fix ArchiveQueueInteractions Cron Job:
                        Resolved issues with the ArchiveQueueInteractions cron job.
                        (Merged PR 255)

                      October 2024

                      October 2024

                      October 28, 2024 — Version 3.35.0

                      Features

                      • Track Missing Rows and Delete:
                        Added functionality to track missing data rows and enable deletions where necessary.
                        (Merged PR 251)

                      Improvements

                      • Implement SLA Target Information in Queue Details:
                        Enhanced queue details with SLA target metrics to improve tracking.
                        (Merged PR 252)
                      • Update Query in userPresenceData to Handle All DBTypes:
                        Improved query compatibility across multiple database types.
                        (Merged PR 253)

                      Bug Fixes

                      • Subscription Duplicate Patch and Cleanup:
                        Resolved duplicate entries in subscriptions, with cleanup enhancements.
                        (Merged PR 247)
                      • Remove Delay in Conversation Looping:
                        Optimized looping process by eliminating unintended delays.
                        (Merged PR 249)
                      • Remove UTC Conversion on Request Dates:
                        Adjusted date handling by removing unnecessary UTC conversions.
                        (Merged PR 250)

                      October 16, 2024 — Version 3.34.3

                      Bug Fixes

                      • Re-open database connection after deletion:
                        Resolved an issue where the database connection wasn't re-opening after a deletion operation.
                        (Merged PR 245)

                      • Resolve column diff errors in Participant Attributes:
                        Resolved an issue where column mismatch occurs in participant attributes, causing an unhandled exception.
                        (Merged PR 246)

                      • Subscription duplicate patch and cleanup:
                        A patch was applied to remove duplicate subscriptions, along with a general cleanup of related code.
                        (Merged PR 247)

                      October 15, 2024 — Version 3.34.2

                      Improvements

                      • Aggregation User Interaction duplicate patch:
                        A patch was applied to remove duplicate user interactions in the Aggregation job.
                        (Merged PR 230)
                      • Increment Merged Branch Version:
                        Disabled the prevent-increment-of-merged-branch-version configuration for the main branch.
                        (Merged PR 236)
                      • Set Requested Date as Last Update:
                        Fixed the last update timestamp to be set to the request date at the end of processing user presence data.
                        (Merged PR 240)

                      October 14, 2024 — Version 3.34

                      Features

                      • Align SQL Database Write Methods:
                        Uplift admin jobs to use writesqldatabulk method.
                        (Merged PR 203)
                      • Clean up Adherence Subscription Channels:
                        Remove subscriptions from adherence websocket.
                        (Merged PR 215)

                      Improvements

                      • Add Look Back Span in WFM Schedule Data Job:
                        Added Look Back Span in WFM schedule data job.
                        (Merged PR 188)
                      • Adjust Lookback and Max Sync Span:
                        Changed lookback and max sync span for adherence, resolving Snowflake errors.
                        (Merged PR 199)
                      • Enhance Performance for Voice Topic Detail Data:
                        Improved performance for mvwconvvoicetopicdetaildata with indexing.
                        (Merged PR 221)
                      • Handle Multiple Executions in User Presence Data:
                        Updated check_and_update_userpresencedetaileddata to support multiple executions.
                        (Merged PR 213)
                      • Implement Mixed Patches Across Various Components:
                        Applied mixed patches for realtime, schedule, adherence, and vwqueuedetails.
                        (Merged PR 218)
                      • Update Fact Data Job:
                        Modified fact data job.
                        (Merged PR 206)
                      • Resolve Adherence Syncing Issues:
                        Addressed adherence syncing issues for actuals and exceptions.
                        (Merged PR 196)
                      • Fix Column Discrepancies:
                        Handled discrepancies in column data.
                        (Merged PR 197)
                      • Improve Logging for Interaction:
                        Updated logging for the interaction job.
                        (Merged PR 221)
                      • Update Job Minimum Definition for Snowflake:
                        Updated job minimum definition schema and defaults for Snowflake.
                        (Merged PR 221)
                      • Add Index to Voice Topic Detail Data:
                        Enhanced mvwconvvoicetopicdetaildata with an index.
                        (Merged PR 221)
                      • Clean Up User Queue Mapping:
                        Removed outdated entries in user queue mapping.
                        (Merged PR 201)

                      Bug Fixes

                      • Fix UserActivity Not Updating Table:
                        Resolved an issue where UserActivity job failed to update the table.
                        (Merged PR 202)
                      • Resolve Schema Errors:
                        Fixed schema errors.
                        (Merged PR 191)
                      • Fix Intermittent Realtime Errors:
                        Addressed intermittent errors in realtime processing.
                        (Merged PR 189)
                      • Remove Division Filtering from Presence Details Sync:
                        Removed Division Filtering from presence details synchronization.
                        (Merged PR 221)
                      • Resolve Duplicates in Job Minimum Definition:
                        Corrected duplicate entries in job minimum definition.
                        (Merged PR 221)
                      • Remove Truncate from User Presence Data:
                        Removed unnecessary truncation in user presencedetailed data.
                        (Merged PR 221)
                      • Handle Unhandled Websockets:
                        Resolved issues with unhandled websockets.
                        (Merged PR 217)
                      • Fix Removal of Schedule Data from vwadhday:
                        Corrected removal of schedule data from vwadhday.
                        (Merged PR 216)
                      5.0ss47.2