How to upgrade the Atea wallboard application (UAW)

Note1: The Wallboard application will be unavailable during the upgrade!
Note2: The 19.0.03+ releases are compiled for Java7 so that it is compatible on all servers!

  1. Download the latest UAW application: v24.0.01 (22 Mar 2024) saving it as a file named UccxStats.war (Google will send us your email address so we can give you access, and your software support must be up-to-date)
  2. Using a web browser, go to the tomcat admin - https://uawserver/manager/html (old vm access http://uawserver:8088/manager/html) The account to access this on recent builds is ursadmin
  3. Click on Undeploy of UccxStats
  4. Click on Choose file under WAR file to deploy. Browse to the downloaded file and click on Deploy
  5. Using putty or another ssh client, ssh to the uaw server with the thirdparty account and enter these commands:

sudo su -
cd /opt/tomcat_latest/webapps/UccxStats/WEB-INF/classes/scripts/upgrade/
sh updateApp.sh ATEA_UAW

Changelog

Version date Changes
24.0.01 22-Mar-2024 Changed
- added logging of stacktrace for addRealTimeStats
23.0.01 31-Aug-2023 Changed
- resized new agent icons to match old ones size
22.0.01 23-Mar-2022 Added
- Gos3 (calls-handled-met-sla / total calls) data source option for older template columns (T02-T17)
21.0.07 08-Sep-2021 Fixed
- GOS
Changed
- Replaced Agent state Icons with modern version
21.0.06 13-Aug-2021 Added
- Button on T98 dashboard to allow Audio threshold (if configured in JS)
Changed
- Sorting on query to uccx for GOS
- Loglevel to debug for GOS query results
21.0.05 24-Jun-2021 Fixed
- Fixed minor issue in migration script
- upgraded informix jdbc driver from 4.10.12 to 4.10.14
21.0.04 16-Mar-2021 Added
- Sound support for thresholds on T98 queue table
21.0.03 03-Feb-2021 Added
- Chat agent state/duration to T98 Agent Table widget for customers with chat service (from finesse/socialminer) enabled
21.0.02 26-Jan-2021 Fixed
- T98 Agent widgets failed to render on old browsers due to missing function
21.0.01 11-Jan-2021 Changed
- changed watchdog for realtime queue stats thread to detect if polling has stopped and restart the thread
20.0.10 24-Nov-2020 Fixed
- T98 Queue summary calculations for weighted values (eg GOS/ASA)
- T98 Admin Custom JS assistant was sending back incorrect character
updated query to get historical stats for callback queue
NOTE: Audible thresholds cannot be used anymore due to browsers blocking sounds if there is no user interaction
20.0.09 16-Nov-2020 Added
- Calls Out and Queues columns (optional) to T98 Agent Table widget
- T98 assistant for Custom JavaScript in UAW Admin for threshold configurations and Queue summarisation
20.0.08 13-Oct-2020 Added
- Ability to specify queue specific thresholds on T98 queue table widget
20.0.07 03-Oct-2020 Fixed
- T98 QueueTable Widget Thresholds
- SCM AGent calls handled
Changed - Disabled SCM Query from poller
20.0.06 02-Jul-2020 Note
- Minor code refactor
20.0.05 25-Jun-2020 Fixed
- Agent state duration websocket update
Changed - Disabled hsqldb for SCM
- Removed livedata
20.0.04 24-Apr-2020 Fixed
- Agent state for SCM
20.0.03 24-Mar-2020 Added
- T98 Agent Grid Widget
20.0.02 13-Mar-2020 Added
- T98 Calls Abandoned Not Met ServiceLevel Widget (& queues column)
- T98 Calls Abandonment Rate Not Met ServiceLevel Widget (& queues column)
Fixed
- agent calls handled query
20.0.01 25-Feb-2020 Added
- T98 Calls Abandoned Widget
Fixed
- jdbc connection (became stuck after uccx restart)
- hostname check for protected wallboards (via reverse proxy)
19.0.10 11-Oct-2019 Added
- T98 option to pivot the vertical queue table to horizontal w JS
Fixed
-T98 queue sorting
Changed
- T98 queue sorting syntax
19.0.09 20-Sep-2019 Added
- T98 TOTAL_SUMMARY (url & JS) for Queue Table - vertical, to show Summary Row at the end
- T98 SUMMARY_ONLY (url & JS) for Queue Table - vertical, to only show Summary Row
- T98 Sorting of Queue Table - vertical w/ JS config
- T98 Row thresholds on Agents table for compound State - Duration w/ JS config
19.0.08 16-Sep-2019 Changed
- replace websocket client library for better reliability
- updated links to admin guide for new website
Fixed
- Fixed grid_base#.css as it had a gap in the media query
- fixed web service reference where UAW Admin login failed to retrieve settings
19.0.07 30-Aug-2019 Changed
- replace websocket client library for better reliability
- Queries to get Agent CallsPresented and CallsHandled to match CUIC stored procedure queries
19.0.06 16-Aug-2019 Fixed
- upgrade script that did not get 19.x.xx version as latest from DB
- admin page where an error occurred "cant test scp enabled" on login due to web service reference change in 19.0.05 in combination with reverse proxy http-https redirect
- admin page wallboard links to open https
Changed
- set z-index on footer on T98 so that the links always work
19.0.05 02-Aug-2019 Changed
- T98 agent widget now includes Extension
- T98 layout settings in the browser are now stored per wallboard id instead of a shared set
19.0.04 17-July-2019 Fixed
- summary for T07 and T13
- ASA query to use correct field
- catch error on system admin page if wallboard or hruser have wrong password
Changed
- T98 queue widget now has ASA
- T98 queue widget summary can now have a class or style for each row
19.0.03 05-July-2019 Fixed
- duration for agents if it was over 24hours (invalid date) or over 12 hours (14:00:00 became 2:00:00)
Changed
- queue ASA/AHT query (moved away from StoredProcedure)
- agent Calls query (moved away from StoredProcedure)
- agent queue-abandoned-calls query (moved away from StoredProcedure)
- default grid size is 12 (12x12) for T98 (can be changed w/ JavaScript GRID_SIZE)
Added
- Abandoned calls rate widget on T98
- default layout for 12x12 grid in T98
- property to disable agent call details poll
19.0.02 25-June-2019 Fixed
- Agents-NR summary templates (T04,5,7,13)
Changed
- gos/agentcallsqueries changed and thread sleeptime (9 sec) removed queue column threshold colour to allow comma separated colours
- upgrade tomcat jdbc and informix jdbc libs
Added
- threshold object on queue widget T98
- column header object for T98
- query duration outputs for info level
- stop all threads in System Admin
19.0.01 21-May-2019 Fixed
- wallboard rotation fixed with proxy
Changed
- App compiled in Java8 for 19.x.xx
- T99 dashboard deprecated - use T98
Added
- iframe/message widgets to T98
2.2.23 05-Feb-2019 Fixed agent calls handled included direct calls, it now shows queue calls only
added CSQ summary logic for dashboard flex (T98), Queue Table - vertical
2.2.22 20-Nov-2018 Fixed issue in agent calls handled thread that may cause the thread to stop
added Copy Config for T98 to allow pre-configured layout in uaw admin
2.2.21 20-Sep-2018 Fixed agent call summary query
2.2.20 30-Aug-2018 Added tcp timeouts to inform jdbc connections
2.2.19 14-Aug-2018 Added Calls presented, Max/Avg Talk to Agent widget (T98 & T99)
Added Total and Dequeued calls to Queues-table-vertical widget (T98)
Added option to show/hide columns on Agent & Queues-table-vertical widgets (T98)
Changed Other thread to poll with fixed delay (to reduce UCCX CPU load)
Changed Other thread to have 1sec interval between individual queries (to reduce UCCX CPU load)
Updated Chart.js to latest version
Fixed issue where thread may stop when no agents are logged in
2.2.18 11-July-2018 Fixed empty agent name for import of logged out agents into the DB (requires manual removal post upgrade)
Changed - split up property so agent and other threads can be disabled
Added sort to agent names
2.2.17 7-June-2018 Fixed: Changed X-Forwarded-Server to X-Forwarded-Host to work with new apache proxy when host not in DNS
Added SCM3 datasources
2.2.16 21-May-2018 Fixed execute permissions for SCM trend graphs
Fixed websocket issue that wasn't updating after clicking Save Settings in system admin
Fixed SCM wallboard issue where logged out unregistered phone still appeared
Changed - Start using "changelog"
Changed System Admin - Latest Query Durations - Queue - Last Run to show last poll timestamp from UAW poller, as opposed to uccx rt snapshot
Changed Trend Graphs to graph MAX (instead of AVG)
Added Units for data sources
System Admin - added field to show Last UCCX Realtime Snapshot
Added four widgets for dashboard T98 (Grade Of Service Summary, Max Queue Depth, Oldest Queue Summary, Queue Table - vertical)
Added Font size increase/decrease on T98 (stored in localStorage)
Added Agents Talking to trend graphs
2.2.15 29-Sep-2017 Fixed enable/disable debug logs from system admin for logback
Included UccxStats.log and latest 0.log.gz in download link
2.2.14 29-Sep-2017 Fixed issue with poller if primary uccx is down and "use standby uccx" is set to false
Added check at startup to wait for first poll to finish
Added tz_offset for graphs on T98 & T99
Added configurable thresholds for T98 & T99 (queued & oldest, orange & red)
Added support for multiple email thresholds per datasource and use mm:ss as the format
2.2.13sr1 30-Aug-2017 Changed session timeout to 1min and added session=false on REST jsp's
2.2.13 29-Aug-2017 Changed session timeout to 1min and added session=false on REST jsp's
Fixed "smaller than" threshold
Fixed error deleting wallboard when editor was linked
Fixed error on saving system admin with regards to CacheManager
Added option to include logged out agents on templates
2.2.12 09-Aug-2017 Fixed ajax calls for server port
Added column IDs and agent sorting to T06
2.2.11 25-July-2017 Fixed issue where wallboard name could be added with empty name
Added support multiple TeamNames
Added DashBoardFlex (T98)
Added websocket for T99 & T98
2.2.10 19-May-2017 Added email alerting
2.2.09.sr10 16-May-2017 Added bootstrap4 templates for finesse and IE
2.2.09.sr9 18-Apr-2017 Changes to logging level - bean debug moved to trace
2.2.09.sr8 03-Apr-2017 Added bootstrap template
2.2.09.sr7 28-Mar-2017 Fixed string concat in logs, update to customer templates
2.2.09sr3 9-Mar-2017 Changed to logback logging. Fixed issue with agent alias being null
2.2.09sr1 6-Feb-2017 Added query timeout to uccx [prepared] statements
2.2.09 3-Feb-2017 Replace agent abandoned calls query with stored procedure
Fixed issue with [beta] LiveData agent state query which stopped on connection errors (i.e. failover)
Fixed Agent State from [beta] LiveData as the values are different and needed mapping
2.2.08beta4 23-Dec-2016 Added gadget.js for Finesse Adding application specific calls handled
2.2.08beta3 21-Dec-2016 Changed copyright year to script that outputs current year
Extracted javascript blocks to js/dashboard_main.js and js/dashboard_end.js
2.2.08beta2 27-Oct-2016 Fixed memory leak for cron4j & tomcat jdbc-pool
Outstanding known issue: memory leak for log4j FileWatcher (only affects tomcat if UccxStats is reloaded)
2.2.08beta1 26-Oct-2016 Added option to use LiveData REST interface to collect Agent State instead of HR DB Query (BETA!)
2.2.08 10-Oct-2016 Added HR max wait in T99 dashboard wait chart
Added Notify.wav to sounds
2.2.07sr5 20-Sep-2016 Fixed issue where board does not load when there is an empty javascript field
2.2.07sr4 19-Sep-2016 Changed query for agent missed calls to use Agent RNA ReasonCode 32763
changed T09 header to Missed
2.2.07sr3 13-Sep-2016 Added error handling for agent calls missed query due to error from Cisco Bug (CSCvb27878)
2.2.07sr2 09-Sep-2016 Added agentMissedCalls to T09
2.2.07sr1 08-Sep-2016 Added MomentJS lib to templates to enable a formatted date to be set on a wallboard via javascript
Added css classes on T05 & T09 to allow setting widths on queue columns (queueHead & queueData)
Added ntpstat output to system admin page
2.2.07 02-Sep-2016 Added option to use the standby uccx server for HR queries
2.2.06 29-Aug-2016 Added T16 template
2.2.05 09-Aug-2016 Fixed wallboard preview links
2.2.04 14-Jun-2016 Fixed issue with caching fields over multiple wallboards
2.2.03 07-Jun-2016 Fixed Apex front end with added links to open wallboard, fixed issue with font-format values caching between wallboards
2.2.02 17-Mar-2016 fixed no data found issues in popup module, added instruction dialogue for create wallboard
2.2.01hf1 25-Jan-2016 fixed CSS, added @media in the grid_base{x}.css to detect aspect ratio and apply a different column width
2.2.01 14-Jan-2016 fixed admin application where the link to manage queues failed
2.2.00 12-Jan-2016 Changed Theme of Admin pages
2.1.34 22-Dec-2015 changed landing page and system administration page layout
2.1.33hf5 19-Nov-2015 added expectedWaitTime to REST JSON
2.1.33hf4 3-Nov-2015 added Uccx state tracking to detect and log a state change
added Uccx state to System Admin page (and list last 10 events since wallboard uptime)
2.1.33hf3 21 Oct 2015 fixed percentAnswered to show 0% instead of NaN% when callsHandled is 0
2.1.33hf2 17 Sep 2015 changed SCM agent state poller to use agent_line_state view to allow CTI Line State
2.1.33hf1 31 Aug 2015 fixed memory database issue for daily stats that could stop poller
2.1.33 21 Aug 2015 added Beta-release supervisor Dashboard (requires HTML5 + canvas support see: support)