Service Operations Insight

Tech Tip: HOTFIX for mapping of existing data after upgrade to CCC 2.9.4 in connection with ‘CLUSTER_ID issue with VMware DB Data Adapter (DE224760)’ 

Nov 07, 2016 09:22 AM

From the CCC 2.9.4 Release Notes: In VMware, multiple VM clusters residing on different vCenters did not necessarily have a unique ID. As a result, in earlier releases, when pulling data from different vCenters, the cluster information from the first vCenter was overwritten by the cluster information from the second vCenter, because, both having the same ID, they were treated as the same entity in CCC. This issue has been fixed in this release by using the vCenter name and the cluster ID to form a unique cluster ID.

 

Problem: After upgrading to CCC 2.9.4 from an earlier release, you need to map your existing cluster data (fetched using the VMware DB data adapter) to the new cluster naming method.

 

Solution: Execute the attached database script as the CCC DB user via a database client, such as Oracle SQL Developer.

  1. In the VMware DB data adapter, enable the cluster metric collection functionality by selecting the Cluster Check box while creating or editing the VMware DB data source.
  2. Use the VMware DB data adapter to load and migrate the data.
  3. Open the DB client.
  4. Log on as the CCC DB user and establish a connection.
  5. Execute the attached script.

 

Note: The script should be executed only once.

Statistics
0 Favorited
1 Views
1 Files
0 Shares
0 Downloads
Attachment(s)
zip file
Script.zip   607 B   1 version
Uploaded - May 29, 2019

Tags and Keywords

Comments

Apr 21, 2017 01:34 PM

Yes.  It worked.

 

David DuPre'

Principal Services Consultant

mobile: +1-404-617-3023

David.Dupre@ca.com<mailto:David.Dupre@ca.com>

 

 

 

Out of Office Alert: April 28 – May 7, 2017

Apr 21, 2017 11:15 AM

Yep, that means it ran.

>KIP

 

Kip Lamb

Sr Principal Consultant, Presales

CA Technologies | Bellevue, WA 98005

Office: +1 512 776 0235 | Mobile: +1 425 591 4358 | Kip.Lamb@ca.com

<mailto:Kip.Lamb@ca.com>[cid:image003.jpg@01D2BA77.61097510][cid:image002.png@01D0928A.5E056B60]

 

<http://www.ca.com/us/default.aspx>

<http://www.ca.com/us/default.aspx>

Apr 21, 2017 09:57 AM

Hi dupda03, biecl01

 

I ran the script and got this output

 

"anonymous block completed"

 

Does that mean all is well?

 

Regards

David

Apr 21, 2017 09:53 AM

Thanks David

 

I will get right on it.

 

Regards

David

Apr 21, 2017 09:39 AM

David T,

  It can be done any time because it is about repairing the old Cluster names in the data-warehouse.  There will be data in the past still pointing at the old cluster names, this step will upgrade them to so the old cluster names will not show up anymore.

 

Cluster names will all have two parts,

David D.

Apr 21, 2017 09:24 AM

Hi Guys biecl01

 

Any update on my previous question?

 

I would like to execute this script but I want to be sure when should I do it.

 

Regards

David

Feb 01, 2017 02:56 AM

Hi

 

Can this be done at any time or must it be done specifically after all data has been migrated to the DATA Tables.

 

And must it be done before the rollups have run.

 

Regards

David

Related Entries and Links

No Related Resource entered.