Unrecoverable error in WHERE clause

haix — Mon, 28 Aug 2023 17:25:14 GMT

Hi all,

I guess this is a reporting a bug and finding out if anyone else experiences the same issue:

Loading a log file

Given a simple data set from a server log file:
message = path to file accessed
response = HTTP response code

SELECT DISTINCT message, COUNT(message) TheCount, method
FROM CurrentView
WHERE response = '200'
-- AND TheCount > 20 --> LogViewPlus crashes with this
GROUP BY message
ORDER BY TheCount DESC
;

With the addition of AND TheCount > 20 the system crashes. Error reporting upload not possible due to 404 error.

RE: Unrecoverable error in WHERE clause

LogViewPlus Support — Mon, 28 Aug 2023 17:25:14 GMT

Hi Haix,

Thanks for reporting this issue.

First, the correct way to execute this SQL statement would be to use the HAVING clause. For example:
[code language="sql"]SELECT DISTINCT message, COUNT(message) TheCount, method
FROM CurrentView
WHERE response = '200'
GROUP BY message
HAVING TheCount > 20
ORDER BY TheCount DESC[/code]
However, LogViewPlus should fail more gracefully. I ran a few tests, and LogViewPlus gracefully reported a "COUNT method not found' error. I will continue testing to try and recreate an application failure.

The issue with error reporting can happen if the application does not have proxy server access or is blocked by antivirus. As a work around, you could email me the error.report file found in the %AppData%\LogViewPlus directory. To do this, we would need to first start an email thread.

Thanks again,

Toby

LogViewPlus Support » LogViewPlus Support » Help & Support » Unrecoverable error in WHERE clause

Unrecoverable error in WHERE clause

RE: Unrecoverable error in WHERE clause