Unable to repost the Intraday files

Unable to repost the Intraday files

Problem Description:
Intraday file processing works fine with the real time interval files but reposting the previous day interval files does not work.
Problem Analysis:
Processing the previous day Intraday files did not work and the data did not get modified in WFM. Enabled the below log which captured the reason for the file not processing.
File name: logback-swxiface-ext.xml
Path: Drive:\totalview\inst\tv4\JBoss\swxiface
Search for "Re-posting allowed" and enable the below log. 
    <logger name="com.iex.tv.integrations.swxiface.inserter.QueueStatsReprocessing" level="info" />

Try reposting a previous day Intraday file and we can see the below highlighted log stated that "Not allowed to re-post"
[t.i.s.i.QueueStatsReprocessing] Not allowed to re-post; QueueStatsReprocessing feature: enabled=false value=1
 
As the old date data was showing incorrect or showing zero or missing some slot stats. The only process available is to repost the Queue Data via QueueStatsReprocessing.

RootCause:
When checking the R_FEATURES table, identified that the feature is disabled due to which the Intraday re-posting for the previous days did not work.

Resolution:

1. Login to application server and open msys.exe as administrator.

2. Connect to customer1 DB.

3. Use below query to check the C_Enabled, C_Value and C_maxvalue present under r_features table.

         Query: - select * from r_features where c_feature='QueueStatsReprocessing';

4. If C_Enabled is F (False), update the value to T (True).

                  update r_features set C_Enabled='T' where c_feature='QueueStatsReprocessing' ;

5. Ensure to check the C_Value, since it is set for past date and calculate the numbers of days from present day.

Like if C_value is set for 30 days then we can process historical file which is 30 days older from today’s date.

Query: - update r_features set C_Value='40' where c_feature='QueueStatsReprocessing' ;

             update r_features set C_maxvalue='40' where c_feature='QueueStatsReprocessing';

6. Now restart swxiface node with customer permission.

7. After restart start processing the older historical files. after successful processing of file you will see data on intraday screen on past date for which stats were missing.