requests.exceptions.HTTPError: 400 Client Error: Update or insert of view or function 'dbo.NCM_Nodes' failed because it contains a derived or constant field.

[the-modern-leo]

I am trying to update the following fields in NCM.
uri = 'swis://orion-npm.ad.utah.edu/Orion/NCM.Nodes/NodeID=C8B848D4-EFE0-4386-9079-10057E8B2F9C'
props = {'SNMPLevel': 3, 'SNMPUsername':XXXXX, 'SNMPAuthType':'MD5', 'SNMPAuthPass':'XXXXXX, 'SNMPEncryptType':'DES', 'SNMPEncryptPass':XXXXXX} self.swis.update(uri, **props)

I get the following Error:

requests.exceptions.HTTPError: 400 Client Error: Update or insert of view or function 'dbo.NCM_Nodes' failed because it contains a derived or constant field. for url: https://smg-mp-p01.sys.utah.edu:17778/SolarWinds/InformationService/v3/Json/swis://orion-npm.ad.utah.edu/Orion/NCM.Nodes/NodeID=C8B848D4-EFE0-4386-9079-10057E8B2F9C

[Mesverrum]

I don't I ncm handy to confirm but it sounds like one or more of those columns is built from data on another table, ncm_nodes is probably a view, not a real table I'd guess. You could confirm by going in your database SSMS and seeing which category it shows up under, and if you poke around in SSMS you can probably find which columns are derived and where they get their data from by checking the table and column properties. On Thursday, May 28, 2020, 05:09:15 PM CDT, the-modern-leo <[email protected]> wrote: I am trying to update the following fields in NCM. uri = 'swis://orion-npm.ad.utah.edu/Orion/NCM.Nodes/NodeID=C8B848D4-EFE0-4386-9079-10057E8B2F9C' props = {'SNMPLevel': 3, 'SNMPUsername':XXXXX, 'SNMPAuthType':'MD5', 'SNMPAuthPass':'XXXXXX, 'SNMPEncryptType':'DES', 'SNMPEncryptPass':XXXXXX} self.swis.update(uri, **props) I get the following Error: requests.exceptions.HTTPError: 400 Client Error: Update or insert of view or function 'dbo.NCM_Nodes' failed because it contains a derived or constant field. for url: https://smg-mp-p01.sys.utah.edu:17778/SolarWinds/InformationService/v3/Json/swis://orion-npm.ad.utah.edu/Orion/NCM.Nodes/NodeID=C8B848D4-EFE0-4386-9079-10057E8B2F9C — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub, or unsubscribe.