Error: F_JT0406: Scanner Encountered After Update before the Before Update Change Is Ready

Issue

The following errors appear:

F_JT0406: Scanner encountered 'after update' before the 'before update' change is ready.

F_JT140E: The previous error occurred during a update_after operation for table id 17 (dt_test1 [SCOTT.dt_test1] with base columns (id poln11 pol effdtec prodnu crdt compused updtprd updtflg update_ident) at sequence number 54878 in transaction 0xd65e from scanned record 39 which has journal receiver+sequence DBJRNTST.ACJRNR0033.54878 and timestamp 2019-03-22T11:50:01-04:00. To report this to Technical Support, first re-run the job as follows; “hvr -EZIZ_FILE_TRACE=1 -EHVR_EXPORT=ZIZ_FILE_TRACE $HVR_CONFIG/job/<hub>/<chn>/<chn>-cap-<loc> >f.out 2>&1” Check that the error in the file is still the same, and then send the following; (1) File f.out. (2) Enroll files matching *.enroll or *.enroll_rev_* in $HVR_CONFIG/router/<hub>/<chn>/loc_<loc> (3) All files mentioned in ZIZ_FILE_TRACE messages in file ‘f.out’. After saving these files, re-run the capture job to check the error and files mentioned in ZIZ_FILE_TRACE messages stay the same. hvralert: db2-cap-db2ix will be retried because ‘F_J’ matched retriable.pat[30] (retries so far=8).

Environment

• HVR 5
• Database DB2 for i

Resolution

To resolve this issue, do the following:

1. Review and apply the settings described in our requirements for DB2 for i documentation.
2. Set the IBM i table attribute IMAGES to *BOTH
   1. Run the following command on your AS400:

      DSPFD FILE(SCOTT.DT_TEST1)
      

   2. Scroll down to find the IMAGES attribute.
3. Run Initialize with Transaction Files and Capture Time, Table Enrollment, and Scripts and Jobs selected.
4. Run HVR Refresh for all tables in your channel.