DX NetOps

If you ever delete an RA box as a data source in NPC, it might not actually tell RA. Consequently, RA might still think it's tied to an NPC. If/when you try to re-add it to the same or a different NPC, you'll get a message saying, 'this data source is already connected to an npc' or something like that.

To fix this, you'll need to tell RA that it's not connected to an NPC.
[list=1]
[*]On the RA server go to http://localhost/reporterdatasource/productsyncws.asmx?op=UnregisterPerformanceCenter
[*]Click the invoke button on the page that comes up.
[list]
There are probably similar web services for each of the products. If you find yourself having to do this, please post that here. If everybody has the problem it might indicate a bug in the npc delete datasources method.

Here it is for all the products:

ReporterAnalyzer: http://localhost/reporterdatasource/productsyncws.asmx
NetVoyant: http://localhost/pollerwebservice/productsyncws.asmx
UCMonitor: http://localhost/VoIPMonitorWebService/ProductSyncWS.asmx
EM: http://localhost/EventManager/ProductSyncWS.asmx?op=UnregisterPerformanceCenter
You may need an IISReset after this.
Alternate method on CAPC:
mysql -P 3308 -D em -e "DELETE from general where Attribute LIKE ‘%NPC.%’;"
/etc/init.d/caperfcenter_eventmanager restart
SuperAgent: http://localhost/superagentdatasource/productsyncws.asmx
It seems there was an issue with superagent unbind that did not clear out all the database entries. At superagent console cmd prompt:
Mysql -P3308 super -e "delete from parameter_descriptions where level='ProductSync'"
Spectrum: Launch the OneClick web page and select the administration tab. On the left select the Performance Center Integration Configuration. Select the option “Disable”. Re-start tomcat services and try to add the data source.
If that doesn't work:
[list=1]
[*]Start -> Run: 'bash-login' (Open bash prompt)
[*]> Cd mysql / bin (Go to the $ SPECROOT / mysql / bin directory)
[*]>. / Mysql-uroot-proot
[*]At mysql> drop database netqos_integ;
[*]Then, restart Tomcat Spectrum service.
[*]Then try to add the data source again to CAPC / NPC.[list]

eHealth
For a distributed eHealth environment run the following command on the distributed eHealth console:
./nhNpcSetup -clear
Now try re-adding the eHealth datasource to NPC.
For standalone eHealth environments, execute the query below to clear the NPC config from the eHealth DB:
$NH_HOME/bin/sys/nhisql "delete from nh_metadata where subject_area='NPC'"
If the change doesn’t immediately allow for the datasource to be re-added, try the steps below to get it going.
[list=1][*]Bring down the ehealth web, httpd and tomcat. (maybe something is caching the value)
[*]Re-check to make sure there are still no NPC values in that table.
[*]Bring back up the ehealth web, httpd and tomcat.
[*]Try to join npc to ehealth again. [list]
Alternate method:
[list=1][*]Log into Oracle SQL developer
[*]Expand “Tables”
[*]Select the NH_METADATA table from the tree on the left hand side
[*]In the right hand panel select the “Data” tab
[*]Use the shift key to multi-select the 5 entries that have “NPC” in the SUBJECT AREA field
[*]Hit the “Red X” at the top of the page to “Delete Selected Rows”
[*]Hit the “Green Check Mark” to “Commit Changes” [list]

Stuart_Weenig wrote:

EM: http://localhost/EventManager/ProductSyncWS.asmx?op=UnregisterPerformanceCenter

Hi Stuart,

Do you know what it is for the EventManager that ships with IM 2.0?

Thanks.

Sorry, I don't. IM2.0 (which is a bundle of CAPC (which in itself contains EM), CAPM, CA Spectrum, and CA NFA) uses RESTful web services, which are a whole different animal than the ASP web services used in the legacy NetQoS products. However, since EM is installed with CAPC on the same box during the install, how would you have destroyed an unregistered EM without also destroying the CAPC?

Stuart_Weenig wrote:

Sorry, I don't. IM2.0 (which is a bundle of CAPC (which in itself contains EM), CAPM, CA Spectrum, and CA NFA) uses RESTful web services, which are a whole different animal than the ASP web services used in the legacy NetQoS products. However, since EM is installed with CAPC on the same box during the install, how would you have destroyed an unregistered EM without also destroying the CAPC?

Excellent question!

I've been practicing in the lab uninstalling and restoring all of the components of IM 2.0. Everything has gone smoothly except for the Performance Center. After I restore the mysql backup for the PC, the list of Data Sources is empty which is accurate per the state of the PC when I created the backup. However, as you noted, the EM is automatically installed and registered during the installation -- I'm just not seeing it since per the backup it doesn't exist. When I then try to add the EM I get the error message saying the EM is already registered with another PC.

My workaround has been to remove the EM after the reinstall but before restoring the mysql backup. Afterward I can then login and add all of the data sources including the EM.

And just in case this follow-up question is asked, I have tested leaving the EM as a data source when creating the backup. The result in this case is the EM showing "Synchronization Failure" after restoring the backup. A resync doesn't fix it, and trying to remove and add the EM results in the same error as stated above.

Yeah, I would backup the CAPC database and the EM database, reinstall both, then restore both, then readd as a data source. I got lost in your process so you may have tried that. If you did, does it allow you to add EM as a data source then?

Stuart_Weenig wrote:

... backup the CAPC database and the EM database, reinstall both, then restore both ...

Okay, the EM database was the piece I was missing. The IM 2.0 PC Install Guide (chapter 7 section "Create a Backup Archive") only makes mention of the 'netqosportal' database, it does not mention the 'em' database.

The issue I described does not present itself if both the 'netqosportal' database and 'em' database are restored.

Thanks Stuart.

This is the unregistering for UCMonitor
http://localhost/VoIPMonitorWebService/ProductSyncWS.asmx

Are there similar commands for Spectrum and eHealth?

Regards
Kurt

Unregister eHealth from NPC Manually
For a distributed eHealth environment run the following command on the distributed eHealth console:
./nhNpcSetup -clear

Now try re-adding the eHealth datasource to NPC.
For standalone eHealth environments, execute the query below to clear the NPC config from the eHealth DB:
$NH_HOME/bin/sys/nhisql "delete from nh_metadata where subject_area='NPC'"

-----------------------------------------------------------------------------------------------------------------------------------------

Steps for Spectrum

Launch the OneClick web page and select the administration tab. On the left select the Performance Center Integration Configuration
Select the option “Disable”.Re-start tomcat services and try to add the data source.

I've updated my original post to include the UCMonitor and Spectrum instructions. Looks like a good candidate for a sticky/wiki.

For what it is worth.
Anomaly Detector
http://localhost/anomalydetector/ProductSyncWS.asmx

At the bottom of the page click the UnregisterPerformanceCenter link.
Now just click the 'Invoke' button on the next page.
A new window will open which can be closed after it is finished loading.
Finish it up with an 'iisreset'.

Already in the original post (although the original post links directly to the operation instead of requiring another click to get to the operation). I'll add the IIS reset info.

As I am reading, you recomend to delete the Data Sources before you uninstall PC, okay so I've got a problem here.

I have installed IM 2.3.1, and I want to reinstall the whole thing, but before a reinstallation I need to remove the DataSources, but when I try to delete the Data Sources from CAPC, the button Delete is in color gray so I cannot, any ideas how to do it? so I can reinstall the whole IM 2.x.x
 

Ah and by the way the Data Sources I've got integrated are:

Spectrum

NFA

Data Aggregator

and EM (which comes along with CAPC)
 

Check the profile for admin. Deleting data sources is not enabled by default. You have to add it to the admin profile.

Awesome mk9999!

It worked, now they say Deleting, thank you a lot.