-
Title
The “activate config” results in “Activation: Horizontal partitioning scheme is not defined. Skipping” -
Description
When activating a config involving Horizontal Partitioning, the following errors are observed:
sp_ctrl (alvsupl14:9006)> activate config hpconfig
Not all tables activated successfully
The event log shows the error “Horizontal partitioning scheme is not defined” for that table defied to replicate in horizontal partitioned manner:
sp_ctrl (alvsupl14:9006)> show log reverse
Info 2017-10-05 18:26:50.476670 28023 553829648 Activation of "hpconfig", actid 20, for database o.ORA11GR2 complete
Info 2017-10-05 18:26:50.476436 28023 553829648 Compile of "hpconfig" for database o.ORA11GR2: Not all tables activated successfully
Warning 2017-10-05 18:26:49.751655 28023 553829648 Activation: Horizontal partitioning scheme is not defined. Skipping ("PAUL9006"."TABLE1A") (activating datasource o.ORA11GR2) [module ocf]
Info 2017-10-05 18:26:48.518193 28023 3520729568 Activation launched, pid = 28023 (activating datasource o.ORA11GR2)
Notice 2017-10-05 18:26:48.515405 27947 3393449408 User command: paul activate config hpconfig (from alvsupl14.prod.quest.corp)
Here is the config file:
sp_ctrl (alvsupl14:9006)> view config hpconfig
datasource:o.ORA11GR2
#source tables target tables routing map
paul9006.table1a sha90.table1a !scheme1
! alvsupu16:queue1@o.ORA11GR2
! alvsupu16:queue2@o.ORA11GR2
paul9006.table1 sha90.table1 alvsupu16@o.ORA11GR2
-
Cause
As the error message implies, there is no partition scheme defined for the table that is configured to replicate in a horizontally partitioned manner. -
Resolution
To resolve the issue:
1. Create partition schemes for that table configured to replicate in a horizontally partitioned manner.
2. Activate the config file or its copy once again.
-
Additional Information
For details on configuring a horizontal partition replication, refer to SharePlex Administrator Guide.