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.
no data found when use log logvisualizer
-
- Posts: 2832
- Joined: Tue May 16, 2006 4:41 am
- Contact:
Re: no data found when use log logvisualizer
Could you provide us the query, specified under "InputQuery" parameter in your aa.ini file? What datatypes have first two fields?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.
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-->).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?
Could you send your log.htm to support@ks-soft.net?
Regards,
Max
Re: no data found when use log logvisualizer
KS-Soft Europe wrote:Could you provide us the query, specified under "InputQuery" parameter in your aa.ini file? What datatypes have first two fields?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.
========================================
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)
===================================
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-->).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?
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
-
- Posts: 2832
- Joined: Tue May 16, 2006 4:41 am
- Contact:
Re: no data found when use log logvisualizer
Why do you convert it to char? Have you tried the following query: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
Code: Select all
select datetime,datetime,testid, testname, status, replyvalue from tb_hostmonitor
Log looks nice, but one record is not enough for LogVisualizer. LogVisualizer requires at least two log records to produce chart.chunlan wrote:Yes, I can find it from source code such as
Regards,
Max
Re: no data found when use log logvisualizer
KS-Soft Europe wrote:Why do you convert it to char? Have you tried the following query: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_hostmonitorAnyway, 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 ).Code: Select all
select datetime,datetime,testid, testname, status, replyvalue from tb_hostmonitor
=======================================
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.
======================================
Log looks nice, but one record is not enough for LogVisualizer. LogVisualizer requires at least two log records to produce chart.chunlan wrote:Yes, I can find it from source code such as
=====
Yes, it works now, thanks.
=====
Regards,
Max
-
- Posts: 2832
- Joined: Tue May 16, 2006 4:41 am
- Contact:
Re: no data found when use log logvisualizer
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.:chunlan wrote:I tried to use the inputQuery and configured it as you suggested above but still failed with "No data found".
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
Glad to hear that.chunlan wrote:Yes, it works now, thanks.

Regards,
Max
-
- Posts: 2832
- Joined: Tue May 16, 2006 4:41 am
- Contact:
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:
Regards,
Max
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.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