Since streamid column is not supported in HTTPErr input log format, all the queries are failing even if I am specifically mentioning the column names. How to get around this problem ? Will you able to add support for streamid column
in LogParser HTTPErr query handler ?
1 Post
HTTPErr input log format is not working when 'streamid' column is present
Mar 09, 2019 12:46 PM|Pratyay|LINK
Since streamid column is not supported in HTTPErr input log format, all the queries are failing even if I am specifically mentioning the column names. How to get around this problem ? Will you able to add support for streamid column in LogParser HTTPErr query handler ?
#Software: Microsoft HTTP API 2.0
#Version: 1.0
#Date: 2019-03-02 09:06:31
#Fields: date time c-ip c-port s-ip s-port cs-version cs-method cs-uri streamid sc-status s-siteid s-reason s-queuename
2019-03-02 09:06:31 123.211.412.127 25144 10.0.0.4 80 - - - - - - Timer_ConnectionIdle -
2019-03-02 09:07:36 123.211.412.127 38801 10.0.0.4 80 - - - - - - Timer_ConnectionIdle -
2019-03-02 09:08:11 123.211.412.127 45184 10.0.0.4 80 - - - - - - Timer_ConnectionIdle -
Error Details
C:\Program Files (x86)\Log Parser 2.2>LogParser.exe -i:HTTPErr "SELECT top 5 date, time, cs-version, cs-method, cs-uri FROM 'D:\HTTPERR\httperr2.log'" -e 10
date time cs-version cs-method cs-uri
---------- -------- ---------- --------- ------------------------------
2019-03-02 09:06:31 - - - - - - Timer_ConnectionIdle -
2019-03-02 09:07:36 - - - - - - Timer_ConnectionIdle -
2019-03-02 09:08:11 - - - - - - Timer_ConnectionIdle -
2019-03-02 19:21:26 - - - - 400 - Verb -
2019-03-02 19:21:26 - - - - 400 - Verb -
Task completed with parse errors.
Parse errors:
Unknown field streamid found in #Fields directive