12.1.08: Service Pack 8

Previously, the work hour and clock hour totals in the data mart trend report were being incorrectly calculated by the incremental load data mart stored procedures for the Ticket Item data marts. To fix issue, a change has been made to the procedure templates.

When the data mart stored procedure templates are changed by an upgrade, a full recalculation of all data marts is triggered. After the upgrade is complete and the Tomcat is restarted, Service Analytics recalculates a full load for all Ticket Item data marts. Because of this, the SQL server insert activity will be busy until all the Full Load with Schedule update tasks in the Data Mart Request Queue are completed.

You can inspect the queue by using the following SQL query:

select c.cntnr_external_name, 
c.item_external_name_en_US, 
v.data_mart_rqst_type_name, 
data_mart_rqst_state_name, 
c.item_defn_id,
v.data_mart_rqst_queue_id
from fpscdb001_system.
v_data_mart_rqst_queue v
join fpscdb001_system.v_cntnr_item_active 
c on c.item_defn_id = v.item_defn_id;

In due course, the queue will only show one or two incremental load tasks or it will appear empty because an incremental load happens quickly. After the task is processed, it is removed from the queue in a few seconds after the insert. The technical support can use the query to diagnose and fix the data mart errors.

The systems that contain a large number of tickets might experience an overall slowness during the recalculation. Also, the Service Analytics data will be unavailable for some items until the recalculation is complete.