Error: F_JT0263: Pipe Sort Supplied Received Rows From Table but No Options Matching That Table To Specify Which Columns Should Be Compared

Issue

The following error appears:

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

Environment

HVR 6

Resolution

This error message indicates that the integrate job failed while processing changes to the table referenced in the error because it couldn't map the table to a table in your HVR repository.

To resolve this issue, skip all changes for the applicable table in the channel by logging into the hub machine and running the following command: hvrcontrol -s -i -t <table_name> -n skip_<table_name> <hub_name> <channel_name>

Alternatively, you can log into a remote machine and skip the changes by running the following commands:

• hvrlogin -R <hub_url> -u <username>
• hvrcontrol -s -i -t <table_name> -n skip_<table_name> -x0 -R <hub_url> <hub_name> <channel_name>

After the first successful integrate cycle, the control file will be removed automatically, allowing you to re-add the table to the channel.

To prevent this issue from occurring again, suspend the capture job and wait for the integrate job to drain out the router folder before you remove, rename, or move the table.

Cause

This issue occurs when a table is removed from the channel, or the table was renamed while the channel still had changes buffered for the table on the hub machine.