After installing ITNM 42 Fixpack 3 the status of discovery is not properly displayed on Jazz server
After installing ITNM 42 Fixpack 3 , login to Jazz server, and go to Discovery->Network Discovery Status "Downloading discovery Status" take forever, and it's impossible to run a full discovery , even though ncp_disco process is up and running
The error present into $GUI_HOME/precision_gui/profile/logs/tnm/ncp_disco.0.log is:
com.micromuse.precision.disco.action.DiscoStatusAction.execute INFO: DiscoStatusAction.execute => Service settings for ncp_d_helpserv does not exist on ncp database on domain
There is a change to the DB schema which must be done upon the FP3 upgrade. The behavior is caused by missing of column 'hostname' from table ncpgui.ctrlServiceData
As a workaround , make sure the file update-4.2-fp3.sql exists into $NCHOME/precision/scripts/sql/updates/db2 (or $NCHOME/precision/scripts/sql/updates/oracle if you're using oracle database) and run:
$NCHOME/precision/bin/ncp_perl $NCHOME/precision/scripts/sql/update_db_schemas.pl -domain DOMAIN_NAME