Highlighted
Frequent Contributor.
Frequent Contributor.
1120 views

Error adding a Monitored Node

When trying to add a new windows 10 monitored node, I get a 500 error.

The pertinent error message says that insert into hdm_180110nt_1 failed. I looked at the postgres rtsm tabl and saw that the table does not exist. Is there a script I can use to add the table?

I know there is a script to create the Events and Management tables.

Any help would be appreciated, thanks.

Labels (1)
0 Likes
10 Replies
Highlighted
Micro Focus Expert
Micro Focus Expert

Hello,

Is that external or internal Postgres?

Please try the following:

  1. Close OMi/RTSM UI.
  2. Log into RTSM JMX
  3. run these two methods:

rebuildModelViews (params empty)

and

rebuildModelDBSchemaAndViews

, first on preview mode set to true and then set to false. It might take a while. The two "skip" parameters should be false in both occurrences.

Afterwards, let us know what is the outcome.

Regards,

Rosen

Micro Focus Software Support
The views expressed in my contributions are my own and do not necessarily reflect the views and strategy of Micro Focus.
If you find this or any post resolves your issue, please be sure to mark it as an accepted solution.
0 Likes
Highlighted
Frequent Contributor.
Frequent Contributor.

Im not able to access the jmx console.

I've completely uninstalled HP OMi and reinstalled clean and am still unable to access the console.

The issue is that I can go to http://<Server>:21212/jmx-console

I enter sysadmin/mypassword

then it forwards me to https://https://<server>:8443

with a menu which includes jmx console in the list.

Clicking on the link just refreshes the screen.

HPi Status shows all services ready, so Im not sure what is wrong and how I can fix it.

Also in configuration I have https turned off, so it should not be going to https anyways.

 

Is there a way I can access the jmx-console from PowerShell or CMD?

Also, I am running the server on a windows 2016 server.

0 Likes
Highlighted
Frequent Contributor.
Frequent Contributor.

To answer your question, its an external postgres, when trying to use the embedded, the installer failed.

0 Likes
Highlighted
Frequent Contributor.
Frequent Contributor.

Ok, so I figured out how to access the JMX console and followed your steps.

After completing:

 

Mbean: UCMDB:service=DAL services. Method: rebuildModelDBSchemaAndViews

 

Views & Tables were rebuilt successfully 

All tables in DB are aligned with the class model

Afterwords however, the table still does not exist.

0 Likes
Highlighted
Micro Focus Frequent Contributor
Micro Focus Frequent Contributor

Hi Michael,

When you are "adding a Monitored Node", how are you doing it?  What process are you using, which agent version, which OMi version?  Sounds like you are using Windows 2016 with an external PostgreSQL DB.

0 Likes
Highlighted
Frequent Contributor.
Frequent Contributor.

I am trying to add the monitored node through the OMi Administrator console:

Administration -> Setup and Maintenance -> Monitored Nodes

Clicking on Monitored Nodes in the Node Views pane

Clicking on new in the Monitored Node Views pane

Selected Computer -> Windows

Entered the DNS name and IP Address of the machine

Then Selected Windows 10 from the Operating System Dropdown

Selected x86_64 as the processor architecture

Pressed OK

Waited for the 500 Error.

I followed the same steps to add an ubuntu server that did not have an agent installed and it worked just fine.

I installed HP OMi 10.62

The agent is installed using the exe's in the Software folder in OMI zip.

The linux box never had an agent installed and the windows fails whether or not the agent is installed.

0 Likes
Highlighted
Frequent Contributor.
Frequent Contributor.

Also, just out of curiousity, I dropped hdm_18011nfs_1 then tried the rebuild tables again and the table was not recreated.

So I'm assuming the jmx-console is not communicating with the external database correctly.

0 Likes
Highlighted
Honored Contributor.
Honored Contributor.

Bit off topic, but I'm curious about rebuildModelViews and rebuildModelDBSchemaAndViews.

We occasionally have problems with broken views that require DPS restart. Gates associated with these views show as "locked".  Could maybe rebuilding help here?

0 Likes
Highlighted
Frequent Contributor.
Frequent Contributor.

I tried restarting the instance and reran the scrpts with no change. I still do not have the hdm_180110nt_1 table or the dropped hdm_180110nfs_1.

0 Likes
Highlighted
Valued Contributor.. Valued Contributor..
Valued Contributor..

Hello,

Has this been solved.

I am having the same type of problem. 

This is my command ...

opr-node.sh -ssl -add_node -node_name AIS-AASSO -ci_name AIS-AASSO -ip 0.0.0.0 -v

and these are the results (snipped to include the missing table only ) ...

[ErrorCode [-2147483648] undefined error code]
Can&#39;t execute BATCH prepared statement [INSERT INTO
HDM_181210HOST_NODE_1 (ID, CMDB_ID,
A_LIC_TYPE_UDI,A_NET_BIOS_NAME,A_SNMP_SYS_NAME,A_CITY,A_PRIMARY_MAC_ADD
RESS,A_NODE_OS_DESCRIPTION,A_UD_UNIQUE_ID,A_PROCESSOR_FAMILY,A_DISCOVER
ED_OS_VENDOR,A_CREATE_TIME,A_BIOS_ASSET_TAG,A_TENANTOWNER,A_HOST_ISVIRT
UAL,A_HOST_OSACCURACY,A_PLATFORM_VENDOR,A_ROOT_CONTAINER,A_DATA_EXTERNA

 

The table 'HDM_181210HOST_NODE_1' does not exist in RTSM.

Thanks,

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.