In the Appadmin DB control center node 2 data store is not present in an HA setup

From DocWiki

Revision as of 10:47, 4 May 2010 by Jayark (Talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

In the Appadmin DB control center node 2 data store is not present in an HA setup

Problem Summary In the Appadmin- >DB control center node 2 data store is not present in an HA setup.

It has the following error. "Error occurred while performing the operation. The cluster information and subscriber configuration does not match. The subscriber might be dropped. (Please check SQL server logs for more details.

Error Message java.sql.SQLException: The Subscriber information could not be obtained

from the Distributor., SQLException Details: [SQLException] (ErrorMsg=The Subscriber information could not be Obtained from the Distributor. SQLState=S1000, SQLErr#=14085)

Possible Cause Some subscription related entries are missing in the distribution database.
Recommended Action Deactivate node2 datastore components from Appadmin control center.

Clean all the system tables starting with sysmerge from the datastore whose replication has been broken. Drop node1 distribution database. For that right click the node1\CRSQL from SQL Enterprise Manager and choose properties. Select replication tab. Click disable. This will drop the distribution database in node1 database. Create distribution database in node1 by executing exec craAddLocalDistributor 1 from SQL Query Analyzer by selecting db_cra database. Activate node2 datastore components from node2 appadmin control center.

Release Release 7.0, Release 5.0
Associated CDETS # None

Rating: 0.0/5 (0 votes cast)

Personal tools