Not able to activate config datastore from node2 of a CCX HA setup.Insert Error: Column name or number of supplied values does not match table definition.

From DocWiki

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

Not able to activate config datastore from node2 of a CCX HA setup.Insert Error: Column name or number of supplied values does not match table definition

Problem Summary When trying to active UCCX 5.0(2) SR02 Historical & Configuration Datastores the following error is received.

"Unable to activate the component(s). Insert Error: Column name or number of supplied values does not match table definition.

Error Message Insert Error: Column name or number of supplied values does not match table definition.
Possible Cause There is some schema mismatch between the config tables between node1 and node2. Possibly there could be rowguid column present in some of the config tables. CDS activation will fail if there is schema mismatch in config tables between the primary and the secondary. If the CDS action fails, HDS activation also will fail. The reason for this issue is, customer might have setup custom replication for the db_cra database.
Recommended Action Remove custom replication. From the Enterprise Manager right click and select design table. Delete the additional column present [mostly rowguid column] from the config tables. Close the design and save the table. After removing the additional column from all the tables, activate config and historical datastore.
Release Release 7.0, Release 5.0
Associated CDETS # None

Rating: 0.0/5 (0 votes cast)

Personal tools