Customer observed that the autoadd feature does not work for sequences from secondary to primary in a High Availability replication environment when the sequences are instantiated from primary despite the setting of the parameters SP_OCT_REPLICATE_SEQUENCES, SP_OCT_AUTOADD_ENABLE and SP_OCT_AUTOADD_SEQ set to 1 on both nodes. These parameters are designed to replicate the creation and subsequent replication of sequences from source to target if they conform to the wildcard specifications. In contrast, the autoadd of tables works fine in a High Availability environment. As a result the customer needs to once again activate the config pointing from secondary to primary to bring the sequences that have already been created and conform to the wildcard specs.
Software bug.
In High Availability replication environment, the autoadd of sequences does not work from second node to the first node when the sequences on secondary are created due to instantiation of sequences from primary by way of autoadd. This is a bug and it would be addressed in SharePlex version 9.2. The reference # for the bug are SPO-14779 and SPO-10081.
To get around this, users need to activate such sequences manually from the HA side to primary side for now.
