UCMDB Support Tip: Probe 10.01 not able to connect the uCMDB 10.01

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)

 at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocket


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.