The following errors are observed when activating a config file that has Horizontal Partitioning:
Error 2014-11-18 16:58:01.790000 4060 4388 Activation: Error, column "COLUMN_NAME" not found in table OWNER.TABLE_NAME (activating sid SID1) [module osp]
Error 2014-11-18 16:58:01.805000 4060 4388 Activation: lookup failed for column ' COLUMN_NAME ' (activating sid SID1) [module hpp]
Correct the entry for column name in COL_CONDITIONS column of the Shareplex internal table SHAREPLEX_PARTITION for the table in question and activate again.
There are two main reasons for seeing this error:
There is a typo in the column name
The same PARTITION_SCHEME is used for multiple tables thereby the column used in COL_CONDITIONS (for specifying the column condition) for one table may not exist in another one. Never use the same value for PARTITION_SCHEME for more than one table. In other words, the value in the field PARTITION_SCHEME is unique and should be associated with one table only.
