-
Titel
Activation fails with "Failed to parse horizontal partition scheme column condition" -
Beschreibung
When activating a config involving horizontal partitioning, it fails with the following error:
07/27/05 12:21 Config compilation completed: datasrc - o.SID; file <config_file>
07/27/05 12:21 Bad config file: file - config_file; Failed to parse horizontal partition scheme columncondition. Check event_log for details. (Scheme: partition_scheme_name) (Column condition: (<column condition clause> ))
-
Ursache
The column condition clause does not conform to the guidelines of Shareplex.
-
Lösung
For details on how to configure column conditions, refer to Shareplex Administrator Guide chapter titled "Preparing for Shareplex Replication" subsection titled "Supported conditional syntax." Correct the condition clause that does not conform to the syntax, commit the entry for shareplex_partition table in the database and activate the config.
-
Weitere Informationen
Some of the common reasons for seeing this error are:
Parenthesis used for separating condition clauses when using AND or OR do not match (more number of parenthesis on one side).
Use of format other than 'MMDDYYYYHH24MISS' for nls_date_format when specifying dates.
Improper use of quotes.
Improper use of conditional operators
Use of functions supported by Oracle but not by horizontal partitioning, for example, TO_DATE conversion function.
There could be a number of other reasons. The solution lies in correcting the syntax after analyzing the clause. For the most part Shareplex guidelines are in conformity with Oracle when it comes to formulating a conditional clause with minor exceptions which are clearly laid out in the Admin Guide section.