Error: F_JT0492 Multiple Describe Tags Have Differing Column Names

Issue

During the Integrate process, the job fails with the following error:

F_JT0492: Multiple describe tags for table '<table>' have differing column names.

Environment

• HVR 6
• Target: All supported relational databases and messaging platforms

Resolution

To resolve this issue, reduce the CycleByteLimit parameter to process router files in smaller batches. This allows HVR to process files containing different table structures in separate integrate cycles.

1. In the HVR UI or CLI, locate the CycleByteLimit parameter for the target location.
2. Set CycleByteLimit to 1000000 (1 MB).
3. Activate the channel for the target location with the Jobs option selected.
4. Allow the integrate job to run.
5. If the error persists, set CycleByteLimit to 100000 (100 KB), reactivate the channel, and allow the job to run again.
6. If the error still persists, set CycleByteLimit to 1, reactivate the channel, and allow the job to run again.
7. After the integrate job processes the backlog beyond the schema change, remove the custom CycleByteLimit setting or restore the default value of 100000000 (100 MB).
8. Activate the channel with the Jobs option selected to resume standard batch processing.

Alternative resolution

Alternatively, use hvrcontrol to skip the affected table:

hvrcontrol -l <location name> -s -t <table name> -x0 <hubname> <channel name>

Cause

This issue occurs when HVR processes router files containing different versions of a table structure in the same integrate cycle. This can happen after a DDL schema change or table re-enrollment. The integrate job can't reconcile the conflicting column definitions.