Trouble with ODBC SQL Polling
-
Hello Victor,
I've managed to build and launch ODBC subagent tried it and got some issues. Current query returns right result, but those results stored previously die or something wrong happens to them. I have included the printscreens of management console showing this and screen of collection configuration.
Agent is configured with the following lines:
*ODBC
Query = SQL.MySQLQuery:mybase:SELECT COUNT(*) FROM USERS WHERE USERACTIVE = 1 AND USERDELETED = 0:60Normally query should return 171 or something like this.
-
Hi!
It looks like problem on server or in management console, because history is corrupted. Last value always good, which means that agent reports correct value. Can you try to change data type of this DCI to integer? Also, is there any other DCIs which experience same problem?
Best regards,
Victor -
-
As all previously stored values displayed correctly now, that means a bug on client side - either in client library or in management console itself. Can you check any other string DCIs if you have any?
Best regards,
Victor -
Hello! It looks like you're interested in this conversation, but you don't have an account yet.
Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.
With your input, this post could be even better 💗
Register Login