The transition to NetApp MS Azure AD B2C is complete. If you missed the pre-registration, you will be invited to register at next log in.
Please note that access to your NetApp data may take up to 1 hour.
To learn more, read the FAQ and watch the video.
Need assistance? Complete this form and select “Registration Issue” as the Feedback Category.

Active IQ Unified Manager Discussions

SQL Error on ESXi host data collection

MATTJBTL

Hi,

I have a number of standalone ESXi hosts which are producing an error when OnCommand Balance attempts data collection on them, they are on two different versions ESXi 4.1.0 582267 and 5.1.0 1021289. The hosts are on the same subnet as the Balance server and they are added with no complaints so I assume it's not an issue with the connection between them. I've had a quick look around in the usual places and through the documentation but not been able to find an answer as to why this error is been produced, I've tried removing and adding them again a few times but the same error persists.

OTHER Collection Service failed to process discovery collection. PreparedStatementCallback; bad SQL grammar call syncRelationships(?, ?, ?) ; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Result consisted of more than one row

Any help with this would be much appreciated and apologies in advance if I've missed anything obvious.

Thanks!

1 ACCEPTED SOLUTION

plauterb

If everything in the environment is configured OK, errors of this type may be transient, and resolve themselves after a few discovery cycles. However, this looks more like a persistent config issue, either with the ESXi servers, or the Balance config for these servers is confused. This may be due to things like duplicate host UUID on the servers, etc. If you delete the servers, Balance will consider the elements LOST after 7 days, and clean them up. This will take way too long.

There is not much more to troubleshoot through this forum. Please open a technical support case, they will triage and escalate to engineering as necessary.

View solution in original post

2 REPLIES 2

plauterb

If everything in the environment is configured OK, errors of this type may be transient, and resolve themselves after a few discovery cycles. However, this looks more like a persistent config issue, either with the ESXi servers, or the Balance config for these servers is confused. This may be due to things like duplicate host UUID on the servers, etc. If you delete the servers, Balance will consider the elements LOST after 7 days, and clean them up. This will take way too long.

There is not much more to troubleshoot through this forum. Please open a technical support case, they will triage and escalate to engineering as necessary.

View solution in original post

MATTJBTL

Thanks for the reply Peter, this appears to have resolved on its own after it was left to its self whilst I was away, I imagine since I had added and removed the servers a couple of times whilst trying to find the problem this might be why this occurred as you suggested.

Announcements
NetApp on Discord Image

We're on Discord, are you?

Live Chat, Watch Parties, and More!

Explore Banner

Meet Explore, NetApp’s digital sales platform

Engage digitally throughout the sales process, from product discovery to configuration, and handle all your post-purchase needs.

NetApp Insights to Action
I2A Banner
Public