Setting Up ODBC Logging

KS-Soft · Post by **KS-Soft** » Wed Nov 02, 2005 7:13 pm

We have improved "Test" function.
Could you please install update www.ks-soft.net/download/la504b.zip , open ODBC Logs Manager dialog, select ODBC log and click "Test" button. If Log Analyzer asks "Structure check: Ok. Perform records check?", click "Yes".

Regards
Alex

johnm · Post by **johnm** » Thu Nov 03, 2005 2:13 pm

Ok Alex, I ran version 5.04b and here are the results:

Structure Check: OK
Records Check: OK

Tried to open the table and the same "Invalid Records" error occurs.

KS-Soft · Post by **KS-Soft** » Thu Nov 03, 2005 10:25 pm

Very odd

"Test" button performs exactly the same data check that is performed when you are loading table
Ok, there is another version at www.ks-soft.net/download/la504c.zip
What error it shows when you LOAD log?

Regards
Alex

johnm · Post by **johnm** » Fri Nov 04, 2005 7:52 am

Returns
SQL Error # 4294967295

johnm · Post by **johnm** » Fri Nov 04, 2005 8:12 am

Alex, I am sending an ODBC trace log file to support@ks-soft.net.

Perhaps, it will help with diagnosis.

John

KS-Soft · Post by **KS-Soft** » Fri Nov 04, 2005 8:34 pm

H'm... according to the trace log contains just 1 record (2nd "SQL_FETCH_NEXT" command fails with error "SQL_NO_DATA_FOUND").
How many records displayed when you click "Test" button? 135??
But this is impossible...
"Test" and "Load" functions use the same query. I see this query in the log: select date1, eventtime, fullpath, status, reply, testname from hmlog order by fullpath, testname, date1, eventtime

BTW: You still using 2 fields "date1" and "eventtime".
If you use %datetime% variable, you don't have to use 2 different fields for date and time. Set "eventtime" for both fields: date, time. In this case Log Analyzer will retrieve date and time from single field.

Regards
Alex

johnm · Post by **johnm** » Fri Nov 04, 2005 9:23 pm

As stated in my reply email, there is only 1 record in the table. I did this to simplify the diagnosis.

Also, I changed both fields to use eventtime.

Still error.

KS-Soft · Post by **KS-Soft** » Sat Nov 05, 2005 2:47 am

Please add some more records. Regular LA 5.02, 5.03 can work with single record but this test version cannot

Regards
Alex

johnm · Post by **johnm** » Mon Nov 07, 2005 9:53 am

Ok. I added a few more rows and now on "Records Check?" I get "Invalid Status" for each row.

johnm · Post by **johnm** » Mon Nov 07, 2005 9:54 am

Statuses are 1 of the following:

Bad, Host is alive or Ok

johnm · Post by **johnm** » Mon Nov 07, 2005 10:19 am

It seems there is a problem with the column 'status'. If I set it to int and use %statusid% I get some rows as good and others as bad from "Records Check". If I set the column to Char and use %status%, all rows fail.

Hm...???

KS-Soft · Post by **KS-Soft** » Mon Nov 07, 2005 3:29 pm

H'm... at least LA accepts all other fields. Staus field check is the last check.
There is another version at the same location www.ks-soft.net/download/la504c.zip
It will show what exactly value Log Analyzer retrieves from status field
May be you have mixed "status" and "reply" fields in database?

Regards
Alex

johnm · Post by **johnm** » Mon Nov 07, 2005 3:41 pm

I confirmed that I have not mixed reply with status. See results below.

Records check: Error

Record #1: Invalid status "Host is alive "
Record #2: Invalid status "Host is alive "

note: After the word "alive" there are about 4 to 5 trailing spaces that are not shown above.

johnm · Post by **johnm** » Mon Nov 07, 2005 3:46 pm

Alex, more info for you...

There are 3 rows in my hmlog table. My previous test only reported an error on Records 1 and 2.

I tried this:

In the ODBC setup instead of setting "Status" to status, I set it to the number "1". The test succeeds on records check and the log displays the actual records for row 1 and 3 of the hmlog table.

Not sure if this helps...

johnm · Post by **johnm** » Mon Nov 07, 2005 3:48 pm

sorry, one more thing: The test and the reading of the log only seems to work if I put a 1 in the ODBC setup field for Status. I tried other numbers and various text but the error occurs.