Return
-
Title
Process Request tab is not showing the correct information for my CSR including the update timestamp -
Description
The wrong migration tasks are a showing incorrect information in the process request tab. I am seeing migrations for my CSR that do not include the objects on my CSR. The dates are showing 2013 when I just did a migration yesterday. The objects showing that was migrated are from other CSRs. -
Resolution
WORKAROUND:
1. If you are running Stat 5.7.4 then do this:
a. Take a good back-up of your stat db
b. Download Stat 5.7.4 hf-d and apply the hotfx
c. Run this dml statement:
UPDATE MERC_OA_DETAIL SET DETAIL_VALUE1 = '0' WHERE DETAIL_TYPE='MID'AND UPDATE_DT < (SELECT MIN(RUN_DT) FROM STAT_DBSCRIPT_TBL WHERE STAT_VERSION LIKE '5.7%')2. If you are running Stat 5.8.0 then do this:a. Take a good back-up of your stat dbb. Run this dml statement:UPDATE MERC_OA_DETAIL SET DETAIL_VALUE1 = '0' WHERE DETAIL_TYPE='MID'AND UPDATE_DT < (SELECT MIN(RUN_DT) FROM STAT_DBSCRIPT_TBL WHERE STAT_VERSION LIKE '5.7%')