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.