Errors “Activation: Replication of sequences is disabled Skipping” (4301843)

Errors “Activation: Replication of sequences is disabled Skipping”

The following errors are observed when activating a config containing sequences:

Warning  2016-08-25 17:31:14.029566 24228 1 Activation: Replication of sequences  is disabled. Skipping ("OWNER"."SEQUENCE_NAME")  (activating sid source_SID) [module ocf]

The sequence replication has inadvertently been disabled.

The parameter SP_OCT_REPLICATE_SEQUENCES has been set to 0 on source. To correct the problem, set it to 1, bounce Capture and then activate afresh:

sp_ctrl>set param SP_OCT_REPLICATE_SEQUENCES 1

sp_ctrl>stop capture  (make sure it is “stopped by user” and not “stopping”. In case of latter wait till it is stopped by user)

sp_ctrl>start capture

The activate the config once again.

The parameter has been introduced in recent versions of SharePlex so users may sometimes turn it off to prevent replication of sequences and it needs to be turned on for enabling the sequence replication prior to activating a config. In older versions of SharePlex the sequences could be brought into replication anytime by activating a config file containing sequences without worrying about setting such type of parameter first.