no data found when use log logvisualizer

All questions related to installations, configurations and maintenance of Advanced Host Monitor (including additional tools such as RMA for Windows, RMA Manager, Web Servie, RCC).
Post Reply
chunlan
Posts: 9
Joined: Thu Dec 04, 2008 7:14 pm

no data found when use log logvisualizer

Post by chunlan »

Hi,
When I use the logvisualizer want to get the test result chart, the result is No data found.
I tried with two ways but both failed.
1. database log. I configured the setupprofile aa.ini and start logvisulizer with command " logvisualizer.exe -testid:1760 -logprofile:aa.ini", the result is window pops up with "no data found". The logvisualizer.log file echo "[2008-12-5 14:45:17] Invalid log record." . But actually, I can get data manually when I using SQL in file aa.ini from database.

Please tell me what's wrong.


2. file log. I used "logvisualizer.exe -testid:1760 -inputfile:"log.htm"", also the same error with "no data found", then I think that's because testid not recorded in the log.htm, and want to go to the Report profile window to add this field, unfortunately, I can't find this macro variable in "Display following fields". Can you tell me how to do?


Thanks.
KS-Soft Europe
Posts: 2832
Joined: Tue May 16, 2006 4:41 am
Contact:

Re: no data found when use log logvisualizer

Post by KS-Soft Europe »

chunlan wrote:1. database log. I configured the setupprofile aa.ini and start logvisulizer with command " logvisualizer.exe -testid:1760 -logprofile:aa.ini", the result is window pops up with "no data found". The logvisualizer.log file echo "[2008-12-5 14:45:17] Invalid log record." . But actually, I can get data manually when I using SQL in file aa.ini from database.
Could you provide us the query, specified under "InputQuery" parameter in your aa.ini file? What datatypes have first two fields?
chunlan wrote:2. file log. I used "logvisualizer.exe -testid:1760 -inputfile:"log.htm"", also the same error with "no data found", then I think that's because testid not recorded in the log.htm, and want to go to the Report profile window to add this field, unfortunately, I can't find this macro variable in "Display following fields". Can you tell me how to do?
Actually, LogVisualizer does not work with reports, it works with log files, generated by HostMonitor ("Options" -> "Log Settings"). Since version 7.00 HostMonitor has wrote TestId into every log record. TestId is not displayed when you open log file with browser, but you may use "View source" option to see TestId record (e.g. <!--TI1-->).
Could you send your log.htm to support@ks-soft.net?

Regards,
Max
chunlan
Posts: 9
Joined: Thu Dec 04, 2008 7:14 pm

Re: no data found when use log logvisualizer

Post by chunlan »

KS-Soft Europe wrote:
chunlan wrote:1. database log. I configured the setupprofile aa.ini and start logvisulizer with command " logvisualizer.exe -testid:1760 -logprofile:aa.ini", the result is window pops up with "no data found". The logvisualizer.log file echo "[2008-12-5 14:45:17] Invalid log record." . But actually, I can get data manually when I using SQL in file aa.ini from database.
Could you provide us the query, specified under "InputQuery" parameter in your aa.ini file? What datatypes have first two fields?
========================================
The inputQuery is,
select to_char(datetime,'yyyy-mm-dd hh24:mi:ss'),to_char(datetime,'yyyy-mm-dd hh24:mi:ss'),testid, testname, status, replyvalue from tb_hostmonitor

the data from database is,
2008-12-05 15:22:56 2008-12-05 15:22:56 1760 WikiServer Ok
68.25

The tb_hostmonitor structure is,
Name Null? Type
----------------------------------------------------- -------- ------------------------------------
TESTNAME VARCHAR2(50)
TESTID NUMBER(5)
DATETIME DATE
REPLYVALUE VARCHAR2(50)
STATUSID NUMBER(2)
REPORT CHAR(1)
THRESHOLD VARCHAR2(50)
STATUS VARCHAR2(40)

===================================
chunlan wrote:2. file log. I used "logvisualizer.exe -testid:1760 -inputfile:"log.htm"", also the same error with "no data found", then I think that's because testid not recorded in the log.htm, and want to go to the Report profile window to add this field, unfortunately, I can't find this macro variable in "Display following fields". Can you tell me how to do?
Actually, LogVisualizer does not work with reports, it works with log files, generated by HostMonitor ("Options" -> "Log Settings"). Since version 7.00 HostMonitor has wrote TestId into every log record. TestId is not displayed when you open log file with browser, but you may use "View source" option to see TestId record (e.g. <!--TI1-->).
Could you send your log.htm to support@ks-soft.net?
====================================
Yes, I can find it from source code such as,
</tr> <tr>
<td bgcolor="#D6D6D6" nowrap valign="top" align="center"> <font color=#000000><!--KSIM--><!--KSFD-03122008131604-->2008-12-3 13:16:04<!--KSIM--></font> </td>
<td bgcolor="#D6D6D6" nowrap valign="top" align="left">  <font color=#000000><!--KSIM-->Oracle:ODBC: orcl<!--TI1760--><!--KSIM--></font> </td>
<td bgcolor="#D6D6D6" nowrap valign="top" align="left">  <font color=#000000><!--KSIM-->Ok<!--KSIM--></font> </td>
<td bgcolor="#D6D6D6" nowrap valign="top" align="center"> <font color=#000000><!--KSIM-->68.25<!--KSIM--></font> </td>
<td bgcolor="#D6D6D6" nowrap valign="top" align="left">  <font color=#000000><!--KSIM-->ODBC test (orcl)<!--KSIM--></font> </td>

=================================


Regards,
Max
KS-Soft Europe
Posts: 2832
Joined: Tue May 16, 2006 4:41 am
Contact:

Re: no data found when use log logvisualizer

Post by KS-Soft Europe »

chunlan wrote:The inputQuery is,
select to_char(datetime,'yyyy-mm-dd hh24:mi:ss'),to_char(datetime,'yyyy-mm-dd hh24:mi:ss'),testid, testname, status, replyvalue from tb_hostmonitor
Why do you convert it to char? Have you tried the following query:

Code: Select all

select  datetime,datetime,testid, testname,  status, replyvalue from tb_hostmonitor
Anyway, you may use your previous query. However, in this case you should enable "Use fixed date&time formats" option and type yyyy-mm-dd and HH:mm:ss into appropriate boxes in "Profile settings" window ( logvisualizer.exe -setupprofile:aa.ini ).
chunlan wrote:Yes, I can find it from source code such as
Log looks nice, but one record is not enough for LogVisualizer. LogVisualizer requires at least two log records to produce chart.

Regards,
Max
chunlan
Posts: 9
Joined: Thu Dec 04, 2008 7:14 pm

Re: no data found when use log logvisualizer

Post by chunlan »

KS-Soft Europe wrote:
chunlan wrote:The inputQuery is,
select to_char(datetime,'yyyy-mm-dd hh24:mi:ss'),to_char(datetime,'yyyy-mm-dd hh24:mi:ss'),testid, testname, status, replyvalue from tb_hostmonitor
Why do you convert it to char? Have you tried the following query:

Code: Select all

select  datetime,datetime,testid, testname,  status, replyvalue from tb_hostmonitor
Anyway, you may use your previous query. However, in this case you should enable "Use fixed date&time formats" option and type yyyy-mm-dd and HH:mm:ss into appropriate boxes in "Profile settings" window ( logvisualizer.exe -setupprofile:aa.ini ).

=======================================
I tried to use the inputQuery and configured it as you suggested above but still failed with "No data found". I am using Oracle database, the inserted datetime value is inserted using the way to_date('%DateTime%','yyyy-mm-dd hh24:mi:ss')

What's wrong? please help me. Thanks.
======================================

chunlan wrote:Yes, I can find it from source code such as
Log looks nice, but one record is not enough for LogVisualizer. LogVisualizer requires at least two log records to produce chart.

=====
Yes, it works now, thanks.
=====
Regards,
Max
KS-Soft Europe
Posts: 2832
Joined: Tue May 16, 2006 4:41 am
Contact:

Re: no data found when use log logvisualizer

Post by KS-Soft Europe »

chunlan wrote:I tried to use the inputQuery and configured it as you suggested above but still failed with "No data found".
Hm. I do no see "TestMethod" field in your database structure. Could you try to select one dumb field instead of TestMethod within your query? E.g.:
select to_char(datetime,'yyyy-mm-dd hh24:mi:ss'),to_char(datetime,'yyyy-mm-dd hh24:mi:ss'),testid, testname, status, replyvalue,'dumb_test method' from tb_hostmonitor
chunlan wrote:Yes, it works now, thanks.
Glad to hear that. :-)

Regards,
Max
KS-Soft Europe
Posts: 2832
Joined: Tue May 16, 2006 4:41 am
Contact:

Post by KS-Soft Europe »

There is an update to LogVisualizer: http://www.ks-soft.net/download/lv105.zip
Could you try it? With this update, LogVisualizer should work with your first query, without dumb TestMethod column:

Code: Select all

select to_char(datetime,'yyyy-mm-dd hh24:mi:ss'),to_char(datetime,'yyyy-mm-dd hh24:mi:ss'),testid, testname, status, replyvalue from tb_hostmonitor


Regards,
Max
chunlan
Posts: 9
Joined: Thu Dec 04, 2008 7:14 pm

Post by chunlan »

KS-Soft Europe wrote:There is an update to LogVisualizer: http://www.ks-soft.net/download/lv105.zip
Could you try it? With this update, LogVisualizer should work with your first query, without dumb TestMethod column:

Code: Select all

select to_char(datetime,'yyyy-mm-dd hh24:mi:ss'),to_char(datetime,'yyyy-mm-dd hh24:mi:ss'),testid, testname, status, replyvalue from tb_hostmonitor


Regards,
Max
Yes, it works now, thanks.
Post Reply