Error: F_JR0549: Unable to Find ColumnProperties

Issue

While trying to run Initialize on a channel with SAP HANA capture configured, the following error appears:

F_JR0549: Unable to find ColumnProperties /SurrogateKey column 'hvr_rowid' of table 'customer' in channel 'HANA 2sql', location 'HANA '.

Environment

• HVR 5

Resolution

It is not possible to enable supplemental logging on HANA. As a result, the key values are unavailable to HVR during capture. The above error occurs when HVR expects more details in the channel for it to know how to map the source row ID into what will be used as the surrogate key to identify the row on the target.

Initialize expects hvr_rowid to be a column on the target location. On the source, HVR will capture values for this extra column from a "hidden" row ID column and replicate them to the target.

Prior to using Table Explore, you can instruct HVR to capture row ID values and use them as surrogate replication keys by doing the following:

• Define the ColumnProperties /Name=hvr_rowid /CaptureFromRowId action for capture locations only.
• Define the ColumnProperties /Name=hvr_rowid /SurrogateKey action for both capture and integrate locations.

Note: the error appears in Initialize if you have added the tables to the channel with Table Explore before adding these parameters. Instead, add the ColumnProperties settings first. See our HANA requirements for more information.