Error: F_JG221C: Pipe ‘Project’ Received Tag! Bytes (3) Which It Does Not Support
Issue
When running the hvrrouterview command to get the contents of a transaction file that is journaled, the following error appears:
F_JG221C when running hvrrouterview command to get the contents of transaction file that is journaled.
Environment
HVR 5
Resolution
To resolve this issue, do the following:
- Run the following hvrrouterview command to display the contents of all the transaction files for table replication:
hvrrouterview -j -bnow-3600 <hub username\>/<hub password\> <channel name\> - Run the following command to view the contents of the specific transaction files:
hvrrouterview hvrhub4/hvrhub4 chn1 5c33d6ab_d29bf_n1_t5c33d6bc_w5c33d6aa_zRsfn.tx_sql2
SQL Server
If tpcc is the SQL server database, bidb is the hub database in SQL server, or chn1 is the channel name, use the following command:
hvrrouterview -j -x\tpcc -u<username for tpcc db>/<Password for tpcc db> bidb chn1
Cause
This error occurs if an incorrect option is passed for the hvrrouterview command while reading the contents of the transaction file.
Usually, this error is seen when --F is used to read the contents of the transaction file for channel replication database tables.
For example, the following command will trigger the error: hvrrouterview -F -j -bnow-3600 hvrhub4/hvrhub4 chn1. In this example, chn1 is a table replication channel and --F (valid for file (blob)replication) is used.