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.
Is that external or internal Postgres?
Please try the following:
- Close OMi/RTSM UI.
- Log into RTSM JMX
- run these two methods:
rebuildModelViews (params empty)
, 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.
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.
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.
Ok, so I figured out how to access the JMX console and followed your steps.
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.
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.
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
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.
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.
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?
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.
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't execute BATCH prepared statement [INSERT INTO
HDM_181210HOST_NODE_1 (ID, CMDB_ID,
The table 'HDM_181210HOST_NODE_1' does not exist in RTSM.