Job Runs Notes are not purged from data files

Document ID : KB000084846
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
Error Message :
N/A

Adding notes to jobs in UVC ("Open Notes") adds lines to the file u_fmrn60.dta. However, these notes are not purged when the job execution is purged. 

The file u_fmrn60.dta keeps growing when notes are used intensively. There is no possibility to delete notes by age with the uxdlt note command.

Investigation
  • Create a note in a job and note the NUPR of the job
  • Wait until the job is purged according to retention criteria (reduce the retention to 1 hour or less in order to reproduce the issue quickly).
  • Check u_fmrn60.dta: the note with that NUPR is still there when the job is purged
Environment:
OS: All
Cause:
Cause type:
Defect
Root Cause: No purge is applied
Resolution:
Update to a fix version listed below or a newer version if available.

Fix Status: Released

Fix Version(s):
Component(s): Application Server

Dollar Universe 6.9.21 - Available
Additional Information:
Workaround :
Reinitialize u_fmrn60.dta when opening notes becomes slow.

On Windows:
  1. Load the DUAS environment
<DUAS_FOLDER>\unienv
  1. Stop the node
%UNI_DIR_EXEC%\unistop
  1. Reinitialize the file
%UNI_DIR_EXEC%\uxrazfic u_fmrn60 X
(I|S|A for another area)
  1. Restart the node
%UNI_DIR_EXEC%\unistart

On Unix:
  1. Load the DUAS environment
. <DUAS>/unienv.ksh
  1. Stop the node
$UNI_DIR_EXEC/unistop
  1. Reinitialize the file
$UNI_DIR_EXEC/uxrazfic u_fmrn60 X
(I|S|A for another area)
  1. Restart the node
$UNI_DIR_EXEC/unistart