Unsolved
This post is more than 5 years old
29 Posts
0
11701
November 30th, 2012 10:00
Cannot edit and save query
I cannot edit the existing query and save it. I am not getting any error message during the edit and save process. It act like it saves the query successfuly. But when I try to create a device group using that query, I can't find query. It disappeared. In Tools\Application Logs, I see error message:
"Critical" "11/30/2012 5:42:20 AM" "Inventory Manager Exception; Device: -1325008538 , Exception: Failed to insert or update records due to non-unique data in columns of table. : Error executing the SQL Statement:INSERT INTO Agent (AgentId,AgentGlobalStatus,AgentManufacturer,AgentDescription,DeviceId) VALUES(?,?,?,?,?)
Error:
SQL_ERROR results:
SQL Error State: 23000,
Native Error Code: 203,
ODBC Error Text: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'AgentName', table 'OMEssentials.dbo.Agent'; column does not allow nulls. INSERT fails.
SQL_ERROR results continued:
SQL Error State: 01000,
Native Error Code: E25,
ODBC Error Text: [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.
ODBC_DatabaseConnection::AddTableRow()"
I am running OME version 1.0.1.1253 with SQL server 2008 at the backend. The OME DB is in our Enterprise SQL cluster and using SQL login.
0 events found
DELL-Rob C
4 Apprentice
•
2.8K Posts
0
November 30th, 2012 12:00
Hi there,
There should be a readme entry on this one. It looks to be fixed in 1.1 though.
Thanks,
Rob
isyed1
29 Posts
0
December 13th, 2012 07:00
I don't understand your answer. Where is the readme entry?
DELL-Rob C
4 Apprentice
•
2.8K Posts
0
December 13th, 2012 18:00
Hi there.
It looks like you are using OME 1.0.1. The current release is OME 1.1 and has this issue fixed I think.
In the 101 readme you can search on text "device search query" and it describes a similar problem if I am looking at it right.
Hope this helps.
Rob
www.dell.com/.../dell-opnmang-essentials-v1.0