KS-Soft. Network Management Solutions
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister    ProfileProfile    Log inLog in 

ODBC query in 9.00 compare not numeric?

 
Post new topic   Reply to topic    KS-Soft Forum Index -> Bug reports
View previous topic :: View next topic  
Author Message
step



Joined: 20 Apr 2006
Posts: 19
Location: Berlin, GER

PostPosted: Fri Nov 04, 2011 6:14 pm    Post subject: ODBC query in 9.00 compare not numeric? Reply with quote

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
View user's profile Send private message
KS-Soft



Joined: 03 Apr 2002
Posts: 12792
Location: USA

PostPosted: Fri Nov 04, 2011 6:25 pm    Post subject: Reply with quote

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
View user's profile Send private message Visit poster's website
step



Joined: 20 Apr 2006
Posts: 19
Location: Berlin, GER

PostPosted: Fri Nov 04, 2011 8:37 pm    Post subject: Reply with quote

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
View user's profile Send private message
KS-Soft



Joined: 03 Apr 2002
Posts: 12792
Location: USA

PostPosted: Mon Nov 07, 2011 6:06 pm    Post subject: Reply with quote

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
View user's profile Send private message Visit poster's website
step



Joined: 20 Apr 2006
Posts: 19
Location: Berlin, GER

PostPosted: Thu Nov 10, 2011 3:59 pm    Post subject: Reply with quote

Thanks for the quick reaction.

Regards
Step.
Back to top
View user's profile Send private message
KS-Soft



Joined: 03 Apr 2002
Posts: 12792
Location: USA

PostPosted: Thu Nov 10, 2011 4:17 pm    Post subject: Reply with quote

You are welcome.
Also we found couple pretty old minor bugs so expect version 9.02 tomorrow

Regards
Alex
Back to top
View user's profile Send private message Visit poster's website
step



Joined: 20 Apr 2006
Posts: 19
Location: Berlin, GER

PostPosted: Thu Nov 10, 2011 4:29 pm    Post subject: Reply with quote

Very fine, thanks.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    KS-Soft Forum Index -> Bug reports All times are GMT - 6 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group

KS-Soft Forum Index