Highlighted
Absent Member.. Absent Member..
Absent Member..
401 views

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

          alignHistoryForType

 

Then,

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.

"HP Support
If you find this or any post resolves your issue, please be sure to mark it as an accepted solution."

Click the KUDOS star on the left to say 'Thanks'
Labels (1)
Tags (1)
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.