View previous topic :: View next topic |
Author |
Message |
step
Joined: 20 Apr 2006 Posts: 19 Location: Berlin, GER
|
Posted: Fri Nov 04, 2011 6:14 pm Post subject: ODBC query in 9.00 compare not numeric? |
|
|
Alex,
since i do update to 9.00 i have problems with some ODBC querys.
An example:
Code: | select top 1 value from perfSampleRt where instance_id = 43 and counter_id = 5 order by timestamp desc |
This request gives an integer value, is the result e.g. 800 and to compare with < 2000 then the test is red. When the result compared with < 99, the test is green.
Results are now, since version 9.00, compared as text - is that intentional?
Best regards.
Step |
|
Back to top |
|
|
KS-Soft
Joined: 03 Apr 2002 Posts: 12807 Location: USA
|
Posted: Fri Nov 04, 2011 6:25 pm Post subject: |
|
|
We did not change anything related to ODBC test in version 9.00. I just re-checked this...
And as I see HostMonitor compares numeric fields as numbers, not strings.
May be you have updates your ODBC driver as well or changed table structure?
What exactly ODBC driver do you use?
What exactly field type?
Can you try to use CAST operator in SQL Query to change value type?
What version of HostMonitor have you used before update?
Regards
Alex |
|
Back to top |
|
|
step
Joined: 20 Apr 2006 Posts: 19 Location: Berlin, GER
|
Posted: Fri Nov 04, 2011 8:37 pm Post subject: |
|
|
KS-Soft wrote: | We did not change anything related to ODBC test in version 9.00. I just re-checked this...
And as I see HostMonitor compares numeric fields as numbers, not strings. |
Hmm...
Quote: | May be you have updates your ODBC driver as well or changed table structure? |
No, no...
Quote: | What exactly ODBC driver do you use?
What exactly field type?
Can you try to use CAST operator in SQL Query to change value type?
What version of HostMonitor have you used before update?
|
The data type from column value is bigint. Do I use "cast ... as int" - of course, it works. Except the update, nothing has changed on my servers. The last used HM-version was 8.86, updated on 18 march 2011. Since it went without implementation with cast. The last server reboot was executed on 18 october - at the time there were no problems. Yesterday I only upgraded HM from version 8.86 to version 9.00. Other systems were not changed during this time.
Is it possible that had in the handling of bigint changed anything?
Regards
Step. |
|
Back to top |
|
|
KS-Soft
Joined: 03 Apr 2002 Posts: 12807 Location: USA
|
Posted: Mon Nov 07, 2011 6:06 pm Post subject: |
|
|
That was our mistake
We did not change ODBC related code at all but one module was rebuilt with wrong option.
There is quick fix: www.ks-soft.net/download/hm900c.zip
Just unzip the file and replace hostmon.exe module.
Regards
Alex |
|
Back to top |
|
|
step
Joined: 20 Apr 2006 Posts: 19 Location: Berlin, GER
|
Posted: Thu Nov 10, 2011 3:59 pm Post subject: |
|
|
Thanks for the quick reaction.
Regards
Step. |
|
Back to top |
|
|
KS-Soft
Joined: 03 Apr 2002 Posts: 12807 Location: USA
|
Posted: Thu Nov 10, 2011 4:17 pm Post subject: |
|
|
You are welcome.
Also we found couple pretty old minor bugs so expect version 9.02 tomorrow
Regards
Alex |
|
Back to top |
|
|
step
Joined: 20 Apr 2006 Posts: 19 Location: Berlin, GER
|
Posted: Thu Nov 10, 2011 4:29 pm Post subject: |
|
|
Very fine, thanks. |
|
Back to top |
|
|
|