Fix bulk-materialization problems that occur during the definition, activation, and validation phases based on the status returned by check subscription.
Status at Replicate Replication Server |
Status at Primary Replication Server |
Subscription State |
Suggested Actions |
---|---|---|---|
Defined/ Pending |
Invalid |
Waiting for other subscriptions for the same replication definition and replicate database. |
Look for other subscriptions for the same replication definition and database. If there are no other subscriptions, wait for five minutes. |
Defined/ Recovering |
Invalid |
Cannot connect to the primary Replication Server to define the subscription. |
Check the replicate Replication Server error log for messages. Make sure the user creating the subscription has the same login name and password at the primary Replication Server and the replicate Replication Server. |
Defined |
Defined |
Definition cycle is complete. |
Activate the subscription. |
Status at Replicate Replication Server |
Status at Primary Replication Server |
Subscription State |
Suggested Actions |
---|---|---|---|
Activating/ Recovering |
Defined |
Cannot send the activation request to the primary Replication Server. |
Verify that the primary Replication Server is running and the Stable Queue Manager (SQM), Stable Queue Transaction (SQT), and Distributor (DIST) threads for the primary database are running. Check the error log in the replicate Replication Server. Investigate whether the primary Replication Server has run out of segments. |
Activating |
Active |
The primary Replication Server received the activation request and returned it to the replicate Replication Server. The replicate Replication Server is waiting for the activation request. |
Verify the connection between the primary Replication Server and the replicate Replication Server. Verify that the Data Server Interface (DSI) thread for the replicate database is running. |
Active |
Active |
The activation stage is complete. |
Validate the subscription. If you specified the with suspension option for the activate subscription command, you may now load the replicate database. |
Status at Replicate Replication Server |
Status at Primary Replication Server |
Subscription State |
Suggested Actions |
---|---|---|---|
Validating/ Recovering |
Active |
Cannot send the validation request to the primary Replication Server. |
Verify that the primary Replication Server is running. |
Validating |
Valid |
The primary Replication Server received the validation request. The replicate Replication Server is waiting for the validation request. |
Verify the route between the primary and replicate Replication Server. Verify the DSI is running. Verify that the replicate Replication Server has sufficient queue segments. |
Valid |
Valid |
Complete. |
None. |