Troubleshooting WebSphere Commerce Analyzer: CHECK_REFERENCE fails due to a missing value

You may receive the following warning message during replication or ETL:

IWD3230E: Parameter value(s) xx are not registered in Reference table WCA.xx.xxx.xxx.

Although the warning message says the value is not registered, WebSphere Commerce Analyzer automatically registers the value, but with NULL (empty) descriptions. If you would like more meaningful descriptions to display, add the missing values to the table by updating the Reference_Table.properties file and load it into the data mart. Refer to Maintaining reference texts for more information.