no data found when use log logvisualizer

[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]

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?

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]

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)

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

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]

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 ).

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]

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.
======================================

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]

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

Yes, it works now, thanks.

Glad to hear that.

Regards,
Max

[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]

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.