HTTPErr input log format is not working when 'streamid' column is presentRSS

1 reply

Last post Oct 23, 2019 02:14 PM by caseee

  • 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

  • Re: HTTPErr input log format is not working when 'streamid' column is present

    Oct 23, 2019 02:14 PM|caseee|LINK

    Same error here.

    Made something like this:


    . "C:\Program Files (x86)\Log Parser 2.2\LogParser.exe" "select * into 'C:\logs\errors.xml' from C:\Windows\System32\LogFiles\HTTPERR\*.*" -i:tsv -iseparator ''space'' -lineFilter +"#" -iheaderfile c:\logs\header.txt

    with header.txt:

    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