When notice probe is not able to connect to the HP Universal CMDB (ucmdb) server and uCMDB 10.01 server UI shows probe status as disconnected is encountered.
First step to take is to review the probe log. Within the log, you should be able to find the following standard error related to the connectivity issue encountered.
<Date> [ERROR] [WrapperSimpleAppMain] (InfrastructureSettingsManager.java:130) - Infrastructure settings file: infrastructureSettings.xmlwas not found
<2013-05-01 10:53:30,432> [ERROR] [WrapperSimpleAppMain] (MainProbeAgent.java:166) - Failed to inform the server that the gateway has started
java.net.ConnectException: Connection refused: connect
at java.net.DualStackPlainSocketImpl.waitForConnect(Native Method)
Such issues is encountered as a result of probe failing to register itself with uCMDB server and not being able to connect uCMDB 10.01 server. As probe was not registered with server UI it will show as disconnected.
As you are aware, probe sends the initial topology of itself to uCMDB server when it starts up. HP uCMDB server was not able to process this topology as it was failing to show the probe status as connected in the UI.
Below, is the error seen in the log; it displays making probe registration incomplete as t failed to show.
date time,### [Process Results Thread-ProbeGW_Topology_Task_] (CmdbDalException.java:88) ERROR - Sql exception occurred. Details:
Can't execute BATCH prepared statement [INSERT INTO HDM_ROOT_1 (CMDB_ID, OBJECT_CLASS, START_TIME ) select ?, ?, ? from dual where not exists (select 1 from HDM_ROOT_1 where CMDB_ID=? and OBJECT_CLASS=?)], failed prior to DB execution due to exception: java.sql.BatchUpdateException: ORA-00942: table or view does not exist
. The exceptions in the chain:
Cause (1): java.sql.BatchUpdateException: ORA-00942: table or view does not exist
Stack trace (1):
java.sql.BatchUpdateException: ORA-00942: table or view does not exist
In order to resolve this issue, you will need to run the below jmx mbean.
Go to the jmx console
History DB Services,
UCMDB:service=History DB Services
You can find the mbean mentioned below
You will need to run the above mbean with below values
customer id =1
CI Type leave empty without any value.
keep alignindexes as true and then invoke the mbean.
In 10.x version rebuildClassModelViews does not align the history tables and hence we need to run the above mbean also to make sure that history tables are also aligned to the class model.