Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

NodeID is not automatically generated in NodesCustomProperties table

We're trying to figure out how to add node by Python. After using the python script provided in github to add a node, the node was created successfully, however when I tried updating the custom properties for the node, the script was able to run successfully but the values were not updated. I tried using the Web GUI and SQL to manually update the custom properties but the values were not updated either with no errors reported. I checked the Orion.Nodes table in the database and the node was there however, in the NodesCustomProperties table, the node was not there. I was wondering how to fix it so that when adding nodes using a python script, I can update the custom properties afterwards. Thanks!

Find more posts tagged with

Accepted answers

All comments

mrxinu

Hey there,

What method did you use to update the custom properties? And just to confirm, is this the script that you used to add the node in the first place?

orionsdk-python/add_node.py at master · solarwinds/orionsdk-python · GitHub

freemanfanb

Thanks Steven,

I found the root cause and work around on the forum. It is a bug of NPM 11.5.

Problem is, that the CRUD action doesn't create the record in the NodesCustomProperties fragment. However here is the workaround how to fix it (until we fix that in the product). Put following lines before the line, where you set the Custom properties values:

[System.String]$sqlCommand=("Insert into NodesCustomProperties (NodeID) VALUES (" + $nodeProps.nodeid + ")")
Invoke-SwisVerb $swis "Orion.Reporting" "ExecuteSQL" $sqlCommand |Out-Null

This should create the correct record, which allows you then to set the Custom Property values.

mrxinu

Well excellent, I'm glad you figured it out!