Sql error codes when performing status polling

Hi,

Thanks for the post.

Logs may have multiple errors. That doesn't always translate to loss of functionality. Are you seeing that none of the discovered devices are showing status?

Regards

Abhijit

hi,i got a same error like below:

Inventory Manager Exception; Device: 2077460267 , 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()

this appear every 1 hour, looks like happed every status pull.

and i have a linux(centos5.7) client in "unknown" group. OME can't pull status more than ip.

but can access the OMSA webserver on this client by brower.

any ideas?

thanks~

Thanks for the post.  

Can you run the Dell Troubleshooting Tool SNMP test against that target?

What version of OMSA is reported in the result set?

Thanks,

Rob

hi, Rob, i believe OMSA is version 7,i install it from dell repository with yum.

snmp test can pass ,but i seem a failure in OMSA remote enablement test.

Operating System

Name CentOS

Version release 5.7 (Final) Kernel 2.6.18-274.17.1.el5 (x86_64)

System Time Mon Jul 23 13:42:23 2012

System Bootup Time Fri Jul 20 16:23:14 2012

Systems Management

Name Dell OpenManage Server Administrator

Version 7.0.0

Description Systems Management Software

Contains A library for parsing GNU style command line arguments 7.0.0

Data Engine 7.0.0

Hardware Abstraction Programming Interface 7.0.0

iDRAC6 Command Interface 7.0.0

Instrumentation Services 7.0.0

Integrated Tunnel Provider 1.3.0

Meta package for installing all Server Administrator features 7.0.0

Meta package for installing the Server Administrator Storage Services feature 7.0.0

Meta package for installing the Server Administrator Web Server feature 7.0.0

Meta package for installing the Server Agent 7.0.0

Meta package for installing the Standard Server Agent 7.0.0

Meta rpm for iDRAC components 7.0.0

Meta rpm for RAC4 components 7.0.0

Meta rpm for RAC5 components 7.0.0

Modular Server Virtual Media CLI Utils 1.0.0

Monolithic Server Virtual Media CLI Utils 1.0.0

RAC5 Command Interface 7.0.0

RAC Command Interface 7.0.0

RAC Integration Layer 7.0.0

Remote Access Card Data Populator 7.0.0

Remote Access Card Data Populator 7.0.0

Remote Access Card Managed Node 7.0.0

Secure Port Server and Server Administrator GUI 7.0.0

Server Administrator Common Framework 7.0.0

Server Administrator Core and CLI 7.0.0

Server Administrator XML Support SDK 7.0.0

Storage Management accessors package 4.0.0

Storage Management common files for GUI and CLI 4.0.0

Storage Management package for GUI component 4.0.0

Storage Management System Utilities Package / Libsysfs 1.3.0

StoreLib package for storage management 7.0.0

SUN Java Runtime Environment 1.6.0_30

System Utilities Package/Libsysfs for LSI storage libraries 2.1.0

Ok, thanks.  This helps a bit.

First, it is a bit of a concern that the TS tool was not on your OME server.  We install it by default.  Are you using OME 1.0.1?  So I'm a bit worried about that....anyway...

When you run the TS SNMP test against your Linux (or Win) target, you *must* see the OMSA version in the result set.  If you do not...full stop, you will never work.

So it is important at this point to review your OMSA install on your target.  Sorry if this was suggested earlier in the thread, I'm just jumping in here, but have you reviewed the Linux/OMSA config movie on delltechcenter.com/ome?  As well as the tutorial section in OME that talks about how to config OMSA linux for discovery on OME?

Once we are able to sort out your OMSA install, OME will discover and inventory the box just fine.

Thanks,

Rob

Thanks for this detail.  But it is not exactly what I need.

Please run the Dell Troubleshooting Tool that is installed on the OME desktop.

Run the SNMP test and tell me the results.  I need to know what OMSA version is reported in this result set to see if it is communicating as expected.

Thanks very much,

Rob

hi, Bob. this is snmp test result, didn't see any version report.

btw, i can't found the troubleshooting tool installed with OME. so i installed it individual. its version is 3.0

Execution Started

Time: 2012/7/23 21:45:26 Device: 192.168.1.29

Protocols Selected are:

SNMP

SNMP

MIB-II (System Name) node01

Top

Execution Completed

Rob,,thank you.

the OME version is 1.0.1.  i run snmp test against other client. it give out the omsa version as you said. because the linux box 's OMSA webserver can work. so i never considered the config may wrong.  i'll focus on it.

if i can go further, i will update it here.

thanks for you help again.

well, i believe i know what is that now.

it's a power supply error. i didn't use power supply redundancy.

HI,Rob, i reinstall the OMSA.   now,snmp test seems succeed.

but i got an error like below.

the server informations are gathered. so i don't know what is this red cross about.

Ok, this looks better.

So they way it works (and I think you determined this as well) is that OME will get a critical status reported from OMSA (Server Administrator).  Now what you do is click on the Server Administrator hyperlink and the details in OMSA will tell you what the problem is.

Looks like you are in good shape now.

Good luck,

Rob