Cannot edit and save query

Question

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.

DELL-Rob C · Answer

Hi there, There should be a readme entry on this one.  It looks to be fixed in 1.1 though. Thanks, Rob

isyed1 · Answer

I don't understand your answer. Where is the readme entry?

DELL-Rob C · Answer

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

Dell OpenManage Essentials

Was this post helpful?