Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
hi, Iam using multimaster replication for 2 sites with 4 master groups. I tried to update a table by adding a new column in one master group. I clicked the submit stop request button in OEM to stop the replication activity of this group, then I updated the table when the status of group was showing "Quesing".
Question: Update should be done only when the status is shown as "Quiesced" ?
There were no errors reported after updating the table through OEM. The Status field shows as "Valid" and the Generation Status shows as "Generated" for the updated table.
Problem: When I crosschecked the table at both the sites, the new column is not added. And now the errors which i mentioned earlier are displayed. And the replication job is also broken due to this there are more transactions waiting to be propagated.
Question: How to solve this problem? and how to register the propagator.