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

Answer

1. First review all the appropriate settings described in the documentation:

   https://www.hvr-software.com/docs/Requirements_for_DB2_for_i

2. Next, run this command on your AS400 to check the value for IMAGES

   DSPFD FILE(SCOTT.DT_TEST1)

   then page down several times until you’ll see IMAGES.

   IBM i Table attribute IMAGES should be set to *BOTH

   

3. If the value for FIXLENDTA is not set, add FIXLENDTA(*SYSSEQ)

   

4. Logged in the HVR console as the HVR administrator (not the AS400 administrator) modify the action /Capture and set the /LogJournal=JRNTEST.DBJRNTST also check /LogJournalSysSeq. The command should look like this if you view the text

   /LogJournal="JRNTEST.DBJRNTST" /LogJournalSysSeq

   This should prevent future resets but currently, you need to recover from the reset setting,

   

5. Initialize: Next to recover from this, you’d need to run Initialize (hvrinit) with “Transaction Files and Capture Time”, ”Table Enrollment/Replace old Enrollment” and “Scripts and Jobs” selected

   

6. Followed by a Refresh for all tables in your channel.