Error: F_JT0263 Pipe Sort Supplied Received Rows From Table

Issue

After removing a table from a channel, the following Capture error appears:

F_JT0263: Pipe Sort supplied received rows from table '<table>' but no options matching that table to specify which columns should be compared.

Environment

HVR 5

Resolution

The error message indicates there are still changes in the router directory for this table but the table has been removed from the HVR catalog. The table can be added back again, or it can be skipped by using the hvrcontrol command:

$ hvrcontrol -s -i -t <table1> -n <control_name> <hub> <channel>

The control can be removed later with this command:

$ hvrcontrol -D -i -n <control_name> <hub> <channel>

Follow the steps below to safely remove a table from a channel:

1. Suspend the capture job.
2. Wait for the integrate job to process all files present in the router directory (the integrate latency will be equal to the capture latency once HVR processed all the files in the router directory).
3. Suspend the integrate job.
4. Remove the table from the channel.
5. Re-initialize the jobs with the Table Enrollment and Scripts and Jobs options.
6. Resume the capture job.
7. Resume the integrate job.

Cause

This issue occurs when you incorrectly remove a table from a channel.