Error: F_JT044C: Warning: HVR Encountered Change to Table

Issue

Why do I see the following error:

F_JT044C: Warning: HVR encountered change to table <table> in transaction id <id> but it did not see the corresponding 'begin transaction' record.

Environment

HVR 5

Resolution

After a restart, HVR's capture will revisit the oldest open transaction. In an effort to avoid high latency during this process, HVR's capture holds the concept of expiring transactions. A transaction expires for one of two reasons:

1. It is open for at least three hours and has no changes to replicated tables contained inside.
2. The transaction is open for at least three days, even if it has replicated transactions contained inside. A warning will appear in this event.

Cause

The above error occurs when a transaction that has expired due to being open for at least three hours has a change to a replicated table. Despite the above error, HVR will still replicate the changes.